public ActionResult Export_EmployeeLst()
{
List <VW_EMPLOYEE> Emp = new List <VW_EMPLOYEE>();
using (OVODEntities5 oe = new OVODEntities5())
{
Emp = oe.VW_EMPLOYEE.ToList();
}
ReportDocument rd = new ReportDocument();
rd.Load(Path.Combine(Server.MapPath("~/Reports"), "rpt_EmployeeListing.rpt"));
DataTable DT = new DataTable();
DT = new DataTable();
DT = db.SqlDatatbl("SELECT * FROM VW_EMPLOYEE");
rd.SetDataSource(DT);
Response.Buffer = false;
Response.ClearContent();
Response.ClearHeaders();
Stream stream = rd.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat);
stream.Seek(0, SeekOrigin.Begin);
return(File(stream, "application/pdf", "rpt_EmployeeListing.pdf"));
}
public ActionResult LoadData()
{
var draw = Request.Form.GetValues("draw").FirstOrDefault();
var start = Request.Form.GetValues("start").FirstOrDefault();
var length = Request.Form.GetValues("length").FirstOrDefault();
var sortColumn = Request.Form.GetValues("columns[" + Request.Form.GetValues("order[0][column]").FirstOrDefault() + "][name]").FirstOrDefault();
var sortColumndir = Request.Form.GetValues("order[0][dir]").FirstOrDefault();
int pagesize = length != null?Convert.ToInt32(length) : 0;
int skip = start != null?Convert.ToInt32(start) : 0;
int totalRecords = 0;
OVODEntities5 oe = new OVODEntities5();
var v = (from a in oe.DEPARTMENTs
orderby a.DP_CD
select a
);
//if (!(string.IsNullOrEmpty(sortColumn) && string.IsNullOrEmpty(sortColumndir)))
//{
// v = v.OrderBy(sortColumn + " " + sortColumndir);
//}
totalRecords = v.Count();
var data = v.Skip(skip).Take(pagesize).ToList();
return(Json(new { draw = draw, recordsFiltered = totalRecords, recordsTotal = totalRecords, data = data }, JsonRequestBehavior.AllowGet));
}
IEnumerable <Item> getAllItem()
{
using (OVODEntities5 db = new OVODEntities5())
{
return(db.Items.ToList());
}
}
public ActionResult Post_Leave(DT_LEAVE model)
{
try
{
if (ModelState.IsValid)
{
using (OVODEntities5 db = new OVODEntities5())
{
DT_LEAVE lv = new DT_LEAVE()
{
LV_DOC_DATE = model.LV_DOC_DATE,
LV_DOC_NO = model.LV_DOC_NO,
EMP_ID = model.EMP_ID,
TT_ID = model.TT_ID,
LV_EMAIL = model.LV_EMAIL,
LV_DT_FROM = model.LV_DT_FROM,
LV_DT_TO = model.LV_DT_TO
};
db.DT_LEAVE.Add(lv);
db.SaveChanges();
}
}
ViewBag.Message = "Record Saved Successfully.";
}
catch (Exception ex)
{
ViewBag.Message = "Error." + ex.Message.ToString();
}
return(View());
}
public ActionResult getAll()
{
using (OVODEntities5 db = new OVODEntities5())
{
return(Json(db.Items.ToList(), JsonRequestBehavior.AllowGet));
}
}
public List <VW_EMPLOYEE> GetEmployees(string search, string sort, string sortdir, int skip, int pagesize, out int totalRecord)
{
using (OVODEntities5 oe = new OVODEntities5())
{
var v = (from a in oe.VW_EMPLOYEE
where a.EM_NAME.Contains(search) ||
a.EM_LASTNAME.Contains(search) ||
a.EM_MAIL.Contains(search) ||
a.EM_USERNAME.Contains(search) ||
a.EM_MAIL.Contains(search) ||
a.EM_CODE.Contains(search) ||
a.EM_ID.ToString().Contains(search)
select a
);
totalRecord = v.Count();
v = v.OrderBy(sort + " " + sortdir);
if (pagesize > 0)
{
v = v.Skip(skip).Take(pagesize);
}
return(v.ToList());
//var item = oe.VW_EMPLOYEE.ToList();
//return View(item);
}
}
public ActionResult De_PayrollAdjDetails(string DocNo = "")
{
if (DocNo != "")
{
using (OVODEntities5 dbContext = new OVODEntities5())
{
var entryPoint = (from ep in dbContext.HD_HRPAYADJ
join e in dbContext.DT_HRPAYADJ on ep.PA_ID equals e.PA_ID
join t in dbContext.TTMASTs on e.TT_ID equals t.TT_ID
join m in dbContext.EMPLOYEEs on e.EM_ID equals m.EM_ID
where ep.PA_DOCNO == DocNo
select new
{
m.EM_ID,
m.EM_NAME,
t.TT_ID,
t.TT_DESC,
e.PAD_QTY,
e.PAD_RATE,
e.PAD_AMT,
e.PAD_REMARKS,
e.PAD_ID
}).ToList();
return(Json(new { data = entryPoint }, JsonRequestBehavior.AllowGet));
}
}
return(Json(new { data = "" }, JsonRequestBehavior.AllowGet));
}
public ActionResult MasterEmployeeDetails(string Code = "")
{
OVODEntities5 db = new OVODEntities5();
List <EMPLOYEE> EmpDetals = db.EMPLOYEEs.ToList();
return(View(EmpDetals));
}
public JsonResult GetDepartments(string term)
{
OVODEntities5 db = new OVODEntities5();
return(Json(db.DEPARTMENTs.Where(c => c.DP_NAME.StartsWith(term))
.Select(a => new { label = a.DP_CD + " / " + a.DP_NAME, id = a.DP_CD }),
JsonRequestBehavior.AllowGet));
}
public JsonResult GetDesignations(string term)
{
OVODEntities5 db = new OVODEntities5();
return(Json(db.DESIGNATIONs.Where(c => c.DG_DESCRIPTION.StartsWith(term))
.Select(a => new { label = a.DG_CD + " / " + a.DG_DESCRIPTION, id = a.DG_CD }),
JsonRequestBehavior.AllowGet));
}
public ActionResult MulitpleData()
{
OVODEntities5 obj = new OVODEntities5();
var myModel = new MultipleData();
myModel.TTMaster = obj.TTMASTs.ToList();
myModel.EmployeeSalary = obj.EMPLOYEESALs.ToList();
return(View(myModel));
}
public ActionResult Diagnosis(DIAGNOSI dIAGNOSI)
{
OVODEntities5 db = new OVODEntities5();
var model = db.DIAGNOSIS.Where(x => x.ID.Equals(dIAGNOSI.ID)).FirstOrDefault();
model.DIAGNOSIS = dIAGNOSI.DIAGNOSIS;
db.SaveChanges();
return(RedirectToAction("GetDiagnosis"));
}
public ActionResult GetDiagnosisDetails(int id)
{
OVODEntities5 _context = new OVODEntities5();
var model = _context.DIAGNOSIS
.Where(x => x.ID == id)
.FirstOrDefault();
return(View(model));
}
public ActionResult DrugDetails(DRUG dRUG)
{
OVODEntities5 _context = new OVODEntities5();
var model = _context.DRUGs
.Where(x => x.ID == dRUG.ID)
.FirstOrDefault();
return(View(model));
}
public ActionResult EmpJqList()
{
List <VW_EMPLOYEE> Emp = new List <VW_EMPLOYEE>();
using (OVODEntities5 oe = new OVODEntities5())
{
Emp = oe.VW_EMPLOYEE.ToList();
return(Json(new { data = Emp }, JsonRequestBehavior.AllowGet));
}
}
public JsonResult PayrollAdjdGrdDetails(string DocNo)
{
OVODEntities5 oe = new OVODEntities5();
var v = (from a in oe.VW_DT_HRPAYADJ
where a.PA_DOCNO.Equals(DocNo)
orderby a.PA_DOCNO
select a
);
return(Json(v, JsonRequestBehavior.AllowGet));
}
public void ExportToExcel()
{
OVODEntities5 db = new OVODEntities5();
List <EmployeeModel> employees = db.VW_EMPLOYEE.Select(x => new EmployeeModel
{
EM_ID = x.EM_ID,
EM_CODE = x.EM_CODE,
EM_NAME = x.EM_NAME,
EM_PHONE = x.EM_PHONE,
EM_MAIL = x.EM_MAIL,
EM_DOB = x.EM_DOB,
EM_DOJ = x.EM_DOJ,
EM_DOBC = x.EM_DOBC,
EM_DOJC = x.EM_DOJC
}).ToList();
ExcelPackage pck = new ExcelPackage();
ExcelWorksheet ws = pck.Workbook.Worksheets.Add("Report");
ws.Cells["A1"].Value = "Employee Details";
ws.Cells["A1"].Value = "Employee ID";
ws.Cells["A2"].Value = "Employee Code";
ws.Cells["A3"].Value = "Employee Name";
ws.Cells["A4"].Value = "Employee Phone";
ws.Cells["A5"].Value = "Employee Email";
ws.Cells["A6"].Value = "Employee DoB";
ws.Cells["A7"].Value = "Employee DoJ";
int RowStart = 3;
foreach (var item in employees)
{
ws.Cells[string.Format("A{0}", RowStart)].Value = item.EM_ID;
ws.Cells[string.Format("B{0}", RowStart)].Value = item.EM_CODE;
ws.Cells[string.Format("C{0}", RowStart)].Value = item.EM_NAME;
ws.Cells[string.Format("D{0}", RowStart)].Value = item.EM_PHONE;
ws.Cells[string.Format("E{0}", RowStart)].Value = item.EM_MAIL;
ws.Cells[string.Format("F{0}", RowStart)].Value = (item.EM_DOBC);
ws.Cells[string.Format("G{0}", RowStart)].Value = item.EM_DOJC;
RowStart += 1;
}
ws.Cells["A:AZ"].AutoFitColumns();
Response.Clear();
HttpContext.Response.AddHeader("", "");
HttpContext.Response.Charset = System.Text.UTF8Encoding.UTF8.WebName;
HttpContext.Response.ContentEncoding = System.Text.UTF8Encoding.UTF8;
HttpContext.Response.AddHeader("content-disposition", "attachment; filename=Report.xlsx");
HttpContext.Response.ContentType = "application/text";
HttpContext.Response.ContentEncoding = System.Text.Encoding.GetEncoding("utf-8");
HttpContext.Response.BinaryWrite(pck.GetAsByteArray());
HttpContext.Response.End();
}
public ActionResult Drugs(DRUG dRUG)
{
OVODEntities5 db = new OVODEntities5();
var model = db.DRUGs
.Where(x => x.ID.Equals(dRUG.ID)).ToList();
DRUG di = new DRUG()
{
DRUG1 = dRUG.DRUG1
};
di.ID.Equals(dRUG.ID);
db.SaveChanges();
return(RedirectToAction("GetDrug"));
}
public ActionResult GetDrug(int?id)
{
//throw new Exception("Something went wrong");
OVODEntities5 _context = new OVODEntities5();
var model = _context.DRUGs.ToList();
if (id != null)
{
model = _context.DRUGs
.Where(x => x.DIG_ID == id)
.ToList();
}
return(View(model));
}
public ActionResult AddorEdit(int id = 0)
{
Item item = new Item
{
Item_Image = "~/Files/Items/default.jpg"
};
if (id != 0)
{
using (OVODEntities5 db = new OVODEntities5()) {
item = db.Items.Where(x => x.Item_Id == id).FirstOrDefault <Item>();
}
}
return(View(item));
}
public JsonResult GetCountries(string term)
{
OVODEntities5 db = new OVODEntities5();
//List<string> COUNTRY;
return(Json(db.VW_COUNTRY1.Where(c => c.CN_NAME.StartsWith(term))
.Select(a => new { label = a.CN_CD + " / " + a.CN_NAME, id = a.CN_CD }),
JsonRequestBehavior.AllowGet));
//COUNTRY = oe.VW_COUNTRY1.Where(x => x.CN_NAME.StartsWith(term))
// //.Select(y => y.CN_CD + " " + y.CN_NAME).ToList();
// .Select(a => new { label = a.CN_CD + " " + a.CN_NAME, id = a.CN_CD }).ToList();
//return Json(COUNTRY, JsonRequestBehavior.AllowGet);
}
public ActionResult Delete(int id)
{
try
{
using (OVODEntities5 db = new OVODEntities5())
{
Item item = db.Items.Where(x => x.Item_Id == id).FirstOrDefault();
db.Items.Remove(item);
db.SaveChanges();
return(Json(new { success = true, html = GlobalClass.RenderRazorViewToString(this, "ViewAll", getAllItem()), message = "Deleted Successfully" }, JsonRequestBehavior.AllowGet));
}
}
catch (Exception ex)
{
return(Json(new { success = false, message = ex.Message }, JsonRequestBehavior.AllowGet));
}
}
public ActionResult jsDashBoard()
{
List <int> repartitions = new List <int>();
OVODEntities5 oe = new OVODEntities5();
var EmpLst = oe.VW_EMPLOYEE.ToList();
var Country = EmpLst.Select(x => x.EM_COUNTRY).Distinct();
foreach (var item in Country)
{
repartitions.Add(EmpLst.Count(x => x.EM_COUNTRY == item));
}
var rep = repartitions;
ViewBag.Cnt = Country;
ViewBag.rep = repartitions.ToList();
return(View());
}
public ActionResult Doc_Emp_details(Doc_Emp_DetailsVM model, HttpPostedFileBase doc_file)
{
var updDate = DateTime.Now;
var _context = new OVODEntities5();
if (model.emp_id > 0)
{
Emp_Doc_History emp = new Emp_Doc_History()
{
emp_id = model.emp_id,
doc_id = model.doc_id,
doc_no = model.doc_no,
doc_issue_date = model.doc_issue_date,
doc_expiry_date = model.doc_expiry_date,
update_date = updDate
};
Doc_History doc = new Doc_History()
{
emp_Id = model.emp_id,
doc_id = model.doc_id,
update_date = updDate,
doc_no = model.doc_no,
doc_issue_date = model.doc_issue_date,
doc_expiry_date = model.doc_expiry_date
};
if (doc_file != null)
{
emp.dof_file = new byte[doc_file.ContentLength];
doc_file.InputStream.Read(emp.dof_file, 0, doc_file.ContentLength);
doc.dof_file = emp.dof_file;
}
_context.Emp_Doc_History.Add(emp);
_context.Doc_History.Add(doc);
_context.SaveChanges();
ViewBag.message = "Record Saved Successfully";
}
//return View("Doc_Emp_details");
return(RedirectToAction("Doc_Emp_details", "Home"));
}
public ActionResult De_PayrollAdj(string DocNo = "")
{
List <HD_HRPAYADJ> payadjh = new List <HD_HRPAYADJ>();
if (DocNo != "")
{
OVODEntities5 oe = new OVODEntities5();
var v = (from a in oe.VW_HD_HRPAYADJ
where a.PA_DOCNO.Equals(DocNo)
orderby a.PA_DOCNO
select a
).FirstOrDefault();
ViewBag.DocNo = v.PA_DOCNO;
ViewBag.DocDate = Convert.ToDateTime(v.PA_DOCDATE).ToShortDateString();
ViewBag.Month = v.PA_MONTH;
ViewBag.Year = v.PA_YEAR;
ViewBag.Header = v.PA_HEADER;
ViewBag.PATitle = v.PA_TITLE;
}
return(View(payadjh));
}
public ActionResult AddorEdit(Item item)
{
try
{
if (item.Upload_Image != null)
{
string fileName = Path.GetFileNameWithoutExtension(item.Upload_Image.FileName);
string extension = Path.GetExtension(item.Upload_Image.FileName);
fileName = fileName + DateTime.Now.ToString("yyMMddmmssfff") + extension;
item.Item_Image = "~/Files/Items/" + fileName;
item.Upload_Image.SaveAs(Path.Combine(Server.MapPath("~/Files/Items/"), fileName));
}
using (OVODEntities5 db = new OVODEntities5())
{
if (item.Item_Id == 0)
{
db.Items.Add(item);
item.Item_Date = DateTime.Now;
item.Item_Expiry = DateTime.Now.AddYears(2);
db.SaveChanges();
}
else
{
item.Item_Date = DateTime.Now;
item.Item_Expiry = DateTime.Now.AddYears(2);
db.Entry(item).State = EntityState.Modified;
db.SaveChanges();
}
}
//ViewRenderer vw = new ViewRenderer();
//return Json(new { success = true, html = vw.RenderPartialView("ViewAll", getAllItem()), message = "Submitted Successfully" }, JsonRequestBehavior.AllowGet);
return(Json(new { success = true, html = GlobalClass.RenderRazorViewToString(this, "ViewAll", getAllItem()), message = "Submitted Successfully" }, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
return(Json(new { success = false, message = ex.Message }, JsonRequestBehavior.AllowGet));
}
}
public ActionResult MastEmpDetSave(string Code, string name, EMPSAL[] salary)
{
int EmpId;
OVODEntities5 db = new OVODEntities5();
string result = "Error! Salary Creation Is Not Completed.";
if (Code != null || name != null || salary != null)
{
//EMPLOYEE model = new EMPLOYEE();
//model.EM_CODE = Code;
//model.EM_NAME = name;
//model.EM_DOJ = DateTime.Now;
//db.EMPLOYEEs.Add(model);
EmpId = (db.EMPLOYEEs.SingleOrDefault(EMPLOYEEs => EMPLOYEEs.EM_CODE == Code).EM_ID);
if (EmpId > 0)
{
foreach (var item in salary)
{
EMPSAL s = new EMPSAL();
s.EM_ID = EmpId;
s.EM_CODE = Code;
s.TT_ID = item.TT_ID;
s.SL_AMT = item.SL_AMT;
s.SL_TYPE = item.SL_TYPE;
db.EMPSALs.Add(s);
}
db.SaveChanges();
result = "Success! Salary Creation Completed.";
}
else
{
result = "Invalid Code!";
}
}
return(Json(result, JsonRequestBehavior.AllowGet));
}
public ActionResult PayrollAdjdChklst()
{
var draw = Request.Form.GetValues("draw").FirstOrDefault();
var start = Request.Form.GetValues("start").FirstOrDefault();
var length = Request.Form.GetValues("length").FirstOrDefault();
var sortColumn = Request.Form.GetValues("columns[" + Request.Form.GetValues("order[0][column]").FirstOrDefault() + "][name]").FirstOrDefault();
var sortColumndir = Request.Form.GetValues("order[0][dir]").FirstOrDefault();
int pagesize = length != null?Convert.ToInt32(length) : 0;
int skip = start != null?Convert.ToInt32(start) : 0;
int totalRecords = 0;
OVODEntities5 oe = new OVODEntities5();
var v = (from a in oe.VW_HD_HRPAYADJ
orderby a.PA_DOCNO
select a
);
totalRecords = v.Count();
var data = v.Skip(skip).Take(pagesize).ToList();
return(Json(new { draw = draw, recordsFiltered = totalRecords, recordsTotal = totalRecords, data = data }, JsonRequestBehavior.AllowGet));
}
public ActionResult PayadjSave(string PA_DOCNO, string PA_DOCDATE, string PA_HEADER, string PA_TITLE, string PA_MONTH, string PA_YEAR, DT_HRPAYADJ[] det)
{
int DocId;
if (PA_DOCNO != null || PA_DOCDATE != null || PA_MONTH != null || PA_YEAR != null)
{
using (var context = new OVODEntities5())
{
using (var dbcxtransaction = context.Database.BeginTransaction())
{
try
{
var DocData = context.HD_HRPAYADJ.Where(x => x.PA_DOCNO == PA_DOCNO).FirstOrDefault();
if (DocData != null)
{
//HD_HRPAYADJ hd = new HD_HRPAYADJ()
//{
// PA_DOCDATE = Convert.ToDateTime(PA_DOCDATE),
// PA_HEADER = PA_HEADER,
// PA_TITLE = PA_TITLE,
// PA_MONTH = PA_MONTH,
// PA_YEAR = PA_YEAR
//};
DocData.PA_DOCDATE = Convert.ToDateTime(PA_DOCDATE);
DocData.PA_HEADER = PA_HEADER;
DocData.PA_TITLE = PA_TITLE;
DocData.PA_MONTH = PA_MONTH;
DocData.PA_YEAR = PA_YEAR;;
context.Entry(DocData).State = EntityState.Modified;
context.SaveChanges();
DocId = context.HD_HRPAYADJ.Where(x => x.PA_DOCNO == PA_DOCNO).Select(a => a.PA_ID).Single();
//DT_HRPAYADJ details = new DT_HRPAYADJ { PAD_ID = DocId };
//context.Entry(details).State = EntityState.Deleted;
var items = context.DT_HRPAYADJ.Where(b => b.PA_ID == DocId);
foreach (var item in items)
{
context.DT_HRPAYADJ.Remove(item);
}
context.SaveChanges();
if (DocId > 0)
{
foreach (var item in det)
{
DT_HRPAYADJ s = new DT_HRPAYADJ()
{
PA_ID = DocId,
EM_ID = item.EM_ID,
TT_ID = item.TT_ID,
PAD_QTY = item.PAD_QTY,
PAD_RATE = item.PAD_RATE,
PAD_AMT = (item.PAD_RATE * item.PAD_QTY),
PAD_REMARKS = item.PAD_REMARKS
};
context.DT_HRPAYADJ.Add(s);
}
context.SaveChanges();
dbcxtransaction.Commit();
result = "Success! Document Update Completed.";
}
else
{
dbcxtransaction.Rollback();
result = "Invalid Code!";
}
}
else
{
HD_HRPAYADJ hd = new HD_HRPAYADJ()
{
PA_DOCNO = PA_DOCNO,
PA_DOCDATE = Convert.ToDateTime(PA_DOCDATE),
PA_HEADER = PA_HEADER,
PA_TITLE = PA_TITLE,
PA_MONTH = PA_MONTH,
PA_YEAR = PA_YEAR
};
context.HD_HRPAYADJ.Add(hd);
context.SaveChanges();
DocId = hd.PA_ID;
if (DocId > 0)
{
foreach (var item in det)
{
DT_HRPAYADJ s = new DT_HRPAYADJ()
{
PA_ID = DocId,
EM_ID = item.EM_ID,
TT_ID = item.TT_ID,
PAD_QTY = item.PAD_QTY,
PAD_RATE = item.PAD_RATE,
PAD_AMT = (item.PAD_RATE * item.PAD_QTY),
PAD_REMARKS = item.PAD_REMARKS
};
context.DT_HRPAYADJ.Add(s);
}
context.SaveChanges();
dbcxtransaction.Commit();
result = "Success! Document Creation Completed.";
}
else
{
dbcxtransaction.Rollback();
result = "Invalid Code!";
}
}
}
catch (Exception ex)
{
result = ex.ToString();
dbcxtransaction.Rollback();
}
}
}
}
return(Json(result, JsonRequestBehavior.AllowGet));
}
public ActionResult GetDiagnosis()
{
OVODEntities5 _context = new OVODEntities5();
return(View(_context.DIAGNOSIS.ToList()));
}
