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