public DataSet getUnderwriterList(clsUnderWriterMaster objUnderwriter)
{
dataAccess = new DataAccess();
Object[] parameters = new Object[2] {
objUnderwriter.UnderWriterId, objUnderwriter.UnderwriterForModule
};
return(dataAccess.LoadDataSet(parameters, "P_pol_UnderwriterMaster_Select", "UnderwriterMasterList"));
}
//
public DataSet SaveUnderwriterHiostory(clsUnderWriterMaster objU)
{
dataAccess = new DataAccess();
Object[] parameters = new Object[5] {
objU.UnderWriterId, objU.UnderwriterName, objU.UnderwriterCode, objU.UnderwriterShortName, objU.RecId
};
return(dataAccess.LoadDataSet(parameters, "P_pol_UnderwriterMasterHistory_InsertUpdate", "ClientHistory"));
}
public DataSet getApprovedUnderwriterListNew(clsUnderWriterMaster objUnderwriter, string process, string scrvl)
{
dataAccess = new DataAccess();
Object[] parameters = new Object[6] {
objUnderwriter.UnderWriterId, objUnderwriter.UnderwriterForModule, objUnderwriter.LoginUserId, null, process, scrvl
};
//Object[] parameters = new Object[3] { objSOB.SOBId, objSOB.SOBName, objSOB.Status };
return(dataAccess.LoadDataSet(parameters, "P_Underwriter_ApprovedInfo_New_Select", "UnderwriterMasterList"));
}
public DataSet SaveUnderwriter(clsUnderWriterMaster objUnderwriter)
{
dataAccess = new DataAccess();
Object[] parameters = new Object[] {//objUnderwriter.RecId,
objUnderwriter.UnderWriterId,
objUnderwriter.UnderwriterCode,
objUnderwriter.UnderwriterName,
objUnderwriter.UnderwriterShortName,
objUnderwriter.PreviousCode,
objUnderwriter.CorporateGroup,
objUnderwriter.Branch,
objUnderwriter.Region,
objUnderwriter.IType,
objUnderwriter.InsurerTypeId,
objUnderwriter.GSTRegistrationNumber,
objUnderwriter.ChUnderwriterName,
objUnderwriter.UnderwriterForModule,
objUnderwriter.CorrAddress1,
objUnderwriter.CorrAddress2,
objUnderwriter.CorrAddress3,
objUnderwriter.ChCorrAddress1,
objUnderwriter.ChCorrAddress2,
objUnderwriter.ChCorrAddress3,
objUnderwriter.Country,
objUnderwriter.BillingAddress1,
objUnderwriter.BillingAddress2,
objUnderwriter.BillingAddress3,
objUnderwriter.ChBillingAddress1,
objUnderwriter.ChBillingAddress2,
objUnderwriter.ChBillingAddress3,
objUnderwriter.BillingCountry,
objUnderwriter.Description,
objUnderwriter.RecordType,
objUnderwriter.SameCorrAddress,
objUnderwriter.SameChCorrAddress,
objUnderwriter.CompanyRegistrationNo,
objUnderwriter.BusinessRegistrationNo,
objUnderwriter.RegistrationDate,
objUnderwriter.GeneralLineCode,
objUnderwriter.GeneralLineNo,
objUnderwriter.FaxNoCode,
objUnderwriter.FaxNo,
objUnderwriter.CompanyEmail,
objUnderwriter.AccountType,
objUnderwriter.NormalBalance,
objUnderwriter.CreditControlAccountNo,
objUnderwriter.Remarks,
objUnderwriter.Level1ApprovedBy,
objUnderwriter.Level1ApprovedDate,
objUnderwriter.Level2ApprovedBy,
objUnderwriter.Level2ApprovedDate,
objUnderwriter.Level3ApprovedBy,
objUnderwriter.Level3ApprovedDate,
objUnderwriter.AdminApprovedBy,
objUnderwriter.AdminApprovedDate,
objUnderwriter.EffFromDate,
objUnderwriter.EffToDate,
//objSOB.Status,
objUnderwriter.LoginUserId,
objUnderwriter.Premium_Settlement,
objUnderwriter.City,
objUnderwriter.Province,
objUnderwriter.PostalCode,
objUnderwriter.ChCity,
objUnderwriter.ChProvince,
objUnderwriter.ChPostalCode,
objUnderwriter.BillingCity,
objUnderwriter.BillingProvince,
objUnderwriter.BillingPostalCode,
objUnderwriter.ChBillingCity,
objUnderwriter.ChBillingProvince,
objUnderwriter.ChBillingPostalCode,
objUnderwriter.GlCode,
objUnderwriter.BankCode,
objUnderwriter.SubDistrict,
objUnderwriter.ChSubDistrict,
objUnderwriter.BillingSubDistrict,
objUnderwriter.ChBillingSubDistrict,
objUnderwriter.ProfitCentre,
objUnderwriter.FundCode,
//objClient.PageMethod
objUnderwriter.SecurityGrading,
objUnderwriter.GSTApplicable,
objUnderwriter.WHTApplicable,
objUnderwriter.VATApplicable,
objUnderwriter.Offshore
};
//return dataAccess.LoadDataSet(parameters, "P_pol_ClientMaster_InsertUpdate", "ClientMaster");
return(dataAccess.LoadDataSet(parameters, "P_UnderwriterApprovedInfo_InsertUpdate", "UnderwriterMaster"));
}
