public ActionResult Index(string redirectbyajax, string entryid, string actiontype, string fa) { //fa: form another - default form popup IDbConnection dbConn = new OrmliteConnection().openConn(); var dict = new Dictionary <string, object>(); dict["activestatus"] = CustomModel.GetActiveStatus(); dict["listlanguage"] = CustomModel.GetLanguage(); dict["areasname"] = "Admin"; dict["redirectbyajax"] = string.IsNullOrEmpty(redirectbyajax) ? "0" : "1"; dbConn.Close(); var dataModel = HomePage.GetLast(); if (dataModel == null) { dataModel = new HomePage(); } dict["dataModel"] = dataModel; dbConn.Close(); //param cho form ViewBag.entryid = dataModel.entryid == 0 ? "0" : dataModel.entryid.ToString(); ViewBag.actiontype = string.IsNullOrEmpty(actiontype) ? "" : actiontype; ViewBag.fa = string.IsNullOrEmpty(fa) ? "" : fa; return(View("HomePageManagementTree", dict)); }
//public ActionResult ReadDetail([DataSourceRequest] DataSourceRequest request, string SONumber) //{ // log4net.Config.XmlConfigurator.Configure(); // string whereCondition = ""; // if (request.Filters.Count > 0) // { // whereCondition = " AND " + new KendoApplyFilter().ApplyFilter(request.Filters[0]); // } // var data = new DC_AD_SO_Detail().GetPage(request, whereCondition, SONumber); // return Json(data); //} public ActionResult Update([DataSourceRequest] DataSourceRequest request, [Bind(Prefix = "models")] IEnumerable <Products> list, string SONumber) { var dbConn = new OrmliteConnection().openConn(); try { if (list != null && ModelState.IsValid) { foreach (var item in list) { if (item.Qty > 0) { //string SONumber = Request["SONumber"]; var header = new SOHeader(); var detail = new SODetail(); if (dbConn.Select <SODetail>(s => s.SONumber == SONumber && s.ItemCode == item.Code).Count() > 0) { dbConn.Update <SODetail>(set: "Qty = '" + item.Qty + "', TotalAmt = '" + item.Qty * item.Price + "'", where : "SONumber = '" + SONumber + "'"); } else { var data = new SODetail(); data.ItemName = item.Name; data.ItemCode = item.Code; data.Note = ""; data.Price = item.VATPrice; data.Qty = item.Qty; data.SONumber = SONumber; data.UnitID = item.Unit; data.UnitName = dbConn.Select <INUnit>(s => s.UnitID == item.Unit).FirstOrDefault().UnitName; data.TotalAmt = item.Qty * item.VATPrice; data.Status = ""; data.CreatedAt = DateTime.Now; data.CreatedBy = currentUser.UserID; //data.UpdatedAt = DateTime.Parse("1900-01-01"); data.UpdatedAt = DateTime.Now; data.UpdatedBy = ""; dbConn.Insert <SODetail>(data); } dbConn.Update <SOHeader>(set: "TotalQty ='" + dbConn.Select <SODetail>(s => s.SONumber == SONumber).Sum(s => s.Qty) + "', TotalAmt = '" + +dbConn.Select <SODetail>(s => s.SONumber == SONumber).Sum(s => s.TotalAmt) + "'", where : "SONumber ='" + SONumber + "'"); } else { dbConn.Delete <SOHeader>(s => s.SONumber == SONumber); ModelState.AddModelError("error", "Đơn hàng được tạo khi số lượng > 0"); return(Json(list.ToDataSourceResult(request, ModelState))); } } } dbConn.Close(); } catch (Exception e) { dbConn.Close(); ModelState.AddModelError("error", e.Message); return(Json(list.ToDataSourceResult(request, ModelState))); } return(Json(new { sussess = true })); }
public ActionResult UpdateDetail([DataSourceRequest] DataSourceRequest request, [Bind(Prefix = "models")] IEnumerable <SODetail> list) { var dbConn = new OrmliteConnection().openConn(); if (userAsset.ContainsKey("Update") && userAsset["Update"]) { if (list != null)//&& ModelState.IsValid) { foreach (var item in list) { if (dbConn.Select <SOHeader>(s => s.SONumber == item.SONumber && s.Status != "Mới").Count() > 0) { return(Json(new { success = false, message = "Đơn hàng đã xác nhận nên không được xóa." })); } else if (item.Qty > 0) { var isExist = dbConn.SingleOrDefault <SODetail>("SONumber = {0} AND ItemCode = {1}", item.SONumber, item.ItemCode); if (isExist != null) { try { isExist.Qty = item.Qty; isExist.TotalAmt = item.Qty * item.Price; isExist.UpdatedAt = DateTime.Now; isExist.UpdatedBy = currentUser.UserID; dbConn.Update <SODetail>(isExist); //dbConn.Update<SODetail>(set: "Qty = '" + item.Qty + "', TotalAmt = '" + item.Qty * item.Price + "',UpdatedAt = '" + DateTime.Now + "', UpdatedBy ='" + currentUser.UserID + "'", where: "SONumber = '" + item.SONumber + "' AND ItemCode ='" + item.ItemCode + "'"); dbConn.Update <SOHeader>(set: "UpdatedBy='" + currentUser.UserID + "',TotalQty ='" + dbConn.Select <SODetail>(s => s.SONumber == item.SONumber).Sum(s => s.Qty) + "', TotalAmt = '" + dbConn.Select <SODetail>(s => s.SONumber == item.SONumber).Sum(s => s.TotalAmt) + "'", where : "SONumber ='" + item.SONumber + "'"); var success = dbConn.Execute(@"UPDATE SOHeader Set UpdatedAt = @UpdatedAt WHERE SONumber = '" + item.SONumber + "'", new { UpdatedAt = DateTime.Now, }) == 1; } catch (Exception ex) { ModelState.AddModelError("error", ex.Message); return(Json(list.ToDataSourceResult(request, ModelState))); } } } else { ModelState.AddModelError("error", "Đơn hàng được tạo khi số lượng > 0"); return(Json(list.ToDataSourceResult(request, ModelState))); } } } dbConn.Close(); return(Json(new { sussess = true })); } else { dbConn.Close(); ModelState.AddModelError("error", "Bạn không có quyền cập nhật."); return(Json(list.ToDataSourceResult(request, ModelState))); } }
public ActionResult Create([DataSourceRequest] DataSourceRequest request, [Bind(Prefix = "models")] IEnumerable <Models.Master_Calendar> lst) { IDbConnection dbConn = new OrmliteConnection().openConn(); try { foreach (var item in lst) { if (userAsset.ContainsKey("Update") && userAsset["Update"] && dbConn.GetByIdOrDefault <Master_Calendar>(item.Date) != null) { if (string.IsNullOrEmpty(item.Holiday)) { item.Holiday = ""; } item.RowUpdatedAt = DateTime.Now; item.RowUpdatedBy = currentUser.UserID; dbConn.Update <Master_Calendar>(item); } else { return(Json(new { success = false, message = "You don't have permission" })); } } return(Json(new { success = true })); } catch (Exception ex) { log.Error("AdminMasterHoliday - Create - " + ex.Message); return(Json(new { success = false, message = ex.Message })); } finally { dbConn.Close(); } }
public ActionResult PartialDetail(string id) { if (userAsset.ContainsKey("View") && userAsset["View"]) { IDbConnection dbConn = new OrmliteConnection().openConn(); var dict = new Dictionary <string, object>(); dict["asset"] = userAsset; dict["listWH"] = dbConn.Select <WareHouse>(p => p.Status == true); dict["listWHL"] = dbConn.Select <WareHouseLocation>(p => p.Status == true); dict["listVendor"] = dbConn.Select <Vendor>(p => p.Status == true); dict["listWH"] = dbConn.Select <WareHouse>(p => p.Status == true); dict["listWHL"] = dbConn.Select <WareHouseLocation>(p => p.Status == true); dict["listUnit"] = dbConn.Select <INUnit>(p => p.Status == true); dict["SONumber"] = id; dict["activestatus"] = new CommonLib().GetActiveStatus(); dbConn.Close(); if (string.IsNullOrEmpty(id)) { return(PartialView("_OP_CreateOrderIndex", dict)); } else { return(PartialView("_OP_CreateOrder", dict)); } } else { return(RedirectToAction("NoAccess", "Error")); } }
//public JsonResult GetMenu([DataSourceRequest] DataSourceRequest request) //{ // IDbConnection db = new OrmliteConnection().openConn(); // try // { // var listMenu = db.Select<Auth_Menu>(p => p.IsVisible == true).OrderBy(p => p.MenuIndex).ToList(); // DataSourceResult dsr = new DataSourceResult(); // dsr.Data = listMenu; // return Json(dsr, JsonRequestBehavior.AllowGet); // } // catch (Exception e) // { // return Json(new { success = false, message = e.Message }); // } // finally { db.Close(); } //} //[HttpPost] public JsonResult GetMenu(string action, int roleID) { IDbConnection db = new OrmliteConnection().openConn(); try { //select list menu cha List <Auth_Menu> lstFirstMenu = db.Select <Auth_Menu>("IsVisible = 1 AND ParentMenuID ='' AND MenuID <> 'Home'").OrderBy(p => p.MenuIndex).ToList(); List <Auth_Menu> allAuthMenu = db.Select <Auth_Menu>("IsVisible = 1 AND MenuID <> 'Home'").OrderBy(p => p.MenuIndex).ToList(); var listAction = new List <Auth_Menu>(); if (!string.IsNullOrEmpty(action)) { listAction = db.SqlList <Auth_Menu>("p_Auth_Menu_Select_By_Action '" + action + "', " + roleID); } List <AuthMenuViewModel> lstMenuView = new List <AuthMenuViewModel>(); foreach (Auth_Menu der in lstFirstMenu) { AuthMenuViewModel node = new AuthMenuViewModel(); node.id = der.MenuID; node.text = der.MenuName; node.items = new List <AuthMenuViewModel>(); AddChidrenNode(ref node, allAuthMenu, listAction); lstMenuView.Add(node); } return(Json(new { success = true, Data = lstMenuView })); } catch (Exception e) { return(Json(new { success = false, message = e.Message })); } finally { db.Close(); } }
public ActionResult Create(Auth_User item) { IDbConnection db = new OrmliteConnection().openConn(); try { if (!string.IsNullOrEmpty(item.UserID) && !string.IsNullOrEmpty(item.DisplayName) && !string.IsNullOrEmpty(item.FullName)) { var isExist = db.GetByIdOrDefault <Auth_User>(item.UserID); item.Phone = !string.IsNullOrEmpty(item.Phone) ? item.Phone : ""; item.Email = !string.IsNullOrEmpty(item.Email) ? item.Email : ""; item.Note = !string.IsNullOrEmpty(item.Note) ? item.Note : ""; if (userAsset.ContainsKey("Insert") && userAsset["Insert"] && item.RowCreatedAt == null && item.RowCreatedBy == null) { if (isExist != null) { return(Json(new { success = false, message = "Người dùng đã tồn tại." })); } item.Password = SqlHelper.GetMd5Hash("123456"); item.RowCreatedAt = DateTime.Now; item.RowCreatedBy = currentUser.UserID; db.Insert <Auth_User>(item); return(Json(new { success = true, UserID = item.UserID, RowCreatedAt = item.RowCreatedAt, RowCreatedBy = item.RowCreatedBy })); } else if (userAsset.ContainsKey("Update") && userAsset["Update"] && isExist != null) { item.Password = isExist.Password; item.RowUpdatedAt = DateTime.Now; item.RowUpdatedBy = currentUser.UserID; if (isExist.RowCreatedBy != "system") { db.Update <Auth_User>(item); } else { return(Json(new { success = false, message = "Dữ liệu này không cho chỉnh sửa liên hệ admin để biết thêm chi tiết" })); } return(Json(new { success = true })); } else { return(Json(new { success = false, message = "Bạn không có quyền" })); } } else { return(Json(new { success = false, message = "Chưa nhập giá trị" })); } } catch (Exception e) { log.Error("AD_User - Create - " + e.Message); return(Json(new { success = false, message = e.Message })); } finally { db.Close(); } }
public ActionResult AddUserToGroup(string id, string data) { IDbConnection db = new OrmliteConnection().openConn(); try { // Delete All Group of User if (string.IsNullOrEmpty(id)) { return(Json(new { success = false, message = "Chọn người dùng trước khi thêm nhóm." })); } db.DeleteById <Auth_UserInRole>(id); // Add User Group if (!string.IsNullOrEmpty(data)) { string[] arr = data.Split(','); foreach (string item in arr) { var detail = new Auth_UserInRole(); detail.UserID = id; detail.RoleID = int.Parse(item); detail.RowCreatedAt = DateTime.Now; detail.RowCreatedBy = currentUser.UserID; db.Insert <Auth_UserInRole>(detail); } } return(Json(new { success = true })); } catch (Exception e) { return(Json(new { success = false, message = e.Message })); } finally { db.Close(); } }
public ActionResult AddTranporterToContract(string id, string data) { IDbConnection db = new OrmliteConnection().openConn(); try { db.Delete <DC_LG_Contract_Transporter>(p => p.ContractID == id); if (!string.IsNullOrEmpty(data)) { string[] arr = data.Split(','); foreach (string item in arr) { var detail = new DC_LG_Contract_Transporter(); detail.ContractID = id; detail.TransporterID = int.Parse(item); detail.Note = ""; detail.UpdatedAt = DateTime.Now; detail.CreatedAt = DateTime.Now; detail.CreatedBy = currentUser.UserID; detail.UpdatedBy = currentUser.UserID; db.Insert <DC_LG_Contract_Transporter>(detail); } } return(Json(new { success = true })); } catch (Exception e) { return(Json(new { success = false, message = e.Message })); } finally { db.Close(); } }
public ActionResult GetByID(int entryid) { IDbConnection dbConn = new OrmliteConnection().openConn(); try { var data = AuthUser.GetById(entryid); var ref_Roles = CustomModel.GetActiveStatus(); var data_images_common = new List <ImgUploadModel>(); if (!string.IsNullOrEmpty(data.avatarpath)) { data_images_common.Add(new ImgUploadModel() { key = 0, value = data.avatarpath }); } return(Json(new { success = true, data = data , ref_Roles = ref_Roles , data_images_common = data_images_common })); } catch (Exception e) { return(Json(new { success = false, message = e.Message })); } finally { dbConn.Close(); } }
public ActionResult SaveCustomerHirerachy(string CustomerID, string CustomerHirerachyIDs) { IDbConnection db = new OrmliteConnection().openConn(); try { if (string.IsNullOrEmpty(CustomerHirerachyIDs)) { db.UpdateOnly(new CustomerHirerachyDetail() { Status = false, UpdatedAt = DateTime.Now, UpdatedBy = currentUser.UserID }, onlyFields: p => new { p.Status, p.UpdatedAt, p.UpdatedBy }, where : p => p.CustomerID == CustomerID); } else { db.ExecuteNonQuery("p_CustomerHirerachyDetail_Save_By_CustomerID @CustomerID, @UserID, @CustomerHirerachyIDs", new { CustomerID = CustomerID, UserID = currentUser.UserID, CustomerHirerachyIDs = CustomerHirerachyIDs }); } return(Json(new { success = true })); } catch (Exception e) { return(Json(new { success = false, message = e.Message })); } finally { db.Close(); } }
public JsonResult GetCustomerHirerachy(string customerid) { IDbConnection db = new OrmliteConnection().openConn(); try { //select list menu cha List <CustomerHirerachy> lstFirstMenu = db.Select <CustomerHirerachy>("Status = 1 AND ParentCustomerHirerachyID ='' ").OrderBy(p => p.CustomerHirerachyIndex).ToList(); List <CustomerHirerachy> allCustomerHirerachy = db.Select <CustomerHirerachy>("Status = 1 ").OrderBy(p => p.CustomerHirerachyIndex).ToList(); var listCustomer = new List <CustomerHirerachy>(); if (!string.IsNullOrEmpty(customerid)) { listCustomer = db.SqlList <CustomerHirerachy>("p_CustomerHirerachy_Select '" + customerid + "'"); } List <CustomerHirerachyViewModel> lstMenuView = new List <CustomerHirerachyViewModel>(); foreach (CustomerHirerachy der in lstFirstMenu) { CustomerHirerachyViewModel node = new CustomerHirerachyViewModel(); node.id = der.CustomerHirerachyID; node.text = der.CustomerHirerachyName; node.items = new List <CustomerHirerachyViewModel>(); AddChildrenNode(ref node, allCustomerHirerachy, listCustomer); lstMenuView.Add(node); } return(Json(new { success = true, Data = lstMenuView })); } catch (Exception e) { return(Json(new { success = false, message = e.Message })); } finally { db.Close(); } }
public ActionResult Deactive(string data) { if (userAsset.ContainsKey("Delete") && userAsset["Delete"]) { IDbConnection dbConn = new OrmliteConnection().openConn(); try { var newdata = data.Split(','); foreach (string id in newdata) { dbConn.Delete <Master_Announcement>(p => p.AnnouncementID == Convert.ToInt32(id)); } return(Json(new { success = true, })); } catch (Exception ex) { return(Json(new { success = false, message = ex.Message })); } finally { dbConn.Close(); } } else { return(Json(new { success = false, message = "You don't have permission" })); } }
public ActionResult AddUserToGroup(int id, string data) { IDbConnection db = new OrmliteConnection().openConn(); try { // Delete All User in Role db.Delete <Auth_UserInRole>(p => p.RoleID == id); // Add User Role if (!string.IsNullOrEmpty(data)) { string[] arr = data.Split(','); foreach (string item in arr) { var detail = new Auth_UserInRole(); detail.UserID = item; detail.RoleID = id; detail.RowCreatedAt = DateTime.Now; detail.RowCreatedBy = currentUser.UserID; db.Insert <Auth_UserInRole>(detail); } } return(Json(new { success = true })); } catch (Exception e) { return(Json(new { success = false, message = e.Message })); } finally { db.Close(); } }
public ActionResult UpdateActiveStatus(int entryid, bool isactive) { IDbConnection db = new OrmliteConnection().openConn(); try { var isExist = AuthUser.GetById(entryid, null, false); isExist.isactive = isactive; isExist.updatedby = currentUser.entryid; isExist.updatedat = DateTime.Now; db.UpdateOnly(isExist, onlyFields: p => new { p.isactive, p.updatedat, p.updatedby }, where : p => p.entryid == entryid); return(Json(new { success = true })); } catch (Exception e) { return(Json(new { success = false, message = e.Message })); } finally { db.Close(); } }
public ActionResult SavePermission(int RoleID, string Action, string MenuIDs) { IDbConnection db = new OrmliteConnection().openConn(); try { if (RoleID == 0 || string.IsNullOrEmpty(Action)) { return(Json(new { success = false, message = "Có dữ liệu rỗng" })); } if (string.IsNullOrEmpty(MenuIDs)) { db.UpdateOnly(new Auth_Action() { IsAllowed = false, RowUpdatedAt = DateTime.Now, RowUpdatedBy = currentUser.UserID }, onlyFields: p => new { p.IsAllowed, p.RowUpdatedAt, p.RowUpdatedBy }, where : p => p.RoleID == RoleID && p.Action == Action); } else { db.ExecuteNonQuery("p_Auth_Action_Save_By_RoleID @RoleID, @UserID, @Action, @MenuIDs", new { RoleID = RoleID, UserID = currentUser.UserID, Action = Action, MenuIDs = MenuIDs }); } return(Json(new { success = true })); } catch (Exception e) { return(Json(new { success = false, message = e.Message })); } finally { db.Close(); } }
public ActionResult Create(DC_LG_Discountion item) { IDbConnection db = new OrmliteConnection().openConn(); try { if (!string.IsNullOrEmpty(item.DiscountionID) && !string.IsNullOrEmpty(item.DiscountionName) ) { var isExist = db.SingleOrDefault <DC_LG_Discountion>("DiscountionID={0}", item.DiscountionID); item.FromDate = item.FromDate != null ? item.FromDate : DateTime.Now; item.EndDate = item.EndDate != null ? item.EndDate : DateTime.Now; item.EndDate = item.EndDate != null ? item.EndDate : DateTime.Now; if (item.FromDate > item.EndDate) { return(Json(new { success = false, message = "Ngày kết thúc không thể lớn hơn " + item.FromDate })); } item.Note = !string.IsNullOrEmpty(item.Note) ? item.Note : ""; item.DiscountionType = !string.IsNullOrEmpty(item.DiscountionType) ? item.DiscountionType : ""; if (userAsset.ContainsKey("Insert") && userAsset["Insert"] && item.CreatedAt == null && item.CreatedBy == null) { if (isExist != null) { return(Json(new { success = false, message = "Mã chương trình chiết khấu đã tồn tại" })); } item.DiscountionName = !string.IsNullOrEmpty(item.DiscountionName) ? item.DiscountionName : ""; item.CreatedAt = DateTime.Now; item.UpdatedAt = DateTime.Now; item.CreatedBy = currentUser.UserID; db.Insert(item); return(Json(new { success = true, DiscountionID = item.DiscountionID, CreatedBy = item.CreatedBy, CreatedAt = item.CreatedAt })); } else if (userAsset.ContainsKey("Update") && userAsset["Update"] && isExist != null) { item.DiscountionName = !string.IsNullOrEmpty(item.DiscountionName) ? item.DiscountionName : ""; item.CreatedAt = item.CreatedAt; item.UpdatedAt = DateTime.Now; item.CreatedBy = currentUser.UserID; db.Update(item); return(Json(new { success = true })); } else { return(Json(new { success = false, message = "Bạn không có quyền" })); } } else { return(Json(new { success = false, message = "Chưa nhập đủ giá trị" })); } } catch (Exception e) { log.Error("DeliveryDiscountion - Create - " + e.Message); return(Json(new { success = false, message = e.Message })); } finally { db.Close(); } }
public ActionResult ReadDetail([DataSourceRequest] DataSourceRequest request, string SONumber) { var dbConn = new OrmliteConnection().openConn(); var data = dbConn.Select <SODetail>("SELECT * FROM SODetail WHERE SONumber = '" + SONumber + "' "); dbConn.Close(); return(Json(data.ToDataSourceResult(request))); }
public List <Auth_Menu> GetAllMenu() { IDbConnection db = new OrmliteConnection().openConn(); var lst = db.Select <Auth_Menu>().Where(p => p.IsVisible == true).ToList(); db.Close(); return(lst); }
public List <CustomerHirerachy> GetAllCustomerHirerachy() { IDbConnection db = new OrmliteConnection().openConn(); var lst = db.Select <CustomerHirerachy>().Where(p => p.Status == true).ToList(); db.Close(); return(lst); }
public int AddOrUpdate(int curruserid) { IDbConnection dbConn = new OrmliteConnection().openConn(); try { //var isexist = dbConn.GetByIdOrDefault<AuthUser>(10); var isexist = dbConn.FirstOrDefault <AuthUser>("entryid={0}", this.entryid); if (isexist == null) { this.isactive = true; this.createdat = DateTime.Now; this.createdby = curruserid; this.updatedat = DateTime.Now; this.updatedby = curruserid; this.lastlogin = DateTime.Now; dbConn.Insert <AuthUser>(this); long lastInsertId = dbConn.GetLastInsertId(); dbConn.Close(); this.entryid = Convert.ToInt32(lastInsertId); return(this.entryid); } else if (isexist != null) { this.isactive = isexist.isactive; this.loginprovider = isexist.loginprovider; this.logintype = isexist.logintype; this.createdat = isexist.createdat; this.createdby = isexist.createdby; this.updatedat = DateTime.Now; this.updatedby = curruserid; this.lastlogin = DateTime.Now; dbConn.Update <AuthUser>(this); dbConn.Close(); return(this.entryid); } else { return(0); } } catch (Exception ex) { return(0); } }
// // GET: /DeliveryManage/Create public ActionResult Create(DC_LG_Transporter item) { IDbConnection db = new OrmliteConnection().openConn(); try { if (//!string.IsNullOrEmpty(item.TransporterID) && !string.IsNullOrEmpty(item.TransporterName) ) { int n; var isExist = db.SingleOrDefault <DC_LG_Transporter>("TransporterID={0}", item.TransporterID); item.Weight = int.TryParse(item.Weight.ToString(), out n) ? item.Weight : 0; item.Note = !string.IsNullOrEmpty(item.Note) ? item.Note : ""; if (userAsset.ContainsKey("Insert") && userAsset["Insert"] && item.CreatedAt == null && item.CreatedBy == null) { if (isExist != null) { return(Json(new { success = false, message = "Mã đơn vị vận chuyển đã tồn tại!" })); } item.TransporterName = !string.IsNullOrEmpty(item.TransporterName) ? item.TransporterName : ""; item.CreatedAt = DateTime.Now; item.UpdatedAt = DateTime.Now; item.CreatedBy = currentUser.UserID; item.UpdatedBy = currentUser.UserID; db.Insert(item); return(Json(new { success = true, TransporterID = item.TransporterID, CreatedBy = item.CreatedBy, CreatedAt = item.CreatedAt })); } else if (userAsset.ContainsKey("Update") && userAsset["Update"] && isExist != null) { item.TransporterName = !string.IsNullOrEmpty(item.TransporterName) ? item.TransporterName : ""; item.CreatedAt = item.CreatedAt; item.UpdatedAt = DateTime.Now; item.CreatedBy = currentUser.UserID; item.UpdatedBy = currentUser.UserID; db.Update(item); return(Json(new { success = true })); } else { return(Json(new { success = false, message = "Bạn không có quyền" })); } } else { return(Json(new { success = false, message = "Chưa nhập giá trị" })); } } catch (Exception e) { log.Error("Transporter - Create - " + e.Message); return(Json(new { success = false, message = e.Message })); } finally { db.Close(); } }
public ActionResult GetBySONumber(string id) { try { var dbConn = new OrmliteConnection().openConn(); var data = dbConn.Select <SOHeader>("SELECT * FROM SOHeader WHERE SONumber ='" + id + "'").FirstOrDefault(); dbConn.Close(); return(Json(data, JsonRequestBehavior.AllowGet)); } catch (Exception e) { return(Json(new { success = false, message = e.Message })); } }
public ActionResult UpdateAction([DataSourceRequest] DataSourceRequest request, int roleid, string menuid, [Bind(Prefix = "models")] IEnumerable <Auth_Action> lst) { if (userAsset.ContainsKey("Update") && userAsset["Update"]) { IDbConnection db = new OrmliteConnection().openConn(); foreach (var item in lst) { if (item != null) { if (string.IsNullOrEmpty(item.Action)) { ModelState.AddModelError("er", "Xin nhập quyền"); return(Json(lst.ToDataSourceResult(request, ModelState))); } var isExist = db.SingleOrDefault <Auth_Action>("RoleID = {0} AND MenuID = {1} AND Action = {2}", roleid, menuid, item.Action); if (isExist != null) { try { item.RoleID = roleid; item.MenuID = menuid; item.Note = ""; item.RowCreatedAt = isExist.RowCreatedAt; item.RowCreatedBy = isExist.RowCreatedBy; item.RowUpdatedAt = DateTime.Now; item.RowUpdatedBy = currentUser.UserID; db.Update <Auth_Action>(item, p => p.RoleID == roleid && p.MenuID == menuid && p.Action == item.Action); } catch (Exception ex) { ModelState.AddModelError("er", ex.Message); return(Json(lst.ToDataSourceResult(request, ModelState))); } } else { ModelState.AddModelError("er", "Quyền không tồn tại"); return(Json(lst.ToDataSourceResult(request, ModelState))); } } } db.Close(); return(Json(lst.ToDataSourceResult(request))); } else { ModelState.AddModelError("er", "Bạn không có quyền cập nhật"); return(Json(lst.ToDataSourceResult(request, ModelState))); } }
public ActionResult DeleteDetail(string data, string SONumber) { var dbConn = new OrmliteConnection().openConn(); if (userAsset.ContainsKey("Delete") && userAsset["Delete"]) { try { string[] separators = { "@@" }; var listdata = data.Split(separators, StringSplitOptions.RemoveEmptyEntries); if (dbConn.Select <SOHeader>(s => s.SONumber == SONumber && s.Status != "Mới").Count() > 0) { return(Json(new { success = false, message = "Đơn hàng đã xác nhận nên không được xóa." })); } foreach (var item in listdata) { dbConn.Delete <SODetail>(s => s.Id == int.Parse(item)); } if (dbConn.Select <SODetail>(s => s.SONumber == SONumber).Count() <= 0) { dbConn.Delete <SOHeader>(s => s.SONumber == SONumber); } return(Json(new { success = true })); } catch (Exception e) { return(Json(new { success = false, message = e.Message })); } dbConn.Close(); } else { dbConn.Close(); return(Json(new { success = false, message = "Bạn không có quyền xóa dữ liệu." })); } }
public FileResult Export([DataSourceRequest] DataSourceRequest request) { ExcelPackage pck = new ExcelPackage(new FileInfo(Server.MapPath("~/ExportTemplate/KhachHang.xlsx"))); ExcelWorksheet ws = pck.Workbook.Worksheets["Data"]; if (userAsset["Export"]) { string whereCondition = ""; if (request.Filters.Count > 0) { whereCondition = new KendoApplyFilter().ApplyFilter(request.Filters[0]); } IDbConnection db = new OrmliteConnection().openConn(); var lstResult = db.Select <Customer>(whereCondition); int rowNum = 2; foreach (var item in lstResult) { ws.Cells["A" + rowNum].Value = item.CustomerID; ws.Cells["B" + rowNum].Value = item.CustomerName; ws.Cells["C" + rowNum].Value = item.Agent; ws.Cells["D" + rowNum].Value = item.Address; ws.Cells["E" + rowNum].Value = item.Email; ws.Cells["F" + rowNum].Value = item.Phone; ws.Cells["G" + rowNum].Value = item.Fax; ws.Cells["H" + rowNum].Value = item.Birthday; ws.Cells["I" + rowNum].Value = item.ProvinceID; ws.Cells["J" + rowNum].Value = item.DistrictID; ws.Cells["K" + rowNum].Value = item.Note; ws.Cells["L" + rowNum].Value = item.CreatedBy; ws.Cells["M" + rowNum].Value = Convert.ToDateTime(item.CreatedAt).ToString("dd/MM/yyyy"); ws.Cells["N" + rowNum].Value = item.UpdatedBy; ws.Cells["O" + rowNum].Value = Convert.ToDateTime(item.UpdatedAt).ToString("dd/MM/yyyy"); ws.Cells["P" + rowNum].Value = item.Status ? "Đang hoạt động" : "Ngưng hoạt động"; rowNum++; } db.Close(); } else { ws.Cells["A2:E2"].Merge = true; ws.Cells["A2"].Value = "You don't have permission to export data."; } MemoryStream output = new MemoryStream(); pck.SaveAs(output); return(File(output.ToArray(), //The binary data of the XLS file "application/vnd.ms-excel", //MIME type of Excel files "KhachHang" + DateTime.Now.ToString("yyyyMMdd_HHmmss") + ".xlsx")); //Suggested file name in the "Save as" dialog which will be displayed to the end user }
// // GET: /DeliveryManage/Create public ActionResult Create(DC_Reason item) { IDbConnection db = new OrmliteConnection().openConn(); try { if (!string.IsNullOrEmpty(item.ReasonID) && item.ReasonType != "None") { var isExist = db.GetByIdOrDefault <DC_Reason>(item.ReasonID); item.Description = !string.IsNullOrEmpty(item.Description) ? item.Description : ""; if (userAsset.ContainsKey("Insert") && userAsset["Insert"] && item.RowCreatedAt == null && item.RowCreatedBy == null) { if (isExist != null) { return(Json(new { success = false, message = "Mã lý do đã tồn tại!" })); } item.ReasonType = !string.IsNullOrEmpty(item.ReasonType) ? item.ReasonType : ""; item.RowCreatedAt = DateTime.Now; item.RowUpdatedAt = DateTime.Now; item.RowCreatedBy = currentUser.UserID; db.Insert <DC_Reason>(item); return(Json(new { success = true, ReasonID = item.ReasonID, RowCreatedBy = item.RowCreatedBy, RowCreatedAt = item.RowCreatedAt })); } else if (userAsset.ContainsKey("Update") && userAsset["Update"] && isExist != null) { item.ReasonType = !string.IsNullOrEmpty(item.ReasonType) ? item.ReasonType : ""; item.RowCreatedAt = item.RowCreatedAt; item.RowUpdatedAt = DateTime.Now; item.RowCreatedBy = currentUser.UserID; db.Update <DC_Reason>(item); return(Json(new { success = true })); } else { return(Json(new { success = false, message = "Bạn không có quyền" })); } } else { return(Json(new { success = false, message = "Chưa nhập giá trị" })); } } catch (Exception e) { log.Error("DeliveryUOMManage - Create - " + e.Message); return(Json(new { success = false, message = e.Message })); } finally { db.Close(); } }
public ActionResult GetByID(string id) { IDbConnection dbConn = new OrmliteConnection().openConn(); try { var data = dbConn.GetByIdOrDefault <Master_Calendar>(id); return(Json(new { success = true, data = data })); } catch (Exception e) { return(Json(new { success = false, message = e.Message })); } finally { dbConn.Close(); } }
//===============================================Import export================================================== //===============================================Openpopup====================================================== #endregion #region Form public ActionResult FormPopup(string entryid, string entrykey, string redirectbyajax) { IDbConnection dbConn = new OrmliteConnection().openConn(); var dict = new Dictionary <string, object>(); dict["activestatus"] = CustomModel.GetActiveStatus(); dbConn.Close(); //set parameter dict["redirectbyajax"] = redirectbyajax; ViewBag.entryid = string.IsNullOrEmpty(entryid) ? "0" : entryid; ViewBag.entrykey = string.IsNullOrEmpty(entrykey) ? "0" : entrykey; return(View("UserManagementForm", dict)); }
public ActionResult GetWH() { IDbConnection dbConn = new OrmliteConnection().openConn(); try { var data = dbConn.Select <WareHouse>("Select * from WareHouse"); return(Json(new { success = true, data = data })); } catch (Exception e) { return(Json(new { success = false, message = e.Message })); } finally { dbConn.Close(); } }