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)); }