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