//public ActionResult Blogs()
//{
// blgList.Clear();
// var post = this.GetPost();
// foreach (var post in posts)
// {
// blgList.Add(new BLOG() { })
// }
//}
public ActionResult GetPost()
{
using (DatabasModel db = new DatabasModel())
{
var blogList = db.BLOGs.ToList();
return(View(blogList));
}
}
public ActionResult GetData()
{
using (DatabasModel db = new DatabasModel())
{
//var stafflist = db.STAFF_DETAILS().ToList();
List <STAFF_DETAILS_Result> stafflist = db.STAFF_DETAILS().ToList();
return(Json(new { data = stafflist }, JsonRequestBehavior.AllowGet));
}
}
public ActionResult DeleteData(int staffID)
{
using (DatabasModel db = new DatabasModel())
{
var staf = db.Staffs.Where(x => x.Staff_ID == staffID).FirstOrDefault <Staff>();
db.Entry(staf).Property(x => x.Status).CurrentValue = false;
db.SaveChanges();
return(Json(new { success = true, message = "Deleted successfully.", JsonRequestBehavior.AllowGet }));
}
}
public JsonResult AutoCompleteAddress(string addName)
{
using (DatabasModel db = new DatabasModel())
{
var addList = db.Addresses.Where(x => x.Address_Code.StartsWith(addName)).Select(x => new
{
Address_Code = x.Address_Code,
Place_Name = x.Place_name
}).ToList();
return(Json(new { data = addList }, JsonRequestBehavior.AllowGet));
}
}
public JsonResult AutoCompleteJob(string jobName)
{
using (DatabasModel db = new DatabasModel())
{
var jobList = db.Job_Title.Where(x => x.Job_Title_Code.StartsWith(jobName)).Select(x => new
{
Job_Title_Code = x.Job_Title_Code,
Position = x.Position
}).ToList();
return(Json(new { data = jobList }, JsonRequestBehavior.AllowGet));
}
}
public ActionResult Posts(BLOG bg)
{
if (bg.BLOG_ID == 0)
{
using (DatabasModel db = new DatabasModel())
{
db.BLOGs.Add(bg);
db.SaveChanges();
return(Json(new { success = true, message = "Blog has been post" }, JsonRequestBehavior.AllowGet));
}
}
return(View());
}
public ActionResult LoginPage(Staff stf)
{
using (DatabasModel db = new DatabasModel())
{
var stfIdentity = db.Staffs.Where(model => model.First_Name == stf.First_Name && model.Last_Name == stf.Last_Name).FirstOrDefault();
if (stfIdentity != null)
{
Session["Staff_ID"] = stfIdentity.Staff_ID;
Session["First_Name"] = stfIdentity.First_Name.ToString();
return(RedirectToAction("Index"));
}
}
return(View());
}
public ActionResult AddStaffExtension(Staff_Extensions stfExt)
{
using (DatabasModel db = new DatabasModel())
{
if (stfExt.Extension_ID == 0)
{
db.Staff_Extensions.Add(stfExt);
db.SaveChanges();
return(Json(new { success = true, message = "Extension is added" }, JsonRequestBehavior.AllowGet));
}
else
{
db.Entry(stfExt).State = EntityState.Modified;
db.SaveChanges();
return(Json(new { success = true, message = "Updated extension." }, JsonRequestBehavior.AllowGet));
}
}
}
public ActionResult AddExtension(int staffID)
{
using (DatabasModel db = new DatabasModel())
{
//var extNum = db.Staff_Extensions.Where(x => x.Staff_ID == staffID).Select(x => new StaffModel
//{
// Extension_ID = x.Extension_ID,
// Staff_ID = x.Staff_ID,
// Extension_Num = x.Extension_Num,
// Extension_Num2 = x.Extension_Num2
//}).FirstOrDefault();
var extnNum = (from sx in db.Staff_Extensions join stf in db.Staffs
on sx.Staff_ID equals stf.Staff_ID
select new { sx.Extension_ID, sx.Staff_ID, sx.Extension_Num, sx.Extension_Num2 }).Where(x => x.Staff_ID == staffID).Select(x => new StaffModel {
Extension_ID = x.Extension_ID,
Staff_ID = x.Staff_ID,
Extension_Num = x.Extension_Num,
Extension_Num2 = x.Extension_Num2
}).FirstOrDefault();
try
{
if (extnNum != null)
{
return(View(extnNum));
}
else
{
var mdl = db.Staffs.Where(x => x.Staff_ID == staffID).Select(x => new StaffModel
{
Staff_ID = x.Staff_ID
}).FirstOrDefault();
return(View(mdl));
}
}
catch (Exception ex)
{
return(Json(new { success = true, message = "Exception " + ex }, JsonRequestBehavior.AllowGet));
}
}
}
public ActionResult StaffRegister(Staff stf)
{
using (DatabasModel db = new DatabasModel())
{
if (stf.Staff_ID == 0)
{
stf.Status = true;
db.Staffs.Add(stf);
db.SaveChanges();
return(Json(new { success = true, message = "Staff is registered.", JsonRequestBehavior.AllowGet }));
}
else
{
stf.Status = true;
db.Entry(stf).State = EntityState.Modified;
db.SaveChanges();
return(Json(new { success = true, message = "Updated successfully" }, JsonRequestBehavior.AllowGet));
}
}
}
public ActionResult StaffRegister(int STAFF_ID = 0)
{
{
using (DatabasModel db = new DatabasModel())
{
List <SelectListItem> branchlist = new List <SelectListItem>();
List <SelectListItem> deptList = new List <SelectListItem>();
List <SelectListItem> joblist = new List <SelectListItem>();
foreach (Branch brh in db.Branches)
{
SelectListItem item = new SelectListItem()
{
Text = brh.Branch_Name,
Value = brh.Branch_Code.ToString(),
Selected = false
};
branchlist.Add(item);
}
foreach (Department dept in db.Departments)
{
SelectListItem item = new SelectListItem()
{
Text = dept.Department_Name,
Value = dept.Department_ID,
Selected = false
};
deptList.Add(item);
}
foreach (Job_Title jobTitle in db.Job_Title)
{
SelectListItem item = new SelectListItem()
{
Text = jobTitle.Position,
Value = jobTitle.Job_Title_Code,
Selected = false
};
joblist.Add(item);
}
ViewData["jobList"] = new SelectList(joblist.ToList(), "Value", "Text");
ViewData["branchList"] = new SelectList(branchlist.ToList(), "Value", "Text");
ViewData["deptList"] = new SelectList(deptList.ToList(), "Value", "Text");
//
}
}
if (STAFF_ID != 0)
{
using (DatabasModel db = new DatabasModel())
{
var mdl = db.Staffs.Where(x => x.Staff_ID == STAFF_ID).Select(x => new StaffModel
{
Staff_ID = x.Staff_ID,
First_Name = x.First_Name,
Middle_Name = x.Middle_Name,
Last_Name = x.Last_Name,
Gender = x.Gender,
Primary_Number = x.Primary_Number,
Secondary_Number = x.Secondary_Number,
Email = x.Email,
Temporary_Address = x.Temporary_Address,
Permanent_Address = x.Permanent_Address,
Qualification = x.Qualification,
Job_Code = x.Job_Code,
Branch_Code = x.Branch_Code,
Department_ID = x.Department_ID
}).ToList().FirstOrDefault();
return(View(mdl));
}
}
return(View());
}
public AdminController()
{
db = new DatabasModel();
db.Configuration.LazyLoadingEnabled = false;
}
