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