public DataSet GetunderwriterStatus(clsUnApprovedInfo objUnApproved)
{
dataAccess = new DataAccess();
Object[] parameters = new Object[] { objUnApproved.RecForId, objUnApproved.RecId, };
return(dataAccess.LoadDataSet(parameters, "P_GetUnderwriterStatus", "Status"));
}
public DataSet LoadPaymentForAgent(clsUnApprovedInfo objUnApproved)
{
dataAccess = new DataAccess();
Object[] parameters = new Object[6] {
objUnApproved.RecId, objUnApproved.RecForType, objUnApproved.AppStatus, objUnApproved.AppStatus1, objUnApproved.LoginUserId, null
};
return(dataAccess.LoadDataSet(parameters, "P_pol_PaymentForAgentDetails_Select", "UnApprovedAgentList"));
}
public DataSet getBankDetailList(clsUnApprovedInfo objUnApproved)
{
dataAccess = new DataAccess();
Object[] parameters = new Object[2] {
objUnApproved.BankCode, objUnApproved.BankName
};
return(dataAccess.LoadDataSet(parameters, "P_BankDetail_Select", "BankDetailList"));
}
public DataSet getGLDetailList(clsUnApprovedInfo objUnApproved)
{
dataAccess = new DataAccess();
Object[] parameters = new Object[2] {
objUnApproved.GLCode, objUnApproved.GLCodeDesc
};
return(dataAccess.LoadDataSet(parameters, "P_GLDetail_Select", "GLDetailList"));
}
public DataSet GetApprovedInfoDetails(clsUnApprovedInfo objUnApproved, string strProcess, string strscrval)
{
dataAccess = new DataAccess();
Object[] parameters = new Object[6] {
objUnApproved.RecId, objUnApproved.RecForModule, objUnApproved.LoginUserId, objUnApproved.AppStatus, strProcess, strscrval
};
return(dataAccess.LoadDataSet(parameters, "P_Reinsurer_ApprovedInfo_Select", "ApprovalDetails"));
}
public DataSet GetApprovalDetails(clsUnApprovedInfo objUnApproved)
{
dataAccess = new DataAccess();
Object[] parameters = new Object[2] {
objUnApproved.RecId, objUnApproved.AppStatus
};
return(dataAccess.LoadDataSet(parameters, "P_GetApprovalDetails", "ApprovalDetails"));
}
public DataSet LoadAgentDetail(clsUnApprovedInfo objUnApproved)
{
dataAccess = new DataAccess();
Object[] parameters = new Object[6] {
objUnApproved.RecId, objUnApproved.RecordFor, objUnApproved.AppStatus, objUnApproved.AppStatus1, objUnApproved.LoginUserId, objUnApproved.scrval
};
return(dataAccess.LoadDataSet(parameters, "P_pol_Agent_UnApprovedInfo_Select", "UnApprovedAgentList"));
}
public DataSet getUnApprovedUWList(clsUnApprovedInfo objUnApproved)
{
dataAccess = new DataAccess();
Object[] parameters = new Object[5] {
objUnApproved.RecId, objUnApproved.RecForModule, objUnApproved.ApprovingAuthority1, objUnApproved.AppStatus, objUnApproved.RecForType
};
return(dataAccess.LoadDataSet(parameters, "P_Underwriter_UnApprovedInfo_Select", "UnderwriterList"));
}
public DataSet getUnApprovClientList(clsUnApprovedInfo objUnApproved)
{
dataAccess = new DataAccess();
Object[] parameters = new Object[6] {
objUnApproved.RecId, objUnApproved.RecForModule, null, null, null, null
};
//Object[] parameters = new Object[3] { objSOB.SOBId, objSOB.SOBName, objSOB.Status };
return(dataAccess.LoadDataSet(parameters, "P_UnApprovedInfo_Select", "UnApprovedClientList"));
}
// Added By Gopal For Gl Code Pop Up
public DataSet getGlCodeList(clsUnApprovedInfo objUnApproved)
{
dataAccess = new DataAccess();
Object[] parameters = new Object[3] {
objUnApproved.RecId, objUnApproved.RecForModule, null
};
return(dataAccess.LoadDataSet(parameters, "P_UnApprovedInfo_ClientSelect", "UnApprovedClientList"));
}
public DataSet GetMasterClient(clsUnApprovedInfo objUnApproved)
{
dataAccess = new DataAccess();
Object[] parameters = new Object[3] {
objUnApproved.RecId, objUnApproved.RecForModule, null
};
return(dataAccess.LoadDataSet(parameters, "P_GetMasterClient", "GetMasterClient"));
}
//
public DataSet getUnApprovConvertPotentialClientList(clsUnApprovedInfo objUnApproved)
{
dataAccess = new DataAccess();
Object[] parameters = new Object[3] {
objUnApproved.RecId, objUnApproved.RecForModule, objUnApproved.ClientType
};
//Object[] parameters = new Object[3] { objSOB.SOBId, objSOB.SOBName, objSOB.Status };
return(dataAccess.LoadDataSet(parameters, "P_UnApprovedInfo_Select_potentail", "UnApprovedClientList"));
}
public DataSet getUnApprovClientCopydetails(clsUnApprovedInfo objUnApproved)
{
dataAccess = new DataAccess();
Object[] parameters = new Object[3] {
objUnApproved.Code, objUnApproved.RecForModule, null
};
return(dataAccess.LoadDataSet(parameters, "P_ClientInfo_SelectByCode", "UnApprovedClientList"));
}
public DataSet getUnApprovCedantList(clsUnApprovedInfo objUnApproved)
{
dataAccess = new DataAccess();
//Object[] parameters = new Object[2] { objUnApproved.RecId, objUnApproved.RecForModule};
Object[] parameters = new Object[5] {
objUnApproved.RecId, objUnApproved.ApprovingAuthority1, objUnApproved.RecForModule, objUnApproved.AppStatus, objUnApproved.RecordFor
};
return(dataAccess.LoadDataSet(parameters, "P_Cedant_UnApprovedInfo_Select", "CedantList"));
}
public DataSet getApprovCedantList(clsUnApprovedInfo objUnApproved, string process, string scrval)
{
dataAccess = new DataAccess();
//Object[] parameters = new Object[2] { objUnApproved.RecId, objUnApproved.RecForModule};
Object[] parameters = new Object[6] {
objUnApproved.RecId, objUnApproved.CedantForModule, objUnApproved.LoginUserId, objUnApproved.AppStatus, process, scrval
};
return(dataAccess.LoadDataSet(parameters, "P_Cedant_ApprovedInfo_Select", "CedantList"));
}
public DataSet getUnApprovReinsurerList(clsUnApprovedInfo objUnApproved)
{
dataAccess = new DataAccess();
Object[] parameters = new Object[5] {
objUnApproved.RecId, objUnApproved.RecForModule, objUnApproved.ApprovingAuthority1, objUnApproved.AppStatus, objUnApproved.RecordFor
};
//Object[] parameters = new Object[3] { objSOB.SOBId, objSOB.SOBName, objSOB.Status };
return(dataAccess.LoadDataSet(parameters, "P_Reinsurer_UnApprovedInfo_Select", "ReinsurerList"));
}
public DataSet getUnApprovPotentialClientList(clsUnApprovedInfo objUnApproved)
{
dataAccess = new DataAccess();
Object[] parameters = new Object[6] {
objUnApproved.RecId, objUnApproved.RecForModule, objUnApproved.ClientType, objUnApproved.ClientShortName, objUnApproved.ClientSourceCode, objUnApproved.CorporateGroupType
};
//Object[] parameters = new Object[3] { objSOB.SOBId, objSOB.SOBName, objSOB.Status };
return(dataAccess.LoadDataSet(parameters, "P_UnApprovedInfo_Select", "UnApprovedClientList"));
}
//public DataSet SaveAgentContact(clsContacts objContact)
//{
// dataAccess = new DataAccess();
// Object[] parameters = new Object[] {objContact.ContactId,
// objContact.Id,
// objContact.LastName,
// objContact.ChLastName,
// objContact.FirstName,
// objContact.ChFirstName,
// objContact.JobTitle,
// objContact.ChJobTitle,
// objContact.Department,
// objContact.ChDepartment,
// objContact.ContactCorrAddress1,
// objContact.ContactCorrAddress2,
// objContact.ContactCorrAddress3,
// objContact.ChContactCorrAddress1,
// objContact.ChContactCorrAddress2,
// objContact.ChContactCorrAddress3,
// objContact.ContactCountry,
// objContact.ChContactCountry,
// objContact.Team,
// //objContact.Dob,
// objAgent.GeneralLineCode,
// objContact.GeneralLineNo,
// objContact.Extension,
// objContact.Salutation,
// objContact.ChSalutation,
// objContact.MobileNoCode,
// objContact.MobileNo,
// objContact.FaxNoCode,
// objContact.FaxNo,
// objContact.Email,
// objAgent.EffFromDate,
// objAgent.EffToDate,
// objAgent.LoginUserId,
// objAgent.PageMethod
// };
// return dataAccess.LoadDataSet(parameters, "P_Contacts_ApprovedInfo_InsertUpdate", "AgentContacts");
//}
//public DataSet SaveApprovedContacts(clsContacts objContacts)
//{
// dataAccess = new DataAccess();
// Object[] parameters = new Object[] {objContacts.Id
// };
// return dataAccess.LoadDataSet(parameters, "P_SaveApprovedContacts", "ApprovedContacts");
//}
public DataSet ChangeStatus(clsUnApprovedInfo objUnApproved)
{
dataAccess = new DataAccess();
Object[] parameters = new Object[] { objUnApproved.RecForType,
objUnApproved.RecForId,
objUnApproved.AppStatus,
objUnApproved.RecordFor,
objUnApproved.RecId,
objUnApproved.LoginUserId,
null };
return(dataAccess.LoadDataSet(parameters, "P_ChangeRequestStatus", "Status"));
}
public DataSet ChangeStatus(clsUnApprovedInfo objUnApproved)
{
dataAccess = new DataAccess();
Object[] parameters = new Object[] { objUnApproved.RecForType,
objUnApproved.RecForId,
objUnApproved.AppStatus,
objUnApproved.RecordFor,
objUnApproved.RecId,
objUnApproved.LoginUserId,
objUnApproved.Code };
return(dataAccess.LoadDataSet(parameters, "P_ChangeRequestStatus", "Status"));
//return dataAccess.ExecuteNonQuery("P_ChangeRequestStatus", parameters);
//return dataAccess.LoadDataSet(parameters, "P_ConfirmRequest", "ConfirmRequest");
}
public DataSet SavePotentialClientInfo(clsUnApprovedInfo objUnApproved)
{
dataAccess = new DataAccess();
Object[] parameters = new Object[] { objUnApproved.RecId,
objUnApproved.RecForType,
objUnApproved.RecordFor,
objUnApproved.RecForId,
objUnApproved.RecForModule,
objUnApproved.AppliedBy,
objUnApproved.AppStatus,
objUnApproved.LoginUserId,
objUnApproved.RecData,
objUnApproved.PageMethod,
objUnApproved.Code };
return(dataAccess.LoadDataSet(parameters, "P_PotentialClient_InsertUpdate", "UnApprovedClientInfo"));
}
public Boolean CheckClientNameExists(clsUnApprovedInfo objUnApproved)
{
dataAccess = new DataAccess();
Object[] parameters = new Object[] { objUnApproved.RecId,
objUnApproved.RecForType,
objUnApproved.RecordFor,
objUnApproved.RecForId,
objUnApproved.RecForModule,
objUnApproved.AppliedBy,
objUnApproved.AppStatus,
objUnApproved.LoginUserId,
objUnApproved.RecData,
objUnApproved.PageMethod,
objUnApproved.Code };
return(Convert.ToBoolean(dataAccess.GetScalarValue(parameters, "P_CheckClientNameExists")));
}
private DataSet ApproveClient(object objEntity)
{
string strMessage = "";
clsUnApprovedInfo objXMLEntity = (clsUnApprovedInfo)(objEntity);
// implement the logic here
clsClientMaster objClient = new clsClientMaster();
clsClientManager objClientBI = new clsClientManager();
DataSet dsApprove = new DataSet();
clsXmlUnApprovedInfo xmlInfo = new clsXmlUnApprovedInfo();
xmlInfo = (clsXmlUnApprovedInfo)BusinessObjectLayer.Common.SerializeDeserialize.DeserializeAnObject(objXMLEntity.RecData, xmlInfo.GetType());
DataMapper.Map(xmlInfo, objClient, false, "RecData");
if (ProcessMasterInfo.EntityStatus == CLIENT_STATUS_APPROVED)
{
objClient.RecId = 0;
objClient.ClientId = objXMLEntity.RecForId;
objClient.ClientForModule = objXMLEntity.RecForModule;
objClient.ClientCode = objXMLEntity.Code;
dsApprove = objClientBI.SaveClient(objClient);
strMessage = Convert.ToString(dsApprove.Tables[0].Rows[0][0]);
#region Save Contacts
ClientContacts objContacts = new ClientContacts();
objContacts.ClientId = objXMLEntity.RecForId;
objContacts.ClientForModule = objXMLEntity.RecForModule;
DataSet dsContacts = objClientBI.SaveApprovedContacts(objContacts);
if (dsContacts.Tables[0].Rows[0][0].ToString().ToLower().IndexOf("success") > 0)
{
strMessage = strMessage + "<br>" + Convert.ToString(dsContacts.Tables[0].Rows[0][0]);
}
#endregion
}
//else
// dsApprove = objClientBI.SaveUnApprovedInfo(objClient);
objClientBI = null;
xmlInfo = null;
return(dsApprove);
}
public override DataSet Approve(object objEntity)
{
clsUnApprovedInfo objXmlEntity = (clsUnApprovedInfo)(objEntity);
EntityProcesses objProcess = base.getProcessObject(objXmlEntity.LoginUserId, EntityType.CLIENT, objXmlEntity.AppStatus, objXmlEntity.RecForId.ToString(), "1");
//{
// EntityCurrentStatus = "",
// EntityNewVersionID ="",
// EntityPreviousStatus = "",
// EntityVersionID ="",
// ProcessID =1,
// ProcessRowId =-1,
// Reason ="",
// Remarks ="",
// SentTO = ""
//};
try
{
base.BeginTransaction();
if (base.StartProcess(objProcess))
{
DataSet dsClient = ApproveClient(objEntity);
base.CommitProcess(objProcess);
base.CommitTransaction();
return(dsClient);
}
else
{
// base.RollbackProcess(objProcess, EntityType.RECEIPT.ToString());
throw (new Exception("Client Can not be approved. Error: Process is not eligible on this entity status."));
}
}
catch (Exception ex)
{
base.RollbackProcess(objProcess, EntityType.CLIENT.ToString());
throw (new Exception("Client Can not be approved. Error: " + ex.Message));
}
}