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" }));
}
