protected void saveButton_Click(object sender, EventArgs e)
{
MoneyReceipt moneyReceipt = new MoneyReceipt();
moneyReceipt.Date = dateTextBox.Value;
moneyReceipt.MrNo = mrNoTextBox.Text;
moneyReceipt.DistrictId = int.Parse(districtNameDropDownList.SelectedValue);
moneyReceipt.PartyId = int.Parse(partyCodeDropDownList.SelectedValue);
moneyReceipt.Mode = modeDropDownList.SelectedValue;
moneyReceipt.ChequeNo = chequeNoTextBox.Text;
moneyReceipt.ChequeDate = chequeDateTextBox.Value;
moneyReceipt.BankId = int.Parse(bankNameDropDownList.SelectedValue);
moneyReceipt.BranchName = branchNameTextBox.Text;
string amount = amountTextBox.Text;
moneyReceipt.Remarks = remarksTextArea.InnerText;
if (dateTextBox.Value == "" || mrNoTextBox.Text == "" || modeDropDownList.Text == "" ||
chequeNoTextBox.Text == "" || chequeDateTextBox.Value == "" || branchNameTextBox.Text == "" ||
amountTextBox.Text == "" || remarksTextArea.InnerText == "")
{
messageLabel.InnerText = "All Fields are Required!!";
}
else
{
moneyReceipt.Amount = Convert.ToDouble(amount);
messageLabel.InnerText = moneyReceiptManager.Save(moneyReceipt);
}
ClearTextBoxes();
}
protected void firstButton_Click(object sender, EventArgs e)
{
MoneyReceipt moneyReceipt = moneyReceiptManager.GetMoneyReceipt(0);
GetData(moneyReceipt);
Session["active"] = 0;
}
public string Save(MoneyReceipt moneyReceipt)
{
if (moneyReceiptGateway.Insert(moneyReceipt) > 0)
{
return("Saved Successfully!!");
}
return("Could Not Save Data in Database!!");
}
private void ShowData()
{
MoneyReceipt.Clear();
for (int i = 0; i < names.Count(); i++)
{
MoneyReceipt.Text += "Name: " + names[i] + "\nContract No: " + phones[i] + "\nAddress: " +
addresses[i] + "\nOrder: " + orders[i] + "\nQuantity: " + quantities[i] + "\n \n";
}
}
protected void lastButton_Click(object sender, EventArgs e)
{
List <MoneyReceipt> moneyReceiptList = (List <MoneyReceipt>)(Session["moneyReceipt"]);
int x = moneyReceiptList.Count - 1;
MoneyReceipt moneyReceipt = moneyReceiptManager.GetMoneyReceipt(x);
GetData(moneyReceipt);
Session["active"] = x;
}
private void showButton_Click(object sender, EventArgs e)
{
size = Convert.ToInt32(arraySize.Text);
string messege = "";
for (int index = 0; index < size; index++)
{
messege += "Customer Name :" + name[index] + "\n Customer Contact Number :" + phone[index] + "\n Customer Address :" + addresss[index] + "\n Customer Ordered Item :" + order[index] + "\n Quantity of this item :" + quantity[index] + "\n\n\n";
}
MoneyReceipt.AppendText(messege);
}
protected void searchButton_Click(object sender, EventArgs e)
{
var mrNo = mrTextBox.Value;
MoneyReceipt moneyReceipt = moneyReceiptManager.GetSearchInfo(mrNo);
if (moneyReceipt.MrNo == null)
{
message.InnerText = "Invalid Mr No!!";
}
else
{
GetData(moneyReceipt);
message.InnerText = "";
}
}
public ActionResult Edit(MoneyReceipt receipt)
{
try
{
if (ModelState.IsValid)
{
db.Entry(receipt).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Details", new { id = receipt.ReceiptID }));
}
return(View("Error"));
}
catch (Exception)
{ return(View("Error")); }
}
private void GetData(MoneyReceipt moneyReceipt)
{
dateTextBox.Value = moneyReceipt.Date;
mrNoTextBox.Text = moneyReceipt.MrNo;
districtNameDropDownList.Text = moneyReceipt.DistrictName;
partyCodeDropDownList.Text = moneyReceipt.PartyId.ToString();
partyNameTextBox.Text = moneyReceipt.PartyName;
modeDropDownList.Text = moneyReceipt.Mode;
chequeNoTextBox.Text = moneyReceipt.ChequeNo;
chequeDateTextBox.Value = moneyReceipt.ChequeDate;
bankNameDropDownList.Text = moneyReceipt.BankName;
branchNameTextBox.Text = moneyReceipt.BranchName;
amountTextBox.Text = moneyReceipt.Amount.ToString();
remarksTextArea.InnerText = moneyReceipt.Remarks;
}
public ActionResult CreateConfirmed(MoneyReceipt receipt)
{
try
{
if (ModelState.IsValid)
{
db.MoneyReceipts.Add(receipt);
db.SaveChanges();
return(RedirectToAction("Details", new { id = receipt.ReceiptID }));
}
return(View("Error"));
}
catch (Exception)
{ return(View("Error")); }
}
public int Insert(MoneyReceipt moneyReceipt)
{
SqlConnection connection = new SqlConnection(connectionString);
string query = "INSERT INTO tbl_moneyReceipt VALUES('" + moneyReceipt.Date + "','" + moneyReceipt.MrNo +
"','" + moneyReceipt.DistrictId + "','" + moneyReceipt.PartyId + "','" + moneyReceipt.Mode +
"','" + moneyReceipt.ChequeNo + "','" + moneyReceipt.ChequeDate + "','" + moneyReceipt.BankId +
"','" + moneyReceipt.BranchName + "','" + moneyReceipt.Amount + "','" + moneyReceipt.Remarks +
"')";
SqlCommand command = new SqlCommand(query, connection);
connection.Open();
int rowAffected = command.ExecuteNonQuery();
connection.Close();
return(rowAffected);
}
protected void previousButton_Click(object sender, EventArgs e)
{
int active = (int)Session["active"];
active--;
List <MoneyReceipt> moneyReceiptList = (List <MoneyReceipt>)(Session["moneyReceipt"]);
if (active <= -1)
{
active = moneyReceiptList.Count - 1;
}
MoneyReceipt moneyReceipt = moneyReceiptManager.GetMoneyReceipt(active);
GetData(moneyReceipt);
Session["active"] = active;
}
protected void nextButton_Click(object sender, EventArgs e)
{
int active = (int)Session["active"];
active++;
List <MoneyReceipt> moneyReceiptList = (List <MoneyReceipt>)(Session["moneyReceipt"]);
if (active >= moneyReceiptList.Count)
{
active = 0;
}
MoneyReceipt moneyReceipt = moneyReceiptManager.GetMoneyReceipt(active);
GetData(moneyReceipt);
Session["active"] = active;
}
public MoneyReceipt GetMoneyReceipt(int i)
{
SqlConnection connection = new SqlConnection(connectionString);
string query = "SELECT * FROM tbl_moneyReceipt ORDER BY id ASC OFFSET " + i + " ROWS FETCH NEXT 1 ROWS ONLY";
SqlCommand command = new SqlCommand(query, connection);
connection.Open();
SqlDataReader reader = command.ExecuteReader();
MoneyReceipt moneyReceipt = new MoneyReceipt();
while (reader.Read())
{
GetValueFromDatabase(moneyReceipt, reader);
}
reader.Close();
connection.Close();
return(moneyReceipt);
}
public MoneyReceipt GetSearchInfo(string mrNo)
{
SqlConnection connection = new SqlConnection(connectionString);
string query = "SELECT * FROM tbl_moneyReceipt WHERE mr_no='" + mrNo + "'";
SqlCommand command = new SqlCommand(query, connection);
connection.Open();
MoneyReceipt moneyReceipt = new MoneyReceipt();
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
GetValueFromDatabase(moneyReceipt, reader);
}
reader.Close();
connection.Close();
return(moneyReceipt);
}
private string LoadNextChequeNo()
{
MoneyReceipt moneyReceipt = moneyReceiptManager.GetNextChequeNo();
string chequeNo = moneyReceipt.ChequeNo;
int count;
if (chequeNo == null)
{
count = 1;
}
else
{
count = (chequeNo[4] - '0') * 10 + (chequeNo[5] - '0') + 1;
}
string nextChequeNo = "Ch-0" + count.ToString("00");
return(nextChequeNo);
}
private void GetValueFromDatabase(MoneyReceipt moneyReceipt, SqlDataReader reader)
{
moneyReceipt.MoneyReceiptId = int.Parse(reader["id"].ToString());
moneyReceipt.Date = reader["date"].ToString();
moneyReceipt.MrNo = reader["mr_no"].ToString();
moneyReceipt.DistrictName = reader["district_id"].ToString();
moneyReceipt.PartyId = int.Parse(reader["party_id"].ToString());
Party party = GetPartyName(moneyReceipt.PartyId);
moneyReceipt.PartyCode = party.PartyCode;
moneyReceipt.PartyName = party.PartyName;
moneyReceipt.Mode = reader["mode"].ToString();
moneyReceipt.ChequeNo = reader["cheque_no"].ToString();
moneyReceipt.ChequeDate = reader["cheque_date"].ToString();
moneyReceipt.BankName = reader["bank_id"].ToString();
moneyReceipt.BranchName = reader["branch_name"].ToString();
moneyReceipt.Amount = Convert.ToDouble(reader["amount"].ToString());
moneyReceipt.Remarks = reader["remarks"].ToString();
}
private string LoadNextMrNo()
{
MoneyReceipt moneyReceipt = moneyReceiptManager.GetNextMrNo();
string mrNo = moneyReceipt.MrNo;
int count;
if (mrNo == null)
{
count = 1;
}
else
{
count = (mrNo[4] - '0') * 10 + (mrNo[5] - '0') + 1;
}
string nextmrNo = "Mr-0" + count.ToString("00");
return(nextmrNo);
}
public MoneyReceipt GetNextChequeNo()
{
SqlConnection connection = new SqlConnection(connectionString);
string query = "SELECT TOP 1 * FROM tbl_moneyReceipt ORDER BY id DESC";
SqlCommand command = new SqlCommand(query, connection);
connection.Open();
SqlDataReader reader = command.ExecuteReader();
MoneyReceipt moneyReceipt = new MoneyReceipt();
while (reader.Read())
{
moneyReceipt.MoneyReceiptId = int.Parse(reader["id"].ToString());
moneyReceipt.ChequeNo = reader["cheque_no"].ToString();
}
reader.Close();
connection.Close();
return(moneyReceipt);
}
public List <MoneyReceipt> GetAllMoneyReceipt()
{
SqlConnection connection = new SqlConnection(connectionString);
string query = "SELECT * FROM tbl_moneyReceipt";
SqlCommand command = new SqlCommand(query, connection);
connection.Open();
SqlDataReader reader = command.ExecuteReader();
List <MoneyReceipt> moneyReceiptList = new List <MoneyReceipt>();
while (reader.Read())
{
MoneyReceipt moneyReceipt = new MoneyReceipt();
GetValueFromDatabase(moneyReceipt, reader);
moneyReceiptList.Add(moneyReceipt);
}
reader.Close();
connection.Close();
return(moneyReceiptList);
}
//.................
//public ActionResult BookList()
//{
// BookCreateVM book = new BookCreateVM();
// book.selectListOrganization = _select.SelectBook();
// return View(book);
//}
public ActionResult SaveOrder(int?invoiceNo, string memoNo, string salesType, int districtId, int clientID, int?packdebit, DateTime date, int?less, int commission2, decimal netAmount, Tr_Details[] Tr_Detail, Book[] book, BookGroup[] bookGroup, District[] district, Client[] client)
{
string result = "Error! Order Is Not Complete ";
if (invoiceNo != null || memoNo != null || Tr_Detail != null || book != null || packdebit != null || bookGroup != null || district != null || client != null)
{
Tr_Masters model = new Tr_Masters();
model.InvoiceNo = invoiceNo;
model.Less = less;
model.DistrictID = districtId;
model.ClientID = clientID;
model.PackDebit = packdebit;
model.Type = salesType;
model.Commission = commission2;
model.Tr_Date = date;
MoneyReceipt moneyReceipt = new MoneyReceipt();
moneyReceipt.PartyCode = clientID;
moneyReceipt.EntryDate = date;
moneyReceipt.Amount = netAmount;
db.MoneyReceipts.Add(moneyReceipt);
db.Tr_Masters.Add(model);
foreach (var item in Tr_Detail)
{
Tr_Details o = new Tr_Details();
o.BookID = item.BookID;
o.BookGroupID = item.BookGroupID;
o.Qty = item.Qty;
o.Rate = item.Rate;
o.Commission = item.Commission;
o.Amount = item.Amount;
db.Tr_Details.Add(o);
}
db.SaveChanges();
result = "Success Order Is Complete ";
}
return(Json(result, JsonRequestBehavior.AllowGet));
}
private void addButton_Click(object sender, EventArgs e)
{
string messege = "";
if (!phones.Contains(Convert.ToInt32(txtContactInput.Text)))
{
if (!String.IsNullOrEmpty(comboBoxItem.Text))
{
if (quantityNumericUpDown != null)
{
MoneyReceipt.Clear();
names.Add(txtNameInput.Text);
addresses.Add(txtAddressInput.Text);
phones.Add(Convert.ToInt32(txtContactInput.Text));
orders.Add(comboBoxItem.Text);
quantities.Add(Convert.ToInt32(quantityNumericUpDown.Value));
messege = "Order Information: " + "\n Name: " + txtNameInput + "\n Contract No: " + Convert.ToInt32(txtContactInput.Text) + "\n Address: " +
txtAddressInput.Text + "\n Order: " + comboBoxItem.Text + "\n Quantity: " + Convert.ToInt32(quantityNumericUpDown.Value) + "\n \n";
MoneyReceipt.AppendText(messege);
}
else
{
MessageBox.Show("Please enter quantity");
return;
}
}
else
{
MessageBox.Show("Plase select order");
return;
}
}
else
{
MessageBox.Show("This Contract no already exist!");
return;
}
}
public ActionResult SaveCashMR(MoneyReceiptVM MrVM, List <MoneyReceiptExt> AdjBills)
{
using (var transaction = new TransactionScope())
{
try
{
RBACUser rUser = new RBACUser(Session["UserName"].ToString());
if (!rUser.HasPermission("MoneyReceiptCash_Insert"))
{
return(Json("X", JsonRequestBehavior.AllowGet));
}
//----Edit Nasir---//
//var cabkop = "";
//var sysSet = _sysSetService.All().FirstOrDefault();
//if (sysSet.ActualBasis == true)
//{
//var cabkop = _defACService.All().ToList().FirstOrDefault().CashAc;
//}
//else
//{
// cabkop = _defACService.All().ToList().FirstOrDefault().CashAc;
//}
//--- ---//
string CRNo = "";
var IfExit = _moneyReceiptService.All().Where(x => x.MRNo == MrVM.MRNo).FirstOrDefault();
if (IfExit == null)
{
//var todayDate = DateTime.Now;
CashReceipt CR = new CashReceipt();
CashReceiptSubDetails CRSD = new CashReceiptSubDetails();
MoneyReceipt MR = new MoneyReceipt();
MR.MRSL = MrVM.MRSL;
MR.BranchCode = (MrVM.BranchCode == null) ? Session["BranchCode"].ToString() : MrVM.BranchCode;
MR.ProjCode = (MrVM.ProjCode == null) ? Session["ProjCode"].ToString() : MrVM.ProjCode;
MR.MRNo = MrVM.MRNo;
MR.MRDate = MrVM.MRDate; //.AddHours(todayDate.Hour).AddMinutes(todayDate.Minute).AddSeconds(todayDate.Second).AddMilliseconds(todayDate.Millisecond);
MR.MRAgainst = MrVM.MRAgainst;
MR.VchrNo = MrVM.VchrNo;
MR.PayMode = "Ca";
MR.Posted = MrVM.Posted;
MR.AdjWithBill = MrVM.AdjWithBill;
MR.MRAmount = MrVM.Amount;
// Accode ????
MR.Accode = MrVM.MRAgainst; // "1.2.001";
MR.CustCode = MrVM.CustCode;
MR.FinYear = Session["FinYear"].ToString();
MR.Remarks = MrVM.Remarks;
MR.JobNo = MrVM.JobNo;
//MR.Ca_Bk = cabkop;
// CR.ReceiptNo = _CashReceiptController.GenerateReceiptNo(MR.BranchCode).Substring(6, 0);//MrVM.MRNo;
CR.ReceiptNo = _CashReceiptController.GenerateReceiptNo(MR.BranchCode);
// CR.ReceiptNo = MrVM.MRNo;
CRNo = CR.ReceiptNo;
CR.ReceiptDate = (DateTime)MrVM.MRDate;
CR.purAccode = MrVM.MRAgainst;// "1.2.004";
CR.RefNo = MrVM.MRSL;
CR.Amount = (Double)MrVM.Amount;
CR.Advance = false;
CR.Remarks = MrVM.Remarks;
CR.GLPost = false;
CR.BranchCode = MrVM.BranchCode;
CR.VoucherNo = MrVM.VchrNo;
CR.BranchCode = MR.BranchCode;
CR.FinYear = Session["FinYear"].ToString();
CRSD.SubCode = MrVM.CustCode;
CRSD.Accode = MrVM.MRAgainst;
CRSD.Amount = (Double)MrVM.Amount;
CRSD.CashReceiptNo = CRNo;
//CR.purAccode = cabkop; // "1.2.004";
_moneyReceiptService.Add(MR);
_CashReceiptService.Add(CR);
_CashReceiptSubDetailsAppService.Add(CRSD);
_CashReceiptService.Save();
_moneyReceiptService.Save();
_CashReceiptSubDetailsAppService.Save();
//List<MoneyReceiptExt> MRExtList = new List<MoneyReceiptExt>();
if (AdjBills != null)
{
decimal TotAmt = MrVM.Amount;
foreach (var bill in AdjBills)
{
MoneyReceiptExt MRExt = new MoneyReceiptExt();
var saleMain = _salesMainService.All().Where(s => s.SaleNo == bill.SaleNo).FirstOrDefault();
MRExt.MRId = _moneyReceiptService.All().OrderBy(s => s.MRId).LastOrDefault().MRId;
MRExt.SaleNo = bill.SaleNo;
MRExt.InstallNo = _moneyReceiptExtService.All().OrderBy(s => s.InstallNo).Where(x => x.SaleNo == bill.SaleNo).Select(s => s.InstallNo).LastOrDefault();
MRExt.InstallNo = MRExt.InstallNo + 1;
MRExt.InstallDate = DateTime.Now;
if (TotAmt >= bill.Amount)
{
MRExt.Amount = bill.Amount;
TotAmt = TotAmt - bill.Amount;
saleMain.ReceiptNo = MrVM.MRNo;
saleMain.ReceiptAmt = bill.Amount;
saleMain.IsPaid = true;
_salesMainService.Update(saleMain);
_salesMainService.Save();
_moneyReceiptExtService.Add(MRExt);
_moneyReceiptExtService.Save();
}
else
{
if (bill.IsPaid_mre)
{
saleMain.IsPaid = true;
MRExt.Amount = TotAmt;
//TotAmt = TotAmt - bill.Amount;
}
else
{
saleMain.IsPaid = false;
MRExt.Amount = TotAmt;
// MRExt.Amount = bill.Amount;
//TotAmt = TotAmt - bill.Amount;
}
saleMain.ReceiptNo = MrVM.MRNo;
saleMain.ReceiptAmt = TotAmt;
_moneyReceiptExtService.Add(MRExt);
_moneyReceiptExtService.Save();
string sql = string.Format("select sm.ReceiptAmt,sm.SaleNo, sm.SaleDate, (sm.NetAmount - isnull(sum(mre.Amount),0)) as Billamount from SalesMain sm left join MoneyReceiptExt mre on mre.SaleNo = sm.SaleNo where sm.CustCode = " + MrVM.CustCode + " and sm.IsPaid = 'false' group by sm.ReceiptAmt, mre.SaleNo, sm.NetAmount, sm.SaleNo, sm.SaleDate, mre.Amount order by sm.SaleNo");
IEnumerable <billShow> BillLst;
using (AcclineERPContext dbContext = new AcclineERPContext())
{
BillLst = dbContext.Database.SqlQuery <billShow>(sql).ToList();
}
foreach (var Salebill in BillLst)
{
if (Salebill.BillAmount == 0)
{
saleMain.ReceiptNo = MrVM.MRNo;
saleMain.ReceiptAmt = ((Salebill.ReceiptAmt == null) ? 0 : Salebill.ReceiptAmt) + TotAmt;
saleMain.IsPaid = true;
_salesMainService.Update(saleMain);
_salesMainService.Save();
}
}
}
} //end of foreach
}
// New Add By Nasir
var GCa = _AcBrService.All().Where(s => s.BranchCode == MR.BranchCode && s.Ca_Ba == "Ca").Select(x => x.Accode).FirstOrDefault();
if (GCa == null)
{
var gset = _gsetService.All().LastOrDefault();
GCa = gset.GCa;
}
//------------------
TransactionLogService.SaveTransactionLog(_transactionLogService, "Cash MR", "Save", MR.MRSL, Session["UserName"].ToString());
LoadDropDown.journalVoucherSave("CR", "I", CRNo, MrVM.VchrNo, Session["FinYear"].ToString(), Session["ProjCode"].ToString(), Session["BranchCode"].ToString(), Convert.ToDateTime(MrVM.MRDate), GCa, Session["UserName"].ToString());
transaction.Complete();
return(Json("1", JsonRequestBehavior.AllowGet));
}
else
{
transaction.Dispose();
return(Json("3", JsonRequestBehavior.AllowGet));
}
}
catch (Exception)
{
transaction.Dispose();
return(Json("0", JsonRequestBehavior.AllowGet));
}
}
}
public ActionResult UpdateCheRec(ChequeReceipt CheRec)
{
RBACUser rUser = new RBACUser(Session["UserName"].ToString());
if (!rUser.HasPermission("ChequeReceipt_Update"))
{
return(Json("U", JsonRequestBehavior.AllowGet));
}
using (var transaction = new TransactionScope())
{
try
{
var VchrExist = _vchrMainService.All().FirstOrDefault(s => s.VchrNo == CheRec.VchrNo);
var chqArcExist = _chequeArchiveService.All().ToList().Where(x => x.ChqNo == CheRec.oldChqNo).Select(s => s.ChqStatus).ToList();
if (chqArcExist.Contains("Receive") && CheRec.ChqStatus == "Receive" || chqArcExist.Contains("Receive") && CheRec.ChqStatus == "Deposit" || chqArcExist.Contains("Deposit") && CheRec.ChqStatus == "Encash" ||
chqArcExist.Contains("Encash") && CheRec.ChqStatus != "Dishonour" && CheRec.ChqStatus != "Return")
{
if (VchrExist == null)
{
ChequeReceipt cr = new ChequeReceipt();
cr = CheRec;
cr.MRTing = 0;
cr.MRTingTime = null;
cr.ProjCode = Session["ProjCode"].ToString();
cr.FinYear = Session["FinYear"].ToString();
_chequeReceiptService.Update(cr);
_chequeReceiptService.Save();
var chqArc = _chequeArchiveService.All().FirstOrDefault(s => s.ChqNo == CheRec.oldChqNo && s.ChqStatus == CheRec.ChqStatus);
if (chqArc != null && chqArc.ChqStatus == CheRec.ChqStatus)
{
chqArc.ChqNo = CheRec.ChqNo;
chqArc.UpdateBy = CheRec.UpdateBy;
chqArc.UpdateDate = CheRec.UpdateDate;
chqArc.Reason = CheRec.Reason;
chqArc.Remarks = CheRec.Remarks;
_chequeArchiveService.Update(chqArc);
_chequeArchiveService.Save();
}
else
{
ChequeArchive ca = new ChequeArchive();
ca.ChqStatus = CheRec.ChqStatus;
ca.ChqNo = CheRec.ChqNo;
ca.UpdateBy = CheRec.UpdateBy;
ca.UpdateDate = CheRec.UpdateDate;
ca.Reason = CheRec.Reason;
ca.Remarks = CheRec.Remarks;
_chequeArchiveService.Add(ca);
_chequeArchiveService.Save();
}
BankReceipt br = _bankReceiptService.All().Where(s => s.RefNo == CheRec.ChqReceiptNo && s.ChequeNo == CheRec.ChqNo).FirstOrDefault();
if (CheRec.ChqStatus == "Deposit")
{
br.BReceiptDate = CheRec.ChqReceiptDate;
br.purAccode = CheRec.MRAgainst.ToString();
br.RefNo = CheRec.ChqReceiptNo;
br.bankAccode = CheRec.DepositBank;
br.ChequeNo = CheRec.ChqNo;
br.ChequeDate = CheRec.ChqDate;
br.Amount = (double)CheRec.Amount;
br.Advance = false;
br.Remarks = CheRec.Remarks;
br.FinYear = Session["FinYear"].ToString();
br.GLPost = CheRec.GLPost;
br.BranchCode = CheRec.BranchCode;
br.VoucherNo = CheRec.VchrNo;
br.SubCode = CheRec.SubCode;
br.bankCode = CheRec.BankCode;
_bankReceiptService.Update(br);
_bankReceiptService.Save();
}
var MoneyR = _moneyReceiptService.All().Where(s => s.MRNo == CheRec.ChqReceiptNo).FirstOrDefault();
//insert to provision and money receipt table
if (CheRec.ChqStatus == "Encash" && (MoneyR == null ? "000000" : MoneyR.MRNo) != CheRec.ChqReceiptNo)
{
MoneyReceipt MR = new MoneyReceipt();
MR.MRSL = LoadDropDown.GenerateRecvSlNo(_moneyReceiptService, CheRec.BranchCode, Session["BranchCode"].ToString(), CheRec.ProjCode, Session["VchrConv"].ToString());
MR.BranchCode = (CheRec.BranchCode == null) ? Session["BranchCode"].ToString() : CheRec.BranchCode;
MR.ProjCode = (CheRec.ProjCode == null) ? Session["ProjCode"].ToString() : CheRec.ProjCode;
MR.MRNo = CheRec.ChqReceiptNo;
MR.MRDate = CheRec.ChqReceiptDate;
MR.MRAgainst = CheRec.MRAgainst;
MR.VchrNo = CheRec.VchrNo;
MR.PayMode = "Cq";
MR.Posted = CheRec.PostDated;
MR.AdjWithBill = CheRec.AdjWithBill;
MR.MRAmount = CheRec.Amount;
MR.Accode = CheRec.MRAgainst;
MR.CustCode = CheRec.SubCode;
MR.FinYear = Session["FinYear"].ToString();
MR.Remarks = CheRec.Remarks;
MR.JobNo = CheRec.JobNo;
MR.Ca_Bk = CheRec.DepositBank;
MR.ChqNo = CheRec.ChqNo;
MR.ChqDate = CheRec.ChqDate;
MR.EncashDate = CheRec.EncashDate;
MR.DepositBank = CheRec.DepositBank;
_moneyReceiptService.Add(MR);
_moneyReceiptService.Save();
var chqExt = _chqRecExtService.All().ToList().Where(s => s.ChqReceiptID == CheRec.ChqReceiptId);
foreach (var chqExtitem in chqExt)
{
MoneyReceiptExt MRExt = new MoneyReceiptExt();
MRExt.MRId = _moneyReceiptService.All().OrderBy(s => s.MRId).LastOrDefault().MRId;
MRExt.SaleNo = chqExtitem.BillNo;
MRExt.Amount = chqExtitem.BillAmount;
_moneyReceiptExtService.Add(MRExt);
_moneyReceiptExtService.Save();
}
LoadDropDown.journalVoucherSave("BR", "I", br.BReceiptNo, CheRec.VchrNo, Session["FinYear"].ToString(), Session["ProjCode"].ToString(), CheRec.BranchCode, CheRec.ChqReceiptDate, CheRec.DepositBank, Session["UserName"].ToString());
}
////update to provision
//LoadDropDown.journalVoucherRemoval("BR", CheRec.ChqReceiptNo, CheRec.VchrNo, Session["FinYear"].ToString());
//LoadDropDown.journalVoucherSave("BR", "I", CheRec.ChqReceiptNo, CheRec.VchrNo, Session["FinYear"].ToString(), Session["ProjCode"].ToString(), CheRec.BranchCode, CheRec.ChqReceiptDate, CheRec.DepositBank, Session["UserName"].ToString());
TransactionLogService.SaveTransactionLog(_transactionLogService, "ChequeReceipt", "Update", CheRec.ChqReceiptNo, Session["UserName"].ToString());
transaction.Complete();
return(Json("1", JsonRequestBehavior.AllowGet));
}
else
{
return(Json("2", JsonRequestBehavior.AllowGet));
}
}
else
{
return(Json("3", JsonRequestBehavior.AllowGet));
}
}
catch (Exception)
{
transaction.Dispose();
return(Json("0", JsonRequestBehavior.AllowGet));
}
}
}
private void SaveButton_Click(object sender, EventArgs e)
{
if (txtNameInput.Text == "")
{
MessageBox.Show("Please Write Your Name");
}
else if (txtContactInput.Text == "")
{
MessageBox.Show("Please Write Your Phone Number");
}
else if (txtAddressInput.Text == "")
{
MessageBox.Show("Please Write Your Address");
}
else if (comboBoxItem.Text == "")
{
MessageBox.Show("Please Select Your Item");
}
else if (txtQuantityInput.Text == "")
{
MessageBox.Show("Please Write Your Item Quantity");
}
else
{
string name = txtNameInput.Text;
string contact = txtContactInput.Text;
string address = txtAddressInput.Text;
string item = comboBoxItem.Text;
string quantity = txtQuantityInput.Text;
int quantityofitem = Convert.ToInt32(quantity);
int totalprice;
string showbill;
if (item == "Black Coffee")
{
totalprice = 120 * quantityofitem;
showbill = Convert.ToString(totalprice);
}
else if (item == "Cold Coffee")
{
totalprice = 100 * quantityofitem;
showbill = Convert.ToString(totalprice);
}
else if (item == "Hot Coffee")
{
totalprice = 90 * quantityofitem;
showbill = Convert.ToString(totalprice);
}
else if (item == "Reguler Coffee")
{
totalprice = 80 * quantityofitem;
showbill = Convert.ToString(totalprice);
}
else
{
showbill = "0 tk.";
}
MoneyReceipt.AppendText("Customer Name : " + name + "\n\n");
MoneyReceipt.AppendText("Customer Contact Number : " + contact + "\n\n");
MoneyReceipt.AppendText("Customer Address : " + address + "\n\n");
MoneyReceipt.AppendText("Customer Ordered Item : " + item + "\n\n");
MoneyReceipt.AppendText("Quantity of this item : " + quantity + "\n\n");
MoneyReceipt.AppendText("Your tatal bill : " + showbill);
}
}
public ActionResult SaveMROnline(MROnlineVM MrVM, List <MoneyReceiptExt> AdjBills)
{
using (var transaction = new TransactionScope())
{
try
{
RBACUser rUser = new RBACUser(Session["UserName"].ToString());
if (!rUser.HasPermission("MoneyReceiptOnline_Insert"))
{
return(Json("X", JsonRequestBehavior.AllowGet));
}
var IfExit = _moneyReceiptService.All().Where(x => x.MRSL == MrVM.MRSL && x.MRNo == MrVM.MRNo).FirstOrDefault();
if (IfExit == null)
{
//var todayDate = DateTime.Now;
//CashReceipt CR = new CashReceipt();
BankReceipt br = new BankReceipt();
MoneyReceipt MR = new MoneyReceipt();
MR.MRSL = MrVM.MRSL;
MR.BranchCode = (MrVM.BranchCode == null) ? Session["BranchCode"].ToString() : MrVM.BranchCode;
MR.ProjCode = (MrVM.ProjCode == null) ? Session["ProjCode"].ToString() : MrVM.ProjCode;
MR.MRNo = MrVM.MRNo;
MR.MRDate = MrVM.MRDate; //.AddHours(todayDate.Hour).AddMinutes(todayDate.Minute).AddSeconds(todayDate.Second).AddMilliseconds(todayDate.Millisecond);
MR.MRAgainst = MrVM.MRAgainst;
MR.VchrNo = MrVM.VchrNo;
MR.PayMode = "Ca";
//MR.Posted = MrVM.Posted;
//MR.AdjWithBill = MrVM.AdjWithBill;
MR.MRAmount = MrVM.MRAmount;
MR.Accode = MrVM.MRAgainst;
//if (MrVM.Accode == "0")
//{
// MR.Accode = _defACService.All().ToList().FirstOrDefault().CashAc;
//}
MR.CustCode = MrVM.CustCode;
MR.FinYear = Session["FinYear"].ToString();
MR.Remarks = MrVM.Remarks;
MR.JobNo = MrVM.JobNo;
MR.CollectedBy = MrVM.CollectedBy;
MR.GetwayId = MrVM.GetwayId;
MR.DepositBank = MrVM.DepositBank;
MR.EncashDate = MrVM.DepositDate;
br.BReceiptNo = MrVM.MRSL;
br.BReceiptDate = (DateTime)MrVM.MRDate;
br.purAccode = MrVM.MRAgainst;
br.RefNo = MrVM.MRNo;
br.bankAccode = MrVM.DepositBank;
br.ChequeNo = "Online";
br.ChequeDate = DateTime.Now;
br.Amount = (double)MrVM.MRAmount;
br.Advance = false;
br.Remarks = MrVM.Remarks;
br.FinYear = Session["FinYear"].ToString();
br.GLPost = false;
br.BranchCode = (MrVM.BranchCode == null) ? Session["BranchCode"].ToString() : MrVM.BranchCode;
br.VoucherNo = MrVM.VchrNo;
br.SubCode = MrVM.CustCode;
br.bankCode = MrVM.DepositBank;
//CR.ReceiptNo = MrVM.MRNo;
//CR.ReceiptDate = (DateTime)MrVM.MRDate;
//CR.purAccode = MrVM.MRAgainst;
////if (MrVM.Accode == "0")
////{
//// CR.purAccode = _defACService.All().ToList().FirstOrDefault().CashAc;
////}
//CR.RefNo = MrVM.MRSL;
//CR.Amount = (Double)MrVM.MRAmount;
//CR.Advance = false;
//CR.Remarks = MrVM.Remarks;
//CR.GLPost = false;
//CR.BranchCode = MrVM.BranchCode;
//CR.VoucherNo = MrVM.VchrNo;
//CR.JobNo = MrVM.JobNo;
//CR.FinYear = Session["FinYear"].ToString();
_moneyReceiptService.Add(MR);
//_CashReceiptService.Add(CR);
//_CashReceiptService.Save();
_bankReceiptService.Add(br);
_moneyReceiptService.Save();
_bankReceiptService.Save();
//List<MoneyReceiptExt> MRExtList = new List<MoneyReceiptExt>();
if (AdjBills != null)
{
decimal TotAmt = MrVM.MRAmount;
foreach (var bill in AdjBills)
{
MoneyReceiptExt MRExt = new MoneyReceiptExt();
var saleMain = _salesMainService.All().Where(s => s.SaleNo == bill.SaleNo).FirstOrDefault();
MRExt.MRId = _moneyReceiptService.All().OrderBy(x => x.MRId).LastOrDefault().MRId;
MRExt.SaleNo = bill.SaleNo;
MRExt.InstallNo = _moneyReceiptExtService.All().OrderBy(s => s.InstallNo).Where(x => x.SaleNo == bill.SaleNo).Select(s => s.InstallNo).LastOrDefault();
MRExt.InstallNo = MRExt.InstallNo + 1;
MRExt.InstallDate = DateTime.Now;
if (TotAmt >= bill.Amount)
{
MRExt.Amount = bill.Amount;
TotAmt = TotAmt - bill.Amount;
saleMain.ReceiptNo = MrVM.MRNo;
saleMain.ReceiptAmt = bill.Amount;
saleMain.IsPaid = true;
_salesMainService.Update(saleMain);
_salesMainService.Save();
_moneyReceiptExtService.Add(MRExt);
_moneyReceiptExtService.Save();
}
else
{
if (bill.IsPaid_mre)
{
saleMain.IsPaid = true;
MRExt.Amount = TotAmt;
}
else
{
saleMain.IsPaid = false;
MRExt.Amount = TotAmt;
}
saleMain.ReceiptNo = MrVM.MRNo;
saleMain.ReceiptAmt = bill.Amount;
//MRExt.Amount = TotAmt;
_moneyReceiptExtService.Add(MRExt);
_moneyReceiptExtService.Save();
string sql = string.Format("select sm.ReceiptAmt,sm.SaleNo, sm.SaleDate, (sm.NetAmount - isnull(sum(mre.Amount),0)) as Billamount from SalesMain sm left join MoneyReceiptExt mre on mre.SaleNo = sm.SaleNo where sm.CustCode = " + MrVM.CustCode + " and sm.IsPaid = 'false' group by sm.ReceiptAmt, mre.SaleNo, sm.NetAmount, sm.SaleNo, sm.SaleDate, mre.Amount order by sm.SaleNo");
IEnumerable <billShow> BillLst;
using (AcclineERPContext dbContext = new AcclineERPContext())
{
BillLst = dbContext.Database.SqlQuery <billShow>(sql).ToList();
}
foreach (var Salebill in BillLst)
{
if (Salebill.BillAmount == 0)
{
saleMain.ReceiptNo = MrVM.MRNo;
saleMain.ReceiptAmt = ((Salebill.ReceiptAmt == null) ? 0 : Salebill.ReceiptAmt) + TotAmt;
saleMain.IsPaid = true;
_salesMainService.Update(saleMain);
_salesMainService.Save();
}
}
}
}
}
//var GCa = _AcBrService.All().Where(s => s.BranchCode == MR.BranchCode && s.Ca_Ba == "Ba").Select(x => x.Accode).FirstOrDefault();
//if (GCa == null)
//{
// var gset = _gsetService.All().LastOrDefault();
// GCa = gset.GCa;
//}
TransactionLogService.SaveTransactionLog(_transactionLogService, "Online MR", "Save", MR.MRSL, Session["UserName"].ToString());
LoadDropDown.journalVoucherSave("BR", "I", MrVM.MRSL, MrVM.VchrNo, Session["FinYear"].ToString(), Session["ProjCode"].ToString(), Session["BranchCode"].ToString(), Convert.ToDateTime(MrVM.MRDate), MrVM.DepositBank, Session["UserName"].ToString());
transaction.Complete();
return(Json("1", JsonRequestBehavior.AllowGet));
}
else
{
transaction.Dispose();
return(Json("3", JsonRequestBehavior.AllowGet));
}
}
catch (Exception)
{
transaction.Dispose();
return(Json("0", JsonRequestBehavior.AllowGet));
}
}
}
