public int AddOrUpdate(int curruserid) { IDbConnection dbConn = new OrmliteConnection().openConn(); try { //var isexist = dbConn.GetByIdOrDefault<AuthUser>(10); var isexist = dbConn.FirstOrDefault <AuthUser>("entryid={0}", this.entryid); if (isexist == null) { this.isactive = true; this.createdat = DateTime.Now; this.createdby = curruserid; this.updatedat = DateTime.Now; this.updatedby = curruserid; this.lastlogin = DateTime.Now; dbConn.Insert <AuthUser>(this); long lastInsertId = dbConn.GetLastInsertId(); dbConn.Close(); this.entryid = Convert.ToInt32(lastInsertId); return(this.entryid); } else if (isexist != null) { this.isactive = isexist.isactive; this.loginprovider = isexist.loginprovider; this.logintype = isexist.logintype; this.createdat = isexist.createdat; this.createdby = isexist.createdby; this.updatedat = DateTime.Now; this.updatedby = curruserid; this.lastlogin = DateTime.Now; dbConn.Update <AuthUser>(this); dbConn.Close(); return(this.entryid); } else { return(0); } } catch (Exception ex) { return(0); } }
public ActionResult Create(Master_Announcement item) { //if (form.AllKeys.Contains("TextContent")) //{ // item.TextContent = form.Get("TextContent"); //} //CHECK IS NULL VALUE if (string.IsNullOrEmpty(item.TextContent)) { item.TextContent = ""; } if (string.IsNullOrEmpty(item.HTMLContent)) { item.HTMLContent = ""; } if (string.IsNullOrEmpty(item.Title)) { item.Title = ""; } IDbConnection dbConn = new OrmliteConnection().openConn(); try { var isExist = dbConn.GetByIdOrDefault <Master_Announcement>(item.AnnouncementID); if (userAsset.ContainsKey("Insert") && userAsset["Insert"] && item.CreatedAt == null && item.CreatedBy == null) { if (isExist != null) { return(Json(new { success = false, message = "Đối tượng này đã tồn tại." })); } item.CreatedAt = DateTime.Now; item.CreatedBy = currentUser.UserID; dbConn.Insert <Master_Announcement>(item); long lastInsertId = dbConn.GetLastInsertId(); dbConn.Close(); return(Json(new { success = true, AnnouncementID = lastInsertId, createdat = item.CreatedAt, createdby = item.CreatedBy })); } else if (userAsset.ContainsKey("Update") && userAsset["Update"] && isExist != null) { item.UpdatedAt = DateTime.Now; item.CreatedBy = currentUser.UserID; dbConn.Update <Master_Announcement>(item); dbConn.Close(); return(Json(new { success = true })); } else { return(Json(new { success = false, message = "You don't have permission" })); } } catch (Exception ex) { log.Error("AD_Announcement - Create - " + ex.Message); return(Json(new { success = false, message = ex.Message })); } finally { dbConn.Close(); } }
public ActionResult Create(FormCollection form) { IDbConnection db = new OrmliteConnection().openConn(); try { if (!string.IsNullOrEmpty(form["RoleName"])) { var item = new Auth_Role(); item.RoleName = form["RoleName"]; item.IsActive = form["IsActive"] != null?Convert.ToBoolean(form["IsActive"]) : false; item.Note = !string.IsNullOrEmpty(form["Note"]) ? form["Note"] : ""; if (userAsset.ContainsKey("Insert") && userAsset["Insert"] && string.IsNullOrEmpty(form["RoleID"])) // Tạo mới { item.RowCreatedAt = DateTime.Now; item.RowCreatedBy = currentUser.UserID; db.Insert <Auth_Role>(item); long lastID = db.GetLastInsertId(); if (lastID > 0) { // Thêm Role vào Auth_Action db.ExecuteSql("EXEC p_Auth_Role_GenerateAction_By_RoleID " + lastID + "," + currentUser.UserID); } return(Json(new { success = true, insert = true, RoleID = lastID, createdat = item.RowCreatedAt, createdby = item.RowCreatedBy })); } else if (userAsset.ContainsKey("Insert") && userAsset["Insert"] && Convert.ToInt32(form["RoleID"]) > 0 && Convert.ToInt32(form["IsCopy"]) == 1) // Sao chép { item.RoleID = Convert.ToInt32(form["RoleID"]); item.RowCreatedAt = DateTime.Now; item.RowCreatedBy = currentUser.UserID; db.Insert <Auth_Role>(item); long lastID = db.GetLastInsertId(); if (lastID > 0) { // Sao chép Action RoleID đã chọn vào RoleID vừa tạo db.ExecuteSql("p_Auth_Role_CopyAction_By_RoleID " + item.RoleID + "," + lastID + "," + currentUser.UserID); } return(Json(new { success = true, insert = true, RoleID = lastID, createdat = item.RowCreatedAt, createdby = item.RowCreatedBy })); } else if (userAsset.ContainsKey("Update") && userAsset["Update"] && Convert.ToInt32(form["RoleID"]) > 0) // Cập nhật { item.RoleID = Convert.ToInt32(form["RoleID"]); item.RowCreatedAt = DateTime.Parse(form["RowCreatedAt"]); item.RowCreatedBy = form["RowCreatedBy"]; item.RowUpdatedAt = DateTime.Now; item.RowUpdatedBy = currentUser.UserID; if (item.RowCreatedBy != "system") { db.Update <Auth_Role>(item); } return(Json(new { success = true, RoleID = item.RoleID })); } 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("HOAdminAuthRole - Create - " + e.Message); return(Json(new { success = false, message = e.Message })); } finally { db.Close(); } }
public string CreateProduct(Merchant_Product product, Merchant_Product_Hierarchy hierarchy, List <Merchant_Product_Image> listimage, List <Merchant_Product_Property> listproperty, string connectstring) { using (var db = new OrmliteConnection().openConn(connectstring)) { //using (var dbTrans = db.OpenTransaction(IsolationLevel.ReadCommitted)) { try { if (!string.IsNullOrEmpty(product.ma_san_pham)) { var Checkproduct = db.FirstOrDefault <Merchant_Product>(s => s.ma_san_pham == product.ma_san_pham); if (Checkproduct != null) { return(UpdateProduct(product, hierarchy, listimage, listproperty, connectstring)); } } if (product.id == 0 && !String.IsNullOrEmpty(product.nguoi_tao) && !String.IsNullOrEmpty(product.ma_gian_hang)) { var lastId = db.FirstOrDefault <Merchant_Product>("SELECT TOP 1 * FROM Merchant_Product ORDER BY ma_san_pham DESC"); if (lastId != null && lastId.ma_san_pham.Contains("SP")) { var nextNo = Int32.Parse(lastId.ma_san_pham.Substring(2, 7)) + 1; product.ma_san_pham = "SP" + String.Format("{0:0000000}", nextNo); } else { product.ma_san_pham = "SP" + "0000001"; } product.ma_loai_san_pham = !string.IsNullOrEmpty(product.ma_loai_san_pham) ? product.ma_loai_san_pham : ""; product.part_no = !string.IsNullOrEmpty(product.part_no) ? product.part_no : ""; product.mo_ta = !string.IsNullOrEmpty(product.mo_ta) ? product.mo_ta : ""; product.noi_dung = !string.IsNullOrEmpty(product.noi_dung) ? product.noi_dung : ""; product.tu_khoa = !string.IsNullOrEmpty(product.tu_khoa) ? product.tu_khoa : ""; product.tag = !string.IsNullOrEmpty(product.tag) ? product.tag : ""; product.slug = !string.IsNullOrEmpty(product.slug) ? product.slug : ""; product.xuat_xu = !string.IsNullOrEmpty(product.xuat_xu) ? product.xuat_xu : ""; product.model = !string.IsNullOrEmpty(product.model) ? product.model : ""; product.trang_thai = AllConstant.trang_thai.DANG_SU_DUNG; //giá trị đang hoạt động product.trang_thai_duyet = AllConstant.trang_thai_duyet.CHUA_DUYET; //giá trị chờ duyệt product.trang_thai_xuat_ban = AllConstant.trang_thai_xuat_ban.CHUA_XUAT_BAN; //giá trị chờ xuất bản product.nguoi_xuat_ban = product.nguoi_duyet = ""; product.ngay_xuat_ban = product.ngay_duyet = product.ngay_cap_nhat = DateTime.Parse("1900-01-01"); product.ngay_tao = DateTime.Now; db.Insert(product); Int64 productId = (Int64)db.GetLastInsertId(); //List<SqlParameter> param = new List<SqlParameter>(); //param.Add(new SqlParameter("@id", productId)); //new SqlHelper().ExecuteNoneQuery("p_UpdateSlugForMerchantProduct", param); if (hierarchy.id == 0) { hierarchy.ma_san_pham = product.ma_san_pham; hierarchy.ma_gian_hang = product.ma_gian_hang; hierarchy.ngay_tao = DateTime.Now; hierarchy.nguoi_tao = product.nguoi_tao; hierarchy.ngay_cap_nhat = DateTime.Parse("1900-01-01"); hierarchy.trang_thai = AllConstant.trang_thai.DANG_SU_DUNG; // Giá trị đang hoạt động db.Insert(hierarchy); if (listimage != null) { foreach (Merchant_Product_Image item in listimage) { if (item.id == 0) { item.ma_san_pham = product.ma_san_pham; item.ma_gian_hang = product.ma_gian_hang; item.ngay_tao = DateTime.Now; item.nguoi_tao = product.nguoi_tao; db.Insert(item); } else { //dbTrans.Rollback(); return("Lỗi khi tạo thumbnail hình ảnh"); } } } if (listproperty != null) { foreach (Merchant_Product_Property item in listproperty) { if (item.id == 0) { item.ma_gian_hang = product.ma_gian_hang; item.ma_san_pham = product.ma_san_pham; item.ngay_tao = DateTime.Now; item.nguoi_tao = product.nguoi_tao; item.ngay_cap_nhat = DateTime.Parse("1900-01-01"); db.Insert(item); } else { //dbTrans.Rollback(); return("Lỗi khi tạo thuộc tính"); } } } //dbTrans.Commit(); new Merchant_Product_Warehouse_DAO().CreateUpdate(product.ma_san_pham, product.ma_gian_hang, product.nguoi_tao, connectstring); return("true@@" + product.ma_san_pham); } else { // dbTrans.Rollback(); return("Lỗi khi tạo ngành hàng"); } } else { // dbTrans.Rollback(); return("Lỗi khi tạo sản phẩm"); } } catch (Exception ex) { //dbTrans.Rollback(); return("Lỗi thao tác dữ liệu"); } } } }