public int InsertPaymentDetails(PaymentMasterMl Mobj, string spName)
{
int intStatus = 0;
DataSet dset = new DataSet();
SqlParameter[] parm = new SqlParameter[8];
SqlConnection connection = new SqlConnection();
connection = SQLHelper.GetSQLConnection();
connection.Open();
try
{
parm[0] = new SqlParameter("@custID", SqlDbType.BigInt);
parm[0].Value = Mobj.intCustID;
parm[1] = new SqlParameter("@MembershipID", SqlDbType.BigInt);
parm[1].Value = Mobj.intMembershipID;
parm[2] = new SqlParameter("@MembershipDiscountID", SqlDbType.BigInt);
parm[2].Value = Mobj.DiscountID;
parm[3] = new SqlParameter("@Points", SqlDbType.Int);
parm[3].Value = Mobj.Points;
parm[4] = new SqlParameter("@MembershipName", SqlDbType.VarChar, 100);
parm[4].Value = Mobj.MembershipName;
parm[5] = new SqlParameter("@Duration", SqlDbType.Int);
parm[5].Value = Mobj.Duration;
parm[6] = new SqlParameter("@Amount", SqlDbType.VarChar, 100);
parm[6].Value = Mobj.MembershipAmount;
parm[7] = new SqlParameter("@Status", SqlDbType.Int);
parm[7].Direction = ParameterDirection.Output;
dset = SQLHelper.ExecuteDataset(connection, CommandType.StoredProcedure, spName, parm);
if (string.Compare(System.DBNull.Value.ToString(), parm[7].Value.ToString()) == 0)
{
intStatus = 0;
}
else
{
intStatus = Convert.ToInt32(parm[7].Value);
}
}
catch (Exception EX)
{
Commonclass.ApplicationErrorLog(spName, Convert.ToString(EX.Message), Convert.ToInt32(Mobj.intCustID), null, null);
}
finally
{
connection.Close();
}
return(intStatus);
}
public int InsertPaymentDetails(PaymentMasterMl Mobj)
{
return(new PaymentDAL().InsertPaymentDetails(Mobj, "[dbo].[Usp_InsertCustomerPayment]"));
}
public int InsertPaymentDetails([FromBody] PaymentMasterMl Mobj)
{
return(this.IPayment.InsertPaymentDetails(Mobj));
}
