//public ActionResult Read([DataSourceRequest] DataSourceRequest request)
//{
// if (asset.View)
// {
// var data = new Merchant_Info_DAO().ReadAll();
// return Json(data.ToDataSourceResult(request));
// }
// else
// {
// return RedirectToAction("NoAccessRights", "Error");
// }
//}
//#region Read_Action
public ActionResult Read([DataSourceRequest] DataSourceRequest request)
{
if (asset.View)
{
using (IDbConnection dbConn = OrmliteConnection.openConn())
{
//var data = Merchant_Info.ReadAll();
DataTable data = new DataTable();
string st = string.Empty;
using (var client = new HttpClient())
{
client.BaseAddress = new Uri(AllConstant.UriAPI);
client.DefaultRequestHeaders.Accept.Clear();
client.DefaultRequestHeaders.Accept.Add(new MediaTypeWithQualityHeaderValue("application/json"));
HttpResponseMessage response = client.GetAsync("api/Merchant_Info/GetAll?key=" + AllConstant.KeyAPI).Result;
if (response.IsSuccessStatusCode)
{
st = response.Content.ReadAsStringAsync().Result;
var test = JsonConvert.DeserializeObject(st);
data = (DataTable)JsonConvert.DeserializeObject(test.ToString(), (typeof(DataTable)));
}
}
return(Json(data.ToDataSourceResult(request)));
}
}
else
{
return(RedirectToAction("NoAccessRights", "Error"));
}
}
public ActionResult Read([DataSourceRequest] DataSourceRequest request)
{
using (IDbConnection dbConn = OrmliteConnection.openConn())
{
var data = new DataSourceResult();
if (asset.View)
{
string strQuery = @"SELECT cus.*
,ISNULL(ps1.Value,'N/A') AS StatusName
,ISNULL(source.Value,'N/A') AS SourceName
,ISNULL(ps2.Value,'N/A') AS TypeName
,ISNULL(emp.Name,'N/A') AS EmployeeName
,ISNULL(team.TeamName,'N/A') AS TeamName
,ISNULL(unit.Value,'N/A') AS RegionName
FROM ERPAPD_Customer cus
LEFT JOIN [Parameters] ps1 ON ps1.ParamID = cus.Status AND ps1.Type = 'CustomerStatus'
LEFT JOIN [Parameters] source ON source.ParamID = cus.Source AND source.Type = 'CustomerSource'
LEFT JOIN [ERPAPD_MasterData_Customer] ps2 ON ps2.Code = cus.CustomerType AND ps2.Type = 'CustomerType'
LEFT JOIN [ERPAPD_Employee] emp ON cus.StaffId = emp.RefEmployeeID
LEFT JOIN [CRM_Team] team ON team.TeamID = cus.GroupId
LEFT JOIN [CRM_Hierarchy] unit ON unit.HierarchyID = cus.UnitId
";
data = KendoApplyFilter.KendoDataByQuery <ERPAPD_Customer>(request, strQuery, "");
return(Json(data));
}
return(RedirectToAction("NoAccessRights", "Error"));
}
}
public ActionResult Update_Color(string RowID, string Value)
{
using (IDbConnection dbConn = OrmliteConnection.openConn())
{
if (RowID != null)
{
try {
var exits = dbConn.SingleOrDefault <CRM_Label>("RowID= {0}", RowID);
exits.Value = !string.IsNullOrEmpty(Value) ? Value.Trim() : "";
exits.RowUpdatedUser = currentUser.UserName;
exits.RowUpdatedAt = DateTime.Now;
dbConn.Update(exits);
}
catch (Exception e)
{
return(Json(new { success = false, message = e.Message }));
}
return(Json(new { success = true }));
}
else
{
return(Json(new { success = false, message = "No rowID" }));
}
}
}
public ActionResult Index()
{
if (asset.View)
{
ViewBag.Create = asset.Create;
ViewBag.Update = asset.Update;
ViewBag.Delete = asset.Delete;
ViewBag.Export = asset.Export;
ViewBag.listWebsite = CRM_Website.GetList();
using (IDbConnection db = OrmliteConnection.openConn())
{
ViewBag.listHierarchy1 = db.Select <Hierarchy>(c => c.cap == 1).OrderBy(s => s.id);
ViewBag.listHierarchy2 = db.Select <Hierarchy>(c => c.cap == 2).OrderBy(s => s.id);
ViewBag.listHierarchy3 = db.Select <Hierarchy>(c => c.cap == 3).OrderBy(s => s.id);
ViewBag.listHierarchy4 = db.Select <Hierarchy>(c => c.cap == 4).OrderBy(s => s.id);
ViewBag.listHierarchy5 = db.Select <Hierarchy>(c => c.cap == 5).OrderBy(s => s.id);
ViewBag.listHierarchy6 = db.Select <Hierarchy>(c => c.cap == 6).OrderBy(s => s.id);
ViewBag.listHierarchy7 = db.Select <Hierarchy>(c => c.cap == 7).OrderBy(s => s.id);
ViewBag.listHierarchy8 = db.Select <Hierarchy>(c => c.cap == 8).OrderBy(s => s.id);
ViewBag.listHierarchy9 = db.Select <Hierarchy>(c => c.cap == 9).OrderBy(s => s.id);
ViewBag.listHierarchy10 = db.Select <Hierarchy>(c => c.cap == 10).OrderBy(s => s.id);
ViewBag.listStatus = db.Select <BIBIAM.Core.Entities.Parameters>(s => s.Type == "ProductHierarchyStatus").OrderBy(s => s.ID);
}
return(View());
}
else
{
return(RedirectToAction("NoAccessRights", "Error"));
}
}
// GET: CRMContactList
public ActionResult Index()
{
using (IDbConnection dbConn = OrmliteConnection.openConn())
{
ViewData["AllowCreate"] = asset.Create;
ViewData["AllowUpdate"] = asset.Update;
ViewData["AllowDelete"] = asset.Delete;
ViewData["AllowExport"] = asset.Export;
// ViewBag.listSubCategory = dbConn.Select<CRM_SubCategory>(s => s.Active == true);
ViewBag.listCategory = dbConn.Select <CRM_CategoryHierarchy>(@"SELECT ID,[HierarchyID],Value,ParentID,[Level] FROM CRM_CategoryHierarchy WHERE Level=1 ");
ViewBag.listSubCategory = dbConn.Select <CRM_CategoryHierarchy>(@"SELECT ID,[HierarchyID],Value,ParentID,[Level] FROM CRM_CategoryHierarchy WHERE Level<>1 AND Level<>0");
ViewBag.listCustomer = dbConn.Select <ERPAPD_Customer>("SELECT TOP 10 CustomerID,CustomerName FROM ERPAPD_Customer ");
ViewBag.listGender = dbConn.Select <Parameters>(s => s.Type == "Gender");
ViewBag.listColumns = dbConn.Select <ERPAPD_Contacts>("SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = N'ERPAPD_Contacts'");
if (Request.Cookies["permissions_contacts_list_" + currentUser.Id] != null)
{
ViewBag.listColumnsCookie = Request.Cookies["permissions_contacts_list_" + currentUser.Id];
}
else
{
ViewBag.listColumnsUserConfig = dbConn.Select <Users_Permissions>("SELECT CustomerInfo FROM Users_Permissions WHERE UserID = 1");
}
return(View());
}
}
public ActionResult Index()
{
//using (IDbConnection dbConn = OrmliteConnection.openConn())
//{
// OrmLiteConfig.DialectProvider.UseUnicode = true;
// dbConn.DropTables(typeof(Deca_SMS_Template));
// const bool overwrite = false;
// dbConn.CreateTables(overwrite, typeof(Deca_SMS_Template));
//}
if (asset.View)
{
ViewData["AllowCreate"] = asset.Create;
ViewData["AllowUpdate"] = asset.Update;
ViewData["AllowDelete"] = asset.Delete;
ViewData["AllowExport"] = asset.Export;
ViewBag.AllowView = true;
using (var dbConn = OrmliteConnection.openConn())
{
ViewBag.listUser = dbConn.Select <Users>();
ViewBag.listGroup = dbConn.Select <Groups>();
}
return(View());
}
else
{
ViewBag.AllowView = false;
return(RedirectToAction("NoAccessRights", "Error"));
}
}
private Image AutoResize(Image img, string type)
{
using (IDbConnection db = OrmliteConnection.openConn(AppConfigs.MCCConnectionString))
{
//db.ChangeDatabase(AllConstant.ERPDBName);
var x = db.Select <Code_Master>(s => s.Type == "IMGAutoResize").OrderBy(s => s.Value);
int width = 0, height = 0;
foreach (Code_Master item in x)
{
if (item.Value == type + "_WIDTH")
{
width = Int16.Parse(item.Name);
}
if (item.Value == type + "_HEIGHT")
{
height = Int16.Parse(item.Name);
}
}
if (width * height != 0)
{
return(ResizeImage(img, width, height));
}
else
{
return(null);
}
}
}
//Result by Customer block
public PartialViewResult PartialResultByCustomer(string ManagementID)
{
using (var dbConn = OrmliteConnection.openConn())
{
//tra ra danh sach header.
List <ExpandoObject> result = new List <ExpandoObject>();
//2 cot dau tien
dynamic Ngaylam = new ExpandoObject();
Ngaylam.Name = "CreatedAt";
Ngaylam.Title = "Ngày làm";
result.Add(Ngaylam);
dynamic khach = new ExpandoObject();
khach.Name = "CustomerInfo";
khach.Title = "Thông tin khách hàng";
result.Add(khach);
//lay danh sach cau hoi, bind thanh header.
string query = @"SELECT mq.Id, q.QuestionID, q.[Description] FROM CRM_Survey_Management_Question mq
LEFT JOIN CRM_Survey_Question q
ON mq.QuestionID = q.QuestionID
WHERE mq.SurveyManagementID = " + ManagementID + " ORDER BY mq.SortOrder";
var listQuestion = dbConn.Select <CRM_Survey_Management_Question>(query);
foreach (var question in listQuestion)
{
dynamic dynamicQuestion = new ExpandoObject();
dynamicQuestion.Name = question.QuestionID;
dynamicQuestion.Title = question.Description;
result.Add(dynamicQuestion);
}
return(PartialView("_GridResultByCustomer", result));
}
}
public JsonResult GetDistrict(string CityID)
{
using (var dbConn = OrmliteConnection.openConn())
{
return(Json(dbConn.Select <DC_OCM_Territory>("[Level] = {0} AND [ParentID] = {1}", "District", CityID).OrderBy(a => a.TerritoryName), JsonRequestBehavior.AllowGet));
}
}
public JsonResult GetCity()
{
using (var dbConn = OrmliteConnection.openConn())
{
return(Json(dbConn.Select <DC_OCM_Territory>("[Level] = {0}", "Province").OrderBy(a => a.TerritoryName), JsonRequestBehavior.AllowGet));
}
}
public ActionResult Read([DataSourceRequest] DataSourceRequest request)
{
if (asset.View)
{
using (IDbConnection dbConn = OrmliteConnection.openConn())
{
//var data = CRM_PageType.ReadAll();
DataTable data = new DataTable();
//string st = "[{\"PageTypeID\":1,\"PageTypeName\":\"asdasdsad\",\"RefID\":\"asdasd\",\"Status\":true,\"CreatedAt\":\"2016-09-09T18:43:46.553\",\"CreatedBy\":\"administrator\",\"UpdatedAt\":\"2016-09-09T18:43:46.553\",\"UpdatedBy\":\"administrator\"}]";
string st = string.Empty;
using (var client = new HttpClient())
{
client.BaseAddress = new Uri(AllConstant.UriAPI);
client.DefaultRequestHeaders.Accept.Clear();
client.DefaultRequestHeaders.Accept.Add(new MediaTypeWithQualityHeaderValue("application/json"));
HttpResponseMessage response = client.GetAsync("api/PageType/GetAllDataTable?key=" + AllConstant.KeyAPI + "&type=datatable").Result;
if (response.IsSuccessStatusCode)
{
st = response.Content.ReadAsStringAsync().Result;
var test = JsonConvert.DeserializeObject(st);
data = (DataTable)JsonConvert.DeserializeObject(test.ToString(), (typeof(DataTable)));
}
}
return(Json(data.ToDataSourceResult(request)));
}
}
else
{
return(RedirectToAction("NoAccessRights", "Error"));
}
}
public ActionResult BookNew()
{
using (var dbConn = OrmliteConnection.openConn())
{
ViewData["AllowCreate"] = asset.Create;
ViewData["AllowUpdate"] = asset.Update;
ViewData["AllowDelete"] = asset.Delete;
ViewData["AllowExport"] = asset.Export;
ViewBag.listStaff = dbConn.Select <DropDownListData>("select RefStaffId AS Code,FullName AS Name from EmployeeInfo");
ViewBag.listWebsite = dbConn.Select <DropDownListDataList>("select Code,Name from ERPAPD_List WHERE FKListtype = 20");
ViewBag.listCategory = dbConn.Select <DropDownListDataList>("select Code,Name from ERPAPD_List WHERE FKListtype = 22");
ViewBag.listLocation = dbConn.Select <DropDownListDataList>("select Code,Name from ERPAPD_List WHERE FKListtype = 23");
ViewBag.listNature = dbConn.Select <DropDownListDataList>("select Code,Name from ERPAPD_List WHERE FKListtype = 25");
ViewBag.listTeam = dbConn.Select <DropDownListData>("select TeamID AS Code ,TeamName AS Name from CRM_Team where FKUnit = 13");
ViewBag.listRegion = dbConn.Select <DropDownListData>("select Code,Name from ERPAPD_List WHERE FKListtype = 52 ");
ViewBag.listPosition = dbConn.Select <DropDownListData>("select PKList AS Code, Name from ERPAPD_List WHERE FKListtype = 5");
var bookcode = dbConn.SingleOrDefault <Parameters>("Type = 'BookLocation'");
if (bookcode != null)
{
var bk = int.Parse(bookcode.Value) + 1;
string b = "B." + String.Format("{0:000000}", bk);
bookcode.Value = bk.ToString();
ViewBag.BookCode = b;
dbConn.Update(bookcode);
}
}
return(View());
}
public static bool CheckScheduleBooking(string action, long id, string type, string website, string category, string location, DateTime dateup, int hour)
{
using (var dbConn = OrmliteConnection.openConn())
{
if (action == "update")
{
var bookBao = dbConn.SingleOrDefault <CRM_BookPRLocation>("Website = {0} AND Category = {1} AND Location = {2} AND NgayLen = {3} AND GioLen = {4} AND Type = {5} AND ID <> {6}", website, category, location, dateup, hour, type, id);
if (bookBao != null)
{
return(false);
}
}
else
{
var bookBao = dbConn.SingleOrDefault <CRM_BookPRLocation>("Website = {0} AND Category = {1} AND Location = {2} AND NgayLen = {3} AND GioLen = {4} AND Type = {5} ", website, category, location, dateup, hour, type);
if (bookBao != null)
{
return(false);
}
}
return(true);
}
}
public ActionResult GetListReason()
{
using (var dbConn = OrmliteConnection.openConn())
{
return(Json(dbConn.Select <Deca_Code_Master>("CodeType={0}", "CancelOrderReason"), JsonRequestBehavior.AllowGet));
}
}
public ActionResult Read([DataSourceRequest] DataSourceRequest request, string ma_gian_hang = "")
{
if (accessDetail != null && (accessDetail.access["all"] || accessDetail.access["view"]))
{
using (IDbConnection db = OrmliteConnection.openConn(AppConfigs.MCCConnectionString))
{
var data = new DataSourceResult();
if (!isAdmin)
{
data = KendoApplyFilter.KendoData <Merchant_Catalog>(request, "ma_gian_hang={0}".Params(currentUser.ma_gian_hang));
//return Json(db.Select<Merchant_Catalog>(s => s.ma_gian_hang == currentUser.ma_gian_hang).ToDataSourceResult(request), JsonRequestBehavior.AllowGet);
}
else
{
if (!string.IsNullOrEmpty(ma_gian_hang.Trim()))
{
//return Json(db.Select<Merchant_Catalog>(s => s.ma_gian_hang == ma_gian_hang).ToDataSourceResult(request), JsonRequestBehavior.AllowGet);
data = KendoApplyFilter.KendoData <Merchant_Catalog>(request, " ma_gian_hang={0}".Params(currentUser.ma_gian_hang));
}
else
{
//return Json(db.Select<Merchant_Catalog>().ToDataSourceResult(request), JsonRequestBehavior.AllowGet);
data = KendoApplyFilter.KendoData <Merchant_Catalog>(request);
}
}
return(Json(data, JsonRequestBehavior.AllowGet));
}
}
else
{
return(RedirectToAction("NoAccessRights", "Error"));
}
}
private Image AutoResize(Image img, string type)
{
using (IDbConnection db = OrmliteConnection.openConn())
{
var x = db.Select <BIBIAM.Core.Entities.Parameters>(s => s.Type == "IMGAutoResize").OrderBy(s => s.ParamID);
int width = 0, height = 0;
foreach (BIBIAM.Core.Entities.Parameters item in x)
{
if (item.ParamID == type + "_WIDTH")
{
width = Int16.Parse(item.Value);
}
if (item.ParamID == type + "_HEIGHT")
{
height = Int16.Parse(item.Value);
}
}
if (width * height != 0)
{
return(ResizeImage(img, width, height));
}
else
{
return(null);
}
}
}
public ActionResult Create(int Id = 0)
{
using (IDbConnection dbConn = OrmliteConnection.openConn())
{
ViewBag.listContractTerms = dbConn.Select <Parameters>("Type ={0}", "ContractDraffType").OrderBy(s => s.ParamID);
if (Id != 0)
{
ViewBag.rowItem = dbConn.SingleOrDefault <CRM_Contract_Extra>("RowID= {0}", Id);
if (asset.Update)
{
return(View());
}
else
{
return(RedirectToAction("NoAccessRights", "Error"));
}
}
else
{
if (asset.Create)
{
return(View());
}
else
{
return(RedirectToAction("NoAccessRights", "Error"));
}
}
}
}
public ActionResult GetListCurrency([DataSourceRequest] DataSourceRequest request)
{
using (var dbConn = OrmliteConnection.openConn())
{
return(Json(dbConn.Select <ti_gia_tien_te>().OrderBy(a => a.ID), JsonRequestBehavior.AllowGet));
}
}
public ActionResult Update(int idWidth, string Width, int idHeight, string Height)
{
if (asset.View)
{
using (IDbConnection db = OrmliteConnection.openConn())
{
var checkWidth = db.FirstOrDefault <Parameters>(s => s.ID == idWidth);
var checkHeight = db.FirstOrDefault <Parameters>(s => s.ID == idHeight);
if (checkWidth != null)
{
checkWidth.Value = Width;
checkWidth.UpdatedAt = DateTime.Now;
checkWidth.UpdatedBy = currentUser.UserName;
db.Update(checkWidth);
}
if (checkHeight != null)
{
checkHeight.Value = Height;
checkHeight.UpdatedAt = DateTime.Now;
checkHeight.UpdatedBy = currentUser.UserName;
db.Update(checkHeight);
}
}
return(Json(new { success = true, message = "Cập nhật thành công", JsonRequestBehavior.AllowGet }));
}
else
{
return(Json(new { success = false, message = "Bạn không có quyền", JsonRequestBehavior.AllowGet }));
}
}
public ActionResult Index()
{
if (asset.View)
{
ViewBag.Create = asset.Create;
ViewBag.Update = asset.Update;
ViewBag.Delete = asset.Delete;
ViewBag.Export = asset.Export;
ViewBag.listWebsite = CRM_Website.GetList();
using (IDbConnection db = OrmliteConnection.openConn())
{
//ViewBag.listAll = db.Select<Hierarchy>();
ViewBag.listAll = db.Select <DropListDown>("Select ma_phan_cap as Value , ten_phan_cap as Text from Hierarchy");
ViewBag.listStatus = db.Select <BIBIAM.Core.Entities.Parameters>(s => s.Type == "HierarchyStatus").OrderBy(s => s.ID);
ViewBag.listHierarchyType = db.Select <BIBIAM.Core.Entities.Parameters>(s => s.Type == "HierarchyType").OrderBy(s => s.ID);
}
return(View());
}
else
{
return(RedirectToAction("NoAccessRights", "Error"));
}
}
public ActionResult Update(string ma_gian_hang, string data)
{
using (IDbConnection db = OrmliteConnection.openConn())
{
if (asset.Create || asset.Update)
{
try
{
new Merchant_Image_DAO().DeleteForCode(ma_gian_hang);
string[] separators = { "@@" };
var listdata = data.Split(separators, StringSplitOptions.RemoveEmptyEntries);
foreach (var item in listdata)
{
new Merchant_Image_DAO().Insert(ma_gian_hang, item, currentUser.UserName);
}
return(Json(new { success = true }));
}
catch (Exception ex)
{
return(RedirectToAction("NoAccess", "Error"));
//return Json(new { success = false, message = e.Message });
}
}
else
{
return(Json(new { success = false, message = "Bạn không có quyền." }));
}
}
}
public ActionResult Read([DataSourceRequest] DataSourceRequest request)
{
if (asset.View)
{
using (IDbConnection dbConn = OrmliteConnection.openConn())
{
string sqlQuery = @"SELECT req.*
,SUBSTRING(c_code,3, 10) AS BookCode
,ISNULL(l.PKBookLocation,0) AS PKBookLocation
,ISNULL(l.FKBookReq,'') AS FKBookReq
,ISNULL(l.Website,'') AS Website
,ISNULL(l.Category,'') AS Category
,ISNULL(l.Location,'') AS Location
,ISNULL(l.Nature,'') AS Nature
,ISNULL(l.NgayLen,'') AS NgayLen
,ISNULL(l.NgayXuong ,'') AS NgayXuong
,ISNULL(l.InputDate,'') AS InputDate
,ISNULL(l.AccountStatus,'') AS AccountStatus
,ISNULL(cus.CustomerName,'') AS CustomerName
FROM CRM_Book_Req req
INNER JOIN CRM_Book_Location l on l.FKBookReq = req.pk_book_req
LEFT JOIN ERPAPD_Customer cus on cus.CustomerCode = req.c_customer_code
";
return(Json(KendoApplyFilter.KendoDataByQuery <BookBannerViewModel>(request, sqlQuery, "")));
}
}
else
{
return(RedirectToAction("NoAccessRights", "Error"));
}
}
public JsonResult GetCompany()
{
using (var dbConn = OrmliteConnection.openConn())
{
return(Json(dbConn.Select <Deca_Company>().OrderBy(a => a.Id), JsonRequestBehavior.AllowGet));
}
}
public ActionResult Read([DataSourceRequest] DataSourceRequest request)
{
using (IDbConnection dbConn = OrmliteConnection.openConn())
{
var data = new DataSourceResult();
if (asset.View)
{
string strQuery = @"SELECT product.*
,ISNULL(ProductType.Name,'') AS ProductTypeName
,ISNULL(pageType.Name,'') AS PageTypeName
,ISNULL(webSite.Name,'') AS WebsiteName
,ISNULL(cate.Name,'') AS CategoryName
,ISNULL(location.Name,'') AS LocationName
,ISNULL(nature.Name,'') AS NatureName
FROM [ERPAPD_Product] product
LEFT JOIN
(
SELECT a.Code,a.Name
FROM [ERPAPDDev].[dbo].[ERPAPD_List] a
INNER JOIN [ERPAPDDev].[dbo].[ERPAPD_ListType] b on b.PKListType = a.FKListtype AND b.PKListType = 19
) productType On productType.Code = product.ProductType
LEFT JOIN
(
SELECT a.Code,a.Name
FROM [ERPAPDDev].[dbo].[ERPAPD_List] a
INNER JOIN [ERPAPDDev].[dbo].[ERPAPD_ListType] b on b.PKListType = a.FKListtype AND b.PKListType = 20
) webSite On webSite.Code = product.Website
LEFT JOIN
(
SELECT a.Code,a.Name
FROM [ERPAPDDev].[dbo].[ERPAPD_List] a
INNER JOIN [ERPAPDDev].[dbo].[ERPAPD_ListType] b on b.PKListType = a.FKListtype AND b.PKListType = 21
) pageType On pageType.Code = product.PageType
LEFT JOIN
(
SELECT a.Code,a.Name
FROM [ERPAPDDev].[dbo].[ERPAPD_List] a
INNER JOIN [ERPAPDDev].[dbo].[ERPAPD_ListType] b on b.PKListType = a.FKListtype AND b.PKListType = 22
) cate On cate.Code = product.Category
LEFT JOIN
(
SELECT a.Code,a.Name
FROM [ERPAPDDev].[dbo].[ERPAPD_List] a
INNER JOIN [ERPAPDDev].[dbo].[ERPAPD_ListType] b on b.PKListType = a.FKListtype AND b.PKListType = 23
) location On location.Code = product.Location
LEFT JOIN
(
SELECT a.Code,a.Name
FROM [ERPAPDDev].[dbo].[ERPAPD_List] a
INNER JOIN [ERPAPDDev].[dbo].[ERPAPD_ListType] b on b.PKListType = a.FKListtype AND b.PKListType = 25
) nature On nature.Code = product.Nature
";
data = KendoApplyFilter.KendoDataByQuery <ERPAPD_Product>(request, strQuery, "");
return(Json(data));
}
return(RedirectToAction("NoAccessRights", "Error"));
}
}
public ActionResult Read([DataSourceRequest] DataSourceRequest request)
{
using (IDbConnection dbConn = OrmliteConnection.openConn())
{
var data = KendoApplyFilter.KendoData <cms_BoxTin>(request);
return(Json(data));
}
}
public ActionResult GetCurrency(string CurrencyCode)
{
using (var dbConn = OrmliteConnection.openConn())
{
var data = dbConn.Select <tien_te>(m => m.ma_tien_te == CurrencyCode);
return(Json(new { data, success = true }, JsonRequestBehavior.AllowGet));
}
}
public ActionResult GetListBank()
{
using (var dbConn = OrmliteConnection.openConn())
{
var data = dbConn.Select <DC_Bank_Definition>().OrderBy(a => a.BankName);
return(Json(data, JsonRequestBehavior.AllowGet));
}
}
public ActionResult GetListCategory(string web)
{
using (var dbConn = OrmliteConnection.openConn())
{
var data = dbConn.SqlList <DropDownListDataList>("EXEC p_SelectERPAPD_Category_byCode @PageCode", new { PageCode = web });
return(Json(new { success = true, listCategory = data }));
}
}
public ActionResult GetListStaff(string team)
{
using (var dbConn = OrmliteConnection.openConn())
{
var data = dbConn.SqlList <DropDownListData>("EXEC p_getListStaffByTeam @team", new { team = team });
return(Json(new { success = true, listStaff = data }));
}
}
public ActionResult GetUserDetail(int leaderId)
{
using (var dbConn = OrmliteConnection.openConn())
{
var data = dbConn.Select <Users>("SELECT * FROM [Users] WHERE Active = 1 AND Id = " + leaderId);
return(Json(new { success = true, data = data }));
}
}