public ActionResult Create(DC_AD_Printer item) { IDbConnection db = new OrmliteConnection().openConn(); try { if (!string.IsNullOrEmpty(item.PrinterName) ) { var isExist = db.SingleOrDefault<DC_AD_Printer>("PrinterID={0}", item.PrinterID); item.Note = !string.IsNullOrEmpty(item.Note) ? item.Note : ""; item.DfltAddress = !string.IsNullOrEmpty(item.DfltAddress) ? item.DfltAddress : ""; item.Phone = !string.IsNullOrEmpty(item.Phone) ? item.Phone : ""; item.Email = !string.IsNullOrEmpty(item.Email) ? item.Email : ""; item.WHAddress = !string.IsNullOrEmpty(item.WHAddress) ? item.WHAddress : ""; item.ShippingAddress = !string.IsNullOrEmpty(item.ShippingAddress) ? item.ShippingAddress : ""; item.ContactPhone = !string.IsNullOrEmpty(item.ContactPhone) ? item.ContactPhone : ""; item.ContactName = !string.IsNullOrEmpty(item.ContactName) ? item.ContactName : ""; if (userAsset.ContainsKey("Insert") && userAsset["Insert"] && item.CreatedAt == null && item.CreatedBy == null) { if (isExist != null) return Json(new { success = false, message = "Mã máy in đã tồn tại" }); string id = ""; var checkID = db.SingleOrDefault<DC_AD_Printer>("SELECT PrinterID, Id FROM dbo.DC_AD_Printer ORDER BY Id DESC"); if (checkID != null) { var nextNo = int.Parse(checkID.PrinterID.Substring(2, checkID.PrinterID.Length - 2)) + 1; id = "PR" + String.Format("{0:00000000}", nextNo); } else { id = "PR00000001"; } item.PrinterID = id; item.PrinterName = !string.IsNullOrEmpty(item.PrinterName) ? item.PrinterName : ""; item.CreatedAt = DateTime.Now; item.UpdatedAt = DateTime.Now; item.CreatedBy = currentUser.UserID; item.UpdatedBy = currentUser.UserID; db.Insert(item); return Json(new { success = true, PrinterID = item.PrinterID, CreatedBy = item.CreatedBy, CreatedAt = item.CreatedAt }); } else if (userAsset.ContainsKey("Update") && userAsset["Update"] && isExist != null) { item.PrinterName = !string.IsNullOrEmpty(item.PrinterName) ? item.PrinterName : ""; 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("Printer - Create - " + e.Message); return Json(new { success = false, message = e.Message }); } finally { db.Close(); } }
public ActionResult Create(DC_AD_Printer item) { IDbConnection db = new OrmliteConnection().openConn(); try { if (!string.IsNullOrEmpty(item.PrinterName) ) { var isExist = db.SingleOrDefault <DC_AD_Printer>("PrinterID={0}", item.PrinterID); item.Note = !string.IsNullOrEmpty(item.Note) ? item.Note : ""; item.DfltAddress = !string.IsNullOrEmpty(item.DfltAddress) ? item.DfltAddress : ""; item.Phone = !string.IsNullOrEmpty(item.Phone) ? item.Phone : ""; item.Email = !string.IsNullOrEmpty(item.Email) ? item.Email : ""; item.WHAddress = !string.IsNullOrEmpty(item.WHAddress) ? item.WHAddress : ""; item.ShippingAddress = !string.IsNullOrEmpty(item.ShippingAddress) ? item.ShippingAddress : ""; item.ContactPhone = !string.IsNullOrEmpty(item.ContactPhone) ? item.ContactPhone : ""; item.ContactName = !string.IsNullOrEmpty(item.ContactName) ? item.ContactName : ""; if (userAsset.ContainsKey("Insert") && userAsset["Insert"] && item.CreatedAt == null && item.CreatedBy == null) { if (isExist != null) { return(Json(new { success = false, message = "Mã máy in đã tồn tại" })); } string id = ""; var checkID = db.SingleOrDefault <DC_AD_Printer>("SELECT PrinterID, Id FROM dbo.DC_AD_Printer ORDER BY Id DESC"); if (checkID != null) { var nextNo = int.Parse(checkID.PrinterID.Substring(2, checkID.PrinterID.Length - 2)) + 1; id = "PR" + String.Format("{0:00000000}", nextNo); } else { id = "PR00000001"; } item.PrinterID = id; item.PrinterName = !string.IsNullOrEmpty(item.PrinterName) ? item.PrinterName : ""; item.CreatedAt = DateTime.Now; item.UpdatedAt = DateTime.Now; item.CreatedBy = currentUser.UserID; item.UpdatedBy = currentUser.UserID; db.Insert(item); return(Json(new { success = true, PrinterID = item.PrinterID, CreatedBy = item.CreatedBy, CreatedAt = item.CreatedAt })); } else if (userAsset.ContainsKey("Update") && userAsset["Update"] && isExist != null) { item.PrinterName = !string.IsNullOrEmpty(item.PrinterName) ? item.PrinterName : ""; 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("Printer - Create - " + e.Message); return(Json(new { success = false, message = e.Message })); } finally { db.Close(); } }