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