public JsonResult Create(JournalModel obj) { tblJournal model = new tblJournal(); if (obj != null) { obj.TPage = obj.EPage - obj.SPage; model.Id = obj.id; model.Category = obj.category; model.title = obj.title; model.Noofauthor = obj.Noofauthor; model.author1 = obj.author1; model.author2 = obj.author2; model.author3 = obj.author3; model.author4 = obj.author4; model.author5 = obj.author6; model.author6 = obj.author6; model.journalName = obj.JournalNm; model.issueno = obj.issueno; model.volumeno = obj.volumeno; model.SPage = obj.SPage; model.EPage = obj.EPage; model.totalPage = obj.TPage; model.pubName = obj.pubName; model.Impact_Factor = obj.impactFactor; model.Country = obj.Country; model.pubDate = obj.PubDate; db.tblJournals.Add(model); db.SaveChanges(); return(Json(obj)); } return(Json("error", JsonRequestBehavior.AllowGet)); }
public ActionResult DeleteConfirmed(int id) { tblJournal tblJournal = db.tblJournals.Find(id); db.tblJournals.Remove(tblJournal); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Edit([Bind(Include = "Id,Category,title,Noofauthor,author1,author2,author3,author4,author5,author6,issueno,journalName,volumeno,SPage,EPage,totalPage,pubName,Impact_Factor,Country,pubDate")] tblJournal tblJournal) { if (ModelState.IsValid) { db.Entry(tblJournal).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(tblJournal)); }
public ActionResult Edit(int?id) { List <string> countrylist = new List <string>(); CultureInfo[] CInfoList = CultureInfo.GetCultures(CultureTypes.SpecificCultures); foreach (CultureInfo CInfo in CInfoList) { RegionInfo R = new RegionInfo(CInfo.LCID); if (!(countrylist.Contains(R.EnglishName))) { countrylist.Add(R.EnglishName); } } countrylist.Sort(); ViewData["CountryList"] = new SelectList(countrylist); if (id == null) { return(HttpStatusCodeResult(HttpStatusCode.BadRequest)); } tblJournal JObj = db.tblJournals.Find(id); if (JObj == null) { return(new HttpStatusCodeResult(HttpStatusCode.NotFound)); } ViewData["Category"] = JObj.Category; ViewData["title"] = JObj.title; ViewData["ImpactFactor"] = JObj.Impact_Factor; ViewData["Noofauthor"] = JObj.Noofauthor; ViewData["author1"] = JObj.author1; ViewData["author2"] = JObj.author2; ViewData["author3"] = JObj.author3; ViewData["author4"] = JObj.author4; ViewData["author5"] = JObj.author5; ViewData["author6"] = JObj.author6; ViewData["volumeno"] = JObj.volumeno; ViewData["journalName"] = JObj.journalName; ViewData["issueno"] = JObj.issueno; ViewData["pubName"] = JObj.pubName; ViewData["pubDate"] = JObj.pubDate; ViewData["SPage"] = JObj.SPage; ViewData["EPage"] = JObj.EPage; ViewData["totalPage"] = JObj.totalPage; ViewData["Country"] = JObj.Country.ToString(); ViewData["Id"] = JObj.Id; return(View(JObj)); }
// GET: tblJournals/Delete/5 public ActionResult Delete(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } tblJournal tblJournal = db.tblJournals.Find(id); if (tblJournal == null) { return(HttpNotFound()); } return(View(tblJournal)); }
public JsonResult Delete(int id) { if (id == null) { return(Json("id is Null")); } tblJournal tblJournal = db.tblJournals.Find(id); if (tblJournal == null) { return(Json("Id is not available")); } db.tblJournals.Remove(tblJournal); db.SaveChanges(); return(Json(tblJournal)); }
public ActionResult AddCustomerPrepaid(int customer, float amount, string desc, int cashacc, DateTime trandate) { //UsersController u = new UsersController(); //u.checkaccess(79); int depositpayableacc = 2110; int userid = (int)Session["UserID"]; DateTime vdate = trandate; int Cust_Tran_Type = 8; // Prepaid // Add Journal tblJournal j = new tblJournal(); string customername = ""; customername = db.tblCustomers.Where(a => a.CustomerID == customer).Select(a => a.Customer_Name).FirstOrDefault(); string tranNbr = DateTime.UtcNow.AddHours(3).ToString().GetHashCode().ToString("x"); j.Journal_Date = vdate; j.Tran_Nbr = tranNbr; j.TYear = DateTime.UtcNow.AddHours(3).Year; j.Period = DateTime.UtcNow.AddHours(3).Month; j.UserID = userid; j.Status = "Open"; j.Tran_Type = "Customer Prepaid"; j.Description = "Prepaid " + customername + "-" + desc; db.tblJournals.Add(j); db.SaveChanges(); int Journal_id = db.tblJournals.Where(a => a.UserID == userid).Select(a => a.Journal_id).Max(); // Deposit Payable db.tblJournal_Details.Add(new tblJournal_Details { Journal_id = Journal_id, Debit = 0, Credit = amount, Account_Number = depositpayableacc }); db.SaveChanges(); // Cash db.tblJournal_Details.Add(new tblJournal_Details { Journal_id = Journal_id, Debit = amount, Credit = 0, Account_Number = cashacc }); db.SaveChanges(); // Add cash flow int Journal_Detail_id = db.tblJournal_Details.Where(a => a.Journal_id == Journal_id).Select(a => a.Journal_Detail_id).Max(); db.tblCash_Flow.Add(new tblCash_Flow { Debit = amount, Credit = 0, Journal_Detail_id = Journal_Detail_id, Description = "Cash Received from Customer Prepaid " + customername, Tran_Nbr = tranNbr, Tran_Type = "Cash In" }); // add customer Transaction int?cust_tran_id = db.tblCustomer_Transaction.Where(a => a.CustomerID == customer && a.Status == "Open").Select(a => a.Cust_Tran_ID).FirstOrDefault(); if (cust_tran_id == null || cust_tran_id == 0) { db.tblCustomer_Transaction.Add(new tblCustomer_Transaction { Amount = amount, CustomerID = customer, Status = "Open", Tran_Date = vdate, UserID = userid }); db.SaveChanges(); cust_tran_id = db.tblCustomer_Transaction.Where(a => a.UserID == userid).Select(a => a.Cust_Tran_ID).Max(); } db.tblCustomer_Transaction_Detail.Add(new tblCustomer_Transaction_Detail { Debit = 0, Credit = amount, Cust_Tran_Type_ID = Cust_Tran_Type, Status = "Open", UserID = userid, Description = "Custmer Prepaid - " + desc, Tran_Nbr = tranNbr, Trans_Date = vdate, Cust_Tran_ID = (int)cust_tran_id }); db.SaveChanges(); float intTotal_Vendor_Balance = (float)db.Get_Total_Customer_Transaction_Detail_by_TranID(cust_tran_id).FirstOrDefault(); db.Update_Customer_Tranaction_Amount_By_Cust_tran_id(intTotal_Vendor_Balance, cust_tran_id); //add log mnc.addlog("Customers", " Customer Prepaid " + customername + " Amount: " + amount, userid); string strWord = mnc.ToWords(amount.ToString()); var x = db.tblReceipt_Voucher.Add(new tblReceipt_Voucher { Receipt_Date = vdate, Balance = intTotal_Vendor_Balance, Tran_Nbr = tranNbr, Description = "Customer Prepaid", Payee = customername, UserID = userid, Amount = amount, In_Word = strWord }); db.SaveChanges(); int voucher_id = db.tblReceipt_Voucher.Where(a => a.UserID == userid).Select(a => a.Voucher_ID).Max(); // UpdateVoucher_Number((int)voucher_id); return(RedirectToAction("ReceiptVoucher", "Accounting", new { id = voucher_id })); }
public ActionResult CustomerPayment(int customerid, int trantype, float amount, string desc, int?cashacc, int?discountacc, int?aracc, DateTime trans_Date) { //UsersController u = new UsersController(); //u.checkaccess(11); string tranNbr = DateTime.UtcNow.AddHours(3).ToString().GetHashCode().ToString("x"); int userid = (int)Session["UserID"]; string tranname = ""; if (trantype == 1) { tranname = "Customer Payment"; } else if (trantype == 2) { tranname = "Customer Discount"; } else { tranname = "Customer Refund"; } int Cust_Tran_Type = trantype; DateTime vdate = trans_Date; string customername = ""; customername = db.tblCustomers.Where(a => a.CustomerID == customerid).Select(a => a.Customer_Name).FirstOrDefault(); string inwords = ""; int? voucher_id; int?cust_tran_id = db.tblCustomer_Transaction.Where(a => a.CustomerID == customerid && a.Status == "Open").Select(a => a.Cust_Tran_ID).Max(); //add log mnc.addlog("Customers", " " + tranname + " | Customer " + customername + " Amount: " + amount, userid); if (cust_tran_id == null) { db.tblCustomer_Transaction.Add(new tblCustomer_Transaction { Amount = amount, CustomerID = customerid, Status = "Open", Tran_Date = vdate, UserID = userid }); db.SaveChanges(); cust_tran_id = db.tblCustomer_Transaction.Where(a => a.UserID == userid).Select(a => a.Cust_Tran_ID).Max(); } if (trantype == 1) { db.tblCustomer_Transaction_Detail.Add(new tblCustomer_Transaction_Detail { Debit = 0, Credit = amount, Cust_Tran_Type_ID = Cust_Tran_Type, Status = "Open", UserID = userid, Description = "Custmer Payment - " + desc, Tran_Nbr = tranNbr, Trans_Date = vdate, Cust_Tran_ID = (int)cust_tran_id }); } if (trantype == 2) { db.tblCustomer_Transaction_Detail.Add(new tblCustomer_Transaction_Detail { Debit = 0, Credit = amount, Cust_Tran_Type_ID = Cust_Tran_Type, Status = "Open", UserID = userid, Description = "Custmer Discount -" + desc, Tran_Nbr = tranNbr, Trans_Date = vdate, Cust_Tran_ID = (int)cust_tran_id }); } if (trantype == 3) { db.tblCustomer_Transaction_Detail.Add(new tblCustomer_Transaction_Detail { Debit = amount, Credit = 0, Cust_Tran_Type_ID = Cust_Tran_Type, Status = "Open", UserID = userid, Description = "Custmer Refund -" + desc, Tran_Nbr = tranNbr, Trans_Date = vdate, Cust_Tran_ID = (int)cust_tran_id }); } db.SaveChanges(); float intTotal_Vendor_Balance = (float)db.Get_Total_Customer_Transaction_Detail_by_TranID(cust_tran_id).FirstOrDefault(); db.Update_Customer_Tranaction_Amount_By_Cust_tran_id(intTotal_Vendor_Balance, cust_tran_id); // Add Journal tblJournal j = new tblJournal(); j.Journal_Date = vdate; j.Tran_Nbr = tranNbr; j.TYear = DateTime.UtcNow.AddHours(3).Year; j.Period = DateTime.UtcNow.AddHours(3).Month; j.UserID = userid; j.Status = "Open"; j.Tran_Type = "Customers"; j.Description = "Customer Transaction-" + desc; db.tblJournals.Add(j); db.SaveChanges(); int Journal_id = db.tblJournals.Where(a => a.UserID == userid).Select(a => a.Journal_id).Max(); if (trantype == 1) { // Cash db.tblJournal_Details.Add(new tblJournal_Details { Journal_id = Journal_id, Debit = amount, Credit = 0, Account_Number = (int)cashacc }); db.SaveChanges(); // Add cash flow int Journal_Detail_id = db.tblJournal_Details.Where(a => a.Journal_id == Journal_id).Select(a => a.Journal_Detail_id).Max(); db.tblCash_Flow.Add(new tblCash_Flow { Debit = amount, Credit = 0, Journal_Detail_id = Journal_Detail_id, Description = "Cash Recieved from CustomerID " + customerid, Tran_Nbr = tranNbr, Tran_Type = "Cash In" }); // Acc Receiable db.tblJournal_Details.Add(new tblJournal_Details { Journal_id = Journal_id, Debit = 0, Credit = amount, Account_Number = (int)aracc }); db.SaveChanges(); } if (trantype == 2) { // Discount Expense db.tblJournal_Details.Add(new tblJournal_Details { Journal_id = Journal_id, Debit = amount, Credit = 0, Account_Number = (int)discountacc }); // Acc Receivable db.tblJournal_Details.Add(new tblJournal_Details { Journal_id = Journal_id, Debit = 0, Credit = amount, Account_Number = (int)aracc }); db.SaveChanges(); } if (trantype == 3) { // Cash db.tblJournal_Details.Add(new tblJournal_Details { Journal_id = Journal_id, Debit = 0, Credit = amount, Account_Number = (int)cashacc }); db.SaveChanges(); // Add cash flow int Journal_Detail_id = db.tblJournal_Details.Where(a => a.Journal_id == Journal_id).Select(a => a.Journal_Detail_id).Max(); db.tblCash_Flow.Add(new tblCash_Flow { Debit = 0, Credit = amount, Journal_Detail_id = Journal_Detail_id, Description = "Cash Refunded for Customer " + customername, Tran_Nbr = tranNbr, Tran_Type = "Cash Out" }); // Acc Receiable db.tblJournal_Details.Add(new tblJournal_Details { Journal_id = Journal_id, Debit = amount, Credit = 0, Account_Number = (int)aracc }); db.SaveChanges(); } if (trantype == 1) { string strWord = mnc.ToWords(amount.ToString()); var x = db.tblReceipt_Voucher.Add(new tblReceipt_Voucher { Receipt_Date = vdate, Balance = intTotal_Vendor_Balance, Tran_Nbr = tranNbr, Description = "Customer Payment", Payee = customername, UserID = userid, Amount = amount, In_Word = strWord }); db.SaveChanges(); voucher_id = db.tblReceipt_Voucher.Where(a => a.UserID == userid).Select(a => a.Voucher_ID).Max(); // UpdateVoucher_Number((int)voucher_id); return(RedirectToAction("ReceiptVoucher", "Accounting", new { id = voucher_id })); } if (trantype == 3) { string strWord = mnc.ToWords(amount.ToString()); var x = db.tblPayment_Voucher.Add(new tblPayment_Voucher { Payment_Date = vdate, Tran_Nbr = tranNbr, Description = "Customer Refund", Payee = customername, UserID = userid, Amount = amount, In_Word = strWord }); db.SaveChanges(); voucher_id = db.tblPayment_Voucher.Where(a => a.UserID == userid).Select(a => a.Voucher_ID).Max(); // UpdateVoucher_Number((int)voucher_id); return(RedirectToAction("PaymentVoucher", "Accounting", new { id = voucher_id })); } return(RedirectToAction("CustomerTrans", "Cust", new { id = customerid, msg = "Customer Transaction Recorded Successfully" })); }