public ActionResult Create(int id)
{
Employee employee = db.Employees.Find(id);
SalaryBookEmployee salaryInstalments = new SalaryBookEmployee();
salaryInstalments.EmployeeID = id;
salaryInstalments.Amount = employee.Salary;
ViewBag.Message = Session["msg"];
ViewBag.Error = Session["err"];
Session["err"] = "";
Session["msg"] = "";
return(View(salaryInstalments));
}
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
SalaryBookEmployee salaryInstalments = db.SalaryBookEmployees.Find(id);
if (salaryInstalments == null)
{
return(HttpNotFound());
}
ViewBag.Existing = salaryInstalments.Title + salaryInstalments.EmployeeID;
return(View(salaryInstalments));
}
public ActionResult DeleteConfirm(int id)
{
Session["err"] = "Error, Can't Delete, Please check Dependency Data";
Session["msg"] = "";
try
{
SalaryBookEmployee salaryInstalments = db.SalaryBookEmployees.Find(id);
db.SalaryBookEmployees.Remove(salaryInstalments);
db.SaveChanges();
Session["err"] = "";
Session["msg"] = "Deleted Successfully";
}
catch { }
return(RedirectToAction("Index", "SalaryBookEmployee"));
}
public ActionResult Edit([Bind(Include = "SalaryBookID,EmployeeID,Title,Amount,Dop")] SalaryBookEmployee salaryinstalments, string existing)
{
Session["err"] = "Error, Please Check Input Fields";
Session["msg"] = "";
if (ModelState.IsValid)
{
if (salaryinstalments.Title + salaryinstalments.EmployeeID != existing)
{
SalaryBookEmployee salaryInstalmentsexisting = db.SalaryBookEmployees.Where(s => s.Title == salaryinstalments.Title && s.EmployeeID == salaryinstalments.EmployeeID).FirstOrDefault();
if (salaryInstalmentsexisting != null)
{
Session["err"] = "Topic already exists";
ViewBag.Existing = existing;
ViewBag.Message = Session["msg"];
ViewBag.Error = Session["err"];
Session["err"] = "";
Session["msg"] = "";
return(View(salaryinstalments));
}
}
db.Entry(salaryinstalments).State = EntityState.Modified;
db.SaveChanges();
Session["err"] = "";
Session["msg"] = "Modified Successfully";
return(RedirectToAction("Index"));
}
ViewBag.Existing = existing;
ViewBag.Message = Session["msg"];
ViewBag.Error = Session["err"];
Session["err"] = "";
Session["msg"] = "";
return(View(salaryinstalments));
}
public ActionResult Create([Bind(Include = "SalaryInstalmentsID,EmployeeID,Title,Amount,Dop")] SalaryBookEmployee salaryinstalments)
{
bool result = false;
errordata data = new errordata();
data.type = "error";
Session["err"] = "Error, Please Check Input Fields";
Session["msg"] = "";
if (ModelState.IsValid)
{
SalaryBookEmployee exist = db.SalaryBookEmployees.Where(s => s.Title == salaryinstalments.Title && s.EmployeeID == salaryinstalments.EmployeeID).FirstOrDefault();
if (exist != null)
{
Session["err"] = "Salary Instalment already exists";
data.message = Session["err"].ToString();
return(Json(data, JsonRequestBehavior.AllowGet));
}
db.SalaryBookEmployees.Add(salaryinstalments);
db.SaveChanges();
ModelState.Clear();
result = true;
if (result == true)
{
//Account
int feedebitaccount = 0;
int salarydebitaccount = 0;
int feecreditaccount = 0;
int salarycreditaccount = 0;
var acheadassignList = db.AccountHeadAssigns.ToList();
foreach (AccountHeadAssign acheadassign in acheadassignList)
{
if (acheadassign.HeadAssignID == 1)
{
feedebitaccount = acheadassign.AccountHeadID;
}
if (acheadassign.HeadAssignID == 2)
{
feecreditaccount = acheadassign.AccountHeadID;
}
if (acheadassign.HeadAssignID == 3)
{
salarydebitaccount = acheadassign.AccountHeadID;
}
if (acheadassign.HeadAssignID == 4)
{
salarycreditaccount = acheadassign.AccountHeadID;
}
}
Employee employee = db.Employees.Find(salaryinstalments.EmployeeID);
string voucherno = "EM" + employee.IdCard + "-" + salaryinstalments.SalaryBookID.ToString();
var accountjournals = db.AccountJournals.Where(a => a.VoucherNo == voucherno).ToList();
foreach (AccountJournal accountjournal1 in accountjournals)
{
var accountjournaldetails = db.AccountJournalDetails.Where(a => a.AccountJournalID == accountjournal1.AccountJournalID).ToList();
foreach (AccountJournalDetail accountjournaldetail1 in accountjournaldetails)
{
db.AccountJournalDetails.Remove(accountjournaldetail1);
}
db.SaveChanges();
db.AccountJournals.Remove(accountjournal1);
}
db.SaveChanges();
AccountJournal accountjournal = new AccountJournal();
accountjournal.VoucherNo = voucherno;
accountjournal.VoucherType = voucherno.Substring(0, 2);
accountjournal.TransactionDate = salaryinstalments.Dop;
accountjournal.BranchID = int.Parse(Session["SchoolID"].ToString());
accountjournal.FinancialYearID = int.Parse(Session["AcademicYearID"].ToString());
accountjournal.UserID = Session["UserID"].ToString();
accountjournal.Remarks = "Employee Salary";
db.AccountJournals.Add(accountjournal);
db.SaveChanges();
//debit
AccountJournalDetail accountjournaldetail = new AccountJournalDetail();
if (salaryinstalments.Amount > 0)
{
accountjournaldetail.AccountJournalID = accountjournal.AccountJournalID;
accountjournaldetail.AccountHeadID = feedebitaccount;
accountjournaldetail.AnalysisHeadID = 0;
accountjournaldetail.Amount = salaryinstalments.Amount;
accountjournaldetail.Remarks = "Employee Salary: " + employee.Name + ", Detail: " + salaryinstalments.Title + ", salary Debit";
db.AccountJournalDetails.Add(accountjournaldetail);
db.SaveChanges();
}
//credit
if (salaryinstalments.Amount > 0)
{
accountjournaldetail = new AccountJournalDetail();
accountjournaldetail.AccountJournalID = accountjournal.AccountJournalID;
accountjournaldetail.AccountHeadID = feecreditaccount;
accountjournaldetail.AnalysisHeadID = 0;
accountjournaldetail.Amount = salaryinstalments.Amount * -1;
accountjournaldetail.Remarks = "Employee Salary: " + employee.Name + ", Detail: " + salaryinstalments.Title + ", salary credit";
db.AccountJournalDetails.Add(accountjournaldetail);
db.SaveChanges();
}
}
Session["err"] = "";
Session["msg"] = "Created Successfully";
}
data.message = Session["msg"].ToString();
data.type = "success";
return(Json(data, JsonRequestBehavior.AllowGet));
}