public static object GetByCode(string fieldname, string keyword, string tablename = "")
{
Models.AdminContext db = new Models.AdminContext();
object results = null;
switch (fieldname)
{
case "CustomerName":
var CustomerName = db.Database.SqlQuery <Models.SenCustomer>("Select * from SenCustomer Where Name={0}", keyword).SingleOrDefault();
results = (new { rows = CustomerName });
break;
case "ProductName":
var ProductName = db.Database.SqlQuery <Models.SenProduct>("Select * from SenProduct Where Name={0}", keyword).SingleOrDefault();
results = (new { rows = ProductName });
break;
case "UserName":
var UserName = db.Database.SqlQuery <Models.aspnet_Users>("Select * from aspnet_Users Where UserName={0}", keyword).SingleOrDefault();
results = (new { rows = UserName });
break;
case "RoleName":
var RoleName = db.Database.SqlQuery <Models.aspnet_Roles>("Select * from aspnet_Roles Where RoleName={0}", keyword).SingleOrDefault();
results = (new { rows = RoleName });
break;
case "CompanyName":
var CompanyName = db.Database.SqlQuery <Models.SenCompany>("Select * from SenCompany Where Name={0}", keyword).SingleOrDefault();
results = (new { rows = CompanyName });
break;
case "ApplicationName":
var ApplicationName = db.Database.SqlQuery <Models.SenApplication>("Select * from SenApplication Where Name={0}", keyword).SingleOrDefault();
results = (new { rows = ApplicationName });
break;
case "TableName":
var TableName = db.Database.SqlQuery <Models.SysTable>("Select * from SysTable Where TableName={0}", keyword).SingleOrDefault();
results = (new { rows = TableName });
break;
case "ColumnName":
var ColumnName = db.Database.SqlQuery <Models.SysColumn>("Select * from SysColumn Where Name={0}", keyword).SingleOrDefault();
results = (new { rows = ColumnName });
break;
default:
break;
}
return(results);
}
public SenVietListObject(HttpRequestBase request)
{
this.InitObject();
this._db = new Models.AdminContext();
this._request = request;
this._metaobject = Services.GlobalMeta.GetMetaObject(this._metaname);
this._paramnameoutput = this._keyfield;
this._paramnameupdate = string.Format("Original_{0}", this._keyfield);
appajaxoption.ajaxoption.Add("ajaxupdateid", string.Format("{0}_container", this._metaname.ToLower()));
appajaxoption.ajaxoption.Add("businesscode", this._businesscode);
appajaxoption.ajaxoption.Add("metaname", this._metaname);
appajaxoption.ajaxoption.Add("keyfield", this._keyfield);
appajaxoption.ajaxoption.Add("action-return", this._request["action_return"]);
//this.sysbusiness = this._db.SysBusinesses.Where(m => m.BusinessCode == this._businesscode).SingleOrDefault();
//int roleid = Services.GlobalVariant.GetAppUser().RoleID;
//this.sysbusinessrole = this._db.SysBusinessRoles.Where(m => m.BusinessCode == this._businesscode & m.RoleID == roleid).SingleOrDefault();
}
public static void SetMetaObject(string tablename)
{
//Dictionary<string, SenViet.Models.MetaObject> MetaObjects = null;
Dictionary <string, Models.MetaObject> MetaObjects = null;
if (HttpContext.Current.Session[CacheKey.GlobalMetaKeys] == null)
{
MetaObjects = new Dictionary <string, Models.MetaObject>();
HttpContext.Current.Session[CacheKey.GlobalMetaKeys] = MetaObjects;
}
else
{
MetaObjects = (Dictionary <string, Models.MetaObject>)HttpContext.Current.Session[CacheKey.GlobalMetaKeys];
}
if (!MetaObjects.ContainsKey(tablename))
{
var MetaObject = new Models.MetaObject();
Models.AdminContext db = new Models.AdminContext();
MetaObject.MetaTable = db.SysTableDetailViews.Where(m => m.TableName == tablename).ToList();
MetaObject.Paging = new Models.Paging();
MetaObjects.Add(tablename, MetaObject);
}
//else // dành cho phát triển sau này phải bỏ
//{
// var MetaObject = new SenViet.Models.MetaObject();
// SenViet.Areas.SysAdmin.Models.SysAdminEntities _slmeta = new SenViet.Areas.SysAdmin.Models.SysAdminEntities();
// var _result = _slmeta.SysTableDetailViews.Where(m => m.TableName == tablename).ToList();
// MetaObject.MetaTable = _result;
// MetaObject.Paging = new Models.Paging();
// MetaObjects.Remove(tablename);
// MetaObjects.Add(tablename, MetaObject);
//}
}
public static object GetByKeyword(System.Web.HttpRequestBase request, string fieldname, string keyword, string tablename = "")
{
Models.AdminContext db = new Models.AdminContext();
//int maxRows = 10;
Models.PagingAutocomplete paging = new Models.PagingAutocomplete(request);
object rows = null;
object results = null;
keyword = keyword.Trim();
switch (fieldname)
{
case "CustomerName":
paging.SetPaging(db.SenCustomers.Where(m => (m.CustomerCode + " - " + m.Name).Contains(keyword)).Count());
rows = (from m in db.SenCustomers
where (m.CustomerCode + " - " + m.Name).Contains(keyword)
orderby m.Name
select new { label = m.CustomerCode + " - " + m.Name, value = m.Name, id = m.CustomerId, name = m.Name })
.Skip(paging.Skip)
.Take(paging.PageSize).ToList();
break;
case "ProductName":
paging.SetPaging(db.SenProducts.Where(m => (m.ProductCode + " - " + m.Name).Contains(keyword)).Count());
rows = (from m in db.SenProducts
where (m.ProductCode + " - " + m.Name).Contains(keyword)
orderby m.Name
select new { label = m.ProductCode + " - " + m.Name, value = m.Name, id = m.ProductId, name = m.Name })
.Skip(paging.Skip)
.Take(paging.PageSize).ToList();
break;
case "CompanyName":
paging.SetPaging(db.SenCompanyViews.Where(m => (m.Name + " - " + m.UserName).Contains(keyword)).Count());
rows = (from m in db.SenCompanyViews
where (m.Name + " - " + m.UserName).Contains(keyword)
orderby m.Name
select new { label = m.Name + " - " + m.UserName, value = m.Name, id = m.CompanyId, name = m.Name })
.Skip(paging.Skip)
.Take(paging.PageSize).ToList();
break;
case "ApplicationName":
paging.SetPaging(db.SenApplications.Where(m => (m.Name).Contains(keyword)).Count());
rows = (from m in db.SenApplications
where (m.Name).Contains(keyword)
orderby m.Name
select new { label = m.Name, value = m.Name, id = m.ApplicationId, name = m.Name })
.Skip(paging.Skip)
.Take(paging.PageSize).ToList();
break;
case "UserName":
paging.SetPaging(db.vw_aspnet_MembershipUsers.Where(m => (m.UserName + m.Email).Contains(keyword)).Count());
rows = (from m in db.vw_aspnet_MembershipUsers
where (m.UserName + m.Email).Contains(keyword)
orderby m.UserName
select new { label = m.UserName + " " + m.Email, value = m.UserName, id = m.UserId, name = m.UserName })
.Skip(paging.Skip)
.Take(paging.PageSize).ToList();
break;
case "RoleName":
paging.SetPaging(db.aspnet_Roles.Where(m => (m.RoleName + m.Description).Contains(keyword)).Count());
rows = (from m in db.aspnet_Roles
where (m.RoleName + m.Description).Contains(keyword)
orderby m.RoleName
select new { label = m.RoleName + " " + m.Description, value = m.RoleName, id = m.RoleId, name = m.RoleName })
.Skip(paging.Skip)
.Take(paging.PageSize).ToList();
break;
case "TableName":
paging.SetPaging(db.SysTables.Where(m => (m.TableName + m.Des).Contains(keyword)).Count());
rows = (from m in db.SysTables
where (m.TableName + m.Des).Contains(keyword)
orderby m.TableName
select new { label = m.TableName + " " + m.Des, value = m.TableName, id = m.TableName, name = m.TableName })
.Skip(paging.Skip)
.Take(paging.PageSize).ToList();
break;
case "ColumnName":
paging.SetPaging(db.SysColumns.Where(m => (m.Name + m.Des).Contains(keyword)).Count());
rows = (from m in db.SysColumns
where (m.Name + m.Des).Contains(keyword)
orderby m.Name
select new { label = m.Name + " " + m.Des, value = m.Name, id = m.Name, name = m.Name })
.Skip(paging.Skip)
.Take(paging.PageSize).ToList();
break;
default:
break;
}
results = (new { rows, paging });
return(results);
}
