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