public static DataSet UpdateRecord(interface_Entrydetail Entrydetail, String _RegestrationNumber)
{
SqlParameter[] _parameters =
{
// Basic Info Start
new SqlParameter("@RegestrationNumber", Entrydetail.RegestrationNumber),
new SqlParameter("@Address", Entrydetail.Address),
new SqlParameter("@City", Entrydetail.City),
new SqlParameter("@State", Entrydetail.State),
new SqlParameter("@PinCode", Entrydetail.PinCode),
new SqlParameter("@PermanentAddress", Entrydetail.PermanentAddress),
new SqlParameter("@PermanentCity", Entrydetail.PermanentCity),
new SqlParameter("@PermanentState", Entrydetail.PermanentState),
new SqlParameter("@PermanentPinCode", Entrydetail.PermanentPinCode),
new SqlParameter("@Nationality", Entrydetail.Nationality),
new SqlParameter("@Gender", Entrydetail.Gender),
new SqlParameter("@MaritalStatus", Entrydetail.MaritalStatus),
new SqlParameter("@debarredGovt", Entrydetail.debarredGovt),
new SqlParameter("@Category", Entrydetail.Category),
new SqlParameter("@Sub_Category", Entrydetail.Sub_Category),
new SqlParameter("@Sub_CategoryType", Entrydetail.Sub_Categorytype),
new SqlParameter("@JoiningDate", Entrydetail.JoiningDate),
new SqlParameter("@LeavingDate", Entrydetail.LeavingDate),
new SqlParameter("@Certificate_Number", Entrydetail.Certificate_Number),
new SqlParameter("@Issue_Date", Entrydetail.Issue_Date),
new SqlParameter("@Issuing_Authority", Entrydetail.Issuing_Authority),
new SqlParameter("@Issuing_Authority_Email", Entrydetail.Issuing_Authority_Email),
new SqlParameter("@Handicap_Sub_Category", Entrydetail.Handicap_Sub_Category),
new SqlParameter("@Contact_Number", Entrydetail.Contact_Number),
new SqlParameter("@Email", Entrydetail.Email),
new SqlParameter("@Perma_contact", Entrydetail.P_contactnumber),
new SqlParameter("@Corres_contact", Entrydetail.C_contactnumber),
new SqlParameter("@Block", Entrydetail.Block),
new SqlParameter("@Area", Entrydetail.Area),
new SqlParameter("@PermanentBlock", Entrydetail.PermanentBlock),
new SqlParameter("@PermanentArea", Entrydetail.PermanentArea),
new SqlParameter("@NationalityName", Entrydetail.NationalityName),
new SqlParameter("@Postapplied", Entrydetail.Postapplied),
new SqlParameter("@Year", Entrydetail.Year),
new SqlParameter("@Matrialstatustype", Entrydetail.Matrialstatustype),
new SqlParameter("@SHG", Entrydetail.SHG),
new SqlParameter("@HSRLM", Entrydetail.HSRLM),
new SqlParameter("@Cadre", Entrydetail.Cadre),
// Address End
};
return(SqlHelper.ExecuteDataset(ConnectionString, "UspUpdateApplication", _parameters));
}
public static DataSet CreateRecord(interface_Entrydetail Entrydetail)
{
SqlParameter[] _parameters =
{
// Basic Info Start
new SqlParameter("@RegestrationNumber", Entrydetail.RegestrationNumber),
new SqlParameter("@PostCode", Entrydetail.PostCode),
new SqlParameter("@CandidateName", Entrydetail.CandidateName),
new SqlParameter("@Aadharnumber", Entrydetail.Aadharnumber),
new SqlParameter("@FatherHusbandName", Entrydetail.FatherHusbandName),
new SqlParameter("@Retiredemployee", Entrydetail.Retiredemployee),
new SqlParameter("@MotherName", Entrydetail.MotherName),
new SqlParameter("@DOB", Entrydetail.DOB),
new SqlParameter("@Password", Entrydetail.Password),
new SqlParameter("@Email_field", Entrydetail.Email_field),
new SqlParameter("@Mobile_Number", Entrydetail.Mobile_Number),
};
return(SqlHelper.ExecuteDataset(ConnectionString, "UspAddApplication", _parameters));
}
