public static List <string> GetProvinceHospitalList()
{
var result = new List <string>();
try
{
using (var ctx = new BIG_DBEntities())
{
var list = ctx.Hospitals.ToList();
var provincelist = list.GroupBy(x => x.PROVINCE)
.Select(grp => grp.First())
.ToList();
foreach (var item in provincelist)
{
result.Add(item.PROVINCE);
}
}
return(result);
}
catch (Exception ex)
{
throw ex;
}
}
public static bool Login(string username, string password)
{
var result = false;
try
{
using (var ctx = new BIG_DBEntities())
{
var list = ctx.Logons.Where(x => x.USERNAME == username && x.PASSWORD == password).ToList();
if (list.Count() > 0)
{
result = true;
}
else
{
result = false;
}
}
}
catch (Exception ex)
{
result = false;
throw ex;
}
return(result);
}
public static bool Add(FingerScan fin)
{
var oldfin = new FingerScan();
try
{
if (fin != null)
{
oldfin = GetObjByEmployeeID(fin.EMP_ID);
DeleteByEmployeeID(fin.EMP_ID);
using (var ctx = new BIG_DBEntities())
{
ctx.FingerScans.Add(fin);
ctx.SaveChanges();
}
}
return(true);
}
catch (Exception ex)
{
Add(oldfin);
throw ex;
}
}
public static bool Add(List <Address> list)
{
try
{
var obj = list.FirstOrDefault();
if (obj != null)
{
DeleteByEmployeeID(obj.EMP_ID);
}
using (var ctx = new BIG_DBEntities())
{
foreach (var objAdd in list)
{
ctx.Addresses.Add(objAdd);
}
ctx.SaveChanges();
}
return(true);
}
catch (Exception ex)
{
throw ex;
}
}
public static void Add(CompanyInfo com)
{
var backup = new CompanyInfo();
try
{
using (var ctx = new BIG_DBEntities())
{
backup = ctx.CompanyInfoes.FirstOrDefault();
}
Delete();
using (var ctx = new BIG_DBEntities())
{
var obj = ctx.CompanyInfoes.Add(com);
ctx.SaveChanges();
}
}
catch (Exception ex)
{
using (var ctx = new BIG_DBEntities())
{
ctx.CompanyInfoes.Add(backup);
ctx.SaveChanges();
}
throw ex;
}
}
public static string GetZipcodeByDistricName(string name)
{
var result = "";
try
{
using (var ctx = new BIG_DBEntities())
{
var districObj = ctx.Districts.Where(x => x.DISTRICT_NAME.Contains(name)).FirstOrDefault();
if (districObj != null)
{
var prov = districObj.PROVINCE_ID.ToString();
var aump = districObj.AMPHUR_ID.ToString();
var dis = districObj.DISTRICT_ID.ToString();
var zipcodeObj = ctx.Zipcodes.Where(o => o.PROVINCE_ID == prov && o.AMPHUR_ID == aump && o.DISTRICT_ID == dis).FirstOrDefault();
if (zipcodeObj != null)
{
result = zipcodeObj.ZIPCODE1.ToString();
}
}
}
}
catch (Exception ex)
{
throw ex;
}
return(result);
}
public static string GetLastEmployeeIDSmutSakorn()
{
var emp_id = string.Empty;
try
{
using (var ctx = new BIG_DBEntities())
{
var yr = DateTime.Now.ToString("yy");
var month = getMonth();
var temp = yr + month;
var empctx = ctx.Employees.Where(x => x.EMP_ID.Contains(temp)).ToList();
if (empctx != null)
{
var obj = empctx.OrderBy(x => x.EMP_ID).LastOrDefault();
if (obj != null)
{
emp_id = obj.EMP_ID;
}
}
}
return(emp_id);
}
catch (Exception ex)
{
throw ex;
}
}
public static List <MasterConfig> GetSubEmployeeStatus()
{
try
{
using (var ctx = new BIG_DBEntities())
{
var list = ctx.MasterConfigs.Where(x => x.NAME == "SUB_EMPLOYEE_STATUS").ToList();
return(list);
}
}
catch (Exception ex)
{
throw ex;
}
}
public static Employee GetEmployeeByIDCard(string idcard)
{
var result = new Employee();
try
{
using (var ctx = new BIG_DBEntities())
{
result = ctx.Employees.Where(x => x.ID_CARD == idcard).FirstOrDefault();
}
return(result);
}
catch (Exception ex)
{
throw ex;
}
}
public static int GetAmphurIDbyName(string name)
{
var result = 0;
try
{
using (var ctx = new BIG_DBEntities())
{
result = ctx.Amphurs.Where(x => x.AMPHUR_NAME.Contains(name)).Select(r => r.AMPHUR_ID).FirstOrDefault();
}
}
catch (Exception ex)
{
return(result);
}
return(result);
}
public static List <ReferenceDocument> GetAll()
{
var result = new List <ReferenceDocument>();
try
{
using (var ctx = new BIG_DBEntities())
{
result = ctx.ReferenceDocuments.ToList();
}
return(result);
}
catch (Exception ex)
{
throw ex;
}
}
public static int GetProvinceIDbyName(string name)
{
var result = 0;
try
{
using (var ctx = new BIG_DBEntities())
{
result = ctx.Provinces.Where(x => x.PROVINCE_NAME.Contains(name)).Select(r => r.PROVINCE_ID).FirstOrDefault();
}
}
catch (Exception ex)
{
return(result);
}
return(result);
}
public static FingerScan GetObjByEmployeeID(string emp)
{
var result = new FingerScan();
try
{
using (var ctx = new BIG_DBEntities())
{
result = ctx.FingerScans.Where(x => x.EMP_ID == emp).FirstOrDefault();
}
return(result);
}
catch (Exception ex)
{
throw ex;
}
}
public static List <WorkExperience> GetAll()
{
var result = new List <WorkExperience>();
try
{
using (var ctx = new BIG_DBEntities())
{
result = ctx.WorkExperiences.ToList();
}
return(result);
}
catch (Exception ex)
{
throw ex;
}
}
public static List <Amphur> GetListAmphur(int province_id)
{
var result = new List <Amphur>();
try
{
using (var ctx = new BIG_DBEntities())
{
result = ctx.Amphurs.Where(x => x.PROVINCE_ID == province_id).ToList();
}
return(result);
}
catch (Exception ex)
{
return(result);
}
}
public static List <District> GetDistrictByAmphurID(int province_id, int amphur_id)
{
var result = new List <District>();
try
{
using (var ctx = new BIG_DBEntities())
{
result = ctx.Districts.Where(x => x.PROVINCE_ID == province_id && x.AMPHUR_ID == amphur_id).ToList();
}
return(result);
}
catch (Exception ex)
{
return(result);
}
}
public static List <Employee> GetByArea(string area)
{
var result = new List <Employee>();
try
{
using (var ctx = new BIG_DBEntities())
{
result = ctx.Employees.Where(x => x.AREA.Contains(area)).Take(50).ToList();
}
return(result);
}
catch (Exception ex)
{
throw ex;
}
}
public static Address GetPermanentByEmployeeID(string emp)
{
var result = new Address();
try
{
using (var ctx = new BIG_DBEntities())
{
result = ctx.Addresses.Where(x => x.EMP_ID == emp && x.ADDRESSTYPE_ID == null).FirstOrDefault();
}
return(result);
}
catch (Exception ex)
{
throw ex;
}
}
public static List <Site> GetListSiteLocation()
{
var result = new List <Site>();
try
{
using (var ctx = new BIG_DBEntities())
{
result = ctx.Sites.ToList();
}
return(result);
}
catch (Exception ex)
{
return(result);
}
}
public static List <Employee> GetBySite(string site)
{
var result = new List <Employee>();
try
{
using (var ctx = new BIG_DBEntities())
{
result = ctx.Employees.Where(x => x.SITE_LOCATION.Contains(site)).Take(50).ToList();
}
return(result);
}
catch (Exception ex)
{
throw ex;
}
}
public static List <Address> GetAll()
{
var result = new List <Address>();
try
{
using (var ctx = new BIG_DBEntities())
{
result = ctx.Addresses.ToList();
}
return(result);
}
catch (Exception ex)
{
throw ex;
}
}
public static List <Employee> GetAll()
{
var result = new List <Employee>();
try
{
using (var ctx = new BIG_DBEntities())
{
result = ctx.Employees.OrderByDescending(o => o.EMP_ID).ToList();
}
return(result);
}
catch (Exception ex)
{
throw ex;
}
}
public static Employee GetEmployeeByEmpID(string empid)
{
var result = new Employee();
try
{
using (var ctx = new BIG_DBEntities())
{
result = ctx.Employees.Where(x => x.EMP_ID == empid).FirstOrDefault();
}
return(result);
}
catch (Exception ex)
{
throw ex;
}
}
public static List <Address> GetByEmployeeID(string emp)
{
var result = new List <Address>();
try
{
using (var ctx = new BIG_DBEntities())
{
result = ctx.Addresses.Where(x => x.EMP_ID == emp).ToList();
}
return(result);
}
catch (Exception ex)
{
throw ex;
}
}
public static List <Title> GetTitleList(string en_or_th)
{
var result = new List <Title>();
try
{
using (var ctx = new BIG_DBEntities())
{
result = ctx.Titles.Where(x => x.DESCRIPTION == en_or_th).ToList();
}
return(result);
}
catch (Exception ex)
{
throw ex;
}
}
public static CurrentImage GetByEmployeeID(string emp)
{
var result = new CurrentImage();
try
{
using (var ctx = new BIG_DBEntities())
{
result = ctx.CurrentImages.Where(x => x.EMP_ID == emp).FirstOrDefault();
}
}
catch (Exception ex)
{
throw ex;
}
return(result);
}
public static bool SaveSites(Site obj)
{
try
{
using (var ctx = new BIG_DBEntities())
{
if (obj != null)
{
ctx.Sites.Add(obj);
ctx.SaveChanges();
}
}
return(true);
}
catch (Exception ex)
{
throw ex;
}
}
public static bool UpdateAddress(List <Address> list)
{
try
{
using (var ctx = new BIG_DBEntities())
{
foreach (var objAdd in list)
{
ctx.Addresses.Add(objAdd);
}
ctx.SaveChanges();
}
return(true);
}
catch (Exception ex)
{
throw ex;
}
}
public static void DeleteByEmployeeID(string emp_id)
{
try
{
using (var ctx = new BIG_DBEntities())
{
var obj = ctx.Employees.Where(x => x.EMP_ID == emp_id).FirstOrDefault();
if (obj != null)
{
ctx.Employees.Remove(obj);
}
ctx.SaveChanges();
}
}
catch (Exception ex)
{
throw ex;
}
}
public static List <Employee> GetByStartDate(DateTime date)
{
var result = new List <Employee>();
try
{
using (var ctx = new BIG_DBEntities())
{
DateTime?dtstart = new DateTime(date.Year, date.Month, date.Day);
DateTime?dtend = new DateTime(date.Year, date.Month, date.Day + 1);
result = ctx.Employees.Where(x => x.DATESTARTWORK.Value >= dtstart && x.DATESTARTWORK <= dtend).Take(50).ToList();
}
return(result);
}
catch (Exception ex)
{
throw ex;
}
}
