public static string GetDataTitle() { string TitleWeb = ""; var entity = new DB_CSEntities1(); string controllerName = HttpContext.Current.Request.RequestContext.RouteData.Values["controller"].ToString(); var menu = entity.Menu.FirstOrDefault(m => m.MenuURL == controllerName); if (menu != null) { if (!string.IsNullOrEmpty(menu.ParentId.ToString())) { int id_parent = 0; int.TryParse(menu.ParentId.ToString(), out id_parent); var parent = entity.Menu.FirstOrDefault(m => m.Id == id_parent).MenuText; TitleWeb = parent; } TitleWeb += " > " + menu.MenuText; } return(TitleWeb); }
public SystemMessage BS_CongSL_SP(int id) { SystemMessage systemMessage = new SystemMessage(); try { var db = new DB_CSEntities1(); var checkTon = db.sys_tonkho.FirstOrDefault(m => m.id_product == id && m.id_center == user.BranchId); if (checkTon == null) { systemMessage.IsSuccess = false; systemMessage.Message = SystemMessageConst.systemmessage.DataNotExisted; return(systemMessage); } checkTon.soluong = checkTon.soluong + 1; db.SaveChanges(); systemMessage.IsSuccess = true; systemMessage.Message = SystemMessageConst.systemmessage.UpdateSuccess; return(systemMessage); } catch (Exception e) { systemMessage.IsSuccess = false; systemMessage.Message = e.ToString(); return(systemMessage); } }
public SystemMessage BS_DeleteMenuInRole(int id) { SystemMessage systemMessage = new SystemMessage(); try { var db = new DB_CSEntities1(); var checkInval = db.MenuPermission.FirstOrDefault(m => m.Id == id); if (checkInval != null) { SqlParameter typeParameter = new SqlParameter("@id_menu_permission", id); db.Database.ExecuteSqlCommand("Role_DeleteMenuInRole @id_menu_permission", typeParameter); systemMessage.IsSuccess = true; systemMessage.Message = SystemMessageConst.systemmessage.DeleteSuccess; return(systemMessage); } else { systemMessage.IsSuccess = false; systemMessage.Message = SystemMessageConst.systemmessage.DataNotExisted; return(systemMessage); } } catch (Exception e) { systemMessage.IsSuccess = false; systemMessage.Message = e.ToString(); return(systemMessage); } }
public SystemMessage Delete_Select_Menu(EditSelectMenu data) { SystemMessage systemMessage = new SystemMessage(); try { var db = new DB_CSEntities1(); var checkitem = db.MenuPermission.FirstOrDefault(m => m.Id == data.id); if (checkitem == null) { systemMessage.IsSuccess = false; systemMessage.Message = SystemMessageConst.systemmessage.DataExisted; return(systemMessage); } else { SqlParameter typeParameter2 = new SqlParameter("@id", data.id); db.Database.ExecuteSqlCommand("sp_delete_menubyid @id", typeParameter2); systemMessage.IsSuccess = true; systemMessage.Message = SystemMessageConst.systemmessage.DeleteSuccess; return(systemMessage); } } catch (Exception e) { systemMessage.IsSuccess = false; systemMessage.Message = e.ToString(); return(systemMessage); } }
public SystemMessage DeleteRoleUserAndMenu(int idrole, int iduser, int idroleuser) { SystemMessage systemMessage = new SystemMessage(); try { var db = new DB_CSEntities1(); var delMenuPer = db.MenuPermission.Where(m => m.UserId == iduser && m.RoleId == idrole).ToList() .All(m => { SqlParameter typeParameter = new SqlParameter("@id", m.Id); db.Database.ExecuteSqlCommand("[sp_delete_role_user_in_menu_permisstion] @id", typeParameter); return(true); }); SqlParameter typeParameter2 = new SqlParameter("@id", idroleuser); db.Database.ExecuteSqlCommand("[sp_delete_roleuser_by_id] @id", typeParameter2); systemMessage.IsSuccess = true; systemMessage.Message = SystemMessageConst.systemmessage.DeleteSuccess; return(systemMessage); } catch (Exception e) { systemMessage.IsSuccess = false; systemMessage.Message = e.ToString(); return(systemMessage); } }
public SystemMessage BS_AddNewContact(tbl_lienhe data) { SystemMessage systemMessage = new SystemMessage(); try { var db = new DB_CSEntities1(); var check = ValidateItem(data); if (check != null) { systemMessage.IsSuccess = false; systemMessage.Message = check; return(systemMessage); } db.tbl_lienhe.Add(data); db.SaveChanges(); systemMessage.IsSuccess = true; systemMessage.Message = SystemMessageConst.systemmessage.sendcontactok; return(systemMessage); } catch (Exception e) { systemMessage.IsSuccess = false; systemMessage.Message = e.ToString(); return(systemMessage); } }
public SystemMessage BS_ChinhSua_Anh_TheoSP(int id_img, int id_product, string txt_des) { SystemMessage systemMessage = new SystemMessage(); try { var db = new DB_CSEntities1(); var checkIMG = db.img_product.FirstOrDefault(m => m.id == id_img && m.id_product == id_product); if (checkIMG == null) { systemMessage.IsSuccess = false; systemMessage.Message = SystemMessageConst.systemmessage.IMG_Not_Exit; return(systemMessage); } checkIMG.description = txt_des; db.SaveChanges(); systemMessage.IsSuccess = true; systemMessage.Message = SystemMessageConst.systemmessage.UpdateSuccess; return(systemMessage); } catch (Exception e) { systemMessage.IsSuccess = false; systemMessage.Message = e.ToString(); return(systemMessage); } }
public SystemMessage BS_XoaGiaTheoSP(int id_price, int id_product) { SystemMessage systemMessage = new SystemMessage(); try { var db = new DB_CSEntities1(); var check = db.tbl_price.FirstOrDefault(m => m.id == id_price && m.id_product == id_product); if (check != null) { db.tbl_price.Remove(check); db.SaveChanges(); systemMessage.IsSuccess = true; systemMessage.Message = SystemMessageConst.systemmessage.DeleteSuccess; } else { systemMessage.IsSuccess = true; systemMessage.Message = SystemMessageConst.systemmessage.DataNotExisted; } return(systemMessage); } catch (Exception e) { systemMessage.IsSuccess = false; systemMessage.Message = e.ToString(); return(systemMessage); } }
//public SystemMessage AddRetail(string code, string name, string price, int status, string username, string unit) //{ // SystemMessage systemMessage = new SystemMessage(); // try // { // var check = ValidateAddRetail(code, name, price, unit); // if (check != null) // { // systemMessage.IsSuccess = false; // systemMessage.Message = check; // return systemMessage; // } // var checkCode = db.sys_product.FirstOrDefault(ob => ob.code == code); // if (checkCode != null) // { // systemMessage.IsSuccess = false; // systemMessage.Message = "Mã service đã tồn tại"; // return systemMessage; // } // sys_product sysProduct = new sys_product(); // sysProduct.code = code; // sysProduct.name = name; // sysProduct.price = Int32.Parse(price); // sysProduct.isactive = status == 1 ? true : false; // sysProduct.CREATED_DATE = DateTime.Now; // sysProduct.CREATED_BY = username; // sysProduct.isappointment = false; // sysProduct.unit = unit; // sysProduct.TYPE = SystemMessageConst.Key.Product_Sale; // db.sys_product.Add(sysProduct); // db.SaveChanges(); // systemMessage.IsSuccess = true; // systemMessage.Message = SystemMessageConst.systemmessage.AddSuccess; // return systemMessage; // } // catch (Exception e) // { // systemMessage.IsSuccess = false; // systemMessage.Message = e.ToString(); // return systemMessage; // } //} //public SystemMessage EditService(int id, string code, string name, string cycle, int status, string username, byte therapystart) //{ // SystemMessage systemMessage = new SystemMessage(); // try // { // var check = ValidateAddService(code, name, cycle); // if (check != null) // { // systemMessage.IsSuccess = false; // systemMessage.Message = check; // return systemMessage; // } // var checkCode = db.sys_product.FirstOrDefault(ob => ob.code == code && ob.id != id); // if (checkCode != null) // { // systemMessage.IsSuccess = false; // systemMessage.Message = "Mã service đã tồn tại"; // return systemMessage; // } // var checkExisted = db.sys_product.FirstOrDefault(ob => ob.id == id && ob.TYPE == SystemMessageConst.Key.Product_Service); // if (checkExisted == null) // { // systemMessage.IsSuccess = false; // systemMessage.Message = "Service không tồn tại !!!"; // return systemMessage; // } // checkExisted.code = code; // checkExisted.name = name; // checkExisted.cycle = Int32.Parse(cycle); // checkExisted.isactive = status == 1 ? true : false; // checkExisted.MODIFY_DATE = DateTime.Now; // checkExisted.MODIFY_BY = username; // checkExisted.isappointment = true; // checkExisted.therapystart = therapystart; // db.SaveChanges(); // systemMessage.IsSuccess = true; // systemMessage.Message = SystemMessageConst.systemmessage.EditSuccess; // return systemMessage; // } // catch (Exception e) // { // systemMessage.IsSuccess = false; // systemMessage.Message = e.ToString(); // return systemMessage; // } //} //public SystemMessage EditRetail(int id, string code, string name, string price, int status, string username, string unit) //{ // SystemMessage systemMessage = new SystemMessage(); // try // { // var check = ValidateAddRetail(code, name, price, unit); // if (check != null) // { // systemMessage.IsSuccess = false; // systemMessage.Message = check; // return systemMessage; // } // var checkCode = db.sys_product.FirstOrDefault(ob => ob.code == code && ob.id != id); // if (checkCode != null) // { // systemMessage.IsSuccess = false; // systemMessage.Message = "Mã sản phẩm đã tồn tại"; // return systemMessage; // } // var checkExisted = db.sys_product.FirstOrDefault(ob => ob.id == id && ob.TYPE == SystemMessageConst.Key.Product_Sale); // if (checkExisted == null) // { // systemMessage.IsSuccess = false; // systemMessage.Message = "sản phẩm không tồn tại !!!"; // return systemMessage; // } // checkExisted.code = code; // checkExisted.name = name; // checkExisted.price = Int32.Parse(price); // checkExisted.isactive = status == 1 ? true : false; // checkExisted.MODIFY_DATE = DateTime.Now; // checkExisted.MODIFY_BY = username; // checkExisted.isappointment = false; // checkExisted.unit = unit; // db.SaveChanges(); // systemMessage.IsSuccess = true; // systemMessage.Message = SystemMessageConst.systemmessage.EditSuccess; // return systemMessage; // } // catch (Exception e) // { // systemMessage.IsSuccess = false; // systemMessage.Message = e.ToString(); // return systemMessage; // } //} //public SystemMessage AddProductDetail(int idproduct, int extend, int number, int price, int cycle, string code, int status, string username) //{ // SystemMessage systemMessage = new SystemMessage(); // try // { // var checkCode = db.sys_product_detail.FirstOrDefault(ob => ob.code == code); // if (checkCode != null) // { // systemMessage.IsSuccess = false; // systemMessage.Message = "Mã chi tiết sản phẩm đã tồn tại"; // return systemMessage; // } // sys_product_detail sysProductDetail = new sys_product_detail(); // sysProductDetail.name = number + extend + " Lần"; // sysProductDetail.EXTEND = extend; // sysProductDetail.NUMBER = number; // sysProductDetail.id_product = idproduct; // sysProductDetail.PRICE = price; // sysProductDetail.cycle = cycle; // sysProductDetail.code = code; // sysProductDetail.isactive = status == 1 ? true : false; // sysProductDetail.CREATED_DATE = DateTime.Now; // sysProductDetail.CREATED_BY = username; // db.sys_product_detail.Add(sysProductDetail); // db.SaveChanges(); // systemMessage.IsSuccess = true; // systemMessage.Message = SystemMessageConst.systemmessage.AddSuccess; // systemMessage.IdResult = sysProductDetail.id; // return systemMessage; // } // catch (Exception e) // { // systemMessage.IsSuccess = false; // systemMessage.Message = e.ToString(); // return systemMessage; // } //} //public SystemMessage EditProductDetail(int id, int extend, int number, int price, int cycle, string code, int status, string username) //{ // SystemMessage systemMessage = new SystemMessage(); // try // { // var checkDetail = db.sys_product_detail.FirstOrDefault(ob => ob.id == id); // if (checkDetail == null) // { // systemMessage.IsSuccess = false; // systemMessage.Message = "Chi tiết sản phẩm không tồn tại"; // return systemMessage; // } // var checkCode = db.sys_product_detail.FirstOrDefault(ob => ob.code == code && ob.id != id); // if (checkCode != null) // { // systemMessage.IsSuccess = false; // systemMessage.Message = "Mã chi tiết sản phẩm đã tồn tại"; // return systemMessage; // } // checkDetail.name = number + extend + " Lần"; // checkDetail.EXTEND = extend; // checkDetail.NUMBER = number; // checkDetail.PRICE = price; // checkDetail.cycle = cycle; // checkDetail.code = code; // checkDetail.isactive = status == 1 ? true : false; // checkDetail.CREATED_DATE = DateTime.Now; // checkDetail.CREATED_BY = username; // db.SaveChanges(); // systemMessage.IsSuccess = true; // systemMessage.Message = SystemMessageConst.systemmessage.EditSuccess; // return systemMessage; // } // catch (Exception e) // { // systemMessage.IsSuccess = false; // systemMessage.Message = e.ToString(); // return systemMessage; // } //} public SystemMessage BS_Themmoi_thongso(int id_attr, string value_attr, int id_product) { SystemMessage systemMessage = new SystemMessage(); try { var db = new DB_CSEntities1(); var checkAttr = db.sys_attributes.FirstOrDefault(m => m.id == id_attr); if (checkAttr == null) { systemMessage.IsSuccess = false; systemMessage.Message = SystemMessageConst.systemmessage.thongsokhongtontai; return(systemMessage); } var checkAttrInval = db.sys_attr_product.FirstOrDefault(m => m.id_attr == id_attr && m.id_product == id_product); if (checkAttrInval != null) { systemMessage.IsSuccess = false; systemMessage.Message = SystemMessageConst.systemmessage.tontaits; return(systemMessage); } if (string.IsNullOrEmpty(value_attr)) { systemMessage.IsSuccess = false; systemMessage.Message = "Mô tả không được để trống và < 500 ký tự"; return(systemMessage); } sys_attr_product item1 = new sys_attr_product(); item1.id_attr = id_attr; item1.id_product = id_product; item1.isactive = true; item1.descripton_attr = value_attr; db.sys_attr_product.Add(item1); db.SaveChanges(); systemMessage.IsSuccess = true; systemMessage.Message = SystemMessageConst.systemmessage.AddSuccess; return(systemMessage); } catch (Exception e) { systemMessage.IsSuccess = false; systemMessage.Message = e.ToString(); return(systemMessage); } }
public SystemMessage BS_ThemMoi_Gia_SP(int gianhap, int giaxuat, string type_price, int id_product) { SystemMessage systemMessage = new SystemMessage(); try { var db = new DB_CSEntities1(); var CheckTypePrice = db.sys_parameter.FirstOrDefault(m => m.value == type_price && m.code == "PRICE_PRODUCT"); if (CheckTypePrice == null) { systemMessage.IsSuccess = false; systemMessage.Message = SystemMessageConst.systemmessage.Type_Price_NotExit; return(systemMessage); } var checkInvail = db.tbl_price.FirstOrDefault(m => m.id_product == id_product && m.type_price == type_price && m.isactive == true); if (checkInvail != null) { systemMessage.IsSuccess = false; systemMessage.Message = SystemMessageConst.systemmessage.Price_Exit; return(systemMessage); } tbl_price item1 = new tbl_price(); item1.id_product = id_product; item1.gia_nhap = gianhap; item1.gia_xuat = giaxuat; item1.type_price = type_price; item1.isactive = true; item1.datecreate = DateTime.Now; db.tbl_price.Add(item1); db.SaveChanges(); systemMessage.IsSuccess = true; systemMessage.Message = SystemMessageConst.systemmessage.AddSuccess; return(systemMessage); } catch (Exception e) { systemMessage.IsSuccess = false; systemMessage.Message = e.ToString(); return(systemMessage); } }
public ListAccountUsingRoleById ListAccountUsingRole(string searchValue, int currPage, int recodperpage, int Id, int userid, int roleiduser, int branchId) { ListAccountUsingRoleById result = new ListAccountUsingRoleById(); List <AccountUsingRoleById> list = new List <AccountUsingRoleById>(); var db = new DB_CSEntities1(); var checkBrand = db.Branch.FirstOrDefault(m => m.Id == branchId); int statusBrand = 0; if (checkBrand.IsParent == true || roleiduser == SystemMessageConst.Role.Admin) { statusBrand = 1; } SqlConnection con = new SqlConnection(); con = Connection.Connect.GetConnect(); SqlCommand cmd = new SqlCommand("getall_account_using_role", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@Id", Id)); cmd.Parameters.Add(new SqlParameter("@statusB", statusBrand)); cmd.Parameters.Add(new SqlParameter("@idB", branchId)); cmd.Parameters.Add(new SqlParameter("@searchValue", searchValue)); cmd.Parameters.Add(new SqlParameter("@currPage", currPage)); cmd.Parameters.Add(new SqlParameter("@recodperpage", 10)); cmd.Parameters.Add("@totalCount", SqlDbType.Int).Direction = ParameterDirection.Output; cmd.Connection = con; SqlDataAdapter da = new SqlDataAdapter(cmd); DataTable dt = new DataTable(); da.Fill(dt); int total = Convert.ToInt16(cmd.Parameters["@totalCount"].Value); foreach (DataRow rowItem in dt.Rows) { AccountUsingRoleById item = new AccountUsingRoleById(); item.Id = Int32.Parse(rowItem["Id"].ToString()); item.RoleId = Int32.Parse(rowItem["RoleId"].ToString()); item.UserId = Int32.Parse(rowItem["UserId"].ToString()); //item.LevelId = Int32.Parse(rowItem["LevelId"].ToString()); item.RoleName = rowItem["RoleName"].ToString(); item.Level = Int32.Parse(rowItem["Level"].ToString()); item.UserName = rowItem["UserName"].ToString(); item.LevelName = rowItem["LevelName"].ToString(); item.Description = rowItem["Description"].ToString(); list.Add(item); } result.Data = list; result.Total = total; return(result); }
public RU_GetAllUserViewModel ListUserInSystem(string searchValue, int currPage, int recodperpage, int userid, int roleiduser, int branchId) { RU_GetAllUserViewModel result = new RU_GetAllUserViewModel(); List <lst_RU_GetAllUserViewModel> list = new List <lst_RU_GetAllUserViewModel>(); var db = new DB_CSEntities1(); var checkBrand = db.Branch.FirstOrDefault(m => m.Id == branchId); int level = db.Role.FirstOrDefault(m => m.Id == roleiduser).Level.Value; int statusBrand = 0; if (checkBrand.IsParent == true || level == 12) { statusBrand = 1; } SqlConnection con = new SqlConnection(); con = Connection.Connect.GetConnect(); SqlCommand cmd = new SqlCommand("get_all_acount_and_role", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@level", level)); cmd.Parameters.Add(new SqlParameter("@statusB", statusBrand)); cmd.Parameters.Add(new SqlParameter("@idB", branchId)); cmd.Parameters.Add(new SqlParameter("@searchValue", searchValue)); cmd.Parameters.Add(new SqlParameter("@currPage", currPage)); cmd.Parameters.Add(new SqlParameter("@recodperpage", 10)); cmd.Parameters.Add("@totalCount", SqlDbType.Int).Direction = ParameterDirection.Output; cmd.Connection = con; SqlDataAdapter da = new SqlDataAdapter(cmd); DataTable dt = new DataTable(); da.Fill(dt); int total = Convert.ToInt16(cmd.Parameters["@totalCount"].Value); foreach (DataRow rowItem in dt.Rows) { lst_RU_GetAllUserViewModel item = new lst_RU_GetAllUserViewModel(); item.Id = Int32.Parse(rowItem["Id"].ToString()); item.UserName = rowItem["UserName"].ToString(); item.Level = Int32.Parse(rowItem["Level"].ToString()); item.RoleName = rowItem["RoleName"].ToString(); item.BRANDNAME = rowItem["BRANDNAME"].ToString(); item.IDROLE = int.Parse(rowItem["IDROLE"].ToString()); item.ROLEUSERID = int.Parse(rowItem["ROLEUSERID"].ToString()); list.Add(item); } result.Data = list; result.Total = total; return(result); }
public SystemMessage AddAccount_Menu_UsingRole(MenuPermission data) { SystemMessage systemMessage = new SystemMessage(); try { var db = new DB_CSEntities1(); var checkrole = db.Role.FirstOrDefault(m => m.Id == data.RoleId && m.IsActive == true); if (checkrole == null) { systemMessage.IsSuccess = false; systemMessage.Message = SystemMessageConst.systemmessage.RoleIsNotExist; return(systemMessage); } var checkaccount = db.User.FirstOrDefault(m => m.Id == data.UserId && m.IsActive == true); if (checkaccount == null) { systemMessage.IsSuccess = false; systemMessage.Message = SystemMessageConst.systemmessage.AccountIsNotExist; return(systemMessage); } var checkroleuser = db.RoleUser.FirstOrDefault(m => m.RoleId == data.RoleId && m.UserId == data.UserId); if (checkroleuser == null) { RoleUser RU = new RoleUser(); RU.RoleId = data.RoleId; RU.UserId = (string.IsNullOrEmpty(data.UserId.ToString())) ? 0 : data.UserId.Value; db.RoleUser.Add(RU); db.SaveChanges(); systemMessage.IsSuccess = true; systemMessage.Message = SystemMessageConst.systemmessage.AddSuccess; } else { systemMessage.IsSuccess = true; systemMessage.Message = SystemMessageConst.systemmessage.RoleAndAccountExit; } return(systemMessage); } catch (Exception e) { systemMessage.IsSuccess = false; systemMessage.Message = e.ToString(); return(systemMessage); } }
public SystemMessage AddRoleSystem(Role role) { SystemMessage systemMessage = new SystemMessage(); try { var check = ValidateRoleSystem(role); if (check != null) { systemMessage.IsSuccess = false; systemMessage.Message = check; return(systemMessage); } var db = new DB_CSEntities1(); var checkisvail = db.Role.FirstOrDefault(m => m.RoleName == role.RoleName); if (checkisvail != null && checkisvail.IsActive == false) { checkisvail.IsActive = true; db.SaveChanges(); systemMessage.IsSuccess = true; systemMessage.Message = "Tên quyền đã có, khôi phục thành công thành công !"; return(systemMessage); } else if (checkisvail != null && checkisvail.IsActive == true) { systemMessage.IsSuccess = false; systemMessage.Message = "Tên quyền này đã tồn tại,vui lòng thực hiện lại !"; return(systemMessage); } else { Role item = new Role(); item.RoleName = role.RoleName; item.IsActive = role.IsActive; item.Level = role.Level; db.Role.Add(item); db.SaveChanges(); systemMessage.IsSuccess = true; systemMessage.Message = SystemMessageConst.systemmessage.AddSuccess; return(systemMessage); } } catch (Exception e) { systemMessage.IsSuccess = false; systemMessage.Message = e.ToString(); return(systemMessage); } }
public long GetBillNumer() { try { var db = new DB_CSEntities1(); var result = db.Database.SqlQuery <Number>("[GetSeqNumberOfBill]").FirstOrDefault(); return(result.number); } catch (Exception e) { return(0); } }
public Role GetRoleSystemById(int id) { try { var db = new DB_CSEntities1(); var result = db.Role.FirstOrDefault(ob => ob.Id == id); return(result); } catch (Exception e) { return(null); } }
public SystemMessage Edit_Select_Menu(EditSelectMenu data) { SystemMessage systemMessage = new SystemMessage(); try { var db = new DB_CSEntities1(); var checkitem = db.MenuPermission.FirstOrDefault(m => m.Id == data.id); if (checkitem == null) { systemMessage.IsSuccess = false; systemMessage.Message = SystemMessageConst.systemmessage.DataExisted; return(systemMessage); } else { if (data.type == "iscreate") { checkitem.IsCreate = data.gt; } else if (data.type == "isread") { checkitem.IsRead = data.gt; } else if (data.type == "isupdate") { checkitem.IsUpdate = data.gt; } else if (data.type == "isexport") { checkitem.IsExport = data.gt; } else { checkitem.IsDelete = data.gt; } db.SaveChanges(); systemMessage.IsSuccess = true; systemMessage.Message = SystemMessageConst.systemmessage.EditSuccess; } return(systemMessage); } catch (Exception e) { systemMessage.IsSuccess = false; systemMessage.Message = e.ToString(); return(systemMessage); } }
public SystemMessage BS_ChinhSua_Gia_SP(int gianhap, int giaxuat, string type_price, int id_product, int id_price) { SystemMessage systemMessage = new SystemMessage(); try { var db = new DB_CSEntities1(); var CheckTypePrice = db.sys_parameter.FirstOrDefault(m => m.value == type_price && m.code == "PRICE_PRODUCT"); if (CheckTypePrice == null) { systemMessage.IsSuccess = false; systemMessage.Message = SystemMessageConst.systemmessage.Type_Price_NotExit; return(systemMessage); } var checkPrice = db.tbl_price.FirstOrDefault(m => m.id == id_price && m.id_product == id_product); if (checkPrice == null) { systemMessage.IsSuccess = false; systemMessage.Message = SystemMessageConst.systemmessage.DataNotExisted; return(systemMessage); } checkPrice.gia_nhap = gianhap; checkPrice.gia_xuat = giaxuat; checkPrice.type_price = type_price; checkPrice.date_modifiel = DateTime.Now; db.SaveChanges(); systemMessage.IsSuccess = true; systemMessage.Message = SystemMessageConst.systemmessage.UpdateSuccess; return(systemMessage); } catch (Exception e) { systemMessage.IsSuccess = false; systemMessage.Message = e.ToString(); return(systemMessage); } }
public MvcHtmlString GetMenuBarPage(Nullable <int> ParentId) { StringBuilder sb = new StringBuilder(); DB_CSEntities1 db = new DB_CSEntities1(); //get role id and role regarding to role bind this var userId = user.Id; var RoleId = user.Roleid; var q = db.MenuPermission.Where(i => (i.Menu.IsDisplayWebsite == true) && ((i.RoleId == RoleId && i.UserId == userId) || (i.RoleId == RoleId && String.IsNullOrEmpty(i.UserId.ToString())))).OrderByDescending(ob => ob.Menu.SortOrder).ToArray(); sb.Append("<ul class=\"nav metismenu\" id=\"side-menu\" >"); sb.Append("<li class=\"active\"> <a href=\"" + MicrosoftHelper.MSHelper.GetSiteRoot() + "/Home\"> <i class=\"fa fa-dashboard\"></i> <span>Home</span> </a> </li>"); sb.Append(GetMenuBar(ParentId, q)); sb.Append("</ul>"); return(MvcHtmlString.Create(sb.ToString())); }
public SystemMessage BS_ChangeStatus(int id, int id_user, string fullname) { SystemMessage systemMessage = new SystemMessage(); DB_CSEntities1 entity = new DB_CSEntities1(); try { var checkitem = entity.tbl_lienhe.FirstOrDefault(m => m.id == id); if (checkitem == null) { systemMessage.IsSuccess = false; systemMessage.Message = SystemMessageConst.systemmessage.DataExisted; return(systemMessage); } else { if (checkitem.trangthai == 1) { systemMessage.IsSuccess = true; systemMessage.Message = "Không thể chuyển trạng thái"; } else { checkitem.trangthai = 1; checkitem.id_rep = id_user; checkitem.nguoitraloi = fullname; checkitem.ngaytraloi = DateTime.Now; entity.SaveChanges(); systemMessage.IsSuccess = true; systemMessage.Message = "Xác nhận thành công"; } return(systemMessage); } } catch (Exception e) { systemMessage.IsSuccess = false; systemMessage.Message = e.ToString(); return(systemMessage); } }
public static void ReturnCheckRuleAndSaveLog(string typeLog, bool stutus, string data) { var entity = new DB_CSEntities1(); string controllerName = HttpContext.Current.Request.RequestContext.RouteData.Values["controller"].ToString(); var menu = entity.Menu.FirstOrDefault(m => m.MenuURL == controllerName); if (menu != null) { sys_log logEntity = new sys_log(); logEntity.moduleName = controllerName; logEntity.type = typeLog; logEntity.result = stutus; logEntity.description = data; new LogApp().WriteDbLog(logEntity); } }
public SystemMessage BS_ChinhSua_Thongso_kythuat(int id_attr, int id_cf_attr, string value_attr, int id_product) { SystemMessage systemMessage = new SystemMessage(); try { var db = new DB_CSEntities1(); var checkAttr = db.sys_attr_product.FirstOrDefault(m => m.id == id_cf_attr && m.id_attr == id_attr && m.id_product == id_product); if (checkAttr == null) { systemMessage.IsSuccess = false; systemMessage.Message = SystemMessageConst.systemmessage.DataNotExisted; return(systemMessage); } if (string.IsNullOrEmpty(value_attr)) { systemMessage.IsSuccess = false; systemMessage.Message = "Mô tả không được để trống và < 500 ký tự"; return(systemMessage); } checkAttr.descripton_attr = value_attr; db.SaveChanges(); systemMessage.IsSuccess = true; systemMessage.Message = SystemMessageConst.systemmessage.UpdateSuccess; return(systemMessage); } catch (Exception e) { systemMessage.IsSuccess = false; systemMessage.Message = e.ToString(); return(systemMessage); } }
public ListRoleViewModel ListRoll(string searchValue, int currPage, int recodperpage) { ListRoleViewModel result = new ListRoleViewModel(); List <CustomerRole> list = new List <CustomerRole>(); var db = new DB_CSEntities1(); SqlConnection con = new SqlConnection(); con = Connection.Connect.GetConnect(); SqlCommand cmd = new SqlCommand("sp_role_getall", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@searchValue", searchValue)); cmd.Parameters.Add(new SqlParameter("@currPage", currPage)); cmd.Parameters.Add(new SqlParameter("@recodperpage", 10)); cmd.Parameters.Add("@totalCount", SqlDbType.Int).Direction = ParameterDirection.Output; cmd.Connection = con; SqlDataAdapter da = new SqlDataAdapter(cmd); DataTable dt = new DataTable(); da.Fill(dt); int total = Convert.ToInt16(cmd.Parameters["@totalCount"].Value); foreach (DataRow rowItem in dt.Rows) { CustomerRole item = new CustomerRole(); item.Id = Int32.Parse(rowItem["Id"].ToString()); item.RoleName = rowItem["RoleName"].ToString(); item.IsActive = bool.Parse(rowItem["IsActive"].ToString()); item.Level = Int32.Parse(rowItem["Level"].ToString()); item.LevelName = rowItem["LevelName"].ToString(); item.Description = rowItem["Description"].ToString(); list.Add(item); } result.Data = list; result.Total = total; return(result); }
public SystemMessage DeleteAccountUsingRole(int Id) { SystemMessage systemMessage = new SystemMessage(); try { var db = new DB_CSEntities1(); SqlParameter typeParameter = new SqlParameter("@idRoleUser", Id); db.Database.ExecuteSqlCommand("sp_DeleteAccountUsingRole @idRoleUser", typeParameter); systemMessage.IsSuccess = true; systemMessage.Message = SystemMessageConst.systemmessage.DeleteSuccess; return(systemMessage); } catch (Exception e) { systemMessage.IsSuccess = false; systemMessage.Message = e.ToString(); return(systemMessage); } }
public SystemMessage BS_ChangeStatusBranch(Branch data) { SystemMessage systemMessage = new SystemMessage(); DB_CSEntities1 entity = new DB_CSEntities1(); try { var checkitem = entity.Branch.FirstOrDefault(m => m.Id == data.Id); if (checkitem == null) { systemMessage.IsSuccess = false; systemMessage.Message = SystemMessageConst.systemmessage.DataExisted; return(systemMessage); } else { if (data.is_active == 1) { checkitem.is_active = 0; } else { checkitem.is_active = 1; } entity.SaveChanges(); systemMessage.IsSuccess = true; systemMessage.Message = SystemMessageConst.systemmessage.EditSuccess; } return(systemMessage); } catch (Exception e) { systemMessage.IsSuccess = false; systemMessage.Message = e.ToString(); return(systemMessage); } }
public SystemMessage BS_EditPage(tbl_gioithieu data) { SystemMessage systemMessage = new SystemMessage(); try { var db = new DB_CSEntities1(); if (string.IsNullOrEmpty(data.noidung)) { systemMessage.IsSuccess = false; systemMessage.Message = "Nội dung không được để trống"; return(systemMessage); } var checkitem = db.tbl_gioithieu.FirstOrDefault(m => m.id == data.id); if (checkitem == null) { systemMessage.IsSuccess = false; systemMessage.Message = SystemMessageConst.systemmessage.DataExisted; return(systemMessage); } checkitem.noidung = data.noidung; checkitem.tennguoisua = data.tennguoisua; checkitem.ngaychinhsua = data.ngaychinhsua; db.SaveChanges(); systemMessage.IsSuccess = true; systemMessage.Message = SystemMessageConst.systemmessage.EditSuccess; return(systemMessage); } catch (Exception e) { systemMessage.IsSuccess = false; systemMessage.Message = e.ToString(); return(systemMessage); } }
public List <ListMenuByUserLoginViewModal> ListMenuByIdUserLogin(int roleid, int userid, int branchId, int idMember, int idrole) { try { var db = new DB_CSEntities1(); List <ListMenuByUserLoginViewModal> list = new List <ListMenuByUserLoginViewModal>(); SqlConnection con = new SqlConnection(); con = Connection.Connect.GetConnect(); SqlCommand cmd = new SqlCommand("sp_getall_menu_import_to_account_member", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@roleid", roleid)); cmd.Parameters.Add(new SqlParameter("@userid", userid)); cmd.Parameters.Add(new SqlParameter("@idMember", idMember)); cmd.Parameters.Add(new SqlParameter("@idRoleMem", idrole)); cmd.Connection = con; SqlDataAdapter da = new SqlDataAdapter(cmd); DataTable dt = new DataTable(); da.Fill(dt); foreach (DataRow rowItem in dt.Rows) { int idParent = 0; ListMenuByUserLoginViewModal item = new ListMenuByUserLoginViewModal(); item.MenuId = Int32.Parse(rowItem["MenuId"].ToString()); item.MenuText = rowItem["MenuText"].ToString(); item.MenuURL = rowItem["MenuURL"].ToString(); int.TryParse(rowItem["ParentId"].ToString(), out idParent); item.ParentId = idParent; list.Add(item); } return(list); } catch (Exception e) { return(null); } }
public List <ListMenuByUserLoginViewModal> BS_Danhsachmenuthemmoivaoquyen(int roleid_login, int userid, int idrole) { try { var db = new DB_CSEntities1(); List <ListMenuByUserLoginViewModal> list = new List <ListMenuByUserLoginViewModal>(); SqlConnection con = new SqlConnection(); con = Connection.Connect.GetConnect(); SqlCommand cmd = new SqlCommand("Role_ListMenuThemMoiVaoRole", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@roleid_login", roleid_login)); cmd.Parameters.Add(new SqlParameter("@userid", userid)); cmd.Parameters.Add(new SqlParameter("@idrole_add", idrole)); cmd.Connection = con; SqlDataAdapter da = new SqlDataAdapter(cmd); DataTable dt = new DataTable(); da.Fill(dt); foreach (DataRow rowItem in dt.Rows) { int idParent = 0; ListMenuByUserLoginViewModal item = new ListMenuByUserLoginViewModal(); item.MenuId = Int32.Parse(rowItem["MenuId"].ToString()); item.MenuText = rowItem["MenuText"].ToString(); item.MenuURL = rowItem["MenuURL"].ToString(); int.TryParse(rowItem["ParentId"].ToString(), out idParent); item.ParentId = idParent; list.Add(item); } return(list); } catch (Exception e) { return(null); } }
public SystemMessage BS_XoaAnhTheoSP(int id_img, int id_product) { SystemMessage systemMessage = new SystemMessage(); try { var db = new DB_CSEntities1(); var check = db.img_product.FirstOrDefault(m => m.id == id_img && m.id_product == id_product); if (check != null) { bool deleteFile = new DeleteFileUntil().DeleteFileByPath(check.path_img); db.img_product.Remove(check); db.SaveChanges(); systemMessage.IsSuccess = true; systemMessage.Message = SystemMessageConst.systemmessage.DeleteSuccess; } else { systemMessage.IsSuccess = true; systemMessage.Message = SystemMessageConst.systemmessage.DataNotExisted; } return(systemMessage); } catch (Exception e) { systemMessage.IsSuccess = false; systemMessage.Message = e.ToString(); return(systemMessage); } }
public SystemMessage BS_NhapKho(sys_Nhap data) { SystemMessage systemMessage = new SystemMessage(); try { var db = new DB_CSEntities1(); var checkSP = db.sys_product.FirstOrDefault(m => m.id == data.id_product); if (checkSP == null) { systemMessage.IsSuccess = false; systemMessage.Message = SystemMessageConst.systemmessage.ProductNotExisted; return(systemMessage); } var checkNguon = db.sys_nguonnhap.FirstOrDefault(m => m.id == data.id_nguonnhap); if (checkNguon == null) { systemMessage.IsSuccess = false; systemMessage.Message = SystemMessageConst.systemmessage.NguonNotExit; return(systemMessage); } // cộng tồn kho var checkTonkho = db.sys_tonkho.FirstOrDefault(m => m.id_product == data.id_product && m.id_center == data.id_center); // chưa có if (checkTonkho == null) { sys_tonkho sys_ton = new sys_tonkho(); sys_ton.id_product = data.id_product; sys_ton.soluong = data.soluong; sys_ton.isactive = true; sys_ton.id_center = data.id_center; db.sys_tonkho.Add(sys_ton); } else // đã có thì cộng dồn { int sl_ton = 0; sl_ton = checkTonkho.soluong; checkTonkho.soluong = sl_ton + data.soluong; } // nhập nhóm hàng sys_Nhap nhap = new sys_Nhap(); nhap.ngaynhap = data.ngaynhap; nhap.soluong = data.soluong; nhap.nguoinhap = data.nguoinhap; nhap.id_product = data.id_product; nhap.tongtien = data.tongtien; nhap.giatrungbinh = data.giatrungbinh; nhap.trangthai = true; nhap.id_center = data.id_center; nhap.id_nguonnhap = data.id_nguonnhap; nhap.group_code_product = data.group_code_product; nhap.mota = data.mota; db.sys_Nhap.Add(nhap); db.SaveChanges(); int id_n = 0; id_n = nhap.id; // nhập chi tiết sinh code cho từng sp for (int i = 0; i < data.soluong; i++) { sys_code_product itemDetail = new sys_code_product(); itemDetail.code = data.group_code_product + "-" + GetBillNumer(); itemDetail.id_product = data.id_product; itemDetail.ngaynhap = DateTime.Now; itemDetail.trangthai = 0; // 0 chua ban, 1 da ban itemDetail.id_nhap = id_n; itemDetail.id_center = data.id_center; itemDetail.giatrungbinh = data.giatrungbinh; itemDetail.group_code = data.group_code_product; itemDetail.isactive = true; db.sys_code_product.Add(itemDetail); } db.SaveChanges(); systemMessage.IsSuccess = true; systemMessage.Message = SystemMessageConst.systemmessage.AddSuccess; return(systemMessage); } catch (Exception e) { systemMessage.IsSuccess = false; systemMessage.Message = e.ToString(); return(systemMessage); } }