public string CreateUpdate(string ma_kho, string ma_gian_hang, string username, string connectionString = "")
{
using (var db = connectionString != "" ? new OrmliteConnection().openConn(connectionString) : new OrmliteConnection().openConn())
{
using (var dbTrans = db.OpenTransaction(IsolationLevel.ReadCommitted))
{
try
{
var exist = db.FirstOrDefault <Merchant_Warehouse>("ma_kho = {0}", ma_kho);
Merchant_Warehouse warehouse = new Merchant_Warehouse();
warehouse.ngay_tao = DateTime.Now;
warehouse.nguoi_tao = username;
warehouse.ma_kho = ma_kho;
warehouse.ma_gian_hang = ma_gian_hang;
dbTrans.Commit();
return("true");
}
catch (Exception e)
{
dbTrans.Rollback();
return(e.Message.ToString());
}
}
}
}
public ActionResult CreateUpdate(Merchant_Warehouse data)
{
try
{
using (var dbConn = MCC.Helpers.OrmliteConnection.openConn())
{
if (data.id > 0)
{
if (accessDetail != null && (accessDetail.access["all"] || accessDetail.access["update"]))
{
var exist_ma_kho = dbConn.Scalar <bool>("SELECT TOP 1 1 FROM Merchant_Warehouse WHERE ma_kho = '" + data.ma_kho + "' AND id <>" + data.id);
if (exist_ma_kho)
{
return(Json(new { success = false, error = "Mã kho đã tồn tại" }));
}
var exist_ten_kho = dbConn.Scalar <bool>("SELECT TOP 1 1 FROM Merchant_Warehouse WHERE ten_kho = '" + data.ten_kho + "' AND id <>" + data.id);
if (exist_ten_kho)
{
return(Json(new { success = false, error = "Tên kho đã tồn tại" }));
}
data.ngay_cap_nhat = DateTime.Now;
data.nguoi_cap_nhat = User.Identity.Name;
dbConn.UpdateOnly(data,
onlyFields: p =>
new
{
p.ma_kho,
p.ten_kho,
p.dia_chi,
p.phone,
p.fax,
p.email,
p.thu_kho,
p.ghi_chu,
p.trang_thai,
p.ngay_cap_nhat,
p.nguoi_cap_nhat
},
where : p => p.id == data.id);
}
else
{
return(Json(new { success = false, error = "Không có quyền chỉnh sửa" }));
}
}
else
{
if (accessDetail != null && (accessDetail.access["all"] || accessDetail.access["create"]))
{
var exist_ma_kho = dbConn.Scalar <bool>("SELECT TOP 1 1 FROM Merchant_Warehouse WHERE ma_kho = '" + data.ma_kho + "'");
if (exist_ma_kho)
{
return(Json(new { success = false, error = "Mã kho đã tồn tại" }));
}
var exist_ten_kho = dbConn.Scalar <bool>("SELECT TOP 1 1 FROM Merchant_Warehouse WHERE ten_kho = '" + data.ten_kho + "'");
if (exist_ten_kho)
{
return(Json(new { success = false, error = "Tên kho đã tồn tại" }));
}
data.ngay_tao = DateTime.Now;
data.nguoi_tao = User.Identity.Name;
data.ma_gian_hang = currentUser.ma_gian_hang;
dbConn.Insert(data);
int Id = (int)dbConn.GetLastInsertId();
data.id = Id;
}
else
{
return(Json(new { success = false, error = "Không có quyền tạo" }));
}
}
}
return(Json(new { success = true, data = data }));
}
catch (Exception e)
{
return(Json(new { success = false, error = e.Message }));
}
}
