public int CustomerInsertPaymentDetilsInfo([FromBody] CustomerPaymentML Mobj)
{
List <CustomerPaymentML> lstPayment = new List <CustomerPaymentML>();
lstPayment.Add(Mobj);
Mobj.dtPaymentDetails = Commonclass.returnListDatatable(PersonaldetailsUDTables.createDataTablePaymentDetails(), lstPayment);
return(this.IPayment.CustomerInsertPaymentDetilsInfo(Mobj));
}
public int CustomerInsertPaymentDetilsInfo(CustomerPaymentML Mobj)
{
return(new PaymentDAL().CustomerInsertPaymentDetilsInfo(Mobj, "[dbo].[Usp_InsertPaymentDetailsInfo]"));
}
public int CustomerInsertPaymentDetilsInfo(CustomerPaymentML Mobj, string spName)
{
int IntStatus = 0;
DataSet dsPaymentDetails = new DataSet();
int? Istatus = null;
int? inull = null;
List <Smtpemailsending> li = new List <Smtpemailsending>();
SqlConnection connection = new SqlConnection();
connection = SQLHelper.GetSQLConnection();
connection.Open();
SqlDataAdapter daPaymentDetails = new SqlDataAdapter();
try
{
SqlCommand cmd = new SqlCommand(spName, connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@dtPaymentDetails", Mobj.dtPaymentDetails);
cmd.Parameters.AddWithValue("@Isonline", Mobj.Isonline);
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 > 3 && dsPaymentDetails.Tables[3] != null)
{
for (int i = 0; i < dsPaymentDetails.Tables[3].Rows.Count; i++)
{
Smtpemailsending smtp = new Smtpemailsending();
{
smtp.profile_name = dsPaymentDetails.Tables[3].Columns.Contains("profile_name") && !string.IsNullOrEmpty(dsPaymentDetails.Tables[3].Rows[i]["profile_name"].ToString()) ? dsPaymentDetails.Tables[3].Rows[i]["profile_name"].ToString() : string.Empty;
smtp.recipients = dsPaymentDetails.Tables[3].Columns.Contains("recipients") && !string.IsNullOrEmpty(dsPaymentDetails.Tables[3].Rows[i]["recipients"].ToString()) ? dsPaymentDetails.Tables[3].Rows[i]["recipients"].ToString() : string.Empty;
smtp.body = dsPaymentDetails.Tables[3].Columns.Contains("body") && !string.IsNullOrEmpty(dsPaymentDetails.Tables[3].Rows[i]["body"].ToString()) ? dsPaymentDetails.Tables[3].Rows[i]["body"].ToString() : string.Empty;
smtp.subject = dsPaymentDetails.Tables[3].Columns.Contains("subject") && !string.IsNullOrEmpty(dsPaymentDetails.Tables[3].Rows[i]["subject"].ToString()) ? dsPaymentDetails.Tables[3].Rows[i]["subject"].ToString() : string.Empty;
smtp.body_format = dsPaymentDetails.Tables[3].Columns.Contains("body_format") && !string.IsNullOrEmpty(dsPaymentDetails.Tables[3].Rows[i]["body_format"].ToString()) ? dsPaymentDetails.Tables[3].Rows[i]["body_format"].ToString() : string.Empty;
Istatus = smtp.Status = dsPaymentDetails.Tables[3].Columns.Contains("Status") && !string.IsNullOrEmpty(dsPaymentDetails.Tables[3].Rows[i]["Status"].ToString()) ? Convert.ToInt32(dsPaymentDetails.Tables[3].Rows[i]["Status"]) : inull;
}
li.Add(smtp);
}
IntStatus = (Istatus != null && Istatus != 0) ? 1 : 0;
if (Mobj.PaysmsID == 1)
{
Commonclass.SendMailSmtpMethod(li, "info");
}
}
else
{
if (Convert.ToInt32(cmd.Parameters[3].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);
}
