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(); }
}