public int CustomerInsertPaymentDetilsInfo_NewDesign([FromBody] PaymentInsertML Mobj)
{
List <PaymentInsertML> lstPayment = new List <PaymentInsertML>();
lstPayment.Add(Mobj);
Mobj.dtPaymentDetails = Commonclass.returnListDatatable(PersonaldetailsUDTables.createDataTablePayment_New(), lstPayment);
return(this.IPayment.CustomerInsertPaymentDetilsInfo_NewDesign(Mobj));
}
public int CustomerInsertPaymentDetilsInfo_NewDesign(PaymentInsertML Mobj)
{
return(new PaymentDAL().CustomerInsertPaymentDetilsInfo_New(Mobj, "[dbo].[Usp_InsertPaymentDetailsInfo_NewDesign_NewDesign]"));
}
//New Payment Table Design Test API
public int CustomerInsertPaymentDetilsInfo_New(PaymentInsertML Mobj, string spName)
{
int IntStatus = 0;
DataSet dsPaymentDetails = new DataSet();
int? Istatus = null;
int? inull = null;
List <Smtpemailsending> li = new List <Smtpemailsending>();
SqlDataAdapter daPaymentDetails = new SqlDataAdapter();
SqlConnection connection = new SqlConnection();
connection = SQLHelper.GetSQLConnection();
connection.Open();
try
{
SqlCommand cmd = new SqlCommand(spName, connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@dtPaymentDetails", Mobj.dtPaymentDetails);
cmd.Parameters.AddWithValue("@PaysmsID", Mobj.PaysmsID);
SqlParameter outputParamStatus = cmd.Parameters.Add("@Status", SqlDbType.Int);
outputParamStatus.Direction = ParameterDirection.Output;
SqlParameter outputParamErrorLog = cmd.Parameters.Add("@ErrorMsg", SqlDbType.VarChar, 1000);
outputParamErrorLog.Direction = ParameterDirection.Output;
daPaymentDetails.SelectCommand = cmd;
daPaymentDetails.Fill(dsPaymentDetails);
if (dsPaymentDetails != null && dsPaymentDetails.Tables.Count > 0 && dsPaymentDetails != null)
{
for (int i = 0; i < dsPaymentDetails.Tables[0].Rows.Count; i++)
{
Smtpemailsending smtp = new Smtpemailsending();
{
smtp.profile_name = dsPaymentDetails.Tables[0].Columns.Contains("profile_name") && !string.IsNullOrEmpty(dsPaymentDetails.Tables[0].Rows[i]["profile_name"].ToString()) ? dsPaymentDetails.Tables[0].Rows[i]["profile_name"].ToString() : string.Empty;
smtp.recipients = dsPaymentDetails.Tables[0].Columns.Contains("recipients") && !string.IsNullOrEmpty(dsPaymentDetails.Tables[0].Rows[i]["recipients"].ToString()) ? dsPaymentDetails.Tables[0].Rows[i]["recipients"].ToString() : string.Empty;
smtp.body = dsPaymentDetails.Tables[0].Columns.Contains("body") && !string.IsNullOrEmpty(dsPaymentDetails.Tables[0].Rows[i]["body"].ToString()) ? dsPaymentDetails.Tables[0].Rows[i]["body"].ToString() : string.Empty;
smtp.subject = dsPaymentDetails.Tables[0].Columns.Contains("subject") && !string.IsNullOrEmpty(dsPaymentDetails.Tables[0].Rows[i]["subject"].ToString()) ? dsPaymentDetails.Tables[0].Rows[i]["subject"].ToString() : string.Empty;
smtp.body_format = dsPaymentDetails.Tables[0].Columns.Contains("body_format") && !string.IsNullOrEmpty(dsPaymentDetails.Tables[0].Rows[i]["body_format"].ToString()) ? dsPaymentDetails.Tables[0].Rows[i]["body_format"].ToString() : string.Empty;
Istatus = smtp.Status = dsPaymentDetails.Tables[0].Columns.Contains("Status") && !string.IsNullOrEmpty(dsPaymentDetails.Tables[0].Rows[i]["Status"].ToString()) ? Convert.ToInt32(dsPaymentDetails.Tables[0].Rows[i]["Status"]) : inull;
}
li.Add(smtp);
}
IntStatus = (Istatus != null && Istatus != 0) ? 1 : 0;
if (Mobj.PaysmsID == 1)
{
Commonclass.SendMailSmtpMethod(li, "info");
Commonclass.PaymentinsertSMS(dsPaymentDetails, Mobj);
}
}
else
{
if (Convert.ToInt32(cmd.Parameters[0].Value) == 1)
{
IntStatus = 1;
}
else
{
IntStatus = 0;
}
}
}
catch (Exception EX) { Commonclass.ApplicationErrorLog(spName, Convert.ToString(EX.Message), null, null, null); }
finally
{
connection.Close();
}
if (dsPaymentDetails.Tables.Count == 0)
{
dsPaymentDetails = null;
}
return(IntStatus);
}
public static void PaymentinsertSMS(DataSet dsPaymentDetails, PaymentInsertML Mobj)
{
string page = string.Empty;
string ProfileID = string.Empty;
string AmountPaid = string.Empty;
string strVerificationText = string.Empty;
if (dsPaymentDetails != null)
{
string lblBalAmount = (Convert.ToDecimal(Mobj.dtPaymentDetails.Rows[0]["AgreedAmount"]) - Convert.ToDecimal(Mobj.dtPaymentDetails.Rows[0]["AmountPaid"])).ToString();
string lblPaymentID = dsPaymentDetails.Tables[0].Rows[0]["paymentid"].ToString();
PaymentDAL payment = new PaymentDAL();
if (Mobj.PaysmsID == 1)
{
ServiceSoapClient cc = new ServiceSoapClient();
DataTable dtProfileID = new DataTable();
string strgender = null;
string strbranchcode = null;
if (Mobj.dtPaymentDetails.Rows[0]["ProfileID"] != null)
{
string strProfileID = Mobj.dtPaymentDetails.Rows[0]["ProfileID"].ToString();
dtProfileID = payment.Bgepay_RegionProfileID(strProfileID);
if (dtProfileID.Rows.Count > 0)
{
if (dtProfileID.Rows[0]["GenderID"].ToString() == "1")
{
strgender = "Mr";
}
else
{
strgender = "Ms";
}
strbranchcode = dtProfileID.Rows[0]["BranchesName"].ToString();
}
}
if (Mobj.dtPaymentDetails.Rows.Count > 0)
{
ProfileID = Mobj.dtPaymentDetails.Rows[0]["ProfileID"].ToString();
AmountPaid = Mobj.dtPaymentDetails.Rows[0]["AmountPaid"].ToString();
strVerificationText = strgender + '.' + dsPaymentDetails.Tables[0].Rows[0]["Name"].ToString() + ", thank you for the payment of Rs." + AmountPaid + "/ @" + strbranchcode + " and your profile id is : " + ProfileID + ".... Kaakateeya.com";
}
else
{
strVerificationText = strgender + '.' + dsPaymentDetails.Tables[0].Rows[0]["Name"].ToString() + " No Payment received for the" + ProfileID + ".";
}
try
{
if (Mobj.dtPaymentDetails.Rows[0]["ProfileID"] != null)
{
string strProfileID = Mobj.dtPaymentDetails.Rows[0]["ProfileID"].ToString();
dtProfileID = payment.Bgepay_RegionProfileID(strProfileID);
if (dtProfileID.Rows.Count > 0)
{
string strRegion = dtProfileID.Rows[0]["Region"].ToString();
if (strRegion == "409")
{
string result1 = cc.SendTextSMS("ykrishna", "summary$1", "9841282222", strVerificationText, "smscntry");
//string result1 = cc.SendTextSMS("ykrishna", "summary$1", "9492117548", strVerificationText, "smscntry");
}
else
{
string result2 = cc.SendTextSMS("ykrishna", "summary$1", "9848355213", strVerificationText, "smscntry");
// string result2 = cc.SendTextSMS("ykrishna", "summary$1", "8341287876", strVerificationText, "smscntry");
}
}
}
//dsPaymentDetails.Tables[0].Rows[0]["Number"] = "9492117548";
string result = cc.SendTextSMS("ykrishna", "summary$1", dsPaymentDetails.Tables[0].Rows[0]["Number"].ToString(), strVerificationText, "smscntry");
}
catch (Exception ee)
{
}
}
}
}
