public ActionResult ExpenseReportsPostSub(string search, string dateStart, string dateEnd)
{
SubHeadAccount accounts = service.findSubHeadAccounts(search);
// var balance = service.findAccountBalance(search);
// ViewBag.openingBalance = balance;
ViewBag.start = Convert.ToDateTime(dateStart);
ViewBag.end = Convert.ToDateTime(dateEnd);
ViewBag.subHeadAccounts = service.allSubHeadAccounts();
return(View(accounts));
}
public ActionResult EditSubHeadAcc(int id, FormCollection collection)
{
try
{
SubHeadAccount head = service.findSubHeadAcc(id);
head.name = collection["name"];
head.update_at = DateTime.UtcNow;
service.save();
return(RedirectToAction("Index"));
}
catch
{
return(View());
}
}
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 ActionResult DeleteSub(int id)
{
try
{
SubHeadAccount main = service.findSubHeadAcc(id);
DateTime updateTime = DateTime.UtcNow;
main.is_active = "N";
main.update_at = updateTime;
foreach (TransactionAccount trans in main.TransactionAccounts)
{
trans.is_active = "N";
trans.updated_at_ = updateTime;
}
service.save();
return(RedirectToAction("Index"));
}
catch
{
return(View());
}
}
public void addSubHeadAcc(SubHeadAccount sub)
{
db.SubHeadAccounts.Add(sub);
db.SaveChanges();
}
public ActionResult CreatePostTrans(string id, FormCollection collection)
{
try
{
AccountServices service = new AccountServices();
string name = collection["name"];
if (service.checkName(name) == true)
{
return(Content("<script language='javascript' type='text/javascript'>alert('Name Already Exists , Try Again with diffrent name !');</script>"));
}
int identity = int.Parse(id);
SubHeadAccount sub = service.findSubHeadAcc(identity);
TransactionAccount trans = new TransactionAccount();
trans.type_ = collection["Type"];
if (collection["OB"] == "Cr.")
{
trans.cr_ = Convert.ToInt32(collection["amount"]);
trans.dr_ = 0;
trans.balance = trans.cr_ * (-1);
}
else
{
trans.dr_ = Convert.ToInt32(collection["amount"]);
trans.cr_ = 0;
trans.balance = trans.dr_;
}
trans.head_id = sub.head_id;
trans.main_id = sub.main_id;
trans.sub_head_id = sub.sub_head_id;
trans.description = "Opening new Account";
trans.WEIGHT = collection["weight"];
trans.opening_weight = trans.WEIGHT;
trans.name = collection["name"];
trans.is_active = "Y";
trans.updated_at_ = DateTime.UtcNow;
trans.created_at_ = Convert.ToDateTime(collection["date"]);
// for Opening Balance store
trans.parent = trans.balance.ToString();
trans.code = "0";
service.addTransAcc(trans);
// AccountServices.addRistrictedAccount(trans.name);
trans.code = "0" + trans.main_id + "00" + trans.head_id + "000" + trans.sub_head_id + "0000" + trans.id;
service.save();
if (sub.sub_head_id == 34) // finished good inventories id
{
SubHeadAccount subHead = new SubHeadAccount();
subHead.head_id = 16;
subHead.main_id = 12;
subHead.parent = "Sales of Products";
subHead.code = "0" + sub.main_id + "00" + sub.head_id + "000";
subHead.name = collection["name"] + " Sale ";
subHead.is_active = "Y";
subHead.update_at = DateTime.UtcNow;
subHead.created_at = DateTime.UtcNow;
service.addSubHeadAcc(subHead);
service.save();
subHead.code = subHead.sub_head_id.ToString();
subHead.code = "0" + sub.main_id + "00" + sub.head_id + "000" + sub.sub_head_id;
TransactionAccount transNew = new TransactionAccount();
transNew.type_ = "income";
transNew.cr_ = 0;
transNew.dr_ = 0;
transNew.balance = 0;
transNew.head_id = 16;
transNew.sub_head_id = subHead.sub_head_id;
transNew.main_id = 12;
transNew.description = "Opening new Account";
transNew.name = collection["name"] + " Sale " + " Account ";
transNew.is_active = "Y";
transNew.updated_at_ = DateTime.UtcNow;
transNew.created_at_ = Convert.ToDateTime(collection["date"]);
transNew.code = "0";
transNew.WEIGHT = trans.WEIGHT;
transNew.opening_weight = trans.opening_weight;
service.addTransAcc(transNew);
transNew.code = "0" + transNew.main_id + "00" + transNew.head_id + "000" + transNew.sub_head_id + "0000" + transNew.id;
transNew.sale_account_id = trans.id;
transNew.parent = trans.parent;
service.save();
trans.sale_account_id = transNew.id;
service.save();
}
}
catch (DbEntityValidationException dbEx)
{
foreach (var validationErrors in dbEx.EntityValidationErrors)
{
foreach (var validationError in validationErrors.ValidationErrors)
{
Trace.TraceInformation("Class: {0}, Property: {1}, Error: {2}",
validationErrors.Entry.Entity.GetType().FullName,
validationError.PropertyName,
validationError.ErrorMessage);
}
}
}
return(RedirectToAction("Index"));
}
