public ActionResult DeleteTransfer(int id) { try { AccountListVsAmountTransfer TransferDetails = db.AccountListVsAmountTransfer.Where(s => s.AccountListVsAmountTransferID == id).FirstOrDefault(); var FromAccountForAmountChange = db.AccountList.Where(s => s.AccountListID == TransferDetails.FromAccountID).FirstOrDefault(); var ToAccountForAmountChange = db.AccountList.Where(s => s.AccountListID == TransferDetails.ToAccountID).FirstOrDefault(); if (ToAccountForAmountChange.InitialBalance < TransferDetails.Amount) { return(Json(new { success = false, message = "Sorry Balance is not avialable for transfer." }, JsonRequestBehavior.AllowGet)); } TransferDetails.DeleteBy = AppUtils.LoginUserID; TransferDetails.DeleteDate = AppUtils.GetDateNow(); TransferDetails.Status = AppUtils.TableStatusIsDelete; FromAccountForAmountChange.InitialBalance = FromAccountForAmountChange.InitialBalance + TransferDetails.Amount; ToAccountForAmountChange.InitialBalance = ToAccountForAmountChange.InitialBalance - TransferDetails.Amount; db.Entry(TransferDetails).State = System.Data.Entity.EntityState.Modified; db.Entry(FromAccountForAmountChange).State = System.Data.Entity.EntityState.Modified; db.Entry(ToAccountForAmountChange).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); TempData["message"] = "Information Removed Successfully"; return(Json(new { success = true }, JsonRequestBehavior.AllowGet)); } catch (Exception ex) { return(Json(new { success = false, message = "Error occourd. Please contact with adminstrator." }, JsonRequestBehavior.AllowGet)); } }
private void SetTransferInformationDuringUpdate(ref AccountListVsAmountTransfer dbTransferDetails, ref AccountList fromAccountForAmountChange, ref AccountList toAccountForAmountChange, AccountListVsAmountTransfer accountlistvsamounttransferdetails) { //dbTransferDetails.AccountListID = accountlistvsamounttransferdetails.AccountListID; //dbTransferDetails.ToAccountID = accountlistvsamounttransferdetails.ToAccountID; dbTransferDetails.TransferDate = accountlistvsamounttransferdetails.TransferDate; dbTransferDetails.Description = accountlistvsamounttransferdetails.Description; dbTransferDetails.PaymentByID = accountlistvsamounttransferdetails.PaymentByID; dbTransferDetails.References = accountlistvsamounttransferdetails.References; dbTransferDetails.UpdateBy = AppUtils.GetLoginUserID(); dbTransferDetails.UpdateDate = AppUtils.GetDateNow(); //if (dbTransferDetails.Amount > accountlistvsamounttransferdetails.Amount) //{ // var ReducedAmount = dbTransferDetails.Amount - accountlistvsamounttransferdetails.Amount; // FromAccountForAmountChange.InitialBalance = FromAccountForAmountChange.InitialBalance + ReducedAmount; // ToAccountForAmountChange.InitialBalance = ToAccountForAmountChange.InitialBalance - ReducedAmount; //} //else if (dbTransferDetails.Amount < accountlistvsamounttransferdetails.Amount) //{ // var AdditionalAmount = dbTransferDetails.Amount - accountlistvsamounttransferdetails.Amount; // FromAccountForAmountChange.InitialBalance = FromAccountForAmountChange.InitialBalance - AdditionalAmount; // ToAccountForAmountChange.InitialBalance = ToAccountForAmountChange.InitialBalance + AdditionalAmount; //} //dbTransferDetails.Amount = accountlistvsamounttransferdetails.Amount; }
private void SetInOutDateDuringCreate(ref AccountListVsAmountTransfer accountListVsAmountTransferIn, ref AccountListVsAmountTransfer accountListVsAmountTransferOut, AccountListVsAmountTransfer cl) { accountListVsAmountTransferIn.BreakDownAccountListID = cl.AccountListVsAmountTransferID; accountListVsAmountTransferIn.TransferType = "In"; accountListVsAmountTransferIn.Amount = cl.Amount; accountListVsAmountTransferIn.CreateBy = cl.CreateBy; accountListVsAmountTransferIn.CreateDate = cl.CreateDate; accountListVsAmountTransferIn.CurrencyID = cl.CurrencyID; accountListVsAmountTransferIn.Description = cl.Description; accountListVsAmountTransferIn.ToAccountID = cl.ToAccountID; accountListVsAmountTransferIn.PaymentByID = cl.PaymentByID; accountListVsAmountTransferIn.References = cl.References; accountListVsAmountTransferIn.Status = cl.Status; accountListVsAmountTransferIn.Tags = cl.Tags; accountListVsAmountTransferIn.TransferDate = cl.TransferDate; accountListVsAmountTransferOut.BreakDownAccountListID = cl.AccountListVsAmountTransferID; accountListVsAmountTransferOut.TransferType = "Out"; accountListVsAmountTransferOut.Amount = cl.Amount; accountListVsAmountTransferOut.CreateBy = cl.CreateBy; accountListVsAmountTransferOut.CreateDate = cl.CreateDate; accountListVsAmountTransferOut.CurrencyID = cl.CurrencyID; accountListVsAmountTransferOut.Description = cl.Description; accountListVsAmountTransferOut.FromAccountID = cl.FromAccountID; accountListVsAmountTransferOut.PaymentByID = cl.PaymentByID; accountListVsAmountTransferOut.References = cl.References; accountListVsAmountTransferOut.Status = cl.Status; accountListVsAmountTransferOut.Tags = cl.Tags; accountListVsAmountTransferOut.TransferDate = cl.TransferDate; }
private string GetButtonForTransfer(AccountListVsAmountTransfer transfer) { AccountListVsAmountTransfer accountListVsAmount = new AccountListVsAmountTransfer(); if (transfer.FromAccountID != 0) { accountListVsAmount = db.AccountListVsAmountTransfer.Where(x => x.Description == transfer.Description && x.TransferDate == transfer.TransferDate && x.Amount == transfer.Amount && x.References == transfer.References && x.FromAccountID == transfer.FromAccountID).FirstOrDefault(); } if (transfer.ToAccountID != 0) { accountListVsAmount = db.AccountListVsAmountTransfer.Where(x => x.Description == transfer.Description && x.TransferDate == transfer.TransferDate && x.Amount == transfer.Amount && x.References == transfer.References && x.ToAccountID == transfer.ToAccountID).FirstOrDefault(); } string s = "<a class='glyphicon glyphicon-edit btn-circle btn-default' href='/AccountListVsAmountTransfer/Manage?id=" + accountListVsAmount.AccountListVsAmountTransferID + "'></a>"; return(s); }
public ActionResult UpdateAccountListVsAmountTransfer(AccountListVsAmountTransfer accountlistvsamounttransferdetails) { try { AccountListVsAmountTransfer dbTransferDetails = db.AccountListVsAmountTransfer.Where(s => s.AccountListVsAmountTransferID == accountlistvsamounttransferdetails.AccountListVsAmountTransferID).FirstOrDefault(); var FromAccountForAmountChange = db.AccountList.Where(s => s.AccountListID == accountlistvsamounttransferdetails.FromAccountID).FirstOrDefault(); var ToAccountForAmountChange = db.AccountList.Where(s => s.AccountListID == accountlistvsamounttransferdetails.ToAccountID).FirstOrDefault(); SetTransferInformationDuringUpdate(ref dbTransferDetails, ref FromAccountForAmountChange, ref ToAccountForAmountChange, accountlistvsamounttransferdetails); db.Entry(dbTransferDetails).State = System.Data.Entity.EntityState.Modified; //db.Entry(FromAccountForAmountChange).State = System.Data.Entity.EntityState.Modified; //db.Entry(ToAccountForAmountChange).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); return(Json(new { success = true }, JsonRequestBehavior.AllowGet)); } catch (Exception ex) { return(Json(new { success = false }, JsonRequestBehavior.AllowGet)); } }
public JsonResult InsertAccountListVsAmountTransfer(AccountListVsAmountTransfer AccountListVsAmountTransferDetails) { try { AccountListVsAmountTransferDetails.CreateBy = AppUtils.GetLoginUserID(); AccountListVsAmountTransferDetails.CreateDate = AppUtils.GetDateTimeNow(); AccountListVsAmountTransferDetails.Status = AppUtils.TableStatusIsActive; AccountListVsAmountTransferDetails.CurrencyID = 1; var FromAccountForAmountChange = db.AccountList.Where(s => s.AccountListID == AccountListVsAmountTransferDetails.FromAccountID).FirstOrDefault(); var ToAccountForAmountChange = db.AccountList.Where(s => s.AccountListID == AccountListVsAmountTransferDetails.ToAccountID).FirstOrDefault(); FromAccountForAmountChange.InitialBalance = (FromAccountForAmountChange.InitialBalance - AccountListVsAmountTransferDetails.Amount); ToAccountForAmountChange.InitialBalance = (ToAccountForAmountChange.InitialBalance + AccountListVsAmountTransferDetails.Amount); db.Entry(FromAccountForAmountChange).State = System.Data.Entity.EntityState.Modified; db.Entry(ToAccountForAmountChange).State = System.Data.Entity.EntityState.Modified; db.AccountListVsAmountTransfer.Add(AccountListVsAmountTransferDetails); db.SaveChanges(); if (AccountListVsAmountTransferDetails.AccountListVsAmountTransferID > 0) { AccountListVsAmountTransfer AccountListVsAmountTransferIn = new AccountListVsAmountTransfer(); AccountListVsAmountTransfer AccountListVsAmountTransferOut = new AccountListVsAmountTransfer(); SetInOutDateDuringCreate(ref AccountListVsAmountTransferIn, ref AccountListVsAmountTransferOut, AccountListVsAmountTransferDetails); db.AccountListVsAmountTransfer.Add(AccountListVsAmountTransferIn); db.AccountListVsAmountTransfer.Add(AccountListVsAmountTransferOut); db.SaveChanges(); } return(Json(new { success = true }, JsonRequestBehavior.AllowGet)); } catch { return(Json(new { success = false }, JsonRequestBehavior.AllowGet)); } }