public ICollection <ErrorHandlerClass> SaveRequitmentRegistrationMaster(RequitmentRegistrationMaster argRequitmentRegistrationMaster, ICollection <EducationMaster> ColEducationMaster, ICollection <ProfessionalEducationMaster> ColProfessionalEducationMaster, ICollection <ExperienceMaster> ColExperienceMaster, ICollection <ReferencesMaster> ColReferencesMaster, ICollection <LanguageMaster> ColLanguageMaster) { List <ErrorHandlerClass> lstErr = new List <ErrorHandlerClass>(); DataAccess da = new DataAccess(); try { da.Open_Connection(); da.BEGIN_TRANSACTION(); string strRetValue = InsertRequitmentRegistrationMaster(argRequitmentRegistrationMaster, da, lstErr); foreach (ErrorHandlerClass objerr in lstErr) { if (objerr.Type == "E") { da.ROLLBACK_TRANSACTION(); return(lstErr); } } if (strRetValue != "") { if (ColEducationMaster != null) { if (ColEducationMaster.Count > 0) { foreach (EducationMaster ObjEducationMaster in ColEducationMaster) { ObjEducationMaster.RRId = Convert.ToInt64(strRetValue); ObjEducationMasterManager.SaveRequitmentEducationMaster(ObjEducationMaster); } } } // insert ProfessionalEducationMaster if (ColProfessionalEducationMaster.Count > 0) { foreach (ProfessionalEducationMaster ObjProfessionalEducationMaster in ColProfessionalEducationMaster) { ObjProfessionalEducationMaster.RRId = Convert.ToInt64(strRetValue); ObjProfessionalEducationMasterManager.SaveRequitmentEducationMaster(ObjProfessionalEducationMaster); } } //insert ExperienceMaster if (ColExperienceMaster.Count > 0) { foreach (ExperienceMaster objExperienceMaster in ColExperienceMaster) { objExperienceMaster.RRId = Convert.ToInt64(strRetValue); ObjExperienceMasterManager.SaveExperienceMasterTable(objExperienceMaster); } } //insert references if (ColReferencesMaster.Count > 0) { foreach (ReferencesMaster obReferencesMaster in ColReferencesMaster) { obReferencesMaster.RRId = Convert.ToInt64(strRetValue); ObjReferencesMasterManager.SaveReferencesMaster(obReferencesMaster); } } //insert references if (ColLanguageMaster.Count > 0) { foreach (LanguageMaster objLanguageMaster in ColLanguageMaster) { objLanguageMaster.RRId = Convert.ToInt64(strRetValue); ObjLanguageMasterManager.SaveLanguageMaster(objLanguageMaster); } } } da.COMMIT_TRANSACTION(); } catch (Exception ex) { if (da != null) { da.ROLLBACK_TRANSACTION(); } objErrorHandlerClass.Type = ErrorConstant.strAboartType; objErrorHandlerClass.MsgId = 0; objErrorHandlerClass.Message = ex.Message.ToString(); objErrorHandlerClass.RowNo = 0; objErrorHandlerClass.FieldName = ""; objErrorHandlerClass.LogCode = ""; lstErr.Add(objErrorHandlerClass); } finally { if (da != null) { da.Close_Connection(); da = null; } } return(lstErr); }
public string InsertRequitmentRegistrationMaster(RequitmentRegistrationMaster argRequitmentRegistrationMaster, DataAccess da, List <ErrorHandlerClass> lstErr) { da.Open_Connection(); SqlParameter[] param = new SqlParameter[37]; param[0] = new SqlParameter("@FName", argRequitmentRegistrationMaster.FName); param[1] = new SqlParameter("@MName", argRequitmentRegistrationMaster.MName); param[2] = new SqlParameter("@LName", argRequitmentRegistrationMaster.LName); param[3] = new SqlParameter("@Post", argRequitmentRegistrationMaster.Post); param[4] = new SqlParameter("@FatherFname", argRequitmentRegistrationMaster.FatherFname); param[5] = new SqlParameter("@FatherMName", argRequitmentRegistrationMaster.FatherMName); param[6] = new SqlParameter("@FatherLName", argRequitmentRegistrationMaster.FatherLName); param[7] = new SqlParameter("@Dob", argRequitmentRegistrationMaster.Dob); param[8] = new SqlParameter("@Category", argRequitmentRegistrationMaster.Category); param[9] = new SqlParameter("@CAddress", argRequitmentRegistrationMaster.CAddress); param[10] = new SqlParameter("@CCity", argRequitmentRegistrationMaster.CCity); param[11] = new SqlParameter("@CState", argRequitmentRegistrationMaster.CState); param[12] = new SqlParameter("@CPincode", argRequitmentRegistrationMaster.CPincode); param[13] = new SqlParameter("@PAddress", argRequitmentRegistrationMaster.PAddress); param[14] = new SqlParameter("@PCity", argRequitmentRegistrationMaster.PCity); param[15] = new SqlParameter("@PState", argRequitmentRegistrationMaster.PState); param[16] = new SqlParameter("@PPincode", argRequitmentRegistrationMaster.PPincode); param[17] = new SqlParameter("@Email", argRequitmentRegistrationMaster.Email); param[18] = new SqlParameter("@Mobile", argRequitmentRegistrationMaster.Mobile); param[19] = new SqlParameter("@TotalEperience", argRequitmentRegistrationMaster.TotalEperience); param[20] = new SqlParameter("@NameOfOrg", argRequitmentRegistrationMaster.NameOfOrg); param[21] = new SqlParameter("@NameOfPost", argRequitmentRegistrationMaster.NameOfPost); param[22] = new SqlParameter("@DateOfApplied", argRequitmentRegistrationMaster.DateOfApplied); param[23] = new SqlParameter("@OutCome", argRequitmentRegistrationMaster.OutCome); param[24] = new SqlParameter("@AboutCompany", argRequitmentRegistrationMaster.AboutCompany); param[25] = new SqlParameter("@Resume", argRequitmentRegistrationMaster.Resume); param[26] = new SqlParameter("@PhoneNo", argRequitmentRegistrationMaster.PhoneNo); param[27] = new SqlParameter("@CardNo", argRequitmentRegistrationMaster.CardNo); param[28] = new SqlParameter("@DateOfIssue", argRequitmentRegistrationMaster.DateOfIssue); param[29] = new SqlParameter("@IssueingAuthority", argRequitmentRegistrationMaster.IssueingAuthority); param[30] = new SqlParameter("@Photo", argRequitmentRegistrationMaster.Photo); param[31] = new SqlParameter("@Signature", argRequitmentRegistrationMaster.Signature); param[32] = new SqlParameter("@Certificate", argRequitmentRegistrationMaster.Certificate); param[33] = new SqlParameter("@AdvertisementId", argRequitmentRegistrationMaster.AdvertisementId); param[34] = new SqlParameter("@Type", SqlDbType.Char); param[34].Size = 1; param[34].Direction = ParameterDirection.Output; param[35] = new SqlParameter("@Message", SqlDbType.VarChar); param[35].Size = 255; param[35].Direction = ParameterDirection.Output; param[36] = new SqlParameter("@returnvalue", SqlDbType.VarChar); param[36].Size = 20; param[36].Direction = ParameterDirection.Output; int i = da.NExecuteNonQuery("Proc_InsertRequitmentRegistration", param); string strMessage = Convert.ToString(param[35].Value); string strType = Convert.ToString(param[34].Value); string strRetValue = Convert.ToString(param[36].Value); objErrorHandlerClass.Type = strType; objErrorHandlerClass.MsgId = 0; objErrorHandlerClass.Message = strMessage.ToString(); objErrorHandlerClass.RowNo = 0; objErrorHandlerClass.FieldName = ""; objErrorHandlerClass.LogCode = ""; objErrorHandlerClass.ReturnValue = strRetValue; lstErr.Add(objErrorHandlerClass); //return i; return(strRetValue); }