예제 #1
0
 public DataTable PaymentSummary(payment_Prop paymentprop)
 {
     try
     {
         return(SqlHelper.ExecuteDataset(com.con, "usp_payment_summary", new object[] { paymentprop.UserName }).Tables[0]);
     }
     catch (Exception e)
     {
         throw e;
     }
 }
예제 #2
0
 public DataTable PaymentChequeSelect_new(payment_Prop paymentprop)
 {
     try
     {
         return(SqlHelper.ExecuteDataset(com.con, "usp_select_paymentcheque_new", new object[] { paymentprop.Bankid, paymentprop.ChequeNo, paymentprop.ChequeDate }).Tables[0]);
     }
     catch (Exception e)
     {
         throw e;
     }
 }
예제 #3
0
 public DataTable PaymentUpdateMultiple(payment_Prop paymentprop)
 {
     try
     {
         return(SqlHelper.ExecuteDataset(com.con, "usp_Update_paymentmultiple", new object[] { paymentprop.Bankid, paymentprop.ChequeNo, paymentprop.ChequeDate }).Tables[0]);
     }
     catch (Exception e)
     {
         throw e;
     }
 }
예제 #4
0
 public string BillCancel(payment_Prop paymentprop)
 {
     try
     {
         return(SqlHelper.ExecuteDataset(com.con, "usp_Payment_Cancel", new object[] { paymentprop.PaymentID, paymentprop.UserName }).Tables[0].Rows[0][0].ToString());
     }
     catch (Exception e)
     {
         throw e;
     }
 }
예제 #5
0
 public DataTable PaymentSelectCancel(payment_Prop paymentprop)
 {
     try
     {
         return(SqlHelper.ExecuteDataset(com.con, "usp_payment_selectCancel", new object[] { paymentprop.SubdivisionCode, paymentprop.AccountNo, paymentprop.Receiptno }).Tables[0]);
     }
     catch (Exception e)
     {
         throw e;
     }
 }
예제 #6
0
 public string PaymentChangeDuedate(payment_Prop paymentprop)
 {
     try
     {
         return(SqlHelper.ExecuteDataset(com.con, "usp_payment_ChangeDuedate", new object[] { paymentprop.BillID, paymentprop.ChequeDate, paymentprop.UserName }).Tables[0].Rows[0][0].ToString());
     }
     catch (Exception e)
     {
         throw e;
     }
 }
예제 #7
0
 public DataTable PaymentCloseTransaction(payment_Prop paymentprop)
 {
     try
     {
         return(SqlHelper.ExecuteDataset(com.con, "usp_payment_closetransaction", new object[] { paymentprop.Fromdate }).Tables[0]);
     }
     catch (Exception e)
     {
         throw e;
     }
 }
예제 #8
0
 public string checkclosedtrasction(payment_Prop paymentprop)
 {
     try
     {
         return(SqlHelper.ExecuteDataset(com.con, "ups_checkClosdTrasaction ", new object[] { paymentprop.UserName }).Tables[0].Rows[0][0].ToString());
     }
     catch (Exception e)
     {
         throw e;
     }
 }
예제 #9
0
 public DataTable PaymentSelectByBillID(payment_Prop paymentprop)
 {
     try
     {
         return(SqlHelper.ExecuteDataset(com.con, "usp_Payment_SelectByBillID", new object[] { paymentprop.BillIDs }).Tables[0]);
     }
     catch (Exception e)
     {
         throw e;
     }
 }
예제 #10
0
 public DataTable PaymentSelect(payment_Prop paymentprop)
 {
     try
     {
         return(SqlHelper.ExecuteDataset(com.con, "usp_payment_select", new object[] { paymentprop.PaymentID }).Tables[0]);
     }
     catch (Exception e)
     {
         throw e;
     }
 }
예제 #11
0
 public DataTable  BillingSelect(payment_Prop paymentprop)
 {
     try
     {
         return(SqlHelper.ExecuteDataset(com.con, "usp_billing_select", new object[] { paymentprop.SubdivisionCode, paymentprop.AccountNo }).Tables[0]);
     }
     catch (Exception e)
     {
         throw e;
     }
 }
예제 #12
0
 public string PaymentDelete(payment_Prop paymentprop)
 {
     try
     {
         return(SqlHelper.ExecuteDataset(com.con, "usp_payment_delete", new object[] { paymentprop.PaymentID }).Tables[0].Rows[0][0].ToString());
     }
     catch (Exception e)
     {
         throw e;
     }
 }
예제 #13
0
 public DataTable PaymentSelectChangeDuedate(payment_Prop paymentprop)
 {
     try
     {
         return(SqlHelper.ExecuteDataset(com.con, "usp_billing_select_chgduedate", new object[] { paymentprop.AccountNo }).Tables[0]);
     }
     catch (Exception e)
     {
         throw e;
     }
 }
예제 #14
0
 public string PaymentInsert_single(payment_Prop paymentprop)
 {
     try
     {
         return(SqlHelper.ExecuteDataset(com.con, "usp_payment_insert_single", new object[] { paymentprop.BillID, paymentprop.Mode, paymentprop.Amount, paymentprop.Bankid, paymentprop.ChequeDate, paymentprop.ChequeNo, paymentprop.PhoneNo, paymentprop.SubdivisionCode, paymentprop.UserName, paymentprop.Emailid, paymentprop.status }).Tables[0].Rows[0][0].ToString());
         // return SqlHelper.ExecuteDataset(com.con, "usp_payment_insert", new object[] { paymentprop.BillID, paymentprop.Mode, paymentprop.Amount, paymentprop.Bankid, paymentprop.ChequeDate, paymentprop.ChequeNo, paymentprop.PhoneNo,  paymentprop.UserName, paymentprop.Emailid, paymentprop.status }).Tables[0].Rows[0][0].ToString();
     }
     catch (Exception e)
     {
         throw e;
     }
 }
예제 #15
0
 public DataTable  BillingSelect(payment_Prop paymentprop)
 {
     try
     {
         paymentdal = new payment_dal();
         DataTable dt = paymentdal.BillingSelect(paymentprop);
         return(dt);
     }
     catch (Exception e)
     {
         ErrMessage = e.Message;
         return(null);
     }
 }
예제 #16
0
 public string PaymentDelete(payment_Prop paymentprop)
 {
     try
     {
         paymentdal = new payment_dal();
         string strMsg = paymentdal.PaymentDelete(paymentprop);
         return(strMsg);
     }
     catch (Exception e)
     {
         ErrMessage = e.Message;
         return("");
     }
 }
예제 #17
0
 public string checkclosedtrasction(payment_Prop paymentprop)
 {
     try
     {
         paymentdal = new payment_dal();
         string strMsg = paymentdal.checkclosedtrasction(paymentprop);
         return(strMsg);
     }
     catch (Exception e)
     {
         ErrMessage = e.Message;
         return("");
     }
 }
예제 #18
0
 public DataTable PaymentClosedTransaction(payment_Prop paymentprop)
 {
     try
     {
         paymentdal = new payment_dal();
         DataTable dt = paymentdal.PaymentCloseTransaction(paymentprop);
         return(dt);
     }
     catch (Exception e)
     {
         ErrMessage = e.Message;
         return(null);
     }
 }
예제 #19
0
 public DataTable PaymentUserSummary(payment_Prop paymentprop)
 {
     try
     {
         paymentdal = new payment_dal();
         DataTable dt = paymentdal.PaymentUserSummary(paymentprop);
         return(dt);
     }
     catch (Exception e)
     {
         ErrMessage = e.Message;
         return(null);
     }
 }
예제 #20
0
 public DataTable PaymentChequeSelect_new(payment_Prop paymentprop)
 {
     try
     {
         paymentdal = new payment_dal();
         DataTable dt = paymentdal.PaymentChequeSelect_new(paymentprop);
         return(dt);
     }
     catch (Exception e)
     {
         ErrMessage = e.Message;
         return(null);
     }
 }
예제 #21
0
 public string PaymentChangeDuedate(payment_Prop paymentprop)
 {
     try
     {
         paymentdal = new payment_dal();
         string dt = paymentdal.PaymentChangeDuedate(paymentprop);
         return(dt);
     }
     catch (Exception e)
     {
         ErrMessage = e.Message;
         return(null);
     }
 }