public bool UpdateCnacleRegisterSIP(int systematicId, int is_Cancel, string remark, int cancelBy)
{
bool bResult = false;
OnlineMFOrderDao OnlineMFOrderDao = new OnlineMFOrderDao();
try
{
bResult = OnlineMFOrderDao.UpdateCnacleRegisterSIP(systematicId, is_Cancel, remark, cancelBy);
}
catch (BaseApplicationException Ex)
{
throw Ex;
}
catch (Exception Ex)
{
BaseApplicationException exBase = new BaseApplicationException(Ex.Message, Ex);
NameValueCollection FunctionInfo = new NameValueCollection();
FunctionInfo.Add("Method", "AdvisorBo.cs:UpdateCnacleRegisterSIP()");
object[] objects = new object[1];
FunctionInfo = exBase.AddObject(FunctionInfo, objects);
exBase.AdditionalInformation = FunctionInfo;
ExceptionManager.Publish(exBase);
throw exBase;
}
return(bResult);
}
public DataSet GetControlDetails(int scheme, string folio, int demat)
{
DataSet ds = null;
OnlineMFOrderDao OnlineMFOrderDao = new OnlineMFOrderDao();
try
{
ds = OnlineMFOrderDao.GetControlDetails(scheme, folio, demat);
}
catch (BaseApplicationException Ex)
{
throw Ex;
}
catch (Exception Ex)
{
BaseApplicationException exBase = new BaseApplicationException(Ex.Message, Ex);
NameValueCollection FunctionInfo = new NameValueCollection();
FunctionInfo.Add("Method", "OrderBo.cs:GetOrderStepsDetails()");
object[] objects = new object[1];
FunctionInfo = exBase.AddObject(FunctionInfo, objects);
exBase.AdditionalInformation = FunctionInfo;
ExceptionManager.Publish(exBase);
throw exBase;
}
return(ds);
}
public DataSet GetFolioAccount(int CustomerId, int exchangeType)
{
DataSet dsFolioAccount = null;
OnlineMFOrderDao OnlineMFOrderDao = new OnlineMFOrderDao();
try
{
dsFolioAccount = OnlineMFOrderDao.GetFolioAccount(CustomerId, exchangeType);
}
catch (BaseApplicationException Ex)
{
throw Ex;
}
catch (Exception Ex)
{
BaseApplicationException exBase = new BaseApplicationException(Ex.Message, Ex);
NameValueCollection FunctionInfo = new NameValueCollection();
FunctionInfo.Add("Method", "OrderBo.cs:GetOrderStepsDetails()");
object[] objects = new object[1];
FunctionInfo = exBase.AddObject(FunctionInfo, objects);
exBase.AdditionalInformation = FunctionInfo;
ExceptionManager.Publish(exBase);
throw exBase;
}
return(dsFolioAccount);
}
public List <int> CreateOnlineMFSwitchOrderDetails(List <OnlineMFOrderVo> lsonlinemforder, int userId, int customerId)
{
OnlineMFOrderDao OnlineMFOrderDao = new OnlineMFOrderDao();
DataTable dtSwitchOrder = new DataTable();
List <int> OrderIds = new List <int>();
try
{
dtSwitchOrder = creataTableForSwitch(lsonlinemforder);
OrderIds = OnlineMFOrderDao.CreateOnlineMFSwitchOrderDetails(dtSwitchOrder, userId, customerId);
}
catch (BaseApplicationException Ex)
{
throw Ex;
}
catch (Exception Ex)
{
BaseApplicationException exBase = new BaseApplicationException(Ex.Message, Ex);
NameValueCollection FunctionInfo = new NameValueCollection();
FunctionInfo.Add("Method", "OnlineMFOrderBo.cs:GetCustomerSchemeFolioHoldings(int customerId, int schemeId)");
object[] objects = new object[1];
FunctionInfo = exBase.AddObject(FunctionInfo, objects);
exBase.AdditionalInformation = FunctionInfo;
ExceptionManager.Publish(exBase);
throw exBase;
}
return(OrderIds);
}
public DataSet GetSIPSummaryBookMIS(int CustomerId, int AmcCode, string systematicType, string SIPMode)
{
DataSet dsSIPSummaryBookMIS = null;
OnlineMFOrderDao OnlineMFOrderDao = new OnlineMFOrderDao();
try
{
dsSIPSummaryBookMIS = OnlineMFOrderDao.GetSIPSummaryBookMIS(CustomerId, AmcCode, systematicType, SIPMode);
}
catch (BaseApplicationException Ex)
{
throw Ex;
}
catch (Exception Ex)
{
BaseApplicationException exBase = new BaseApplicationException(Ex.Message, Ex);
NameValueCollection FunctionInfo = new NameValueCollection();
FunctionInfo.Add("Method", "OrderBo.cs:GetSIPSummaryBookMIS()");
object[] objects = new object[1];
FunctionInfo = exBase.AddObject(FunctionInfo, objects);
exBase.AdditionalInformation = FunctionInfo;
ExceptionManager.Publish(exBase);
throw exBase;
}
return(dsSIPSummaryBookMIS);
}
public DataSet GetCustomerSchemeFolioHoldings(int customerId, int schemeId, out string schemeDividendOption, int Demate, int accountId)
{
DataSet ds = null;
OnlineMFOrderDao OnlineMFOrderDao = new OnlineMFOrderDao();
try
{
ds = OnlineMFOrderDao.GetCustomerSchemeFolioHoldings(customerId, schemeId, out schemeDividendOption, Demate, accountId);
}
catch (BaseApplicationException Ex)
{
throw Ex;
}
catch (Exception Ex)
{
BaseApplicationException exBase = new BaseApplicationException(Ex.Message, Ex);
NameValueCollection FunctionInfo = new NameValueCollection();
FunctionInfo.Add("Method", "OnlineMFOrderBo.cs:GetCustomerSchemeFolioHoldings(int customerId, int schemeId)");
object[] objects = new object[1];
FunctionInfo = exBase.AddObject(FunctionInfo, objects);
exBase.AdditionalInformation = FunctionInfo;
ExceptionManager.Publish(exBase);
throw exBase;
}
return(ds);
}
public DataSet GetOrderBookMIS(int CustomerId, int AmcCode, string OrderStatus, DateTime dtFrom, DateTime dtTo, string orderType)
{
DataSet dsOrderBookMIS = null;
OnlineMFOrderDao OnlineMFOrderDao = new OnlineMFOrderDao();
try
{
dsOrderBookMIS = OnlineMFOrderDao.GetOrderBookMIS(CustomerId, AmcCode, OrderStatus, dtFrom, dtTo, orderType);
}
catch (BaseApplicationException Ex)
{
throw Ex;
}
catch (Exception Ex)
{
BaseApplicationException exBase = new BaseApplicationException(Ex.Message, Ex);
NameValueCollection FunctionInfo = new NameValueCollection();
FunctionInfo.Add("Method", "OrderBo.cs:GetOrderStepsDetails()");
object[] objects = new object[1];
FunctionInfo = exBase.AddObject(FunctionInfo, objects);
exBase.AdditionalInformation = FunctionInfo;
ExceptionManager.Publish(exBase);
throw exBase;
}
return(dsOrderBookMIS);
}
public DataSet GetSipDetails(int SchemeId, string frequency, bool IsDemat)
{
DataSet dsSipDetails = null;
OnlineMFOrderDao OnlineMFOrderDao = new OnlineMFOrderDao();
try
{
dsSipDetails = OnlineMFOrderDao.GetSipDetails(SchemeId, frequency, IsDemat);
}
catch (BaseApplicationException Ex)
{
throw Ex;
}
catch (Exception Ex)
{
BaseApplicationException exBase = new BaseApplicationException(Ex.Message, Ex);
NameValueCollection FunctionInfo = new NameValueCollection();
FunctionInfo.Add("Method", "OrderBo.cs:GetSipDetails()");
object[] objects = new object[1];
FunctionInfo = exBase.AddObject(FunctionInfo, objects);
exBase.AdditionalInformation = FunctionInfo;
ExceptionManager.Publish(exBase);
throw exBase;
}
return(dsSipDetails);
}
public int CreateMandateOrder(int customerId, double Amount, int BankName, string BankBranch, int UserId, int mandateId, string BankAccNo, string IFSCCode)
{
int result = 0;
try
{
OnlineMFOrderDao OnlineMFOrderDao = new OnlineMFOrderDao();
{
result = OnlineMFOrderDao.CreateMandateOrder(customerId, Amount, BankName, BankBranch, UserId, mandateId, BankAccNo, IFSCCode);
}
}
catch (BaseApplicationException Ex)
{
throw Ex;
}
catch (Exception Ex)
{
BaseApplicationException exBase = new BaseApplicationException(Ex.Message, Ex);
NameValueCollection FunctionInfo = new NameValueCollection();
FunctionInfo.Add("Method", "CreateMandateOrder(int customerId, double Amount, string BankName, string BankBranch, int UserId)");
object[] objects = new object[5];
objects[0] = customerId;
objects[1] = Amount;
objects[2] = BankName;
objects[3] = BankBranch;
objects[4] = UserId;
FunctionInfo = exBase.AddObject(FunctionInfo, objects);
exBase.AdditionalInformation = FunctionInfo;
ExceptionManager.Publish(exBase);
throw exBase;
}
return(result);
}
public DataTable GetMFSchemeDetailsForLanding(int Schemeplancode, string category)
{
DataTable dtGetMFSchemeDetailsForLanding;
OnlineMFOrderDao OnlineMFOrderDao = new OnlineMFOrderDao();
try
{
dtGetMFSchemeDetailsForLanding = OnlineMFOrderDao.GetMFSchemeDetailsForLanding(Schemeplancode, category);
}
catch (BaseApplicationException Ex)
{
throw Ex;
}
catch (Exception Ex)
{
BaseApplicationException exBase = new BaseApplicationException(Ex.Message, Ex);
NameValueCollection FunctionInfo = new NameValueCollection();
FunctionInfo.Add("Method", "OnlineMFOrderBo.cs:GetMFSchemeDetailsForLanding()");
object[] objects = new object[1];
FunctionInfo = exBase.AddObject(FunctionInfo, objects);
exBase.AdditionalInformation = FunctionInfo;
ExceptionManager.Publish(exBase);
throw exBase;
}
return(dtGetMFSchemeDetailsForLanding);
}
public DataSet GetOrderStatus()
{
DataSet dsOrderStatus = null;
OnlineMFOrderDao OnlineMFOrderDao = new OnlineMFOrderDao();
{
dsOrderStatus = OnlineMFOrderDao.GetOrderStatus();
}
return(dsOrderStatus);
}
public void TriggerAutoOrderFromSIP()
{
OnlineMFOrderDao OnlineMFOrderDao = new OnlineMFOrderDao();
try
{
OnlineMFOrderDao.TriggerAutoOrderFromSIP();
}
catch (BaseApplicationException Ex)
{
throw (Ex);
}
}
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);
}
public DataSet GetTransAllAmcDetails(int customerId)
{
DataSet dsGetTransAllAmcDetails;
OnlineMFOrderDao OnlineMFOrderDao = new OnlineMFOrderDao();
try
{
dsGetTransAllAmcDetails = OnlineMFOrderDao.GetTransAllAmcDetails(customerId);
}
catch (BaseApplicationException Ex)
{
throw (Ex);
}
return(dsGetTransAllAmcDetails);
}
public DataTable GetCustomerFolioSchemeWise(int customerId, int schemeCode, int IsDemat)
{
DataTable dt;
OnlineMFOrderDao OnlineMFOrderDao = new OnlineMFOrderDao();
try
{
dt = OnlineMFOrderDao.GetCustomerFolioSchemeWise(customerId, schemeCode, IsDemat);
}
catch (BaseApplicationException Ex)
{
throw Ex;
}
return(dt);
}
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 DataSet GetCustomerHoldingAMCList(int customerId, char type)
{
DataSet dsCustomerHoldingAMCList;
OnlineMFOrderDao OnlineMFOrderDao = new OnlineMFOrderDao();
try
{
dsCustomerHoldingAMCList = OnlineMFOrderDao.GetCustomerHoldingAMCList(customerId, type);
}
catch (BaseApplicationException Ex)
{
throw (Ex);
}
return(dsCustomerHoldingAMCList);
}
public DataSet GetCustomerOrderBookTransaction(int customerId, int amcCode, int schemeCode, string orderType, int exchangeType)
{
DataSet dsGetCustomerOrderBookTransaction;
OnlineMFOrderDao OnlineMFOrderDao = new OnlineMFOrderDao();
try
{
dsGetCustomerOrderBookTransaction = OnlineMFOrderDao.GetCustomerOrderBookTransaction(customerId, amcCode, schemeCode, orderType, exchangeType);
}
catch (BaseApplicationException Ex)
{
throw Ex;
}
return(dsGetCustomerOrderBookTransaction);
}
public DataSet GetSIPAmcDetails(int customerId, string systematicType)
{
DataSet dsGetSIPAmcDetails;
OnlineMFOrderDao OnlineMFOrderDao = new OnlineMFOrderDao();
try
{
dsGetSIPAmcDetails = OnlineMFOrderDao.GetSIPAmcDetails(customerId, systematicType);
}
catch (BaseApplicationException Ex)
{
throw (Ex);
}
return(dsGetSIPAmcDetails);
}
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 DataSet BindMandateddetailsDetails(int adviserId)
{
DataSet ds = null;;
OnlineMFOrderDao OnlineMFOrderDao = new OnlineMFOrderDao();
try
{
ds = OnlineMFOrderDao.BindMandateddetailsDetails(adviserId);
}
catch (BaseApplicationException Ex)
{
throw Ex;
}
catch (Exception Ex)
{
}
return(ds);
}
/// <summary>
/// Gets the Sip dates from the database for the scheme & sipFreq
/// </summary>
/// <param name="schemePlanCode"></param>
/// <param name="sipFreqCode"></param>
/// <returns></returns>
public DateTime[] GetSipStartDates(int schemePlanCode, string sipFreqCode, bool IsDemat)
{
DataSet dsSipDetails = null;
OnlineMFOrderDao OnlineMFOrderDao = new OnlineMFOrderDao();
List <DateTime> lstSipStartDates = new List <DateTime>();
try
{
dsSipDetails = OnlineMFOrderDao.GetSipDetails(schemePlanCode, sipFreqCode, IsDemat);
if (dsSipDetails == null)
{
return(lstSipStartDates.ToArray());
}
string sipStartDates = dsSipDetails.Tables[0].Rows[0]["PASPSD_StatingDates"].ToString();
List <int> lstSipDates = new List <int>();
string[] temp = sipStartDates.Split(';');
foreach (string date in temp)
{
if (!string.IsNullOrEmpty(date.Trim()))
{
lstSipDates.Add(int.Parse(date.Trim()));
}
}
DateTime dateCurr = DateTime.Now;
if (DateTime.Now.TimeOfDay > System.TimeSpan.Parse("12:59:00"))
{
dateCurr = DateTime.Now.AddDays(1);
}
while (dateCurr <= DateTime.Now.AddMonths(3))
{
int res = lstSipDates.Find(delegate(int date)
{
return(date == dateCurr.Day);
});
if (res > 0)
{
lstSipStartDates.Add(dateCurr);
}
dateCurr = dateCurr.AddDays(1);
}
return(lstSipStartDates.ToArray());
}
catch (BaseApplicationException Ex)
{
throw Ex;
}
catch (Exception Ex)
{
BaseApplicationException exBase = new BaseApplicationException(Ex.Message, Ex);
NameValueCollection FunctionInfo = new NameValueCollection();
FunctionInfo.Add("Method", "OrderBo.cs:GetSipStartDates(int schemePlanCode, string sipFreqCode)");
object[] objects = new object[2];
objects[0] = schemePlanCode;
objects[1] = sipFreqCode;
FunctionInfo = exBase.AddObject(FunctionInfo, objects);
exBase.AdditionalInformation = FunctionInfo;
ExceptionManager.Publish(exBase);
throw exBase;
}
}
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);
}
