public ActionResult DeleteHead(int id)
{
try
{
HeadAccount main = service.findHeadAcc(id);
DateTime updateTime = DateTime.UtcNow;
main.is_active = "N";
main.update_at = updateTime;
foreach (SubHeadAccount sub in main.SubHeadAccounts)
{
sub.is_active = "N";
sub.update_at = updateTime;
foreach (TransactionAccount trans in sub.TransactionAccounts)
{
trans.is_active = "N";
trans.updated_at_ = updateTime;
}
}
service.save();
return(RedirectToAction("Index"));
}
catch
{
return(View());
}
}
public MainAccount findMainHead(int id)
{
HeadAccount head = db.HeadAccounts.Find(id);
MainAccount main = db.MainAccounts.Find(head.main_id);
return(main);
}
public ActionResult ExpenseReportsPostHead(string search, string dateStart, string dateEnd)
{
HeadAccount accounts = service.findHeadAccounts(search);
// var balance = service.findAccountBalance(search);
// ViewBag.openingBalance = balance;
ViewBag.start = Convert.ToDateTime(dateStart);
ViewBag.end = Convert.ToDateTime(dateEnd);
ViewBag.headAccounts = service.allHeadAccounts();
return(View(accounts));
}
public ActionResult EditHeadAcc(int id, FormCollection collection)
{
try
{
HeadAccount head = service.findHeadAcc(id);
head.name = collection["name"];
head.update_at = DateTime.UtcNow;
service.save();
return(RedirectToAction("Index"));
}
catch
{
return(View());
}
}
public ActionResult CreatePostHead(string id, FormCollection collection)
{
int identity = int.Parse(id);
AccountServices service = new AccountServices();
HeadAccount headAccount = new HeadAccount();
MainAccount mainAccount = service.findMainAcc(identity);
headAccount.main = mainAccount.name;
headAccount.code = collection["code"];
headAccount.name = collection["name"];
headAccount.main_id = identity;
headAccount.is_active = "Y";
headAccount.update_at = DateTime.UtcNow;
headAccount.created_at = DateTime.UtcNow;
headAccount.code = "0" + headAccount.main_id + "00" + headAccount.code;
service.addHeadAcc(headAccount);
return(RedirectToAction("Index"));
}
public ActionResult CreatePostSubHead(string id, FormCollection collection)
{
int identity = int.Parse(id);
AccountServices service = new AccountServices();
MainAccount main = service.findMainHead(identity);
HeadAccount head = service.findHeadAcc(identity);
SubHeadAccount sub = new SubHeadAccount();
sub.head_id = head.head_id;
sub.main_id = head.main_id;
sub.parent = head.name;
sub.code = collection["code"];
sub.name = collection["name"];
sub.is_active = "Y";
sub.update_at = DateTime.UtcNow;
sub.created_at = DateTime.UtcNow;
sub.code = "0" + sub.main_id + "00" + sub.head_id + "000" + sub.code;
service.addSubHeadAcc(sub);
return(RedirectToAction("Index"));
}
public void addHeadAcc(HeadAccount head)
{
db.HeadAccounts.Add(head);
db.SaveChanges();
}
