public ActionResult DeleteConfirmed(int id)
{
SalaryHis salaryHis = db.SalaryHises.Find(id);
db.SalaryHises.Remove(salaryHis);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult IndividualSheetData(int id)
{
var salaries = new List <Salary>();
var firstOrDefault
= db.SalaryHises.ToList().FirstOrDefault();
if (firstOrDefault != null)
{
var preData = firstOrDefault.Data;
if (preData.Equals(""))
{
var employees = db.Employees.ToList();
foreach (Employee employee in employees)
{
Salary salary = MapEmployeeToSalary(employee);
salaries.Add(salary);
}
db.SalaryHises.AddOrUpdate(new SalaryHis {
Data = new JavaScriptSerializer().Serialize(Json(salaries))
});
}
else
{
salaries = JsonConvert.DeserializeObject <List <Salary> >(preData);
}
Salary sa = salaries.Find(i => i.SerialNo == id);
return(Json(sa, JsonRequestBehavior.AllowGet));
}
var preData2 = "";
var employees2 = db.Employees.ToList();
foreach (Employee employee in employees2)
{
Salary salary = MapEmployeeToSalary(employee);
salaries.Add(salary);
}
string json = new JavaScriptSerializer().Serialize(Json(salaries).Data);
SalaryHis sal = new SalaryHis {
SerialNo = 1, Data = json
};
try
{
db.SalaryHises.AddOrUpdate(i => i.SerialNo, sal);
db.SaveChanges();
}
catch (Exception e)
{
string j = e.StackTrace;
}
Salary sa2 = salaries.Find(i => i.SerialNo == id);
return(Json(sa2, JsonRequestBehavior.AllowGet));
// var employee = db.Employees.Find(id);
// Salary salary = MapEmployeeToSalary(employee);
// return Json(salary, JsonRequestBehavior.AllowGet);
}
public ActionResult Edit([Bind(Include = "SerialNo,Data")] SalaryHis salaryHis)
{
if (ModelState.IsValid)
{
db.Entry(salaryHis).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(salaryHis));
}
public ActionResult SalarySheetAng()
{
var salaries = new List <Salary>();
var firstOrDefault
= db.SalaryHises.ToList().FirstOrDefault();
if (firstOrDefault != null)
{
var preData = firstOrDefault.Data;
if (preData.Equals(""))
{
var employees = db.Employees.ToList();
foreach (Employee employee in employees)
{
Salary salary = MapEmployeeToSalary(employee);
salaries.Add(salary);
}
db.SalaryHises.AddOrUpdate(i => i.SerialNo, new SalaryHis {
SerialNo = 1, Data = JsonConvert.SerializeObject(salaries)
});
db.SaveChanges();
}
else
{
/* var obj = JObject.Parse(preData);
* var url = obj["Data"];*/
salaries = JsonConvert.DeserializeObject <List <Salary> >(preData);
}
return(Json(salaries, JsonRequestBehavior.AllowGet));
}
var preData2 = "";
var employees2 = db.Employees.ToList();
foreach (Employee employee in employees2)
{
Salary salary = MapEmployeeToSalary(employee);
salaries.Add(salary);
}
string json = new JavaScriptSerializer().Serialize(Json(salaries).Data);
SalaryHis sal = new SalaryHis {
SerialNo = 1, Data = json
};
try
{
db.SalaryHises.AddOrUpdate(i => i.SerialNo, sal);
db.SaveChanges();
}
catch (Exception e)
{
string j = e.StackTrace;
}
return(Json(salaries, JsonRequestBehavior.AllowGet));
}
public ActionResult Create([Bind(Include = "SerialNo,Data")] SalaryHis salaryHis)
{
if (ModelState.IsValid)
{
db.SalaryHises.Add(salaryHis);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(salaryHis));
}
// GET: SalaryHis/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
SalaryHis salaryHis = db.SalaryHises.Find(id);
if (salaryHis == null)
{
return(HttpNotFound());
}
return(View(salaryHis));
}
