public void Delete(string id)
{
using (OASEntities _ent = new OASEntities())
{
ms_company comp = _ent.ms_company.Find(id);
_ent.ms_company.Remove(comp);
_ent.SaveChanges();
}
}
public ms_company Insert(ms_company comp)
{
using (OASEntities _ent = new OASEntities())
{
_ent.ms_company.Add(comp);
_ent.SaveChanges();
return(comp);
}
}
public DataPaging <ms_company> List(HttpRequestMessage v)
{
DataPaging <ms_company> dataPaging = new DataPaging <ms_company>();
dataPaging.meta = new MetaPaging();
var p = v.Content.ReadAsStringAsync().Result;
//var xsss = p.Result[""] ; // exam
NameValueCollection qscoll = HttpUtility.ParseQueryString(p);
string search = "";
string orderField = "";
string orderby = "";
string page = "";
string perpage = "";
string startRow = "";
search = qscoll["query[generalSearch]"];
page = qscoll["pagination[page]"];
perpage = qscoll["pagination[perpage]"];
orderField = qscoll["sort[field]"];
orderby = qscoll["sort[sort]"];
dataPaging.meta.perpage = Convert.ToInt32(perpage);
dataPaging.meta.page = Convert.ToInt32(page);
startRow = ((dataPaging.meta.page - 1) * dataPaging.meta.perpage).ToString();
// datatable[query]:
//pagination[page]:1
//pagination[pages]:1
//pagination[perpage]:5
//pagination[total]:0
//sort[field]:CompName
//sort[sort]:asc
//query:
List <ms_company> compList = null;
using (OASEntities _ent = new OASEntities())
{
int totalRow = _ent.Database.SqlQuery <int>(@" select count(*) totalRow from ms_company where compName like '%" + search + "%' or compCode like '%" + search + "%' ").Single();
compList = _ent.ms_company.SqlQuery(@" select top " + perpage + " * from ( Select *,ROW_NUMBER() OVER(ORDER BY " +
orderField + " " + orderby + ") r from ms_company where compName like '%" + search + "%' or compCode like '%" + search + "%'"
+ " ) company where r > " + startRow + " "
).ToList();
dataPaging.data = compList;
dataPaging.meta.total = totalRow;
dataPaging.meta.pages = Decimal.ToInt32(dataPaging.meta.total / dataPaging.meta.perpage);
}
return(dataPaging);
}
public ms_company Get(string id)
{
ms_company msCompany = null;
DataPaging <ms_company> dataPaging = new DataPaging <ms_company>();
using (OASEntities _ent = new OASEntities())
{
msCompany = _ent.ms_company.Find(id);
}
return(msCompany);
}
public ms_company Put(string id, ms_company comp)
{
using (OASEntities _ent = new OASEntities())
{
ms_company compExits = _ent.ms_company.Find(id);
if (compExits == null)
{
throw new Exception("id:" + id + " not found ");
}
compExits.comp_name = comp.comp_name;
compExits.update_user = comp.update_user;
compExits.update_datetime = DateTime.Now;
_ent.SaveChanges();
return(comp);
}
}
public MS_Company Put(string id, MS_Company comp)
{
using (OASEntities _ent = new OASEntities())
{
MS_Company compExits = _ent.MS_Company.Find(id);
if (compExits == null)
{
throw new Exception("id:" + id + " not found ");
}
compExits.CompName = comp.CompName;
compExits.UpdateUser = comp.UpdateUser;
compExits.UpdateDatetime = DateTime.Now;
_ent.SaveChanges();
return(comp);
}
}
public DataPaging <MS_Company> List(SearchCompDataPaging search)
{
List <MS_Company> compList = null;
DataPaging <MS_Company> dataPaging = new DataPaging <MS_Company>();
if (search != null)
{
using (OASEntities _ent = new OASEntities())
{
compList = _ent.MS_Company.Where(x => x.CompName.Contains(search.compName)).OrderBy(x => x.CompName).ToList();
dataPaging.data = compList;
dataPaging.meta = new MetaPaging();
dataPaging.meta.total = compList.Count;
dataPaging.meta.perpage = 10;
dataPaging.meta.page = 1;
}
}
return(dataPaging);
}
