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 string ChangeStatus(string[] ids, string connectionString, string Username, string status) { using (var db = new OrmliteConnection().openConn(connectionString)) { try { foreach (var id in ids) { var checkID = db.SingleOrDefault <Merchant_Warehouse>("id={0}", id); if (checkID != null) { checkID.trang_thai = (status == AllConstant.trang_thai.DANG_SU_DUNG) ? AllConstant.trang_thai.DANG_SU_DUNG : AllConstant.trang_thai.KHONG_SU_DUNG; checkID.nguoi_cap_nhat = Username; checkID.ngay_cap_nhat = DateTime.Now; db.UpdateOnly(checkID, onlyFields: p => new { p.trang_thai, p.nguoi_cap_nhat, p.ngay_cap_nhat }, where : p => p.id == checkID.id); } } return("true"); } catch (Exception e) { return(e.Message.ToString()); } } }
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(); } }
//Chuyển trạng thái sản phẩm sang trạng thái ngưng sử dụng public string ChangeStatus(string[] ids, string connectionString, string Username, string status) { using (var db = new OrmliteConnection().openConn(connectionString)) { try { foreach (var id in ids) { var checkID = db.SingleOrDefault <Merchant_Product>("id={0}", id); if (checkID != null) { checkID.trang_thai = (status == AllConstant.trang_thai.DANG_SU_DUNG) ? AllConstant.trang_thai.DANG_SU_DUNG : AllConstant.trang_thai.KHONG_SU_DUNG; checkID.trang_thai_duyet = AllConstant.trang_thai_duyet.CHUA_DUYET; checkID.trang_thai_xuat_ban = AllConstant.trang_thai_xuat_ban.CHUA_XUAT_BAN; checkID.nguoi_cap_nhat = Username; checkID.ngay_cap_nhat = DateTime.Now; db.UpdateOnly(checkID, onlyFields: p => new { p.trang_thai, p.trang_thai_xuat_ban, p.trang_thai_duyet, p.nguoi_cap_nhat, p.ngay_cap_nhat }, where : p => p.id == checkID.id); string rs = SyncToMySQL(id, connectionString); if (rs != "true") { return("Lỗi đồng bộ!"); } } } return("true"); } catch (Exception e) { return(e.Message.ToString()); } } }
public string ChangeStatusApproval(string[] ids, string connectionString, string Username) { using (var db = new OrmliteConnection().openConn(connectionString)) { try { foreach (var id in ids) { var checkID = db.SingleOrDefault <Merchant_Info>("id={0}", id); if (checkID != null) { checkID.trang_thai_duyet = (checkID.trang_thai_duyet == AllConstant.trang_thai_duyet.DA_DUYET) ? AllConstant.trang_thai_duyet.TU_CHOI : AllConstant.trang_thai_duyet.DA_DUYET; checkID.nguoi_duyet = checkID.nguoi_cap_nhat = Username; checkID.ngay_duyet = checkID.ngay_cap_nhat = DateTime.Now; db.UpdateOnly(checkID, onlyFields: p => new { p.trang_thai_duyet, p.nguoi_duyet, p.ngay_duyet, p.nguoi_cap_nhat, p.ngay_cap_nhat }, where : p => p.id == checkID.id); string rs = SyncToMySQL(id, connectionString); if (rs != "true") { return("Lỗi đồng bộ!"); } } } return("true"); } catch (Exception e) { return(e.Message.ToString()); } } }
public string ChangeStatus(string ma_don_hang, string trang_thai_don_hang, string Username, string connectstring) { using (var dbConn = new OrmliteConnection().openConn(connectstring)) { { try { var exist = dbConn.FirstOrDefault <Merchant_OrderHeader>("ma_don_hang={0}".Params(ma_don_hang)); if (exist != null) { if (exist.trang_thai_don_hang == "New" && trang_thai_don_hang == "Confirm") { exist.trang_thai_don_hang = "Confirm"; } if (exist.trang_thai_don_hang == "Confirm" && trang_thai_don_hang == "Shipping") { exist.trang_thai_don_hang = "Shipping"; } if (exist.trang_thai_don_hang == "Shipping" && trang_thai_don_hang == "POD") { exist.trang_thai_don_hang = "POD"; } if (exist.trang_thai_don_hang == "POD" && trang_thai_don_hang == "Completed") { exist.trang_thai_don_hang = "Completed"; } exist.ngay_cap_nhat = DateTime.Now; exist.nguoi_cap_nhat = Username; dbConn.UpdateOnly(exist, onlyFields: p => new { p.trang_thai_don_hang, p.nguoi_cap_nhat, p.ngay_cap_nhat }, where : p => p.ma_don_hang == exist.ma_don_hang); if (exist.trang_thai_don_hang == "Confirm") { List <SqlParameter> param = new List <SqlParameter>(); //Update Merchant_Product_Warehouse param.Add(new SqlParameter("@ma_don_hang", exist.ma_don_hang)); new SqlHelper(connectstring).ExecuteQuery("p_Update_Merchant_Product_Warehouse_Order", param); } using (MySqlConnection con = new MySqlConnection(AppConfigs.FEConnectionString)) { con.Open(); string sqlOrder = @"update order_merchant set trang_thai_don_hang={0}, ngay_cap_nhat={1}, nguoi_cap_nhat={2} where ma_don_hang={3} and ma_gian_hang={4}".Params(exist.trang_thai_don_hang, exist.ngay_cap_nhat, exist.nguoi_cap_nhat, exist.ma_don_hang_cha, exist.ma_gian_hang); using (MySql.Data.MySqlClient.MySqlTransaction trans = con.BeginTransaction()) { try { using (MySqlCommand cmd = new MySqlCommand(sqlOrder, con, trans)) { cmd.ExecuteNonQuery(); } trans.Commit(); } catch (Exception e) { trans.Rollback(); return(e.Message.ToString()); } } } } } catch (Exception e) { return("false@@" + e.Message); } } } return("true@@" + trang_thai_don_hang); }
public string Cancel(string ma_don_hang, string ly_do_huy, string Username, string connectstring) { using (var dbConn = new OrmliteConnection().openConn(connectstring)) { { try { var exist = dbConn.FirstOrDefault <Merchant_OrderHeader>("ma_don_hang={0}".Params(ma_don_hang)); if (exist != null) { if (exist.trang_thai_don_hang == "New" || exist.trang_thai_don_hang == "Confirm" || exist.trang_thai_don_hang == "Shipping") { exist.trang_thai_don_hang = "Cancel"; exist.ly_do_huy = ly_do_huy; } else { return("false@@" + "Không thể hủy"); } exist.ngay_cap_nhat = DateTime.Now; exist.nguoi_cap_nhat = Username; dbConn.UpdateOnly(exist, onlyFields: p => new { p.trang_thai_don_hang, p.ly_do_huy, p.nguoi_cap_nhat, p.ngay_cap_nhat }, where : p => p.ma_don_hang == exist.ma_don_hang); using (MySqlConnection con = new MySqlConnection(AppConfigs.FEConnectionString)) { con.Open(); string sqlOrder = @"update order_merchant set trang_thai_don_hang={0} ngay_cap_nhat={1} nguoi_cap_nhat={2} where ma_don_hang={3} and ma_gian_hang={4}".Params(exist.trang_thai_don_hang, exist.ngay_cap_nhat, exist.nguoi_cap_nhat, exist.ma_don_hang_cha, exist.ma_gian_hang); using (MySql.Data.MySqlClient.MySqlTransaction trans = con.BeginTransaction()) { try { using (MySqlCommand cmd = new MySqlCommand(sqlOrder, con, trans)) { cmd.ExecuteNonQuery(); } trans.Commit(); } catch (Exception e) { trans.Rollback(); return(e.Message.ToString()); } } } } } catch (Exception e) { return("false@@" + e.Message); } } } return("true@@" + ly_do_huy); }