Upload excel data into sql

CREATE PROC YourProc
(
   @Status VARCHAR(50),
   @Gender VARCHAR(50),
   @Type VARCHAR(50)
)
AS
BEGIN
   --Get Status ID
   DECLARE @StatusID INT 
   IF(EXISTS(SELECT ID FROM StatusMaster WHERE Desc=@Status))
   BEGIN
     --check if the status already exists then get the id
     SELECT @StatusID=ID FROM StatusMaster WHERE Desc=@Status
   END
   ELSE
   BEGIN
     --else insert a new entry and get the inserted id
     INSERT INTO StatusMaster VALUES(@Status)
     SELECT @StatusID = IDENT_CURRENT(‘StatusMaster’)
   END

   --Get Gender ID
   DECLARE @GenderID INT 
   IF(EXISTS(SELECT ID FROM GenderMaster WHERE Desc=@Gender))
   BEGIN
     SELECT @GenderID =ID FROM GenderMaster WHERE Desc=@Gender
   END
   ELSE
   BEGIN
     INSERT INTO GenderMaster VALUES(@Gender)
     SELECT @GenderID = IDENT_CURRENT(‘GenderMaster’)
   END

   --Get Type ID
   DECLARE @TypeID INT 
   IF(EXISTS(SELECT ID FROM TypeMaster WHERE Desc=@Type))
   BEGIN
     SELECT @TypeID =ID FROM TypeMaster WHERE Desc=@Type
   END
   ELSE
   BEGIN
     INSERT INTO TypeMaster VALUES(@Type)
     SELECT @TypeID = IDENT_CURRENT(‘TypeMaster’)
   END

   --insert data to master table
   INSERT INTO MasterTable (StatusID, GenderID, TypeID, createdBy)
   VALUES(@StatusID,@GenderID,@TypeID,'')
END

foreach(DataRow dr in yourDatatable.Rows)
{
    using (SqlConnection conn = new SqlConnection("Server=YourSQLServerInstanceName;DataBase=YourDBName;UserId=YourUserId;Password=YourPassword")) // replace with your connection string
    {
       conn.Open();
       SqlCommand cmd  = new SqlCommand("YourProc", conn);
       cmd.CommandType = CommandType.StoredProcedure;
       cmd.Parameters.Add(new SqlParameter("@Status", dr["Status"].ToString()));
       cmd.Parameters.Add(new SqlParameter("@Gender", dr["Gender"].ToString()));
       cmd.Parameters.Add(new SqlParameter("@Type", dr["Type"].ToString()));
       cmd.ExecuteNonQuery();
    }
}