public bool DebitRMSUserAccountBalanceOrderUpdate(string userAccountId, double amount, int orderId)
{
bool result = false;
string Response = string.Empty;
OnlineOrderDao onlineOrderDao = new OnlineOrderDao();
string rmsAPI = ConfigurationSettings.AppSettings["RMS_USER_ACCOUNT_BALANCE_API"];
DataTable dt = new DataTable();
try
{
rmsAPI = rmsAPI.Replace("#UserAccountId#", userAccountId);
rmsAPI = rmsAPI.Replace("#Amount#", amount.ToString());
onlineOrderDao.UpdateOrderRMSAccountDebitRequestTime(orderId, Convert.ToDecimal(amount));
Response = TrigerAPI(rmsAPI);
StringReader theReader = new StringReader(Response);
DataSet theDataSet = new DataSet();
theDataSet.ReadXml(theReader);
dt = theDataSet.Tables[0];
dt.Rows[0]["ReferenceNumber"].ToString();
if (Response.Contains("TRUE"))
{
onlineOrderDao.UpdateOrderRMSAccountDebitDetails(orderId, 1, string.Empty, "RMSREsponse:-" + Response, dt.Rows[0]["ReferenceNumber"].ToString());
result = true;
}
else if (Response.Contains("FALSE"))
{
result = false;
}
}
catch (Exception Ex)
{
result = false;
}
return(result);
}
public DataTable GetAdvertisementData(string assetGroupCode, string type)
{
OnlineOrderDao onlineOrderDao = new OnlineOrderDao();
DataTable dt;
try
{
dt = onlineOrderDao.GetAdvertisementData(assetGroupCode, type);
}
catch (BaseApplicationException Ex)
{
throw Ex;
}
return(dt);
}
public DataTable GetImageListForBanner(string assetGroupCode)
{
OnlineOrderDao onlineOrderDao = new OnlineOrderDao();
DataTable dt;
try
{
dt = onlineOrderDao.GetImageListForBanner(assetGroupCode);
}
catch (BaseApplicationException Ex)
{
throw Ex;
}
return(dt);
}
public Dictionary <string, string> GetschemedetailonlineorDemate(int schemecode)
{
Dictionary <string, string> SchemetransactType = new Dictionary <string, string>();
OnlineOrderDao onlineOrderDao = new OnlineOrderDao();
DataTable dt = onlineOrderDao.GetschemedetailonlineorDemate(schemecode);
foreach (DataRow dr in dt.Rows)
{
SchemetransactType.Add(dr["ExchangeType"].ToString(), dr["TransType"].ToString());
}
//SchemetransactType.Add("exchange", "Online,Demat");
//SchemetransactType.Add("Online", "SIP,NFO");
//SchemetransactType.Add("Demat", "");
return(SchemetransactType);
}
public bool DebitOrCreditRMSUserAccountBalance(int userId, string userAccountId, double amount, int rmsID, out int resultRmsId)
{
bool result = false;
string Response = string.Empty;
resultRmsId = 0;
string rmsType = amount < 0 ? "Debit" : "Credit";
DateTime requestTime = DateTime.Now;
DateTime responseTime = DateTime.Now;
OnlineOrderDao onlineOrderDao = new OnlineOrderDao();
string rmsAPI = ConfigurationSettings.AppSettings["RMS_USER_ACCOUNT_BALANCE_API"];
DataTable dt = new DataTable();
try
{
rmsAPI = rmsAPI.Replace("#UserAccountId#", userAccountId);
rmsAPI = rmsAPI.Replace("#Amount#", amount.ToString());
requestTime = DateTime.Now;
Response = TrigerAPI(rmsAPI);
responseTime = DateTime.Now;
StringReader theReader = new StringReader(Response);
DataSet theDataSet = new DataSet();
theDataSet.ReadXml(theReader);
dt = theDataSet.Tables[0];
if (Response.Contains("TRUE"))
{
resultRmsId = onlineOrderDao.CreateOrUpdateRMSLog(userId, rmsID, 1, rmsType, amount, requestTime, responseTime, string.Empty, "RMSREsponse:-" + Response, dt.Rows[0]["ReferenceNumber"].ToString());
result = true;
}
if (Response.Contains("FALSE"))
{
resultRmsId = onlineOrderDao.CreateOrUpdateRMSLog(userId, rmsID, 0, rmsType, amount, requestTime, responseTime, string.Empty, "RMSREsponse:-" + Response, dt.Rows[0]["ReferenceNumber"].ToString());
result = false;
}
}
catch (Exception Ex)
{
resultRmsId = onlineOrderDao.CreateOrUpdateRMSLog(userId, rmsID, 0, rmsType, amount, requestTime, responseTime, string.Empty, ("RMSREsponse:-" + Response + "ERROR:-" + Ex.Message), dt.Rows[0]["ReferenceNumber"].ToString());
result = false;
}
return(result);
}
//public string CreateClientMFAccessMessage(string accessCode)
//{
// string message = string.Empty;
// switch (accessCode)
// {
// case "NA":
// message = "KRA not completed / updated. Hence cannot invest in mutual fund. Please contact SSL customer care";
// break;
// case "PA":
// message = "KRA not completed / updated. Hence cannot invest in mutual fund. Please contact SSL customer care";
// break;
// }
// return message;
//}
public string GetClientMFAccessStatus(int customerId)
{
string strClientAccess = "NA";
DataTable dtClientKYCStatus = new DataTable();
OnlineOrderDao onlineOrderDao = new OnlineOrderDao();
try
{
dtClientKYCStatus = onlineOrderDao.GetClientKYCStatus(customerId);
DataRow[] drKYCYes = dtClientKYCStatus.Select("C_IsKYCAvailable=1", "C_IsKYCAvailable");
DataRow[] drKYCNo = dtClientKYCStatus.Select("C_IsKYCAvailable=0", "C_IsKYCAvailable");
if (drKYCYes.Count() == dtClientKYCStatus.Rows.Count)
{
strClientAccess = "FA";
}
else if (drKYCNo.Count() >= 1)
{
strClientAccess = "PA";
}
}
catch (BaseApplicationException Ex)
{
throw Ex;
}
catch (Exception Ex)
{
BaseApplicationException exBase = new BaseApplicationException(Ex.Message, Ex);
NameValueCollection FunctionInfo = new NameValueCollection();
FunctionInfo.Add("Method", "OnlineOrderBo.cs:GetClientMFAccessStatus()");
object[] objects = new object[1];
FunctionInfo = exBase.AddObject(FunctionInfo, objects);
exBase.AdditionalInformation = FunctionInfo;
ExceptionManager.Publish(exBase);
throw exBase;
}
return(strClientAccess);
}
