//UPDATE EVENT
public static string UpdateEvent(EventViewModel paramEv)
{
string latestSaveCode = string.Empty;
try
{
using (var db = new MarkomApplicationDBEntities())
{
ObjectParameter returnId = new ObjectParameter("Code", typeof(string));
db.spEventUpdate(
paramEv.id
, returnId
, paramEv.eventName
, paramEv.place
, paramEv.startDate
, paramEv.endDate
, paramEv.budget
, paramEv.note
, paramEv.updateBy
, paramEv.updateDate);
latestSaveCode = (String)returnId.Value;
}
}
catch (Exception ex)
{
Message = ex.Message;
}
return(latestSaveCode);
}
//UPDATE Unit
public static bool UpdateUnit(UnitViewModel paramEditEmp)
{
bool result = true;
try
{
using (MarkomApplicationDBEntities db = new MarkomApplicationDBEntities())
{
db.spUnitUpdate(
paramEditEmp.id
, paramEditEmp.name
, paramEditEmp.description
, paramEditEmp.updateBy
, paramEditEmp.updateDate
);
}
}
catch (Exception ex)
{
Message = ex.Message;
result = false;
//throw;
}
return(result);
}
public static List <SouvenirViewModel> GetListSouvenir(SouvenirViewModel paramSearch)
{
List <SouvenirViewModel> result = new List <SouvenirViewModel>();
if (paramSearch.mUnitId != 0)
{
paramSearch.unitId = paramSearch.mUnitId;
}
using (var context = new MarkomApplicationDBEntities())
{
var res = context.spSouSearch(paramSearch.code, paramSearch.name, paramSearch.unitId, paramSearch.createDate2, paramSearch.createBy);
List <SouvenirViewModel> comList = res.Select(c => new SouvenirViewModel
{
id = c.id,
code = c.code,
name = c.name,
unitName = c.unit_name,
createDate = c.create_date,
createBy = c.create_by
}).ToList();
result = comList;
}
return(result);
}
public static List <MenuViewModel> SearchMenuStringParent(string prefix)
{
List <MenuViewModel> result = new List <MenuViewModel>();
try
{
using (MarkomApplicationDBEntities db = new MarkomApplicationDBEntities())
{
var res = db.spMenuParent(prefix);
List <MenuViewModel> nameList = res.Select(c => new MenuViewModel
{
parentId = c.id,
parentName = c.name
}).ToList();
result = nameList;
}
}
catch (Exception ex)
{
Message = ex.Message;
}
return(result);
}
//GET LIST EVENT
public static List <EventViewModel> GetListEvent(EventViewModel paramSearch)
{
List <EventViewModel> result = new List <EventViewModel>();
if (paramSearch.statusName != null)
{
paramSearch.status = GetIntStatus(paramSearch.statusName);
}
using (var context = new MarkomApplicationDBEntities())
{
var res = context.spEventSearch(paramSearch.code, paramSearch.requestByName, paramSearch.requestDate2, paramSearch.status, paramSearch.createDate, paramSearch.createBy);
List <EventViewModel> comList = res.Select(c => new EventViewModel
{
id = c.id,
code = c.code,
requestByName = c.first_name + " " + c.last_name,
requestDate = c.request_date,
status = c.status,
statusName = GetStringStatus(c.status),
createDate = c.create_date,
createBy = c.create_by
}).ToList();
result = comList;
}
return(result);
}
public static List <EventViewModel> GetAllEmpName()
{
List <EventViewModel> result = new List <EventViewModel>();
try
{
using (MarkomApplicationDBEntities db = new MarkomApplicationDBEntities())
{
var res = db.spGetEmpNameStaff();
List <EventViewModel> comList = res.Select(c => new EventViewModel
{
empId = c.id,
empFullName = c.first_name + " " + c.last_name,
}).ToList();
result = comList;
}
}
catch (Exception ex)
{
Message = ex.Message;
}
return(result);
}
public static List <SouvenirViewModel> SearchUnitName(string prefix)
{
List <SouvenirViewModel> result = new List <SouvenirViewModel>();
try
{
using (MarkomApplicationDBEntities db = new MarkomApplicationDBEntities())
{
var res = db.spUnitName(prefix);
List <SouvenirViewModel> comList = res.Select(c => new SouvenirViewModel
{
mUnitId = c.id,
unitName = c.name,
}).ToList();
result = comList;
}
}
catch (Exception ex)
{
Message = ex.Message;
}
return(result);
}
//Reject EVENT
public static string CloseEv(EventViewModel paramEv)
{
string latestSaveCode = string.Empty;
try
{
using (var db = new MarkomApplicationDBEntities())
{
ObjectParameter returnId = new ObjectParameter("Code", typeof(string));
db.spEventClose(
paramEv.id
, returnId
, paramEv.status
, paramEv.closedDate
);
latestSaveCode = (String)returnId.Value;
}
}
catch (Exception ex)
{
Message = ex.Message;
}
return(latestSaveCode);
}
public static List <RoleViewModel> SearchStringRoleName(string prefix)
{
List <RoleViewModel> result = new List <RoleViewModel>();
try
{
using (MarkomApplicationDBEntities db = new MarkomApplicationDBEntities())
{
var res = db.spRoleName(prefix);
List <RoleViewModel> roleList = res.Select(c => new RoleViewModel
{
id = c.id,
name = c.name
}).ToList();
result = roleList;
}
}
catch (Exception ex)
{
Message = ex.Message;
}
return(result);
}
public static List <CompanyViewModel> SearchStringName(string prefix)
{
List <CompanyViewModel> result = new List <CompanyViewModel>();
try
{
using (MarkomApplicationDBEntities db = new MarkomApplicationDBEntities())
{
var res = (from m_company in db.m_company
where m_company.name.StartsWith(prefix) &&
m_company.is_delete == false
select new CompanyViewModel
{
id = m_company.id,
name = m_company.name
}).ToList();
result = res;
}
}
catch (Exception ex)
{
Message = ex.Message;
}
return(result);
}
//GET DETAIL EVENT
public static EventViewModel GetDetailEventById(int paramEvId)
{
EventViewModel result = new EventViewModel();
using (var db = new MarkomApplicationDBEntities())
{
var res = db.spEventDetailByID(paramEvId);
result = res.Select(c => new EventViewModel
{
id = c.id,
code = c.code,
eventName = c.event_name,
place = c.place,
startDate = c.start_date,
endDate = c.end_date,
budget = c.budget,
requestBy = c.request_by,
requestByName = c.first_name + " " + c.last_name,
requestDate = c.request_date,
note = c.note,
status = c.status,
statusName = GetStringStatus(c.status)
}).FirstOrDefault();
}
return(result);
}
public static string UnitCode()
{
string kode = "";
using (var db = new MarkomApplicationDBEntities())
{
var maxCodeNum = db.m_unit.Max(mc => mc.code);
if (maxCodeNum != null)
{
var max = 50;
string lastCode = maxCodeNum.Substring(2, maxCodeNum.Length - 2);
if (lastCode.Length < max - 2)
{
long numCode = long.Parse(lastCode) + 1;
kode = "UN" + AddZero(lastCode, numCode) + numCode.ToString();
}
}
else
{
kode = "UN0001";
}
}
return(kode);
}
public static List <EmployeeViewModel> SearchStringEmployeeNumber(string prefix)
{
List <EmployeeViewModel> result = new List <EmployeeViewModel>();
try
{
using (MarkomApplicationDBEntities db = new MarkomApplicationDBEntities())
{
var res = db.spEmployeeNumber(prefix);
List <EmployeeViewModel> comList = res.Select(c => new EmployeeViewModel
{
id = c.id,
code = c.employee_number
}).ToList();
result = comList;
}
}
catch (Exception ex)
{
Message = ex.Message;
}
return(result);
}
//UPDATE Menu
public static bool UpdateMenu(MenuViewModel paramEditMenu)
{
bool result = true;
try
{
using (MarkomApplicationDBEntities db = new MarkomApplicationDBEntities())
{
db.spMenuUpdate(
paramEditMenu.id
, paramEditMenu.name
, paramEditMenu.controller
, paramEditMenu.parentId
, paramEditMenu.updateBy
, paramEditMenu.updateDate
);
}
}
catch (Exception ex)
{
Message = ex.Message;
result = false;
//throw;
}
return(result);
}
public static string EventCode()
{
string kode = "";
using (var db = new MarkomApplicationDBEntities())
{
var maxCodeNum = db.t_event.Max(t => t.code);
string d = DateTime.Now.ToString("dd");
string m = DateTime.Now.ToString("MM");
string y = DateTime.Now.ToString("yy");
if (maxCodeNum != null)
{
var max = 50;
string lastCode = maxCodeNum.Substring(12, maxCodeNum.Length - 12);
if (lastCode.Length < max - 2)
{
long numCode = long.Parse(lastCode) + 1;
kode = "TRWOEV" + d + m + y + AddZero(lastCode, numCode) + numCode.ToString();
}
}
else
{
kode = "TRWOEV" + d + m + y + "0001";
}
}
return(kode);
}
public static List <EmployeeViewModel> GetListEmployee(string code, string fullName, int?mCompanyId, DateTime?createDate2, string createBy)
{
List <EmployeeViewModel> result = new List <EmployeeViewModel>();
using (var context = new MarkomApplicationDBEntities())
{
var res = context.spEmployeeSearch(code, fullName, mCompanyId, createDate2, createBy);
List <EmployeeViewModel> comList = res.Select(c => new EmployeeViewModel
{
id = c.id,
code = c.employee_number,
firstName = c.first_name,
lastName = c.last_name,
mCompanyId = c.m_company_id,
companyName = c.name,
createDate = c.create_date,
createBy = c.create_by
}).ToList();
result = comList;
}
return(result);
}
//UPDATE EMPLOYEE
public static bool UpdateEmployee(EmployeeViewModel paramEditEmp)
{
bool result = true;
try
{
using (MarkomApplicationDBEntities db = new MarkomApplicationDBEntities())
{
db.spEmployeeUpdate(
paramEditEmp.id
, paramEditEmp.code
, paramEditEmp.firstName
, paramEditEmp.lastName
, paramEditEmp.mCompanyId
, paramEditEmp.email
, paramEditEmp.updateBy
, paramEditEmp.updateDate
);
}
}
catch (Exception ex)
{
Message = ex.Message;
result = false;
//throw;
}
return(result);
}
public static List <UnitViewModel> SearchUnitCode(string prefix)
{
List <UnitViewModel> result = new List <UnitViewModel>();
try
{
using (MarkomApplicationDBEntities db = new MarkomApplicationDBEntities())
{
var res = db.spUnitCode(prefix);
List <UnitViewModel> comList = res.Select(c => new UnitViewModel
{
id = c.id,
code = c.code
}).ToList();
result = comList;
}
}
catch (Exception ex)
{
Message = ex.Message;
}
return(result);
}
public static bool UpdateCompany(CompanyViewModel paramEditCompany)
{
bool result = true;
try
{
using (MarkomApplicationDBEntities db = new MarkomApplicationDBEntities())
{
db.spCompanyUpdate(
paramEditCompany.id
, paramEditCompany.name
, paramEditCompany.email
, paramEditCompany.address
, paramEditCompany.phone
, paramEditCompany.updateBy
, paramEditCompany.updateDate
);
}
}
catch (Exception ex)
{
Message = ex.Message;
result = false;
//throw;
}
return(result);
}
public static int?GetEventStatus(int eventId)
{
int?result = 0;
using (var db = new MarkomApplicationDBEntities())
{
var evStat = (from te in db.t_event where te.id == eventId select te.status).First();
result = evStat;
}
return(result);
}
public static int?NameValidation(string name)
{
int?result = 0;
using (var db = new MarkomApplicationDBEntities())
{
var res = db.spUnitCountName(name).FirstOrDefault();
result = res;
}
return(result);
}
public static int?NumberValidation(string empCode)
{
int?result = 0;
using (var db = new MarkomApplicationDBEntities())
{
//var result = db.m_employee.Any(u => u.employee_number.ToLower() == empCode.ToLower());
var res = db.spEmployeeCountCode(empCode).FirstOrDefault();
result = res;
}
return(result);
}
//GET DETAIL Unit
public static UnitViewModel GetDetailUnitById(int paramUnitId)
{
UnitViewModel result = new UnitViewModel();
using (var db = new MarkomApplicationDBEntities())
{
var res = db.spUnitDetailByID(paramUnitId);
result = res.Select(c => new UnitViewModel
{
id = c.id,
code = c.code,
name = c.name,
description = c.description
}).FirstOrDefault();
}
return(result);
}
//CREATE EVENT
public static string CreateEvent(EventViewModel paramDataEvent)
{
string latestSaveCode = string.Empty;
using (var db = new MarkomApplicationDBEntities())
{
using (var dbContextTransaction = db.Database.BeginTransaction())
{
try
{
t_event c = new t_event();
c.code = EventCode();
c.event_name = paramDataEvent.eventName;
c.place = paramDataEvent.place;
c.start_date = paramDataEvent.startDate;
c.end_date = paramDataEvent.endDate;
c.budget = paramDataEvent.budget;
c.status = paramDataEvent.status;
c.is_delete = paramDataEvent.isDelete;
c.request_by = paramDataEvent.requestBy;
c.request_date = paramDataEvent.requestDate;
c.note = paramDataEvent.note;
c.create_by = paramDataEvent.createBy;
c.create_date = paramDataEvent.createDate;
db.t_event.Add(c);
db.SaveChanges();
dbContextTransaction.Commit();
//get latest save code
latestSaveCode = c.code;
}
catch (Exception ex)
{
Message = ex.Message;
dbContextTransaction.Rollback();
}
}
}
return(latestSaveCode);
}
//DELETE ROLE
public static string DeleteProduct(int name)
{
string latestSaveCode = string.Empty;
try
{
using (var db = new MarkomApplicationDBEntities())
{
ObjectParameter returnId = new ObjectParameter("IdNumber", typeof(string));
db.spProductDelete(name, returnId);
latestSaveCode = (String)returnId.Value;
}
}
catch (Exception ex)
{
Message = ex.Message;
}
return(latestSaveCode);
}
//DELETE
public static string DeleteUnit(int name)
{
string latestSaveCode = string.Empty;
try
{
using (var db = new MarkomApplicationDBEntities())
{
ObjectParameter returnId = new ObjectParameter("IdNumber", typeof(string)); //Create Object parameter to receive a output value.It will behave like output parameter
db.spUnitDelete(name, returnId); //calling our entity imported function "Bangalore" is our input parameter, returnId is a output parameter, it will receive the output value
latestSaveCode = (String)returnId.Value;
}
}
catch (Exception ex)
{
Message = ex.Message;
}
return(latestSaveCode);
}
public static CompanyViewModel GetDetailCompanyById(int paramComId)
{
CompanyViewModel result = new CompanyViewModel();
using (var db = new MarkomApplicationDBEntities())
{
var res = db.spCompanyDetailByID(paramComId);
result = res.Select(c => new CompanyViewModel
{
id = c.id,
code = c.code,
name = c.name,
address = c.address,
email = c.email,
phone = c.phone
}).FirstOrDefault();
}
return(result);
}
//GET DETAIL Souvenir
public static SouvenirViewModel GetDetailSouvenirById(int paramSouvenirId)
{
SouvenirViewModel result = new SouvenirViewModel();
using (var db = new MarkomApplicationDBEntities())
{
var res = db.spSouDetailByID(paramSouvenirId);
result = res.Select(c => new SouvenirViewModel
{
id = c.id,
code = c.code,
name = c.name,
mUnitId = c.m_unit_id,
unitName = c.unit_name,
description = c.description
}).FirstOrDefault();
}
return(result);
}
//GET DETAIL Menu
public static MenuViewModel GetDetailMenuById(int paramMenuId)
{
MenuViewModel result = new MenuViewModel();
using (var db = new MarkomApplicationDBEntities())
{
var res = db.spMenuDetailByID(paramMenuId);
result = res.Select(c => new MenuViewModel
{
id = c.id,
code = c.code,
name = c.name,
controller = c.controller,
parentId = c.parent_id,
parentName = db.m_menu.Where(x => x.id == c.parent_id).SingleOrDefault()?.name
}).FirstOrDefault();
}
return(result);
}
public static string GetEmployeeName(int empId)
{
string result = string.Empty;
using (var db = new MarkomApplicationDBEntities())
{
var res = db.spEmpNameById(empId).Select(em => em.first_name + " " + em.last_name).FirstOrDefault();
//var q = res.Select(c => new EventViewModel
//{
// empId = c.id,
// firstName = c.first_name,
// lastName = c.last_name
//}).FirstOrDefault();
//result = q;
result = res;
}
return(result);
}
