public DataTable creataTableForSwitch(List <OnlineMFOrderVo> lsonlinemforder)
{
OnlineMFOrderVo onlineMFOrderVo = new OnlineMFOrderVo();
DataTable dtSwitchOrder = new DataTable();
dtSwitchOrder.Columns.Add("CMFSO_AccountId");
dtSwitchOrder.Columns.Add("CMFSO_SchemePlanCode");
dtSwitchOrder.Columns.Add("CMFSO_Amount");
dtSwitchOrder.Columns.Add("CMFSO_TransactionType");
dtSwitchOrder.Columns.Add("CMFSO_DivOption");
dtSwitchOrder.Columns.Add("CO_OrderId");
DataRow drOrderDetails;
for (int i = 0; i < lsonlinemforder.Count; i++)
{
onlineMFOrderVo = lsonlinemforder[i];
drOrderDetails = dtSwitchOrder.NewRow();
drOrderDetails["CMFSO_AccountId"] = onlineMFOrderVo.AccountId.ToString();
drOrderDetails["CMFSO_SchemePlanCode"] = onlineMFOrderVo.SchemePlanCode.ToString();
drOrderDetails["CMFSO_Amount"] = onlineMFOrderVo.Amount.ToString();
drOrderDetails["CMFSO_TransactionType"] = onlineMFOrderVo.TransactionType.ToString();
if (onlineMFOrderVo.DivOption == string.Empty)
{
drOrderDetails["CMFSO_DivOption"] = onlineMFOrderVo.DivOption.ToString();
}
else
{
drOrderDetails["CMFSO_DivOption"] = null;
}
dtSwitchOrder.Rows.Add(drOrderDetails);
}
return(dtSwitchOrder);
}
protected void BindSipDetailsForEdit()
{
SipDataForOrderEditList = new List <OnlineMFOrderVo>();
SipDataForOrderEditList = commonLookupBo.GetAllSIPDataForOrderEdit(orderIdForEdit, customerIdforEdit);
onlineMFOrderVo = (OnlineMFOrderVo)SipDataForOrderEditList[0];
BindEachControlForEditWithVo();
}
public OnlineMFOrderVo GetOrderDetails(int Id)
{
OnlineMFOrderVo onlinemforderVo = new OnlineMFOrderVo();
OnlineMFOrderDao OnlineMFOrderDao = new OnlineMFOrderDao();
try
{
onlinemforderVo = OnlineMFOrderDao.GetOrderDetails(Id);
}
catch (BaseApplicationException Ex)
{
throw (Ex);
}
return(onlinemforderVo);
}
public List <int> CreateCustomerOnlineMFOrderDetails(OnlineMFOrderVo onlinemforderVo, int UserId, int CustomerId)
{
List <int> orderIds = new List <int>();
OnlineMFOrderDao onlineOrderdao = new OnlineMFOrderDao();
try
{
orderIds = onlineOrderdao.CreateCustomerOnlineMFOrderDetails(onlinemforderVo, UserId, CustomerId);
}
catch (BaseApplicationException Ex)
{
throw Ex;
}
return(orderIds);
}
public IDictionary <string, string> CreateOrderMFSipDetails(OnlineMFOrderVo onlineMFOrderVo, int userId)
{
IDictionary <string, string> sipOrderIds = new Dictionary <string, string>();
OnlineMFOrderDao OnlineMFOrderDao = new OnlineMFOrderDao();
try
{
sipOrderIds = OnlineMFOrderDao.CreateOrderMFSipDetails(onlineMFOrderVo, userId);
}
catch (BaseApplicationException Ex)
{
throw Ex;
}
return(sipOrderIds);
}
private void CreatePurchaseOrderType()
{
OnlineMFOrderVo[] onlinemforderVo = new OnlineMFOrderVo[2];
List <OnlineMFOrderVo> lsonlinemforder = new List <OnlineMFOrderVo>();
onlinemforderVo[0] = new OnlineMFOrderVo();
onlinemforderVo[0].SchemePlanCode = Int32.Parse(ddlScheme.SelectedValue.ToString());
onlinemforderVo[0].AccountId = Int32.Parse(ddlFolio.SelectedValue.ToString());
List <int> OrderIds = new List <int>();
if (!string.IsNullOrEmpty(lblAmtVale.Text.ToString()))
{
onlinemforderVo[0].Amount = double.Parse(txtSwitchAmnt.Text.ToString());
}
else
{
onlinemforderVo[0].Amount = 0.0;
}
onlinemforderVo[0].TransactionType = "SO";
lsonlinemforder.Add(onlinemforderVo[0]);
onlinemforderVo[1] = new OnlineMFOrderVo();
onlinemforderVo[1].AccountId = int.Parse(ddlSwitchFolio.SelectedValue.ToString());
onlinemforderVo[1].SchemePlanCode = int.Parse(ddlSchemeName.SelectedValue.ToString());
onlinemforderVo[1].Amount = int.Parse(txtSwitchAmnt.Text.ToString());
onlinemforderVo[1].DivOption = ddlSwitchDvdnType.SelectedValue.ToString();
onlinemforderVo[1].TransactionType = "SI";
string message = string.Empty;
lsonlinemforder.Add(onlinemforderVo[1]);
OrderIds = onlineMforderBo.CreateOnlineMFSwitchOrderDetails(lsonlinemforder, (BackOfficeUserId != 0) ? BackOfficeUserId : userVo.UserId, customerVo.CustomerId);
OrderId = int.Parse(OrderIds[0].ToString());
char msgType = 's';
ShowMessage(message, msgType);
}
public string BSESIPorderEntryParam(int UserID, string ClientCode, OnlineMFOrderVo onlinemforderVo, int CustomerId, string DematAcctype, out char msgType, out IDictionary <string, string> sipOrderIds)
{
DemoBSEMFOrderEntry.MFOrderEntryClient webOrderEntryClient = new DemoBSEMFOrderEntry.MFOrderEntryClient();
BSEMFSIPOdererVo bseMFSIPOdererVo = new BSEMFSIPOdererVo();
msgType = 'F';
string message = string.Empty;
int systematicId = 0;
int rmsId = 0;
sipOrderIds = null;
try
{
string orderEntryresponse = string.Empty;
string PurchaseType = string.Empty;
string purchase = string.Empty;
OnlineMFOrderDao OnlineMFOrderDao = new OnlineMFOrderDao();
string bseuserID = string.Empty;
string bsepass = string.Empty;
bool result = false;
string bseMemberId = string.Empty;
DataSet ds = OnlineMFOrderDao.GetAPICredentials("BSE", 1021);
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
bseuserID = ds.Tables[0].Rows[0]["AEAC_Username"].ToString();
bsepass = ds.Tables[0].Rows[0]["AEAC_Password"].ToString();
bseMemberId = ds.Tables[0].Rows[0]["AEAC_MemberId"].ToString();
}
string passkey = "E234586789D12";
string password = webOrderEntryClient.getPassword(bseuserID, bsepass, passkey);
string[] bsePassArray = password.Split('|');
if (bsePassArray[0].ToString() == "100")
{
if (onlinemforderVo.DividendType != "0" && onlinemforderVo.DividendType != "")
{
onlinemforderVo.BSESchemeCode = OnlineMFOrderDao.BSESchemeCode(onlinemforderVo.SchemePlanCode, onlinemforderVo.DividendType);
}
if (DematAcctype == "CDSL" || DematAcctype == "")
{
DematAcctype = "C";
}
else if (DematAcctype == "NSDL")
{
DematAcctype = "N";
}
bseMFSIPOdererVo.Password = bsePassArray[1];
if (onlinemforderVo.IsCancelled != "True" && onlinemforderVo.IsCancelled == null)
{
bseMFSIPOdererVo.Transactioncode = "NEW";
}
else
{
bseMFSIPOdererVo.Transactioncode = "CXL";
systematicId = onlinemforderVo.SystematicId;
}
bseMFSIPOdererVo.BSEOrderId = 0;
bseMFSIPOdererVo.BSEUserId = bseuserID;
bseMFSIPOdererVo.MemberId = bseMemberId;
bseMFSIPOdererVo.ClientCode = ClientCode;
bseMFSIPOdererVo.SchemeCode = onlinemforderVo.BSESchemeCode;
//bseMFSIPOdererVo.InternalReferenceNo = transCode;
bseMFSIPOdererVo.TransMode = "D";
bseMFSIPOdererVo.DPTransactionMode = DematAcctype;
bseMFSIPOdererVo.StartDate = String.Format("{0:d}", onlinemforderVo.StartDate);
bseMFSIPOdererVo.FrequenceType = GetBSESIPFrequencyCode(onlinemforderVo.FrequencyCode);
bseMFSIPOdererVo.FrequenceAllowed = "1";
bseMFSIPOdererVo.InstallmentAmount = Convert.ToInt16(onlinemforderVo.Amount).ToString();
bseMFSIPOdererVo.NoOfInstallments = onlinemforderVo.TotalInstallments.ToString();
bseMFSIPOdererVo.Remarks = string.Empty;
bseMFSIPOdererVo.FolioNo = string.Empty;// As its demat SIP
bseMFSIPOdererVo.FirstOrderFlag = "Y";
bseMFSIPOdererVo.SubBRCode = string.Empty;
bseMFSIPOdererVo.EUIN = "E116327";
bseMFSIPOdererVo.EUINDeclarationFlag = "Y";
bseMFSIPOdererVo.DPC = "Y";
bseMFSIPOdererVo.REGID = onlinemforderVo.IsCancelled == "True" ? onlinemforderVo.BSEREGID.ToString(): string.Empty;
bseMFSIPOdererVo.IPAddress = string.Empty;
bseMFSIPOdererVo.Password = bsePassArray[1];
bseMFSIPOdererVo.PassKey = passkey;
bseMFSIPOdererVo.Param1 = string.Empty;
bseMFSIPOdererVo.Param2 = string.Empty;
bseMFSIPOdererVo.Param3 = string.Empty;
bseMFSIPOdererVo.MandateId = onlinemforderVo.MandateId.ToString();
Random ran = new Random();
int transCode = OnlineMFOrderDao.BSEMFSIPorderResponseParam(bseMFSIPOdererVo, rmsId, UserID);
bseMFSIPOdererVo.UniqueReferanceNumber = transCode.ToString() + ran.Next().ToString();
bseMFSIPOdererVo.InternalReferenceNo = transCode.ToString();
if (onlinemforderVo.ModeTypeCode == "BXSIP")
{
orderEntryresponse = webOrderEntryClient.xsipOrderEntryParam(bseMFSIPOdererVo.Transactioncode,
bseMFSIPOdererVo.UniqueReferanceNumber, bseMFSIPOdererVo.SchemeCode, bseMFSIPOdererVo.MemberId, bseMFSIPOdererVo.ClientCode, bseMFSIPOdererVo.BSEUserId
, bseMFSIPOdererVo.InternalReferenceNo, bseMFSIPOdererVo.TransMode, bseMFSIPOdererVo.DPTransactionMode
, bseMFSIPOdererVo.StartDate, bseMFSIPOdererVo.FrequenceType, bseMFSIPOdererVo.FrequenceAllowed, bseMFSIPOdererVo.InstallmentAmount
, bseMFSIPOdererVo.NoOfInstallments, bseMFSIPOdererVo.Remarks, bseMFSIPOdererVo.FolioNo, bseMFSIPOdererVo.FirstOrderFlag
, bseMFSIPOdererVo.SubBRCode, bseMFSIPOdererVo.MandateId, bseMFSIPOdererVo.SubBRCode, bseMFSIPOdererVo.EUIN, bseMFSIPOdererVo.EUINDeclarationFlag, bseMFSIPOdererVo.DPC, bseMFSIPOdererVo.REGID
, bseMFSIPOdererVo.IPAddress, bseMFSIPOdererVo.Password, bseMFSIPOdererVo.PassKey,
bseMFSIPOdererVo.Param1, bseMFSIPOdererVo.Param2, bseMFSIPOdererVo.Param3);
}
else if (onlinemforderVo.ModeTypeCode == "BSSIP")
{
orderEntryresponse = webOrderEntryClient.sipOrderEntryParam(bseMFSIPOdererVo.Transactioncode,
bseMFSIPOdererVo.UniqueReferanceNumber, bseMFSIPOdererVo.SchemeCode, bseMFSIPOdererVo.MemberId, bseMFSIPOdererVo.ClientCode, bseMFSIPOdererVo.BSEUserId,
bseMFSIPOdererVo.InternalReferenceNo, bseMFSIPOdererVo.TransMode, bseMFSIPOdererVo.DPTransactionMode,
bseMFSIPOdererVo.StartDate, bseMFSIPOdererVo.FrequenceType, bseMFSIPOdererVo.FrequenceAllowed, bseMFSIPOdererVo.InstallmentAmount,
bseMFSIPOdererVo.NoOfInstallments, bseMFSIPOdererVo.Remarks, bseMFSIPOdererVo.FolioNo, bseMFSIPOdererVo.FirstOrderFlag,
bseMFSIPOdererVo.SubBRCode, bseMFSIPOdererVo.EUIN, bseMFSIPOdererVo.EUINDeclarationFlag, bseMFSIPOdererVo.DPC, bseMFSIPOdererVo.REGID,
bseMFSIPOdererVo.IPAddress, bseMFSIPOdererVo.Password, bseMFSIPOdererVo.PassKey,
bseMFSIPOdererVo.Param1, bseMFSIPOdererVo.Param2, bseMFSIPOdererVo.Param3);
}
string[] bseorderEntryresponseArray = orderEntryresponse.Split('|');
Int64 bseSIPId = 0;
Int64.TryParse(bseorderEntryresponseArray[5], out bseSIPId);
OnlineMFOrderDao.BSEMFSIPorderResponseParam(transCode, UserID, bseSIPId, bseMemberId, ClientCode, bseorderEntryresponseArray[6], bseorderEntryresponseArray[7], rmsId, bseMFSIPOdererVo.UniqueReferanceNumber);
if (bseorderEntryresponseArray[7] == "0")
{
if (onlinemforderVo.ModeTypeCode == "BXSIP" && onlinemforderVo.IsCancelled != "True")
{
OnlineMFOrderDao.UpdateSystematicStep(onlinemforderVo.SystematicId, "IP", UserID);
systematicId = onlinemforderVo.SystematicId;
}
else if (onlinemforderVo.ModeTypeCode == "BSSIP" && onlinemforderVo.IsCancelled != "True")
{
sipOrderIds = CreateOrderMFSipDetails(onlinemforderVo, UserID);
systematicId = Convert.ToInt32(sipOrderIds["SIPId"].ToString());
}
result = OnlineMFOrderDao.BSESIPRequestUpdate(systematicId, transCode);
msgType = 'S';
}
else if (bseorderEntryresponseArray[7] != "0" && onlinemforderVo.ModeTypeCode == "BXSIP")
{
OnlineMFOrderDao.UpdateSystematicStep(onlinemforderVo.SystematicId, "RJ", UserID);
}
message = bseorderEntryresponseArray[6];
//}
//else
//{
// message = "No response from RMS";
//}
}
else
{
message = "Unable to process the order as Exchange is not available for Now.";
}
}
catch (Exception ex)
{
message = "Unable to process the order as Exchange is not available for Now." + ex.Message;
}
finally
{
webOrderEntryClient.Close();
}
return(message);
}
public string BSEorderEntryParam(int UserID, string ClientCode, OnlineMFOrderVo onlinemforderVo, int CustomerId, string DematAcctype, out char msgType)
{
DemoBSEMFOrderEntry.MFOrderEntryClient webOrderEntryClient = new DemoBSEMFOrderEntry.MFOrderEntryClient();
List <int> orderIds = new List <int>();
msgType = 'F';
string message = string.Empty;
bool isRMSDebited = false;
int rmsId = 0;
try
{
string PurchaseType = string.Empty;
string purchase = string.Empty;
OnlineMFOrderDao OnlineMFOrderDao = new OnlineMFOrderDao();
string bseuserID = string.Empty;
string bsepass = string.Empty;
string bseMemberId = string.Empty;
DataSet ds = OnlineMFOrderDao.GetAPICredentials("BSE", 1021);
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
bseuserID = ds.Tables[0].Rows[0]["AEAC_Username"].ToString();
bsepass = ds.Tables[0].Rows[0]["AEAC_Password"].ToString();
bseMemberId = ds.Tables[0].Rows[0]["AEAC_MemberId"].ToString();
}
string passkey = "E234586789D12";
string password = webOrderEntryClient.getPassword(bseuserID, bsepass, passkey);
string[] bsePassArray = password.Split('|');
if (bsePassArray[0].ToString() == "100")
{
if (onlinemforderVo.DividendType != "0" && onlinemforderVo.DividendType != "")
{
onlinemforderVo.BSESchemeCode = OnlineMFOrderDao.BSESchemeCode(onlinemforderVo.SchemePlanCode, onlinemforderVo.DividendType);
}
string allRedeem = "N";
string DPCFlag = "Y";
string Amount = string.Empty;
string Unit = string.Empty;
if (DematAcctype == "CDSL" || DematAcctype == "")
{
DematAcctype = "C";
}
else if (DematAcctype == "NSDL")
{
DematAcctype = "N";
}
if (onlinemforderVo.TransactionType == "BUY")
{
Amount = onlinemforderVo.Amount.ToString();
PurchaseType = "FRESH";
purchase = "P";
}
else if (onlinemforderVo.TransactionType == "ABY")
{
Amount = onlinemforderVo.Amount.ToString();
PurchaseType = "ADDITIONAL";
purchase = "P";
}
else if (onlinemforderVo.TransactionType == "SEL")
{
if (onlinemforderVo.IsAllUnits)
{
allRedeem = "Y";
}
else
{
Unit = onlinemforderVo.Redeemunits.ToString();
}
PurchaseType = "FRESH";
purchase = "R";
DPCFlag = "N";
}
if (onlinemforderVo.TransactionType != "SEL")
{
isRMSDebited = DebitOrCreditRMSUserAccountBalance(UserID, ClientCode, -onlinemforderVo.Amount, rmsId, out rmsId);
}
else if (onlinemforderVo.TransactionType == "SEL")
{
isRMSDebited = true;
}
if (isRMSDebited)
{
int transCode = OnlineMFOrderDao.BSEorderEntryParam("NEW", UserID, ClientCode, onlinemforderVo.BSESchemeCode, purchase, PurchaseType, DematAcctype, Amount, Unit, allRedeem, "", "Y", "", "", "E116327", "Y", "N", DPCFlag, "", rmsId);
string uniqueRefNo;
Random ran = new Random();
uniqueRefNo = transCode.ToString() + ran.Next().ToString();
string orderEntryresponse = webOrderEntryClient.orderEntryParam("NEW", uniqueRefNo, "", bseuserID, bseMemberId, ClientCode, onlinemforderVo.BSESchemeCode, purchase, PurchaseType, DematAcctype, Amount, Unit, allRedeem, "", "", "Y", "", "", "E116327", "Y", "N", DPCFlag, "", bsePassArray[1], passkey, "", "", "");
string[] bseorderEntryresponseArray = orderEntryresponse.Split('|');
OnlineMFOrderDao.BSEorderResponseParam(transCode, UserID, Convert.ToInt64(bseorderEntryresponseArray[2]), ClientCode, bseorderEntryresponseArray[6], bseorderEntryresponseArray[7], rmsId, uniqueRefNo);
if (Convert.ToInt32(bseorderEntryresponseArray[7]) == 1)
{
if (onlinemforderVo.TransactionType != "SEL")
{
DebitOrCreditRMSUserAccountBalance(UserID, ClientCode, onlinemforderVo.Amount, rmsId, out rmsId);
}
message = "Order cannot be processed." + bseorderEntryresponseArray[6];
}
else if ((Convert.ToInt32(bseorderEntryresponseArray[7]) == 0))
{
orderIds = CreateCustomerOnlineMFOrderDetails(onlinemforderVo, UserID, CustomerId);
bool result = OnlineMFOrderDao.BSERequestOrderIdUpdate(orderIds[0], transCode, rmsId);
message = "Order placed successfully with Exchange. Order reference no is " + orderIds[0].ToString();
msgType = 'S';
}
}
else
{
message = "No response from RMS";
}
}
else
{
message = "Unable to process the order as Exchange is not available for Now.";
}
}
catch (Exception ex)
{
if (isRMSDebited && onlinemforderVo.TransactionType != "SEL")
{
DebitOrCreditRMSUserAccountBalance(UserID, ClientCode, onlinemforderVo.Amount, rmsId, out rmsId);
}
message = "Unable to process the order as Exchange is not available for Now." + ex.Message;
}
finally
{
webOrderEntryClient.Close();
}
return(message);
}
protected void LoadOrderDetails()
{
int ID = int.Parse(Session["OrderId"].ToString());
onlinemforderVo = onlineMforderBo.GetOrderDetails(ID);
}
