public async Task <IActionResult> Edit(int id, [Bind("ID,AccNo,Narration,Amount,Balance")] BankDeposit bankDeposit)
{
if (id != bankDeposit.ID)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(bankDeposit);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!BankDepositExists(bankDeposit.ID))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
return(View(bankDeposit));
}
protected void firstButton_Click(object sender, EventArgs e)
{
BankDeposit bankDeposit = bankDepositManager.GetBankDepositInfo(0);
GetValue(bankDeposit);
Session["active"] = 0;
}
protected void saveButton_Click(object sender, EventArgs e)
{
BankDeposit bankDeposit = new BankDeposit();
bankDeposit.BankDate = bankDateTextBox.Value;
bankDeposit.BankId = int.Parse(bankNameDropDownList.SelectedValue);
bankDeposit.Mode = modeDropDownList.SelectedValue;
bankDeposit.PartyBankName = partyBankNameTextBox.Text;
bankDeposit.CheckNo = checkTextBox.Text;
bankDeposit.DistrictId = int.Parse(districtDropDownList.SelectedValue);
bankDeposit.PartyId = int.Parse(partyDropDownList.SelectedValue);
string amount = amountTextBox.Text;
if (bankDateTextBox.Value == "" || modeDropDownList.Text == "" || checkTextBox.Text == "" ||
partyBankNameTextBox.Text == "" || amountTextBox.Text == "")
{
messageLabel.InnerText = "All Fields are Required!!";
}
else
{
bankDeposit.Amount = Convert.ToDouble(amount);
messageLabel.InnerText = bankDepositManager.Save(bankDeposit);
}
ClearTextBoxes();
}
private void InitViewBag(BankDeposit info)
{
ViewBag.BankAccountList =
new SelectList(this._GlobalService.GetBankAccountList(), "Value", "Text", null);
HashSet <MyTextValue> sort = new HashSet <MyTextValue>();
sort.Add(new MyTextValue {
Text = "票據號碼", Value = "CheckNum", Disabled = false
});
sort.Add(new MyTextValue {
Text = "收(開)票日期", Value = "DealDate", Disabled = false
});
sort.Add(new MyTextValue {
Text = "到期日期", Value = "ExpiryDate", Disabled = false
});
ViewBag.SortList = new SelectList(sort, "Value", "Text", null);
ViewBag.DepositSummaryList =
new SelectList(this._GlobalService.GetDepositSummaryList(), "Text", "Text", null);
ViewBag.CheckStatusList =
new SelectList(this._GlobalService.GetCheckStatusList(), "Value", "Text", null);
ViewBag.DealItemList =
new SelectList(this._GlobalService.GetDealItemList(), "Value", "Text", null);
ViewBag.YseNoList =
new SelectList(YesNo.GetAll(), "value", "Text", info?.Activate);
}
public void OnUpdate(AprajitaRetailsContext db, BankDeposit objectName)
{
var old = db.BankDeposits.Where(c => c.BankDepositId == objectName.BankDepositId).Select(d => new { d.Amount, d.DepoDate, d.PayMode }).FirstOrDefault();
if (old != null)
{
if (old.PayMode == BankPayModes.Cash)
{
CashTrigger.UpDateCashOutHand(db, old.DepoDate, 0 - old.Amount);
CashTrigger.UpdateCashInBank(db, old.DepoDate, 0 - old.Amount);
}
if (old.PayMode != BankPayModes.Cash)
{
CashTrigger.UpdateCashInBank(db, old.DepoDate, 0 - old.Amount);
}
}
if (objectName.PayMode == BankPayModes.Cash)
{
CashTrigger.UpDateCashOutHand(db, objectName.DepoDate, objectName.Amount);
CashTrigger.UpdateCashInBank(db, objectName.DepoDate, objectName.Amount);
}
//TODO: in future make it more robust
if (objectName.PayMode != BankPayModes.Cash)
{
CashTrigger.UpdateCashInBank(db, objectName.DepoDate, objectName.Amount);
}
}
public async Task <IActionResult> PutBankDeposit(int id, BankDeposit bankDeposit)
{
if (id != bankDeposit.BankDepositId)
{
return(BadRequest());
}
_context.Entry(bankDeposit).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!BankDepositExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
public async Task <ActionResult <BankDeposit> > PostBankDeposit(BankDeposit bankDeposit)
{
_context.BankDeposits.Add(bankDeposit);
await _context.SaveChangesAsync();
return(CreatedAtAction("GetBankDeposit", new { id = bankDeposit.BankDepositId }, bankDeposit));
}
// 處理銀行票據
private void ProcessBankDeposit(Receipt info)
{
BankDeposit deposite = new BankDeposit()
{
DealDate = info.ReceiptDate,
ExpiryDate = info.DueDate,
Summary = GetDipositSummary(info),
DebitAmount = 0,
CreditAmount = info.CheckAmount + info.CashAmount,
CompanyID = info.CustomerID,
CheckNum = info.CheckNum,
//BankID = info.BankID,
//AccountID = info.AccountID,
SourceID = info.ReceiptID,
CheckStatus = CheckStatus.Uncounted.Value,
Activate = YesNo.Yes.Value
};
// 先刪除舊資料
var delate =
_BankDeposit.GetAll().Where(x => x.SourceID == info.ReceiptID).SingleOrDefault();
if (delate != null)
{
_BankDeposit.Delete(delate);
}
_BankDeposit.Create(deposite);
}
public ActionResult DeleteConfirmed(int id)
{
BankDeposit bankDeposit = db.BankDeposits.Find(id);
db.BankDeposits.Remove(bankDeposit);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public string Save(BankDeposit bankDeposit)
{
if (bankDepositGateway.Insert(bankDeposit) > 0)
{
return("Saved Successfully!!");
}
return("Could Not Save data In Database!!");
}
private BankDeposit GetInfoOnUpdate(BankDeposit source)
{
BankDeposit info = Mapper.Map <BankDeposit>(source);
info.LastPerson = IdentityService.GetUserData().UserID;
info.LastUpdate = DateTime.Now;
return(info);
}
private Model.BankDeposit GetInfoOnDelete(BankDeposit info)
{
info.Activate = YesNo.No.Value;
info.LastPerson = _CurrentUser.UserID;;
info.LastUpdate = DateTime.Now;
return(info);
}
public bool IsUsed(BankDeposit info)
{
//var query = this._Repository.Get(x => x.BankDepositID == info.BankDepositID);
//var result = query.Product.Any();
//this._Repository.HandleDetached(query); //
//return result;
return(true);
}
public ActionResult DeleteConfirmed(int id)
{
BankDeposit bankDeposit = db.BankDeposits.Find(id);
Utils.UpDateCashOutHand(db, bankDeposit.DepoDate, 0 - bankDeposit.Amount);
db.BankDeposits.Remove(bankDeposit);
db.SaveChanges();
return(RedirectToAction("Index"));
}
protected void lastButton_Click(object sender, EventArgs e)
{
List <BankDeposit> bankDepositList = (List <BankDeposit>)(Session["bankDeposit"]);
int x = bankDepositList.Count - 1;
BankDeposit bankDeposit = bankDepositManager.GetBankDepositInfo(x);
GetValue(bankDeposit);
Session["active"] = x;
}
public void Delete(BankDeposit info)
{
if (info == null)//沒有資料
{
throw new Exception("MessageNoData".ToLocalized());
}
this._Repository.Delete(info);
this._UnitOfWork.SaveChange();
}
private void GetValue(BankDeposit bankDeposit)
{
bankDateTextBox.Value = bankDeposit.BankDate;
bankNameDropDownList.Text = bankDeposit.BankName;
modeDropDownList.Text = bankDeposit.Mode;
partyBankNameTextBox.Text = bankDeposit.PartyBankName;
checkTextBox.Text = bankDeposit.CheckNo;
districtDropDownList.Text = bankDeposit.DistrictName;
partyDropDownList.Text = bankDeposit.PartyName;
amountTextBox.Text = bankDeposit.Amount.ToString();
}
public void Update(BankDeposit info)
{
BankDeposit query = GetInfoOnUpdate(info);
if (query == null)//沒有資料
{
throw new Exception("MessageNoData".ToLocalized());
}
this._Repository.Update(query);
this._UnitOfWork.SaveChange();
}
private static void GetValueFromDatabase(BankDeposit bankDeposit, SqlDataReader reader)
{
bankDeposit.BankDepositId = int.Parse(reader["id"].ToString());
bankDeposit.BankDate = reader["date"].ToString();
bankDeposit.BankName = reader["bank_id"].ToString();
bankDeposit.Mode = reader["mode"].ToString();
bankDeposit.PartyBankName = reader["party_bank_name"].ToString();
bankDeposit.CheckNo = reader["check_no"].ToString();
bankDeposit.DistrictName = reader["district_id"].ToString();
bankDeposit.PartyName = reader["party_id"].ToString();
bankDeposit.Amount = Convert.ToDouble(reader["amount"].ToString());
}
public void OnDelete(AprajitaRetailsContext db, BankDeposit objectName)
{
if (objectName.PayMode == BankPayModes.Cash)
{
CashTrigger.UpDateCashOutHand(db, objectName.DepoDate, 0 - objectName.Amount);
CashTrigger.UpdateCashInBank(db, objectName.DepoDate, 0 - objectName.Amount);
}
//TODO: in future make it more robust
if (objectName.PayMode != BankPayModes.Cash)
{
CashTrigger.UpdateCashInBank(db, objectName.DepoDate, 0 - objectName.Amount);
}
}
public async Task <IActionResult> Create([Bind("BankDepositId,DepoDate,AccountNumberId,Amount,PayMode,Details,Remarks")] BankDeposit bankDeposit)
{
if (ModelState.IsValid)
{
_context.Add(bankDeposit);
new BankingManager().OnInsert(_context, bankDeposit);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
ViewData["AccountNumberId"] = new SelectList(_context.AccountNumbers, "AccountNumberId", "Account", bankDeposit.AccountNumberId);
return(PartialView(bankDeposit));
}
public ActionResult Create([Bind(Include = "BankDepositId,DepoDate,AccountNumberId,Amount,PayMode,Details,Remarks")] BankDeposit bankDeposit)
{
if (ModelState.IsValid)
{
db.BankDeposits.Add(bankDeposit);
ProcessAccounts(bankDeposit);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.AccountNumberId = new SelectList(db.BankAccounts, "AccountNumberId", "Account", bankDeposit.AccountNumberId);
return(View(bankDeposit));
}
private void ProcessAccounts(BankDeposit objectName)
{
if (objectName.PayMode == BankPayModes.Cash)
{
Utils.UpDateCashOutHand(db, objectName.DepoDate, objectName.Amount);
Utils.UpDateCashInBank(db, objectName.DepoDate, objectName.Amount);
}
//TODO: in future make it more robust
if (objectName.PayMode != BankPayModes.Cash)
{
Utils.UpDateCashInBank(db, objectName.DepoDate, objectName.Amount);
}
}
public ActionResult Edit([Bind(Include = "BankDepositId,DepoDate,AccountNumberId,Amount,PayMode,Details,Remarks")] BankDeposit bankDeposit)
{
if (ModelState.IsValid)
{
//TODO: Rectifed This ProcessAccounts(bankDeposit);
bankDeposit.Remarks += " Edit, Match with original data";
db.Entry(bankDeposit).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.AccountNumberId = new SelectList(db.BankAccounts, "AccountNumberId", "Account", bankDeposit.AccountNumberId);
return(View(bankDeposit));
}
// GET: BankDeposits/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
BankDeposit bankDeposit = db.BankDeposits.Find(id);
if (bankDeposit == null)
{
return(HttpNotFound());
}
return(PartialView(bankDeposit));
}
// GET: BankDeposits/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
BankDeposit bankDeposit = db.BankDeposits.Find(id);
if (bankDeposit == null)
{
return(HttpNotFound());
}
ViewBag.AccountNumberId = new SelectList(db.BankAccounts, "AccountNumberId", "Account", bankDeposit.AccountNumberId);
return(View(bankDeposit));
}
public int Insert(BankDeposit bankDeposit)
{
SqlConnection connection = new SqlConnection(connectionString);
string query = "INSERT INTO tbl_bankDeposit VALUES('" + bankDeposit.BankDate + "','" + bankDeposit.BankId +
"','" + bankDeposit.Mode + "','" + bankDeposit.PartyBankName + "','" + bankDeposit.CheckNo +
"','" + bankDeposit.DistrictId + "','" + bankDeposit.PartyId + "','" + bankDeposit.Amount +
"')";
SqlCommand command = new SqlCommand(query, connection);
connection.Open();
int rowAffected = command.ExecuteNonQuery();
connection.Close();
return(rowAffected);
}
public IActionResult Create(BankDepositViewModel model)
{
BankDeposit bankDeposit = _mapper.Map <BankDeposit>(model);
bankDeposit.CreatedDate = DateTime.Now;
bankDeposit.Status = 1;
var bankDepositThirdPartyCheques = new List <BankDepositThirdPartyCheque>();
model.ThirdPartyChequesId.ForEach(item => {
bankDepositThirdPartyCheques.Add(new BankDepositThirdPartyCheque()
{
ThirdPartyChequeId = item
});
});
bankDeposit.BankDepositThirdPartyCheques = bankDepositThirdPartyCheques;
_context.BankDeposits.Add(bankDeposit);
var balanceSheets = _context.BalanceSheets.SingleOrDefault(c => c.BalanceSheetId == 1);
if (balanceSheets == null)
{
return(Ok());
}
balanceSheets.InHandCash -= bankDeposit.InHandCash;
balanceSheets.BankBalance += bankDeposit.Cash + bankDeposit.InHandCash;
balanceSheets.InHold += model.ChequeTotal;
var thirdPartyCheques = _context.ThirdPartyCheques.Where(x => model.ThirdPartyChequesId.Contains(x.ThirdPartyChequeId)).ToList();
thirdPartyCheques.ForEach(x => x.Status = 5);
_context.ThirdPartyCheques.UpdateRange(thirdPartyCheques);
var flag = _context.SaveChanges();
List <ThirdPartyChequeActionLog> actionLog = new List <ThirdPartyChequeActionLog>();
thirdPartyCheques.ForEach(y => {
actionLog.Add(new ThirdPartyChequeActionLog {
UserId = model.CreatedBy, ChequeStatusId = 5, ThirdPartyChequeId = y.ThirdPartyChequeId, ReferenceId = bankDeposit.BankDepositId
});
});
_context.ThirdPartyChequeActionLogs.AddRange(actionLog);
_context.SaveChanges();
return(Ok(flag > 0));
}
protected void nextButton_Click(object sender, EventArgs e)
{
int active = (int)Session["active"];
active++;
List <BankDeposit> bankDepositList = (List <BankDeposit>)(Session["bankDeposit"]);
if (active >= bankDepositList.Count)
{
active = 0;
}
BankDeposit bankDeposit = bankDepositManager.GetBankDepositInfo(active);
GetValue(bankDeposit);
Session["active"] = active;
}
public void InstantiateIn(Control container)
{
parent = (GridViewBaseRowTemplateContainer)container;
//CssPostfix = parent.Grid.CssPostfix;
//tbControl = new Table();
tbData = new Table();
//tbControl.SetTableControlStyle(CssPostfix);
//tbData.SetTableStyle(CssPostfix);
//TableRow row = new TableRow();
//TableCell cell = new TableCell();
//cell.Controls.Add(tbData);
//row.Cells.Add(cell);
//tbControl.Rows.Add(row);
//tbData.SetPageContentStyle(parent.Grid.CssPostfix);
int paymentID = (int)DataBinder.Eval(parent.DataItem, "PaymentID");
payment = context.PersistencySession.Get <iSabaya.Payment>(paymentID);
if (payment.Type.Equals(typeof(Cheque)))
{
Cheque c = payment as Cheque;
this.AddDataItem(c);
}
else if (payment.Type.Equals(typeof(Cash)))
{
Cash c = payment as Cash;
this.AddDataItem("Destination Bank Account:", c.DestinationBankAccount);
this.AddDataItem("Recipient Name:", c.RecipientName);
}
else if (payment.Type.Equals(typeof(BankDeposit)))
{
BankDeposit bd = payment as BankDeposit;
this.AddDataItem(bd.Cheque);
this.AddDataItem("Bank Account:", bd.BankAccount);
this.AddDataItem("Recipient Name:", bd.RecipientName);
}
else if (payment.Type.Equals(typeof(FundTransfer)))
{
FundTransfer ft = payment as FundTransfer;
this.AddDataItem("Status:", ft.Status.ToString());
this.AddDataItem("Status Date:", ft.StatusDate);
this.AddDataItem("From Bank Account:", ft.FromBankAccount);
this.AddDataItem("To Bank Account:", ft.ToBankAccount);
this.AddDataItem("Recipient Name:", ft.RecipientName);
}
parent.Controls.Add(tbData);
}
