public string GetEncryptedmandateId(GetMandateReq Data)
{
string URl = "";
string TempId = "";
try
{
TempId = Dbsecurity.Decrypt(Data.AppId) + Dbsecurity.Decrypt(Data.MandateId);
TempId = Global.ReverseString(TempId);
TempId = Global.CreateRandomCode(6) + TempId;
List <GetCredential> GetCredentialList = new List <GetCredential>();
QuickCheck_AngularEntities dbcontext = new QuickCheck_AngularEntities();
var Result = dbcontext.MultipleResults("[dbo].[Sp_GetMandatemodeData]").With <GetCredential>().
Execute("@QueryType", "@AppId", "GetEntityCredential", Dbsecurity.Decrypt(Data.AppId));
GetCredentialList = Result[0].Cast <GetCredential>().ToList();
try
{
dbcontext = new QuickCheck_AngularEntities();
var Result1 = dbcontext.MultipleResults("[dbo].[sp_ESign]").With <doneres>().
Execute("@QueryType", "@MandateId", "@WebAppUrl", "@EncodedMandateID", "@AppId", "@EncodedAppId", "SaveLinkWithoutSMS", Dbsecurity.Decrypt(Data.MandateId), GetCredentialList[0].EWebAppUrl, TempId, Dbsecurity.Decrypt(Data.AppId), Data.AppId);
URl = "/MandateDetails?ID=" + TempId + "&AppId=" + Data.AppId;
// string WebAppUrl = ConfigurationManager.AppSettings["EWebAppUrl"].ToString();
// CommonManger.FillDatasetWithParam("sp_ESign", );
}
catch (Exception ex) { }
}
catch (Exception ex)
{ return("0"); }
return(URl);
}
public string GetMandateInfo(GetMandateReq Data)
{
string msg = "";
try
{
msg = SendmailSMS.SemdEmailSms(Data);
}
catch (Exception ex)
{
return(ex.Message);
}
return(msg);
}
public BankResponseData GetBankdata(GetMandateReq Data)
{
BankResponseData response = new BankResponseData();
List <BankResponse> ListView = new List <BankResponse>();
if (Data.AppID == "")
{
response.Message = "Incomplete data";
response.Status = "Failure";
response.ResCode = "ykR20020";
return(response);
}
else if (Data.AppID != "" && CheckMandateInfo.ValidateAppID(Data.AppID) != true)
{
response.Message = "Invalid AppId";
response.Status = "Failure";
response.ResCode = "ykR20023";
return(response);
}
else if (Data.MerchantKey == "")
{
response.Message = "Incomplete data";
response.Status = "Failure";
response.ResCode = "ykR20020";
return(response);
}
else if (Data.MerchantKey != "" && CheckMandateInfo.ValidateEntityMerchantKey(Data.MerchantKey, Data.AppID) != true)
{
response.Message = "Invalid MerchantKey";
response.Status = "Failure";
response.ResCode = "ykR20021";
return(response);
}
else
{
string query = "Sp_WebAPI";
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings[Convert.ToString(Data.AppID)].ConnectionString);
SqlCommand cmd = new SqlCommand(query, con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@QueryType", "GetLiveBank");
// cmd.Parameters.AddWithValue("@appId", Data.AppID);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
da.Fill(dt);
foreach (DataRow row in dt.Rows)
{
BankResponse bnk = new BankResponse();
bnk.BankCode = row["BankCode"].ToString();
bnk.BankName = row["BankName"].ToString();
bnk.LiveOnDebitCard = row["LiveOnDebitCard"].ToString();
bnk.LiveOnNetBanking = row["LiveOnNetBanking"].ToString();
ListView.Add(bnk);
}
response.BankData = ListView;
response.Message = "All Live Bank Data On NPCI received successfully";
response.ResCode = "ykR20035";
response.Status = "Success";
return(response);
}
}
public GetMandateResponse GetMandateInfo(GetMandateReq Data)
{
GetMandateResponse response = new GetMandateResponse();
if (Data.AppID == "")
{
response.Message = "Incomplete data";
response.Status = "Failure";
response.ResCode = "ykR20020";
return(response);
}
else if (Data.AppID != "" && CheckMandateInfo.ValidateAppID(Data.AppID) != true)
{
response.Message = "Invalid AppId";
response.Status = "Failure";
response.ResCode = "ykR20023";
return(response);
}
//else if (ValidatePresement.CheckAccess(Data.AppID.Trim(), "A") != true)
//{
// response.Message = "Unauthorized user";
// response.Status = "Failure";
// response.ResCode = "ykR20038";
// return response;
//}
else if (Data.MdtID == "")
{
response.Message = "Incomplete data";
response.Status = "Failure";
response.ResCode = "ykR20020";
return(response);
}
else if (!CheckMandateInfo.CheckManadateID(Data.MdtID, Data.AppID))
{
response.Message = "Invalid MandateId";
response.Status = "Failure";
response.ResCode = "ykR20022";
return(response);
}
else if (Data.MerchantKey == "")
{
response.Message = "Incomplete data";
response.Status = "Failure";
response.ResCode = "ykR20020";
return(response);
}
else if (Data.MerchantKey != "" && CheckMandateInfo.ValidateEntityMerchantKey(Data.MerchantKey, Data.AppID) != true)
{
response.Message = "Invalid MerchantKey";
response.Status = "Failure";
response.ResCode = "ykR20021";
return(response);
}
else
{
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings[Convert.ToString(Data.AppID)].ConnectionString);
bool Flag = false;
//string temp = ConfigurationManager.AppSettings["EnitityMarchantKey" + Data.AppID];
string UserId = "";
string query = "Sp_WebAPI";
//if (temp.Trim() == DBsecurity.Decrypt(Data.MerchantKey))
//{
SqlCommand cmd = new SqlCommand(query, con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@QueryType", "GetEntityUser");
cmd.Parameters.AddWithValue("@appId", Data.AppID);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
da.Fill(dt);
if (dt.Rows.Count > 0)
{
UserId = Convert.ToString(dt.Rows[0][0]);
Flag = true;
}
//}
if (Flag)
{
try
{
con.Open();
query = "Sp_WebAPI";
cmd = new SqlCommand(query, con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@QueryType", "GetMandateStatus");
cmd.Parameters.AddWithValue("@MandateId", Data.MdtID);
da = new SqlDataAdapter(cmd);
dt = new DataTable();
da.Fill(dt);
con.Close();
if (dt != null && dt.Rows.Count > 0)
{
string Nach = Convert.ToString(dt.Rows[0]["Nach"]) == "True" ? "Yes" : "No";
string Aadhar = Convert.ToString(dt.Rows[0]["IsLiveInNACH"]) == "True" ? "Yes" : "No";
string Netbanking = Convert.ToString(dt.Rows[0]["Netbanking"]) == "1" ? "Yes" : "No";
string Debitcard = Convert.ToString(dt.Rows[0]["DebitCard"]) == "1" ? "Yes" : "No";
string UPI = Convert.ToString(dt.Rows[0]["Is_UPI"]) == "True" ? "Yes" : "No";
string Lateststatus = Convert.ToString(dt.Rows[0]["status"]);
string StatusDescription = Convert.ToString(dt.Rows[0]["StatusDescription"]);
string isAggr = "";
if (Convert.ToString(dt.Rows[0]["IsAggregator"]).ToLower() == "true")
{
isAggr = "1";
}
else
{
isAggr = "0";
}
response.Message = "Mandate Status received";
response.ResCode = "ykR20035";
response.Status = "Success";
response.MandateId = Data.MdtID;
response.Mandatestatus = Convert.ToString(dt.Rows[0]["status"]);
//response.MandateData = "<MandateData><AppID>" + Data.AppID + "</AppID><MerchantKey>" + Data.MerchantKey + "</MerchantKey><MandateId>" + Data.MdtID + "</MandateId><MandateMode> " + Convert.ToString(dt.Rows[0]["MandateType"]) + " </MandateMode><DateOnMandate> " + Convert.ToString(dt.Rows[0]["DateOnMandate"]) + "</DateOnMandate><SponsorCode>" + Convert.ToString(dt.Rows[0]["SponsorbankCode"]) + "</SponsorCode><UtilityCode> " + Convert.ToString(dt.Rows[0]["UtilityCode"]) + " </UtilityCode ><ToDebit>" + Convert.ToString(dt.Rows[0]["ToDebit"]) + "</ToDebit ><BankName>" + Convert.ToString(dt.Rows[0]["BankName"]) + "</BankName><AcNo>" + Convert.ToString(dt.Rows[0]["AcNo"]) + "</AcNo><IFSC> " + Convert.ToString(dt.Rows[0]["IFSC"]) + " </IFSC><MICR>" + Convert.ToString(dt.Rows[0]["MICR"]) + "</MICR><AmountRupees>" + Convert.ToString(dt.Rows[0]["AmountRupees"]) + "</AmountRupees><Frequency>" + Convert.ToString(dt.Rows[0]["Frequency"]) + "</Frequency><DebitType>" + Convert.ToString(dt.Rows[0]["DebitType"]) + "</DebitType><Refrence1> " + Convert.ToString(dt.Rows[0]["Refrence1"]) + " </Refrence1><Refrence2> " + Convert.ToString(dt.Rows[0]["Refrence2"]) + " </Refrence2>< PhNumber> " + Convert.ToString(dt.Rows[0]["PhoneNumber"]) + " </PhNumber><EmailId> " + Convert.ToString(dt.Rows[0]["EmailId"]) + " </EmailId><From> " + Convert.ToString(dt.Rows[0]["FromDate"]) + "</From><To> " + Convert.ToString(dt.Rows[0]["Todate"]) + " </To>< Customer1> " + Convert.ToString(dt.Rows[0]["Customer1"]) + " </Customer1><Customer2> " + Convert.ToString(dt.Rows[0]["Customer2"]) + "</Customer2><Customer3> " + Convert.ToString(dt.Rows[0]["Customer3"]) + "</Customer3><Nach>" + Nach + "</Nach><EMandateAadhar>" + Aadhar + "</EMandateAadhar><EMandateNetBanking>" + Netbanking + "</EMandateNetBanking><EMandateDebitCard>" + Debitcard + "</EMandateDebitCard><EMandateUPI>" + UPI + "</EMandateUPI><MandateStatus>" + Lateststatus + "</MandateStatus><IsAggregator>" + isAggr + "</IsAggregator><SubMerchantId>" + Convert.ToString(dt.Rows[0]["IsAggregatorValue"]) + "</SubMerchantId><CategoryCode>" + Convert.ToString(dt.Rows[0]["CategoryCode"]) + "</CategoryCode></MandateData>";
response.MandateData = "<MandateData><AppID>" + Data.AppID + "</AppID><MerchantKey>" + Data.MerchantKey + "</MerchantKey><MdtID>" + Data.MdtID + "</MdtID><MType>" + Convert.ToString(dt.Rows[0]["MandateType"]) + "</MType><MDate>" + Convert.ToString(dt.Rows[0]["DateOnMandate"]) + "</MDate><SpBankCode>" + Convert.ToString(dt.Rows[0]["SponsorbankCode"]) + "</SpBankCode><UTLSCode>" + Convert.ToString(dt.Rows[0]["UtilityCode"]) + "</UTLSCode><TDebit>" + Convert.ToString(dt.Rows[0]["ToDebit"]) + "</TDebit><BankName>" + Convert.ToString(dt.Rows[0]["BankName"]) + "</BankName><BankAc>" + Convert.ToString(dt.Rows[0]["AcNo"]) + "</BankAc><IFSC>" + Convert.ToString(dt.Rows[0]["IFSC"]) + "</IFSC><MICR>" + Convert.ToString(dt.Rows[0]["MICR"]) + "</MICR><Amt>" + Convert.ToString(dt.Rows[0]["AmountRupees"]) + "</Amt><Frequency>" + Convert.ToString(dt.Rows[0]["Frequency"]) + "</Frequency><DType>" + Convert.ToString(dt.Rows[0]["DebitType"]) + "</DType><Ref1>" + Convert.ToString(dt.Rows[0]["Refrence1"]) + "</Ref1><Ref2>" + Convert.ToString(dt.Rows[0]["Refrence2"]) + "</Ref2><Phone>" + Convert.ToString(dt.Rows[0]["PhoneNumber"]) + "</Phone><Email>" + Convert.ToString(dt.Rows[0]["EmailId"]) + "</Email><PFrom>" + Convert.ToString(dt.Rows[0]["FromDate"]) + "</PFrom><PTo>" + Convert.ToString(dt.Rows[0]["Todate"]) + "</PTo><Cust1>" + Convert.ToString(dt.Rows[0]["Customer1"]) + "</Cust1><Cust2>" + Convert.ToString(dt.Rows[0]["Customer2"]) + "</Cust2><Cust3>" + Convert.ToString(dt.Rows[0]["Customer3"]) + "</Cust3><Nach>" + Nach + "</Nach><EMandateAadhar>" + Aadhar + "</EMandateAadhar><EMandateNetBanking>" + Netbanking + "</EMandateNetBanking><EMandateDebitCard>" + Debitcard + "</EMandateDebitCard><EMandateUPI>" + UPI + "</EMandateUPI><MandateStatus>" + Lateststatus + "</MandateStatus><IsAggregator>" + isAggr + "</IsAggregator><SubMerchantId>" + Convert.ToString(dt.Rows[0]["IsAggregatorValue"]) + "</SubMerchantId><CategoryCode>" + Convert.ToString(dt.Rows[0]["CategoryCode"]) + "</CategoryCode><AcceptRefNo>" + Convert.ToString(dt.Rows[0]["AcceptRefNo"]) + "</AcceptRefNo><MndtReqId>" + Convert.ToString(dt.Rows[0]["MSGId"]) + "</MndtReqId><NPCIRefMsgId>" + Convert.ToString(dt.Rows[0]["NPCIMsgId"]) + "</NPCIRefMsgId><StatusDescription>" + StatusDescription + "</StatusDescription><UMRN>" + Convert.ToString(dt.Rows[0]["UMRN"]) + "</UMRN></MandateData>";
}
}
catch (Exception ex)
{
Console.Out.WriteLine("-----------------");
Console.Out.WriteLine(ex.Message);
}
}
else
{
response.Status = "Failure";
response.ResCode = "ykR20020";
response.Message = "Invalid data";
return(response);
}
}
return(response);
}
public static string SemdEmailSms(GetMandateReq Data)
{
string Msg = "";
try
{
QuickCheck_AngularEntities dbcontext = new QuickCheck_AngularEntities();
List <GetCredential> GetCredentialList = new List <GetCredential>();
var Result = dbcontext.MultipleResults("[dbo].[Sp_GetMandatemodeData]").With <GetCredential>().
Execute("@QueryType", "@AppId", "GetEntityCredential", Dbsecurity.Decrypt(Data.AppId));
GetCredentialList = Result[0].Cast <GetCredential>().ToList();
string WebAppUrl = GetCredentialList[0].EWebAppUrl; // ConfigurationManager.AppSettings["EWebAppUrl"].ToString();
string SMTPHost = GetCredentialList[0].Amazon_SMTPHost; // ConfigurationManager.AppSettings["Amazon_SMTPHost"].ToString();
string UserId = GetCredentialList[0].Amazon_UserId; // ConfigurationManager.AppSettings["Amazon_UserId"].ToString();
string MailPassword = GetCredentialList[0].Amazon_MailPassword; // ConfigurationManager.AppSettings["Amazon_MailPassword"].ToString();
string SMTPPort = GetCredentialList[0].Amazon_SMTPPort; // ConfigurationManager.AppSettings["Amazon_SMTPPort"].ToString();
string SMTPEnableSsl = Convert.ToString(GetCredentialList[0].Amazon_SMTPEnableSsl); // ConfigurationManager.AppSettings["Amazon_SMTPEnableSsl"].ToString();
string FromMailId = GetCredentialList[0].Amazon_FromMailId; // ConfigurationManager.AppSettings["Amazon_FromMailId" + Dbsecurity.Decrypt(Data.AppId)].ToString();
string Teamtext = GetCredentialList[0].Team; //ConfigurationManager.AppSettings["Team"].ToString();
string response = string.Empty; //Added by Bibhu on 18Mar2020 ** Reason to insert MessageRequstId SP-
int SmsCount = 0;
int EmailCount = 0;
Boolean IsMail = false;
Boolean IsSMS = false;
int SMSlen = 0;
string mandateid = Dbsecurity.Decrypt(Data.MandateId);
//string Emandatetype = Data.Emandatetype;// txtmandatetype.Text;
string EntityName = "";
string Amt = "";
string TempId = Dbsecurity.Decrypt(Data.AppId) + mandateid;
TempId = Global.ReverseString(TempId);
TempId = Global.CreateRandomCode(6) + TempId;
DataSet ds = SendMailAndSMSMethods.GetMobileNo(mandateid, Dbsecurity.Decrypt(Data.AppId), Data.Emandatetype); //CommonManger.FillDatasetWithParam("sp_ESign", "@QueryType", "@mandateid", "@emandatetype", "GetMobileNo", mandateid, Emandatetype);
DataSet dtset = SendMailAndSMSMethods.GetData_MandateID(mandateid, Dbsecurity.Decrypt(Data.AppId), WebAppUrl, "ESingle", Dbsecurity.Decrypt(Data.UserId)); //CommonManger.FillDatasetWithParam("Sp_SendEmail", "@QueryType", "@MandateId", "@Activity", "@WebAppUrl", "@EncodedMandateID", "@UserId", "GetData_MandateID", Convert.ToString(mandateid), "ESingle", WebAppUrl, TempId,Dbsecurity.Decrypt(Data.UserId).ToString());
if (ds.Tables[0].Rows.Count > 0)
{
EntityName = Convert.ToString(ds.Tables[0].Rows[0]["Entityname"]);
Amt = Dbsecurity.Decrypt(Convert.ToString(ds.Tables[0].Rows[0]["AmountRupees"]));
if (Data.EntityDebitValidateMail == "true" || Data.EntityNetValidateMail == "true")
{
try
{
StringBuilder sb = new StringBuilder();
sb.Append(dtset.Tables[2].Rows[0][0].ToString());
sb.Append("Team " + GetCredentialList[0].Team); //Convert.ToString(ConfigurationManager.AppSettings["Team"]));
sb.Append("<br/>");
sb.Append("<i style='font-size:11px'>(Email Generated from Unattendable MailBox, Please Do Not reply.)</i>");
SmtpClient smtpClient = new SmtpClient();
MailMessage mailmsg = new MailMessage();
MailAddress mailaddress = new MailAddress(FromMailId);
mailmsg.To.Add(ds.Tables[0].Rows[0]["emailid"].ToString());
mailmsg.From = mailaddress;
mailmsg.Subject = dtset.Tables[3].Rows[0][0].ToString() + " " + GetCredentialList[0].Team;// Convert.ToString(ConfigurationManager.AppSettings["Team"]);
mailmsg.IsBodyHtml = true;
mailmsg.Body = sb.ToString();
smtpClient.Host = SMTPHost;
smtpClient.Port = Convert.ToInt32(SMTPPort);
smtpClient.EnableSsl = Convert.ToBoolean(SMTPEnableSsl);
smtpClient.UseDefaultCredentials = false;
smtpClient.Credentials = new System.Net.NetworkCredential(UserId, MailPassword);
smtpClient.Send(mailmsg);
IsMail = true;
EmailCount = 1;
}
catch (Exception ex)
{
}
}
if (Data.EntityNetSMS == "true" || Data.EntityDebitSMS == "true")
{
string[] arr = EntityName.Split(' ');
StringBuilder sb = new StringBuilder();
//sb.Append("To process Mandate Reg. amt " + Amt + " at " + arr[0] + " click " + WebAppUrl + "Master/MandateDetails.aspx?ID=" + DbSecurity.Base64Encode(mandateid));
sb.Append(dtset.Tables[1].Rows[0][0].ToString());
string URL = "";
if (GetCredentialList[0].IsClientSmsApi == "0") // if (ConfigurationManager.AppSettings["IsSmsApi"] == "0")
{
//URL = "http://api.msg91.com/api/sendhttp.php?sender=" + ConfigurationManager.AppSettings["SenderId" + Dbsecurity.Decrypt(Data.AppId)] + "&route=4&mobiles=" + Convert.ToString(ds.Tables[0].Rows[0]["phonenumber"].ToString()) + "&authkey=" + ConfigurationManager.AppSettings["authkey"] + "&country=91&message=" + sb.ToString() + "";
URL = "http://api.msg91.com/api/sendhttp.php?sender=" + GetCredentialList[0].SenderId + "&route=4&mobiles=" + Convert.ToString(ds.Tables[0].Rows[0]["phonenumber"].ToString()) + "&authkey=" + GetCredentialList[0].AuthKey + "&country=91&message=" + sb.ToString() + "";
}
else
{
URL = ConfigurationManager.AppSettings["IsSmsApiurL"] + "&mobiles=" + Convert.ToString(ds.Tables[0].Rows[0]["phonenumber"].ToString()) + "&message=" + sb.ToString() + "&sender=" + ConfigurationManager.AppSettings["IsSmsApisender"] + "&route=" + ConfigurationManager.AppSettings["IsSmsApiroute"] + "&country=" + ConfigurationManager.AppSettings["IsSmsApicountry"] + "";
}
HttpWebRequest request = (HttpWebRequest)WebRequest.Create(URL);
request.Method = "POST";
request.ContentType = "application/json";
try
{
WebResponse webResponse = request.GetResponse();
using (Stream webStream = webResponse.GetResponseStream())
{
if (webStream != null)
{
using (StreamReader responseReader = new StreamReader(webStream))
{
//string response = responseReader.ReadToEnd(); // Commented by Bibhu on 18Mar2020
response = responseReader.ReadToEnd(); // Added by Bibhu on 18Mar2020
// Console.Out.WriteLine(response);
}
}
}
}
catch (Exception ex)
{
Console.Out.WriteLine("-----------------");
Console.Out.WriteLine(ex.Message);
}
IsSMS = true;
SMSlen = (dtset.Tables[1].Rows[0][0].ToString()).Length;
}
}
if (SMSlen <= 160)
{
SmsCount = 1;
}
if (SMSlen > 160 && SMSlen <= 306)
{
SmsCount = 2;
}
if (SMSlen > 306 && SMSlen <= 459)
{
SmsCount = 3;
}
if (SMSlen > 459)
{
SmsCount = 4;
}
SendMailAndSMSMethods.SendMailCount(mandateid, Dbsecurity.Decrypt(Data.AppId), EmailCount.ToString(), SmsCount.ToString(), SMSlen, response);
Msg = "Email and SMS sent successfully on customer email address and mobile number";
}
catch (Exception ex)
{
Msg = "Some thing went wrong";
}
return(Msg);
}
