public long SaveDomesticIns(DomesticModel objDomesticIns)
{
long returnCode = -1;
using (TransactionScope transactionScope = new TransactionScope())
{
try
{
returnCode = objMotorAppDAL.SaveDomesticIns(objDomesticIns);
transactionScope.Complete();
transactionScope.Dispose();
}
catch (Exception ex)
{
transactionScope.Dispose();
throw ex;
}
return(returnCode);
}
}
public DataTable ConvertToDomestic(DomesticModel _objDomesticIns)
{
try
{
DataTable _dt = new DataTable();
_dt.Columns.Add("DraftNo", typeof(string));
_dt.Columns.Add("PolicyNo", typeof(string));
_dt.Columns.Add("IssueDate", typeof(DateTime));
_dt.Columns.Add("Branch", typeof(string));
_dt.Columns.Add("PolicyStartDate", typeof(DateTime));
_dt.Columns.Add("PolicyEndDate", typeof(DateTime));
_dt.Columns.Add("NoofYears", typeof(int));
_dt.Columns.Add("Marketer", typeof(string));
_dt.Columns.Add("Broker_AgentCode", typeof(string));
_dt.Columns.Add("IssueFrom", typeof(string));
_dt.Columns.Add("SpecialDiscount", typeof(string));
_dt.Columns.Add("Amount", typeof(long));
_dt.Columns.Add("AssuredName", typeof(string));
_dt.Columns.Add("AssuredName_Arabic", typeof(string));
_dt.Columns.Add("CivilID", typeof(long));
_dt.Columns.Add("PostBox", typeof(long));
_dt.Columns.Add("PostalCode", typeof(long));
_dt.Columns.Add("City", typeof(string));
_dt.Columns.Add("ResPhoneNo", typeof(long));
_dt.Columns.Add("OfficePhoneNo", typeof(long));
_dt.Columns.Add("MobileNo", typeof(long));
_dt.Columns.Add("HelperProfession", typeof(string));
_dt.Columns.Add("Gender", typeof(string));
_dt.Columns.Add("DateofBirth", typeof(DateTime));
_dt.Columns.Add("Age", typeof(int));
_dt.Columns.Add("PassportNo", typeof(long));
_dt.Columns.Add("Nationality", typeof(string));
_dt.Columns.Add("MazayaCard", typeof(string));
_dt.Columns.Add("SameasHouseMaidAddress", typeof(string));
_dt.Columns.Add("Sponsor_ProposerName", typeof(string));
_dt.Columns.Add("SponsorPostBox", typeof(long));
_dt.Columns.Add("SponsorPostalCode", typeof(long));
_dt.Columns.Add("SponsorCity", typeof(string));
_dt.Columns.Add("SponsorMobileNo", typeof(long));
_dt.Columns.Add("SponsorOfficePhone", typeof(long));
_dt.Columns.Add("SponsorNationality", typeof(string));
_dt.Columns.Add("VIPCustomer", typeof(string));
_dt.Columns.Add("Email", typeof(string));
DataRow _dr;
_dr = _dt.NewRow();
_dr["DraftNo"] = _objDomesticIns.DraftNo;
_dr["PolicyNo"] = _objDomesticIns.PolicyNo;
_dr["IssueDate"] = _objDomesticIns.IssueDate;
_dr["Branch"] = _objDomesticIns.Branch;
_dr["PolicyStartDate"] = _objDomesticIns.PolicyStartDate;
_dr["PolicyEndDate"] = _objDomesticIns.PolicyEndDate;
_dr["NoofYears"] = _objDomesticIns.NoofYears;
_dr["Marketer"] = _objDomesticIns.Marketer;
_dr["Broker_AgentCode"] = _objDomesticIns.Broker_AgentCode;
_dr["IssueFrom"] = _objDomesticIns.IssueFrom;
_dr["SpecialDiscount"] = _objDomesticIns.SpecialDiscount;
_dr["Amount"] = _objDomesticIns.Amount;
_dr["AssuredName"] = _objDomesticIns.AssuredName;
_dr["AssuredName_Arabic"] = _objDomesticIns.AssuredName_Arabic;
_dr["CivilID"] = _objDomesticIns.CivilID;
_dr["PostBox"] = _objDomesticIns.PostBox;
_dr["PostalCode"] = _objDomesticIns.PostalCode;
_dr["City"] = _objDomesticIns.City;
_dr["ResPhoneNo"] = _objDomesticIns.ResPhoneNo;
_dr["OfficePhoneNo"] = _objDomesticIns.OfficePhoneNo;
_dr["MobileNo"] = _objDomesticIns.MobileNo;
_dr["HelperProfession"] = _objDomesticIns.HelperProfession;
_dr["Gender"] = _objDomesticIns.Gender;
_dr["DateofBirth"] = _objDomesticIns.DateofBirth;
_dr["Age"] = _objDomesticIns.Age;
_dr["PassportNo"] = _objDomesticIns.PassportNo;
_dr["Nationality"] = _objDomesticIns.Nationality;
_dr["MazayaCard"] = _objDomesticIns.MazayaCard;
_dr["SameasHouseMaidAddress"] = _objDomesticIns.SameasHouseMaidAddress;
_dr["Sponsor_ProposerName"] = _objDomesticIns.Sponsor_ProposerName;
_dr["SponsorPostBox"] = _objDomesticIns.SponsorPostBox;
_dr["SponsorPostalCode"] = _objDomesticIns.SponsorPostalCode;
_dr["SponsorCity"] = _objDomesticIns.SponsorCity;
_dr["SponsorMobileNo"] = _objDomesticIns.SponsorMobileNo;
_dr["SponsorOfficePhone"] = _objDomesticIns.SponsorOfficePhone;
_dr["SponsorNationality"] = _objDomesticIns.SponsorNationality;
_dr["VIPCustomer"] = _objDomesticIns.VIPCustomer;
_dr["Email"] = _objDomesticIns.Email;
_dt.Rows.Add(_dr);
return(_dt);
}
catch (Exception ex)
{
throw ex;
}
}