public int CustomerPersonalUpdateProfessionDetails([FromBody] JObject CProfessiondetails)
{
CutomerProfessiondetails customerProfession = CProfessiondetails["customerProfession"].ToObject <CutomerProfessiondetails>();
UpdatePersonaldetails customerpersonaldetails = CProfessiondetails["customerpersonaldetails"].ToObject <UpdatePersonaldetails>();
List <CutomerProfessiondetails> lstProf = new List <CutomerProfessiondetails>();
lstProf.Add(customerProfession);
customerpersonaldetails.dtTableValues = Commonclass.returnListDatatable(PersonaldetailsUDTables.createDataTableprofessiondetails(), lstProf);
return(this.ICustomerpersonalupdate.getProfessionDetails_Customer(customerpersonaldetails));
}
public int CustomerSibBrotherUpdatedetails([FromBody] JObject CgetDetails)
{
TSibBrother SibBrother = CgetDetails["GetDetails"].ToObject <TSibBrother>();
UpdatePersonaldetails customerpersonaldetails = CgetDetails["customerpersonaldetails"].ToObject <UpdatePersonaldetails>();
List <TSibBrother> lstProf = new List <TSibBrother>();
lstProf.Add(SibBrother);
customerpersonaldetails.dtTableValues = Commonclass.returnListDatatable(PersonaldetailsUDTables.dtCreateDatatableBrotherDetail(), lstProf);
return(this.ICustomerpersonalupdate.CustomerSibBrotherUpdatedetails(customerpersonaldetails));
}
public int CustomerPartnerPreferencesUpdatedetails([FromBody] JObject CgetDetails)
{
TCustomerPartnerPreferences TCustomer = CgetDetails["GetDetails"].ToObject <TCustomerPartnerPreferences>();
UpdatePersonaldetails customerpersonaldetails = CgetDetails["customerpersonaldetails"].ToObject <UpdatePersonaldetails>();
List <TCustomerPartnerPreferences> lstProf = new List <TCustomerPartnerPreferences>();
lstProf.Add(TCustomer);
customerpersonaldetails.dtTableValues = Commonclass.returnListDatatable(PersonaldetailsUDTables.dtCreatePartnerPreferences(), lstProf);
return(this.ICustomerpersonalupdate.CustomerPartnerPreferencesUpdatedetails(customerpersonaldetails));
}
public int UpdateSpouseChildDetails([FromBody] JObject CgetDetails)
{
TSpouseChildDetailsUpdate sibSister = CgetDetails["GetDetails"].ToObject <TSpouseChildDetailsUpdate>();
UpdatePersonaldetails customerpersonaldetails = CgetDetails["customerpersonaldetails"].ToObject <UpdatePersonaldetails>();
List <TSpouseChildDetailsUpdate> lstSpouse = new List <TSpouseChildDetailsUpdate>();
lstSpouse.Add(sibSister);
customerpersonaldetails.dtTableValues = Commonclass.returnListDatatable(PersonaldetailsUDTables.dtSpouseChildDetailsUpdate(), lstSpouse);
return(this.ICustomerpersonalupdate.UpdateSpouseChildDetails(customerpersonaldetails));
}
public int UpdatePersonalDetails_Customersetails([FromBody] JObject CgetDetails)
{
TpersonalDetailsUpdate personaldetails = CgetDetails["GetDetails"].ToObject <TpersonalDetailsUpdate>();
UpdatePersonaldetails customerpersonaldetails = CgetDetails["customerpersonaldetails"].ToObject <UpdatePersonaldetails>();
List <TpersonalDetailsUpdate> lstpersonal = new List <TpersonalDetailsUpdate>();
lstpersonal.Add(personaldetails);
customerpersonaldetails.dtTableValues = Commonclass.returnListDatatable(PersonaldetailsUDTables.dtUpdatePersonalDetails(), lstpersonal);
return(this.ICustomerpersonalupdate.UpdatePersonalDetails_Customersetails(customerpersonaldetails));
}
public ArrayList Savephotosofcustomer([FromBody] JObject CgetDetails)
{
TuploadPhoto edituploadPhoto = CgetDetails["GetDetails"].ToObject <TuploadPhoto>();
UpdatePersonaldetails customerpersonaldetails = CgetDetails["customerpersonaldetails"].ToObject <UpdatePersonaldetails>();
List <TuploadPhoto> lstuploadPhoto = new List <TuploadPhoto>();
lstuploadPhoto.Add(edituploadPhoto);
customerpersonaldetails.dtTableValues = Commonclass.returnListDatatable(PersonaldetailsUDTables.dtSavephotosofcustomer(), lstuploadPhoto);
return(this.ICustomerpersonalupdate.Savephotosofcustomer(customerpersonaldetails));
}
public int CustomerPropertyUpdatedetails([FromBody] JObject CgetDetails)
{
TeditProperty editProperty = CgetDetails["GetDetails"].ToObject <TeditProperty>();
UpdatePersonaldetails customerpersonaldetails = CgetDetails["customerpersonaldetails"].ToObject <UpdatePersonaldetails>();
List <TeditProperty> lsteditProperty = new List <TeditProperty>();
lsteditProperty.Add(editProperty);
customerpersonaldetails.dtTableValues = Commonclass.returnListDatatable(PersonaldetailsUDTables.dtcreatePropertydetails(), lsteditProperty);
return(this.ICustomerpersonalupdate.CustomerPropertyUpdatedetails(customerpersonaldetails));
}
public int CustomerMotherSisterUpdatedetails([FromBody] JObject CgetDetails)
{
TeditMS editMS = CgetDetails["GetDetails"].ToObject <TeditMS>();
UpdatePersonaldetails customerpersonaldetails = CgetDetails["customerpersonaldetails"].ToObject <UpdatePersonaldetails>();
List <TeditMS> lsteditMS = new List <TeditMS>();
lsteditMS.Add(editMS);
customerpersonaldetails.dtTableValues = Commonclass.returnListDatatable(PersonaldetailsUDTables.dtcreateMotherSisterDetail(), lsteditMS);
return(this.ICustomerpersonalupdate.CustomerMotherSisterUpdatedetails(customerpersonaldetails));
}
public int?CustomerRegProfileDetails([FromBody] JObject CustomerHome)
{
TDetailedRegistration TCustomer = CustomerHome["GetDetails"].ToObject <TDetailedRegistration>();
UpdatePersonaldetails customerpersonaldetails = CustomerHome["customerpersonaldetails"].ToObject <UpdatePersonaldetails>();
List <TDetailedRegistration> lstProf = new List <TDetailedRegistration>();
lstProf.Add(TCustomer);
customerpersonaldetails.dtTableValues = Commonclass.returnListDatatable(PersonaldetailsUDTables.dtCustomerRegProfileDetails(), lstProf);
return(this.IRegistration.CustomerRegProfileDetails_Myprofile(customerpersonaldetails));
}
public int CustomerAstrodetailsUpdatedetails([FromBody] JObject CgetDetails)
{
TeditAstro editAstro = CgetDetails["GetDetails"].ToObject <TeditAstro>();
UpdatePersonaldetails customerpersonaldetails = CgetDetails["customerpersonaldetails"].ToObject <UpdatePersonaldetails>();
List <TeditAstro> lstAstro = new List <TeditAstro>();
lstAstro.Add(editAstro);
customerpersonaldetails.dtTableValues = Commonclass.returnListDatatable(PersonaldetailsUDTables.dtcreateAstrodetail(), lstAstro);
return(this.ICustomerpersonalupdate.CustomerAstrodetailsUpdatedetails(customerpersonaldetails));
}
public int CustomerReferencedetailsUpdatedetails([FromBody] JObject CgetDetails)
{
TeditReference editReference = CgetDetails["GetDetails"].ToObject <TeditReference>();
UpdatePersonaldetails customerpersonaldetails = CgetDetails["customerpersonaldetails"].ToObject <UpdatePersonaldetails>();
List <TeditReference> lstRef = new List <TeditReference>();
lstRef.Add(editReference);
customerpersonaldetails.dtTableValues = Commonclass.returnListDatatable(PersonaldetailsUDTables.dtcreateDatatableReferenceDetail(), lstRef);
return(this.ICustomerpersonalupdate.CustomerReferencedetailsUpdatedetails(customerpersonaldetails));
}
public int CustomerPersonalUpdateEducationdetail([FromBody] JObject Cedetails)
{
CutomerEducationdetails customerEducation = Cedetails["customerEducation"].ToObject <CutomerEducationdetails>();
UpdatePersonaldetails customerpersonaldetails = Cedetails["customerpersonaldetails"].ToObject <UpdatePersonaldetails>();
customerEducation.Passofyear = customerEducation.Passofyear != 0 ? customerEducation.Passofyear : null;
List <CutomerEducationdetails> listEdu = new List <CutomerEducationdetails>();
listEdu.Add(customerEducation);
customerpersonaldetails.dtTableValues = Commonclass.returnListDatatable(PersonaldetailsUDTables.createEducationdataTable(), listEdu);
return(this.ICustomerpersonalupdate.getEducationdetails_Updatecustomer(customerpersonaldetails));
}
public int DgetCustomerRegProfileDetails_Myprofile(UpdatePersonaldetails Mobj, string spName)
{
ArrayList arrayList = new ArrayList();
SqlParameter[] parm = new SqlParameter[5];
SqlDataReader reader = null;
int intStatus = 0;
SqlConnection connection = new SqlConnection();
connection = SQLHelper.GetSQLConnection();
connection.Open();
try
{
parm[0] = new SqlParameter("@CustomerID", SqlDbType.Int);
parm[0].Value = Mobj.intCusID;
parm[1] = new SqlParameter("@t_CustProfileDetails", SqlDbType.Structured);
parm[1].Value = Mobj.dtTableValues;
parm[2] = new SqlParameter("@ErrorMsg", SqlDbType.VarChar, 1000);
parm[2].Direction = ParameterDirection.Output;
parm[3] = new SqlParameter("@i_Status", SqlDbType.Int);
parm[3].Direction = ParameterDirection.Output;
reader = SQLHelper.ExecuteReader(connection, CommandType.StoredProcedure, spName, parm);
reader.Close();
if (string.Compare(parm[3].Value.ToString(), System.DBNull.Value.ToString()) != 0)
{
intStatus = Convert.ToInt32(parm[3].Value);
}
else
{
intStatus = 0;
}
}
catch (Exception EX)
{
Commonclass.ApplicationErrorLog(spName, Convert.ToString(EX.Message), Mobj.intCusID, null, null);
}
finally
{
connection.Close();
}
return(intStatus);
}
public int CustomerRegProfileDetails_Myprofile(UpdatePersonaldetails Mobj)
{
return(new RegistrationDAL().DgetCustomerRegProfileDetails_Myprofile(Mobj, "[dbo].[usp_CustomerRegProfiledetails-Customer_NewDesign]"));
}
public int CustomerPropertyUpdatedetails(UpdatePersonaldetails MobjProf)
{
return(customerdetails.DCustomerPersonal_insertUpdateDetails(MobjProf, "[dbo].[usp_Customer_PropertySubmit]", "@dtPropertyCustomerEdit"));
}
} //usp_emplanding_counts_Admin_New
public int UpdateSpoucedetails_Customersetails(UpdatePersonaldetails customerpersonaldetails)
{
return(customerdetails.UpdateSpoucedetails_Customersetails(customerpersonaldetails, "[dbo].[usp_edit_Spoucedetails_CustomerEdit]"));
}
public ArrayList Savephotosofcustomer(UpdatePersonaldetails savePhoto)
{
return(customerdetails.Savephotosofcustomer(savePhoto, "[dbo].[usp_Edit_Photoupload_forCustomer]"));
}
public int CustomerReferencedetailsUpdatedetails(UpdatePersonaldetails MobjProf)
{
return(customerdetails.DCustomerPersonal_insertUpdateDetails(MobjProf, "[dbo].[usp_edit_Refrencedetails_CustomerEdit]", "@dtCustomerRefdetails"));
}
public int CustomerMotherSisterUpdatedetails(UpdatePersonaldetails MobjProf)
{
return(customerdetails.DCustomerPersonal_insertUpdateDetails(MobjProf, "[dbo].[usp_edit_MotherSisterDetails_CustomerEdit_NewDesign]", "@dtMotherSisterDetails"));
}
public int CustomerFathersBrotherUpdatedetails(UpdatePersonaldetails MobjProf)
{
return(customerdetails.DCustomerPersonal_insertUpdateDetails(MobjProf, "[dbo].[usp_edit_FathersBrotherDetails_CustomerEdit_NewDesign]", "@dtFatherBrotherRel"));
}
public int CustomerPartnerPreferencesUpdatedetails(UpdatePersonaldetails MobjProf)
{
return(customerdetails.DCustomerPersonal_insertUpdateDetails(MobjProf, "[dbo].[usp_edit_PartnerPreferences_EmployeeEdit]", "@dtPartnerPreferences"));
} //usp_edit_PartnerPreferences_CustomerEdit replaced Sp(23_02_2018)
public int CustomerContactAddressUpdatedetails(UpdatePersonaldetails MobjProf)
{
return(customerdetails.DCustomerPersonal_insertUpdateDetails(MobjProf, "[dbo].[usp_edit_ContactAddress_CustomerEdit]", "@dtParentContactAddress"));
}
} //usp_edit_PartnerPreferences_CustomerEdit replaced Sp(23_02_2018)
public int CustomerSibBrotherUpdatedetails(UpdatePersonaldetails MobjProf)
{
return(customerdetails.DCustomerPersonal_insertUpdateDetails(MobjProf, "[dbo].[usp_edit_SibblingBrother_CustomerEdit_NewDesign]", "@dtsibBrotherdetails"));
}
public int getProfessionDetails_Customer(UpdatePersonaldetails MobjProf)
{
return(customerdetails.DCustomerPersonal_insertUpdateDetails(MobjProf, "[dbo].[usp_edit_Profession_CustomerEdit]", "@dtprofessiondetails"));
}
public int CustomerPhysicalAttributesUpdatedetails(UpdatePersonaldetails MobjProf)
{
return(customerdetails.DCustomerPersonal_insertUpdateDetails(MobjProf, "[dbo].[usp_edit_ParentphysicalHealth_CustomerEdit]", "@dtParentPhysicalhealth"));
}
public int UpdateSpouseChildDetails(UpdatePersonaldetails customerpersonaldetails)
{
return(customerdetails.UpdateSpouseChildDetails(customerpersonaldetails, "[dbo].[usp_edit_SpoucedetailsChildern_CustomerEdit_NewDesign]"));
}
public int CustomerParentUpdatedetails(UpdatePersonaldetails MobjProf)
{
return(customerdetails.DCustomerPersonal_insertUpdateDetails(MobjProf, "[dbo].[usp_edit_ParenentFatherMother_CustomerEdit]", "@dtParentFathermother"));
}
public int UpdatePersonalDetails_Customersetails(UpdatePersonaldetails customerpersonaldetails)
{
return(customerdetails.UpdatePersonalDetails_Customersetails(customerpersonaldetails, "[dbo].[usp_edit_Personaldetailsupdate_NewDesign]"));
}
public int getEducationdetails_Updatecustomer(UpdatePersonaldetails MobjEdudetails)
{
return(customerdetails.DCustomerPersonal_insertUpdateDetails(MobjEdudetails, "[dbo].[usp_edit_updateEducion_CustomerEdit]", "@dtEducationdetails"));
}
