public IHttpActionResult DeleteAndUpdatePayment(PaymentModels payment) { SqlDataReader SqlDtr; string sql; sql = "delete from payment_transaction where voucher_id = " + payment.VoucherId; SqlDtr = obj.GetRecordSet(sql); SqlDtr.Close(); sql = "delete from AccountsLedgerTable where Particulars = 'Payment (" + payment.VoucherId + ")'"; SqlDtr = obj.GetRecordSet(sql); SqlDtr.Close(); if (payment.OldCust_ID != "") { sql = "delete from CustomerLedgerTable where Particular = 'Voucher(" + payment.VoucherId + ")' and CustID='" + payment.OldCust_ID + "'"; SqlDtr = obj.GetRecordSet(sql); SqlDtr.Close(); } sql = "insert into payment_transaction values(" + payment.Vouch_ID + ",'Payment'," + payment.Ledger_ID1 + "," + payment.Amount1 + "," + payment.By_ID1 + "," + payment.Amount1 + ",'" + payment.Bank_name1 + "','" + payment.Cheque_No1 + "',CONVERT(datetime,'" + payment.dtDate + "', 103),'" + payment.narration1 + "','" + payment.uid + "',CONVERT(datetime,'" + payment.Entry_Date + "', 103))"; SqlDtr = obj.GetRecordSet(sql); SqlDtr.Close(); object obj1 = null; dbobj.ExecProc(DbOperations_LATEST.OprType.Insert, "ProInsertAccountsLedger", ref obj1, "@Ledger_ID", payment.Ledger_ID1, "@Particulars", "Payment (" + payment.Vouch_ID + ")", "@Debit_Amount", payment.Amount1, "@Credit_Amount", "0.0", "@type", "Dr", "@Invoice_Date", payment.Entry_Date); //dbobj.ExecProc(DBOperations.OprType.Insert, "ProInsertAccountsLedger", ref obj1, "@Ledger_ID", payment.By_ID1, "@Particulars", "Payment (" + payment.Vouch_ID + ")", "@Debit_Amount", "0.0", "@Credit_Amount", payment.Amount1, "@type", "Cr", "@Invoice_Date", payment.Entry_Date); dbobj.ExecProc(DbOperations_LATEST.OprType.Insert, "ProCustomerLedgerEntry", ref obj1, "@Voucher_ID", payment.Vouch_ID, "@Ledger_ID", payment.Ledger_ID1, "@Amount", payment.Amount1, "@Type", "Dr.", "@Invoice_Date", payment.Entry_Date); //dbobj.ExecProc(DBOperations.OprType.Insert, "ProCustomerLedgerEntry", ref obj1, "@Voucher_ID", payment.Vouch_ID, "@Ledger_ID", payment.By_ID1, "@Amount", payment.Amount1, "@Type", "Cr.", "@Invoice_Date", payment.Entry_Date); if (payment.Equals(0) || payment == null) { return(Content(HttpStatusCode.NotFound, "Payment Not Updated")); } return(Ok(payment)); }
public IHttpActionResult UpdatePayment(PaymentModels payment) { SqlDataReader SqlDtr; SqlCommand SqlCmd; SqlConnection SqlCon1 = new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["Servosms"]); payment.c = 0; string sql = "Update Payment_transaction set Ledger_ID_Dr = " + payment.Ledger_ID1 + ",Amount1 = " + payment.Amount1 + ",Ledger_ID_Cr = " + payment.By_ID1 + ",Amount2 = " + payment.Amount1 + ",Bank_Name='" + payment.Bank_name1 + "',Cheque_No='" + payment.Cheque_No1 + "',Cheque_date = CONVERT(datetime,'" + payment.dtDate + "', 103),Narration ='" + payment.narration1 + "',Entered_By = '" + payment.uid + "', Entry_Date= CONVERT(datetime,'" + payment.Entry_Date + "', 103) where Voucher_ID = '" + payment.VoucherId + "'"; SqlCmd = new SqlCommand(sql, SqlCon1); SqlCon1.Open(); SqlDtr = SqlCmd.ExecuteReader(); SqlDtr.Close(); payment.c = 1; object obj1 = null; if (payment.CheckCashMode.Equals(payment.DropBy)) { dbobj.ExecProc(DbOperations_LATEST.OprType.Update, "ProUpdateAccountsLedger", ref obj1, "@Voucher_ID", payment.VoucherId, "@Ledger_ID", payment.Ledger_ID1, "@Amount", payment.Amount1, "@Type", "Dr", "@Invoice_Date", System.Convert.ToDateTime(payment.Entry_Date)); dbobj.ExecProc(DbOperations_LATEST.OprType.Update, "ProUpdateAccountsLedger", ref obj1, "@Voucher_ID", payment.VoucherId, "@Ledger_ID", payment.By_ID1, "@Amount", payment.Amount1, "@Type", "Cr", "@Invoice_Date", System.Convert.ToDateTime(payment.Entry_Date)); } else { sql = "delete from CustomerLedgerTable where Particular = 'Voucher(" + payment.VoucherId + ")' and CustID='" + payment.OldCust_ID + "'"; SqlCmd = new SqlCommand(sql, SqlCon1); SqlDtr = SqlCmd.ExecuteReader(); SqlDtr.Close(); sql = "delete from AccountsLedgerTable where Particulars = 'Payment (" + payment.VoucherId + ")'"; SqlCmd = new SqlCommand(sql, SqlCon1); SqlDtr = SqlCmd.ExecuteReader(); SqlDtr.Close(); dbobj.ExecProc(DbOperations_LATEST.OprType.Insert, "ProInsertAccountsLedger", ref obj1, "@Ledger_ID", payment.Ledger_ID1, "@Particulars", "Payment (" + payment.Vouch_ID + ")", "@Debit_Amount", payment.Amount1, "@Credit_Amount", "0.0", "@type", "Dr", "@Invoice_Date", System.Convert.ToDateTime(payment.Entry_Date)); //dbobj.ExecProc(DBOperations.OprType.Insert, "ProInsertAccountsLedger", ref obj1, "@Ledger_ID", payment.By_ID1, "@Particulars", "Payment (" + payment.Vouch_ID + ")", "@Debit_Amount", "0.0", "@Credit_Amount", payment.Amount1, "@type", "Cr", "@Invoice_Date", System.Convert.ToDateTime(payment.Entry_Date)); dbobj.ExecProc(DbOperations_LATEST.OprType.Insert, "ProCustomerLedgerEntry", ref obj1, "@Voucher_ID", payment.Vouch_ID, "@Ledger_ID", payment.Ledger_ID1, "@Amount", payment.Amount1, "@Type", "Dr.", "@Invoice_Date", System.Convert.ToDateTime(payment.Entry_Date)); //dbobj.ExecProc(DBOperations.OprType.Insert, "ProCustomerLedgerEntry", ref obj1, "@Voucher_ID", payment.Vouch_ID, "@Ledger_ID", payment.By_ID1, "@Amount", payment.Amount1, "@Type", "Cr.", "@Invoice_Date", System.Convert.ToDateTime(payment.Entry_Date)); } if (payment.Equals(0) || payment == null) { return(Content(HttpStatusCode.NotFound, "Payment Not Updated")); } return(Ok(payment)); }
public IHttpActionResult SavePayment(PaymentModels payment) { SqlDataReader SqlDtr; string Vouch_ID; string By_ID = ""; string sql = "Select Ledger_ID from Ledger_Master where Ledger_Name ='" + payment.By_Name + "'"; SqlDtr = obj.GetRecordSet(sql); if (SqlDtr.Read()) { By_ID = SqlDtr.GetValue(0).ToString(); } SqlDtr.Close(); sql = "Select top 1(voucher_ID + 1) from Payment_Transaction order by voucher_ID desc"; SqlDtr = obj.GetRecordSet(sql); if (SqlDtr.Read()) { Vouch_ID = SqlDtr.GetValue(0).ToString(); } else { Vouch_ID = "50001"; } SqlDtr.Close(); payment.c = 0; sql = "insert into payment_transaction values(" + Vouch_ID + ",'Payment'," + payment.Ledger_ID + "," + payment.Amount + "," + By_ID + "," + payment.Amount + ",'" + payment.Bank_name + "','" + payment.Cheque_No + "',CONVERT(datetime,'" + payment.dtDate + "', 103),'" + payment.narration + "','" + payment.uid + "', CONVERT(datetime,'" + payment.Entry_Date + "', 103))"; SqlDtr = obj.GetRecordSet(sql); payment.c = 1; object obj1 = null; dbobj.ExecProc(DbOperations_LATEST.OprType.Insert, "ProInsertAccountsLedger", ref obj1, "@Ledger_ID", payment.Ledger_ID, "@Particulars", "Payment (" + Vouch_ID + ")", "@Debit_Amount", payment.Amount, "@Credit_Amount", "0.0", "@type", "Dr", "@Invoice_Date", System.Convert.ToDateTime(payment.Entry_Date)); dbobj.ExecProc(DbOperations_LATEST.OprType.Insert, "ProInsertAccountsLedger", ref obj1, "@Ledger_ID", By_ID, "@Particulars", "Payment (" + Vouch_ID + ")", "@Debit_Amount", "0.0", "@Credit_Amount", payment.Amount, "@type", "Cr", "@Invoice_Date", System.Convert.ToDateTime(payment.Entry_Date)); dbobj.ExecProc(DbOperations_LATEST.OprType.Insert, "ProCustomerLedgerEntry", ref obj1, "@Voucher_ID", Vouch_ID, "@Ledger_ID", payment.Ledger_ID, "@Amount", payment.Amount, "@Type", "Dr.", "@Invoice_Date", System.Convert.ToDateTime(payment.Entry_Date)); dbobj.ExecProc(DbOperations_LATEST.OprType.Insert, "ProCustomerLedgerEntry", ref obj1, "@Voucher_ID", Vouch_ID, "@Ledger_ID", By_ID, "@Amount", payment.Amount, "@Type", "Cr.", "@Invoice_Date", System.Convert.ToDateTime(payment.Entry_Date)); if (payment.Equals(0) || payment == null) { return(Content(HttpStatusCode.NotFound, "Payment Not Saved")); } return(Ok(payment)); }
public IHttpActionResult LedgerName_SelectedIndexChanged(string VoucherId) { SqlDataReader SqlDtr, SqlDtr1; SqlCommand SqlCmd; string sql, sql2; using (SqlCon = new SqlConnection()) { SqlCon = new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["ServoSMS"]); SqlCon.Open(); sql = "Select * from payment_transaction where voucher_Id ='" + VoucherId + "' "; SqlDtr = obj.GetRecordSet(sql); while (SqlDtr.Read()) { payment.tempPaymentID = SqlDtr.GetValue(0).ToString(); payment.txtBankname = SqlDtr["Bank_Name"].ToString().Trim(); payment.txtCheque = SqlDtr["Cheque_No"].ToString().Trim(); payment.txtchkDate = obj.checkDate(GenUtil.str2DDMMYYYY(obj.trimDate(SqlDtr["cheque_date"].ToString().Trim()))); payment.txtAmount = SqlDtr["Amount1"].ToString().Trim(); payment.txtNarrartion = SqlDtr["Narration"].ToString().Trim(); payment.txtDate = GenUtil.str2DDMMYYYY(GenUtil.trimDate(SqlDtr["Entry_Date"].ToString())); payment.Invoice_Date = SqlDtr["Entry_Date"].ToString(); payment.LedgerID = SqlDtr["Ledger_ID_Dr"].ToString(); payment.LedgerID1 = SqlDtr["Ledger_ID_Cr"].ToString(); sql2 = "Select Ledger_Name from Ledger_Master where Ledger_ID = " + SqlDtr["Ledger_ID_Cr"].ToString().Trim(); SqlCmd = new SqlCommand(sql2, SqlCon); SqlDtr1 = SqlCmd.ExecuteReader(); if (SqlDtr1.Read()) { payment.CheckCashMode = SqlDtr1["Ledger_Name"].ToString(); } SqlDtr1.Close(); } SqlDtr.Close(); } if (payment.Equals(0) || payment == null) { return(Content(HttpStatusCode.NotFound, "Ledger Name Not Found")); } return(Ok(payment)); }