public JsonResult CasualLeave(CasualLeave obj)
{
db.CasualLeaves.Add(obj);
db.SaveChanges();
return(Json(obj));
}
public ActionResult DeleteConfirmed(int id)
{
CasualLeave casualLeave = db.CasualLeaves.Find(id);
db.CasualLeaves.Remove(casualLeave);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "Id,EmployeeCode,Name,Department,Post,FromDate,ToDate,Reason,ResponsiblePerson,HodComment,AnyLeaveDays,OfficeInChargeName,ApprovedDays,CreatedDate,IsDeleted,CustomerId")] CasualLeave casualLeave)
{
if (ModelState.IsValid)
{
db.Entry(casualLeave).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.EmployeeCode = new SelectList(db.EmployeeGIs, "EmployeeCode", "Rank", casualLeave.EmployeeCode);
ViewBag.EmployeeCode = new SelectList(db.EmployeeGIs, "EmployeeCode", "Rank", casualLeave.EmployeeCode);
return(View(casualLeave));
}
// GET: CasualLeaves/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
CasualLeave casualLeave = db.CasualLeaves.Find(id);
if (casualLeave == null)
{
return(HttpNotFound());
}
return(View(casualLeave));
}
public JsonResult CausalLeave(CasualLeave obj)
{
try
{
db.CasualLeaves.Add(obj);
db.SaveChanges();
return(Json(obj));
}
catch (Exception ext)
{
return(Json(ext));
}
}
// GET: CasualLeaves/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
CasualLeave casualLeave = db.CasualLeaves.Find(id);
if (casualLeave == null)
{
return(HttpNotFound());
}
ViewBag.EmployeeCode = new SelectList(db.EmployeeGIs, "EmployeeCode", "Rank", casualLeave.EmployeeCode);
ViewBag.EmployeeCode = new SelectList(db.EmployeeGIs, "EmployeeCode", "Rank", casualLeave.EmployeeCode);
return(View(casualLeave));
}
private void SaveLeave_Click(object sender, EventArgs e)
{
string query = "";
if (SttafIdText.Text.Trim() == "")
{
MessageBox.Show("Please Enter Employee ID");
SttafIdText.Focus();
return;
}
if (CasualLeave.Text.Trim() == "")
{
MessageBox.Show("Please Enter The Number");
CasualLeave.Focus();
return;
}
if (Sickleave.Text.Trim() == "")
{
MessageBox.Show("Please Enter The Number");
Sickleave.Focus();
return;
}
if (MaternityLeave.Text.Trim() == "")
{
MessageBox.Show("Please Enter Password");
MaternityLeave.Focus();
return;
}
if (EarnedLeave.Text.Trim() == "")
{
MessageBox.Show("Please Enter Number");
EarnedLeave.Focus();
return;
}
query = "SELECT COUNT(*) AS Count FROM Leave_Info WHERE StaffID = " + SttafIdText.Text + "";
if (stfID == 0)
{
if (DbAccess.NumberOfRecords(query) > 0)
{
MessageBox.Show("This username already exists! Please try another ID!");
SttafIdText.Focus();
return;
}
}
else
{
if (DbAccess.NumberOfRecords(query) > 1)
{
MessageBox.Show("This username already exists! Please try another ID!");
SttafIdText.Focus();
return;
}
}
try
{
if (stfID == 0)
{
query = "INSERT INTO Leave_Info(StaffID,CasualLeave,SickLeave,MaternityLeave,EarnedLeave) VALUES(" + Convert.ToInt32(SttafIdText.Text) + ", '" + Convert.ToInt32(CasualLeave.Text) + "', '" + Convert.ToInt32(Sickleave.Text) + "', '" + Convert.ToInt32(MaternityLeave.Text) + "', '" + Convert.ToInt32(EarnedLeave.Text) + "' )";
}
else
{
query = "UPDATE Leave_Info SET CasualLeave = '" + Convert.ToInt32(CasualLeave.Text) + "', SickLeave = '" + Convert.ToInt32(Sickleave.Text) + "',MaternityLeave= '" + Convert.ToInt32(MaternityLeave.Text) + "',EarnedLeave = '" + Convert.ToInt32(EarnedLeave.Text) + "' WHERE StaffID = " + stfID;
}
if (DbAccess.ExecuteToDB(query))
{
if (stfID == 0)
{
MessageBox.Show("Saved Successfully!!!");
}
else
{
MessageBox.Show("Update Successfully!!!");
}
}
else
{
MessageBox.Show("Failed To Save!!!");
}
}
catch (Exception ex)
{
MessageBox.Show("Connection Error!!!");
}
finally
{
Reset();
}
}
