public async Task <ActionResult> Create([Bind(Include = "Id,RecieverName,PayingDate,ItemQuantity,ItemName,CategoryId,TransactionYear,PaidAmount")] ExpensesRecords expensesRecords)
{
if (ModelState.IsValid)
{
expensesRecords.TransactionYear = DateTime.Now.Year;
db.ExpensesRecords.Add(expensesRecords);
await db.SaveChangesAsync();
db.Entry(expensesRecords).GetDatabaseValues();
int salaryrecid = expensesRecords.Id;
//here inserting inventory expense records into the expense outgoing mpdel
ExpenseOutgoingRecords expensetransection = new ExpenseOutgoingRecords();
expensetransection.RecordId = salaryrecid;
expensetransection.Personid = 0;
expensetransection.PersonName = expensesRecords.RecieverName;
expensetransection.TransactionType = "Inventory Expense";
expensetransection.TransactionDate = expensesRecords.PayingDate;
expensetransection.TransactionYear = expensesRecords.TransactionYear;
expensetransection.TransactionAmount = expensesRecords.PaidAmount;
db.ExpenseOutgoingRecords.Add(expensetransection);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.CategoryId = new SelectList(db.collegeExpenseCategories, "Id", "Categories", expensesRecords.CategoryId);
return(View(expensesRecords));
}
public ActionResult DeleteConfirmed(int id)
{
ExpenseOutgoingRecords expenseOutgoingRecords = db.ExpenseOutgoingRecords.Find(id);
db.ExpenseOutgoingRecords.Remove(expenseOutgoingRecords);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "Id,TransactionDate,TransactionType,RecordId,TransactionYear,TransactionAmount,PersonName,Personid")] ExpenseOutgoingRecords expenseOutgoingRecords)
{
if (ModelState.IsValid)
{
db.Entry(expenseOutgoingRecords).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(expenseOutgoingRecords));
}
// GET: ExpenseOutgoingRecords/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
ExpenseOutgoingRecords expenseOutgoingRecords = db.ExpenseOutgoingRecords.Find(id);
if (expenseOutgoingRecords == null)
{
return(HttpNotFound());
}
return(View(expenseOutgoingRecords));
}
public ActionResult Create(TeacherSalaryRecords teacherSalaryRecords)
{
if (ModelState.IsValid)
{
teacherSalaryRecords.GrossTotalAmount = teacherSalaryRecords.PayingAmount + teacherSalaryRecords.OverTime;
teacherSalaryRecords.Name = (from alias in db.Teachers where alias.Id == teacherSalaryRecords.TeacherId select alias.TeacherName).FirstOrDefault();
teacherSalaryRecords.FatherName = (from alias in db.Teachers where alias.Id == teacherSalaryRecords.TeacherId select alias.FatherName).FirstOrDefault();
teacherSalaryRecords.Recievingstatus = "Salary Recieved";
int depid = (from alias in db.Teachers where alias.Id == teacherSalaryRecords.TeacherId select alias.DesignationId).FirstOrDefault();
teacherSalaryRecords.TeacherDepartment = (from alias in db.teacherdesignationcategory where alias.Id == depid select alias.DepartmentName).FirstOrDefault();
if (teacherSalaryRecords.checkNo == null)
{
teacherSalaryRecords.checkNo = "N/A";
}
if (teacherSalaryRecords.Remarks == null)
{
teacherSalaryRecords.Remarks = "N/A";
}
teacherSalaryRecords.AddedOn = DateTime.UtcNow.AddHours(5);
db.TeacherSalaryRecords.Add(teacherSalaryRecords);
db.SaveChanges();
db.Entry(teacherSalaryRecords).GetDatabaseValues();
int salaryrecid = teacherSalaryRecords.Id;
TempData["salid"] = salaryrecid;
//here inserting expense out come transaction records
ExpenseOutgoingRecords expensetransection = new ExpenseOutgoingRecords();
expensetransection.RecordId = salaryrecid;
expensetransection.Personid = teacherSalaryRecords.TeacherId;
expensetransection.PersonName = teacherSalaryRecords.Name;
expensetransection.TransactionType = "Teacher Salary";
expensetransection.TransactionDate = teacherSalaryRecords.SubmissionDate;
expensetransection.TransactionYear = teacherSalaryRecords.Year;
expensetransection.TransactionAmount = teacherSalaryRecords.GrossTotalAmount;
db.ExpenseOutgoingRecords.Add(expensetransection);
db.SaveChanges();
return(RedirectToAction("PrintSalarySlip"));
}
ViewBag.TeacherId = new SelectList(db.Teachers, "Id", "TeacherName", teacherSalaryRecords.TeacherId);
return(View(teacherSalaryRecords));
}
public ActionResult Create(EmployeeSalary EmployeeSalary)
{
if (ModelState.IsValid)
{
EmployeeSalary.GrossTotalAmount = EmployeeSalary.PayingAmount + EmployeeSalary.OverTime;
EmployeeSalary.Name = (from alias in db.CollegeEmployees where alias.Id == EmployeeSalary.EmployeeId select alias.EmployeeName).FirstOrDefault();
EmployeeSalary.FatherName = (from alias in db.CollegeEmployees where alias.Id == EmployeeSalary.EmployeeId select alias.FatherName).FirstOrDefault();
EmployeeSalary.Recievingstatus = "Salary Recieved";
//int depid = (from alias in db.CollegeEmployees where alias.Id == EmployeeSalary.EmployeeId select alias.DesignationId).FirstOrDefault();
//EmployeeSalary. = (from alias in db.employeeDesignationCategory where alias.Id == depid select alias.DesignationName).FirstOrDefault();
if (EmployeeSalary.checkNo == null)
{
EmployeeSalary.checkNo = "N/A";
}
if (EmployeeSalary.Remarks == null)
{
EmployeeSalary.Remarks = "N/A";
}
EmployeeSalary.AddedOn = DateTime.UtcNow.AddHours(5);
db.EmployeeSalary.Add(EmployeeSalary);
db.SaveChanges();
db.Entry(EmployeeSalary).GetDatabaseValues();
int salaryrecid = EmployeeSalary.Id;
TempData["salid"] = salaryrecid;
//here inserting expense out come transaction records
ExpenseOutgoingRecords expensetransection = new ExpenseOutgoingRecords();
expensetransection.RecordId = salaryrecid;
expensetransection.Personid = EmployeeSalary.EmployeeId;
expensetransection.PersonName = EmployeeSalary.Name;
expensetransection.TransactionType = "Employee Salary";
expensetransection.TransactionDate = EmployeeSalary.SubmissionDate;
expensetransection.TransactionYear = EmployeeSalary.Year;
expensetransection.TransactionAmount = EmployeeSalary.GrossTotalAmount;
db.ExpenseOutgoingRecords.Add(expensetransection);
db.SaveChanges();
return(RedirectToAction("EmployeeSalarySlip"));
}
ViewBag.EmployeeId = new SelectList(db.CollegeEmployees, "Id", "EmployeeName", EmployeeSalary.EmployeeId);
return(View(EmployeeSalary));
}
