public ActionResult _AddCategory(string fullName, string note, bool status = false)
{
// kiểm tra quyền thêm
var sys = CheckActiveMenu.ReturnActive(SystemMessageConst.TypeAction.Addnew);
if (sys.IsSuccess == false)
{
return(Json(new { result = sys }, JsonRequestBehavior.AllowGet));
}
var db = new ManagerCategoryBusiness();
tbl_LoaiSP serviceCustomer = new tbl_LoaiSP();
serviceCustomer.category_name = fullName;
serviceCustomer.description = note;
serviceCustomer.isactive = status;
var result = db.AddCategory(serviceCustomer);
// luu log - thêm mới
CheckRuleAndSaveLog.ReturnCheckRuleAndSaveLog(DbLogType.Create.ToString(), result.IsSuccess, JsonConvert.SerializeObject(new { data = serviceCustomer }, Newtonsoft.Json.Formatting.Indented, new JsonSerializerSettings {
NullValueHandling = NullValueHandling.Ignore
}));
return(Json(new { result }, JsonRequestBehavior.AllowGet));
}
public ActionResult _EditBranch(int id = 0, string name = "", string add = "", string phone = "", string tax = "", string brandcode = "", string shortname = "", string city = "", bool status = false)
{
// kiểm tra quyền thêm sửa xóa của từng menu , nhớ truyền type tương ứng
var sys = CheckActiveMenu.ReturnActive(SystemMessageConst.TypeAction.Update);
if (sys.IsSuccess == false)
{
return(Json(new { result = sys }, JsonRequestBehavior.AllowGet));
}
var db = new BranchBusiness();
Branch item = new Branch();
item.Id = id;
item.Name = name;
item.AddressName = add;
item.Phone = phone;
item.Tax_Number = tax;
item.Branch_code = brandcode;
item.ShortName = shortname;
item.City = city;
item.is_active = Convert.ToInt32(status);
var result = db.BS_EditBrandch(item);
// luu log - sửa
CheckRuleAndSaveLog.ReturnCheckRuleAndSaveLog(DbLogType.Update.ToString(), result.IsSuccess, JsonConvert.SerializeObject(new { data = item }, Newtonsoft.Json.Formatting.Indented, new JsonSerializerSettings {
NullValueHandling = NullValueHandling.Ignore
}));
return(Json(new { result }, JsonRequestBehavior.AllowGet));
}
public ActionResult _EditPage(FormCollection formCollection)
{
// kiểm tra quyền thêm sửa xóa của từng menu , nhớ truyền type tương ứng
var sys = CheckActiveMenu.ReturnActive(SystemMessageConst.TypeAction.Update);
if (sys.IsSuccess == false)
{
return(Json(new { result = sys }, JsonRequestBehavior.AllowGet));
}
var db = new gioithieuwebsiteBusiness();
tbl_gioithieu item = new tbl_gioithieu();
item.id = int.Parse(formCollection.Get("id"));
item.noidung = formCollection.Get("noidung");
item.ngaychinhsua = DateTime.Now;
item.tennguoisua = user.FullName;
var result = db.BS_EditPage(item);
// luu log - sửa
CheckRuleAndSaveLog.ReturnCheckRuleAndSaveLog(DbLogType.Update.ToString(), result.IsSuccess, JsonConvert.SerializeObject(new { data = item }, Newtonsoft.Json.Formatting.Indented, new JsonSerializerSettings {
NullValueHandling = NullValueHandling.Ignore
}));
return(Json(new { result }, JsonRequestBehavior.AllowGet));
}
public ActionResult _AddMenuIntoAccount(int idAccount, int idRole, int idMenu, string IsRead, string IsCreate, string IsUpdate, string IsDelete, string IsExport)
{
// kiểm tra quyền thêm sửa xóa của từng menu , nhớ truyền type tương ứng
var sys = CheckActiveMenu.ReturnActive(SystemMessageConst.TypeAction.Addnew);
if (sys.IsSuccess == false)
{
return(Json(new { result = sys }, JsonRequestBehavior.AllowGet));
}
var db = new RoleUserBusiness();
MenuPermission item = new MenuPermission();
item.MenuId = idMenu;
item.RoleId = idRole;
item.UserId = idAccount;
item.IsRead = bool.Parse(IsRead);
item.IsCreate = bool.Parse(IsCreate);
item.IsUpdate = bool.Parse(IsUpdate);
item.IsDelete = bool.Parse(IsDelete);
item.IsExport = bool.Parse(IsExport);
var result = db.AddMenuIntoAccountRole(item);
return(Json(new { result }, JsonRequestBehavior.AllowGet));
}
public ActionResult _AddNguonnhap(string fullName, string address, string phone, string code, string note, int branchId = 0)
{
// kiểm tra quyền thêm
var sys = CheckActiveMenu.ReturnActive(SystemMessageConst.TypeAction.Addnew);
if (sys.IsSuccess == false)
{
return(Json(new { result = sys }, JsonRequestBehavior.AllowGet));
}
var db = new quanlynguonnhapBusiness();
sys_nguonnhap serviceCustomer = new sys_nguonnhap();
serviceCustomer.tennguon = fullName;
serviceCustomer.diachi = address;
serviceCustomer.sdt = phone;
serviceCustomer.code = code;
serviceCustomer.description = note;
serviceCustomer.isactive = true;
serviceCustomer.id_center = branchId;
var result = db.AddNguonnhap(serviceCustomer);
// luu log - thêm mới
CheckRuleAndSaveLog.ReturnCheckRuleAndSaveLog(DbLogType.Create.ToString(), result.IsSuccess, JsonConvert.SerializeObject(new { data = serviceCustomer }, Newtonsoft.Json.Formatting.Indented, new JsonSerializerSettings {
NullValueHandling = NullValueHandling.Ignore
}));
return(Json(new { result }, JsonRequestBehavior.AllowGet));
}
public ActionResult _AddNewRoleUserMenu()
{
// kiểm tra quyền thêm sửa xóa của từng menu , nhớ truyền type tương ứng
var sys = CheckActiveMenu.ReturnActive(SystemMessageConst.TypeAction.Addnew);
if (sys.IsSuccess == false)
{
return(Json(new { result = sys }, JsonRequestBehavior.AllowGet));
}
int userid = user.Id;
int roleid = user.Roleid;
int branchId = user.BranchId;
List <int> lstAccount = (List <int>)Newtonsoft.Json.JsonConvert.DeserializeObject(HttpContext.Request["listAccount"], typeof(List <int>));
List <int> listMenu = (List <int>)Newtonsoft.Json.JsonConvert.DeserializeObject(HttpContext.Request["listMenu"], typeof(List <int>));
List <string> lstOptionMenu = (List <string>)Newtonsoft.Json.JsonConvert.DeserializeObject(HttpContext.Request["lstOptionMenu"], typeof(List <string>));
bool statusCheckAllAcount = false;
int RoleId = 0;
int.TryParse(HttpContext.Request["roleId"], out RoleId);
bool.TryParse(HttpContext.Request["statusCheckAllAcount"], out statusCheckAllAcount);
var db = new RoleUserBusiness();
var result = db._AddNewRoleUserMenu(lstAccount, listMenu, lstOptionMenu, RoleId, statusCheckAllAcount);
return(Json(new { result }, JsonRequestBehavior.AllowGet));
}
public ActionResult ChangeStatusBranch(int id, int status = 0)
{
// kiểm tra quyền thêm sửa xóa của từng menu , nhớ truyền type tương ứng
var sys = CheckActiveMenu.ReturnActive(SystemMessageConst.TypeAction.Update);
if (sys.IsSuccess == false)
{
return(Json(new { result = sys }, JsonRequestBehavior.AllowGet));
}
var db = new BranchBusiness();
Branch item = new Branch();
item.Id = id;
item.is_active = status;
var result = db.BS_ChangeStatusBranch(item);
// luu log - sửa
CheckRuleAndSaveLog.ReturnCheckRuleAndSaveLog(DbLogType.Update.ToString(), result.IsSuccess, JsonConvert.SerializeObject(new { data = item }, Newtonsoft.Json.Formatting.Indented, new JsonSerializerSettings {
NullValueHandling = NullValueHandling.Ignore
}));
return(Json(new { result }, JsonRequestBehavior.AllowGet));
}
public ActionResult _EditUnit(string fullName, string note, int branchId = 0, int id = 0)
{
// kiểm tra quyền thêm sửa
var sys = CheckActiveMenu.ReturnActive(SystemMessageConst.TypeAction.Update);
if (sys.IsSuccess == false)
{
return(Json(new { result = sys }, JsonRequestBehavior.AllowGet));
}
var db = new quanlydonviBusiness();
tbl_Unit serviceCustomer = new tbl_Unit();
serviceCustomer.unit_name = fullName;
serviceCustomer.description = note;
serviceCustomer.id_center = branchId;
serviceCustomer.id = id;
var result = db.EditUnit(serviceCustomer);
CheckRuleAndSaveLog.ReturnCheckRuleAndSaveLog(DbLogType.Update.ToString(), result.IsSuccess, JsonConvert.SerializeObject(new { log = "CapNhatThongTinDVT", newtdata = serviceCustomer }, Newtonsoft.Json.Formatting.Indented, new JsonSerializerSettings {
NullValueHandling = NullValueHandling.Ignore
}));
return(Json(new { result }, JsonRequestBehavior.AllowGet));
}
public ActionResult _ThemmoiSP(int id_product = 0, int id = 0)
{
// kiểm tra quyền thêm
var sys = CheckActiveMenu.ReturnActive(SystemMessageConst.TypeAction.Addnew);
if (sys.IsSuccess == false)
{
return(Json(new { result = sys }, JsonRequestBehavior.AllowGet));
}
var db = new ManagerCategoryBusiness();
tbl_detail_category item = new tbl_detail_category();
item.id_product = id_product;
item.id_category = id;
item.isactive = true;
var result = db.AddProductToCategory(item);
// luu log - thêm mới
CheckRuleAndSaveLog.ReturnCheckRuleAndSaveLog(DbLogType.Create.ToString(), result.IsSuccess, JsonConvert.SerializeObject(new { data = item }, Newtonsoft.Json.Formatting.Indented, new JsonSerializerSettings {
NullValueHandling = NullValueHandling.Ignore
}));
return(Json(new { result }, JsonRequestBehavior.AllowGet));
}
public ActionResult _AddCustomer(string fullName, string cmt, string birth, string address, string phone, string note, int branchId = 0)
{
// kiểm tra quyền thêm
var sys = CheckActiveMenu.ReturnActive(SystemMessageConst.TypeAction.Addnew);
if (sys.IsSuccess == false)
{
return(Json(new { result = sys }, JsonRequestBehavior.AllowGet));
}
var db = new CustomerBusiness();
service_customer serviceCustomer = new service_customer();
var getbrand = entity.Branch.FirstOrDefault(m => m.Id == branchId);
serviceCustomer.fullname = fullName;
serviceCustomer.id_card = cmt;
serviceCustomer.address = address;
serviceCustomer.mobile = phone;
serviceCustomer.note = note;
serviceCustomer.status = 1;
serviceCustomer.id_center = branchId;
serviceCustomer.code_center = getbrand.Branch_code;
serviceCustomer.created_by = user.FullName;
serviceCustomer.created_at = DateTime.Now;
DateTime _birth;
if (!string.IsNullOrEmpty(birth))
{
if (!DateTime.TryParseExact(birth, "dd/MM/yyyy", CultureInfo.InvariantCulture,
DateTimeStyles.None, out _birth))
{
SystemMessage systemMessage = new SystemMessage();
systemMessage.IsSuccess = false;
systemMessage.Message = string.Format(SystemMessageConst.ValidateConst.DateIsNotValid, "Ngày sinh");
return(Json(new { result = systemMessage }, JsonRequestBehavior.AllowGet));
}
serviceCustomer.birthday = _birth;
}
var result = db.AddCustomer(serviceCustomer);
// luu log - thêm mới
CheckRuleAndSaveLog.ReturnCheckRuleAndSaveLog(DbLogType.Create.ToString(), result.IsSuccess, JsonConvert.SerializeObject(new { data = serviceCustomer }, Newtonsoft.Json.Formatting.Indented, new JsonSerializerSettings {
NullValueHandling = NullValueHandling.Ignore
}));
return(Json(new { result }, JsonRequestBehavior.AllowGet));
}
public ActionResult _ChinhSua_Anh_TheoSP(int id_img, int id_product, string txt_des)
{
var db = new ProductServiceBusiness();
// kiểm tra quyền thêm sửa xóa của từng menu , nhớ truyền type tương ứng
var sys = CheckActiveMenu.ReturnActive(SystemMessageConst.TypeAction.Update);
if (sys.IsSuccess == false)
{
return(Json(new { result = sys }, JsonRequestBehavior.AllowGet));
}
var result = db.BS_ChinhSua_Anh_TheoSP(id_img, id_product, txt_des);
return(Json(new { result }, JsonRequestBehavior.AllowGet));
}
public ActionResult _CongSL_Chil_SP(int id_p, string groupcode)
{
var db = new nhap_tonkhoBussiness();
// kiểm tra quyền thêm sửa xóa của từng menu , nhớ truyền type tương ứng
var sys = CheckActiveMenu.ReturnActive(SystemMessageConst.TypeAction.Update);
if (sys.IsSuccess == false)
{
return(Json(new { result = sys }, JsonRequestBehavior.AllowGet));
}
var result = db.BS_CongSL_Chil_SP(id_p, groupcode);
return(Json(new { result }, JsonRequestBehavior.AllowGet));
}
public ActionResult _Chinhsua_TT_SP(int id, string tensp, string codesp, string loaisp, int unitsp, string gioithieusp, bool status = false)
{
var db = new ProductServiceBusiness();
// kiểm tra quyền thêm sửa xóa của từng menu , nhớ truyền type tương ứng
var sys = CheckActiveMenu.ReturnActive(SystemMessageConst.TypeAction.Update);
if (sys.IsSuccess == false)
{
return(Json(new { result = sys }, JsonRequestBehavior.AllowGet));
}
var result = db.BS_Chinhsua_TT_SP(id, tensp, codesp, loaisp, unitsp, gioithieusp, status);
return(Json(new { result }, JsonRequestBehavior.AllowGet));
}
public ActionResult _ThemMoi_Gia_SP(int gianhap, int giaxuat, string type_price, int id_product)
{
var db = new ProductServiceBusiness();
// kiểm tra quyền thêm sửa xóa của từng menu , nhớ truyền type tương ứng
var sys = CheckActiveMenu.ReturnActive(SystemMessageConst.TypeAction.Addnew);
if (sys.IsSuccess == false)
{
return(Json(new { result = sys }, JsonRequestBehavior.AllowGet));
}
var result = db.BS_ThemMoi_Gia_SP(gianhap, giaxuat, type_price, id_product);
return(Json(new { result }, JsonRequestBehavior.AllowGet));
}
public ActionResult _XoathongsoTheoSP(int id_config_attr = 0)
{
// kiểm tra quyền thêm sửa xóa của từng menu , nhớ truyền type tương ứng
var sys = CheckActiveMenu.ReturnActive(SystemMessageConst.TypeAction.Delete);
if (sys.IsSuccess == false)
{
return(Json(new { result = sys }, JsonRequestBehavior.AllowGet));
}
var db = new ProductServiceBusiness();
var result = db.BS_XoathongsoTheoSP(id_config_attr);
return(Json(new { result }, JsonRequestBehavior.AllowGet));
}
public ActionResult DeleteUserAndRole(int idrole, int iduser, int idroleuser)
{
// kiểm tra quyền thêm sửa xóa của từng menu , nhớ truyền type tương ứng
var sys = CheckActiveMenu.ReturnActive(SystemMessageConst.TypeAction.Delete);
if (sys.IsSuccess == false)
{
return(Json(new { result = sys }, JsonRequestBehavior.AllowGet));
}
var db = new RoleUserBusiness();
var result = db.DeleteRoleUserAndMenu(idrole, iduser, idroleuser);
return(Json(new { result }, JsonRequestBehavior.AllowGet));
}
public ActionResult _xuat_ban_daily(FormCollection formCollection)
{
// kiểm tra quyền thêm sửa
var sys = CheckActiveMenu.ReturnActive(SystemMessageConst.TypeAction.Addnew);
if (sys.IsSuccess == false)
{
return(Json(new { result = sys }, JsonRequestBehavior.AllowGet));
}
Add_Bill item = new Add_Bill();
item.type = "DL";
item.loaibill = 1;
item.data = formCollection.Get("data");
item.billType = formCollection.Get("billType");
item.bonusTotal = long.Parse(formCollection.Get("bonusTotal"));
item.total = long.Parse(formCollection.Get("total"));
item.discount = long.Parse(formCollection.Get("discount"));
item.billNumber = formCollection.Get("billNumber");
item.ngayxuat = formCollection.Get("ngayxuat");
item.nguoixuat = formCollection.Get("nguoixuat");
item.notebill = formCollection.Get("notebill");
item.tenkh = formCollection.Get("tenkh");
item.diachi = formCollection.Get("diachi");
item.nguoidaidien = formCollection.Get("nguoidaidien");
item.dienthoai = formCollection.Get("dienthoai");
item.id_center = user.BranchId;
item.id_thaotac = user.Id;
item.code_center = user.Code_brand;
item.tennguoithaotac = user.FullName;
var db = new xuat_dailyBusiness();
var result = db.AddBillProduct(item);
// luu log - thêm mới
CheckRuleAndSaveLog.ReturnCheckRuleAndSaveLog(DbLogType.Create.ToString(), result.IsSuccess, JsonConvert.SerializeObject(new { data = item }, Newtonsoft.Json.Formatting.Indented, new JsonSerializerSettings {
NullValueHandling = NullValueHandling.Ignore
}));
return(Json(new { result }, JsonRequestBehavior.AllowGet));
}
public ActionResult _NhapKho(int id_product = 0, int soluong = 0, int id_nguonnhap = 0, float tongtien = 0, string group_code_product = "", string ngaynhap = "", string mota = "")
{
// kiểm tra quyền thêm sửa xóa của từng menu , nhớ truyền type tương ứng
var sys = CheckActiveMenu.ReturnActive(SystemMessageConst.TypeAction.Addnew);
if (sys.IsSuccess == false)
{
return(Json(new { result = sys }, JsonRequestBehavior.AllowGet));
}
var db = new nhap_tonkhoBussiness();
sys_Nhap item = new sys_Nhap();
System.Globalization.CultureInfo enUS = new System.Globalization.CultureInfo("en-US");
DateTime n_n;
DateTime.TryParseExact(ngaynhap, "dd/MM/yyyy", enUS,
System.Globalization.DateTimeStyles.None,
out n_n);
double tb = 0;
tb = Math.Round(tongtien / soluong, 0);
item.id_product = id_product;
item.soluong = soluong;
item.id_nguonnhap = id_nguonnhap;
item.tongtien = tongtien;
item.group_code_product = group_code_product;
item.ngaynhap = n_n;
item.mota = mota;
item.trangthai = true;
item.nguoinhap = user.Id;
item.id_center = user.BranchId;
item.giatrungbinh = tb;
var result = db.BS_NhapKho(item);
// luu log - thêm mới
CheckRuleAndSaveLog.ReturnCheckRuleAndSaveLog(DbLogType.Create.ToString(), result.IsSuccess, JsonConvert.SerializeObject(new { data = item }, Newtonsoft.Json.Formatting.Indented, new JsonSerializerSettings {
NullValueHandling = NullValueHandling.Ignore
}));
return(Json(new { result }, JsonRequestBehavior.AllowGet));
}
public ActionResult _EditCustomer(string fullName, string cmt, string birth, string address, string phone, string note, int branchId = 0, int id = 0)
{
// kiểm tra quyền thêm sửa
var sys = CheckActiveMenu.ReturnActive(SystemMessageConst.TypeAction.Update);
if (sys.IsSuccess == false)
{
return(Json(new { result = sys }, JsonRequestBehavior.AllowGet));
}
var db = new CustomerBusiness();
service_customer serviceCustomer = new service_customer();
serviceCustomer.fullname = fullName;
serviceCustomer.id_card = cmt;
serviceCustomer.address = address;
serviceCustomer.mobile = phone;
serviceCustomer.note = note;
serviceCustomer.id_center = branchId;
serviceCustomer.id = id;
DateTime _birth;
if (!string.IsNullOrEmpty(birth))
{
if (!DateTime.TryParseExact(birth, "dd/MM/yyyy", CultureInfo.InvariantCulture,
DateTimeStyles.None, out _birth))
{
SystemMessage systemMessage = new SystemMessage();
systemMessage.IsSuccess = false;
systemMessage.Message = string.Format(SystemMessageConst.ValidateConst.DateIsNotValid, "Ngày sinh");
return(Json(new { result = systemMessage }, JsonRequestBehavior.AllowGet));
}
serviceCustomer.birthday = _birth;
}
var result = db.EditCustomer(serviceCustomer);
CheckRuleAndSaveLog.ReturnCheckRuleAndSaveLog(DbLogType.Update.ToString(), result.IsSuccess, JsonConvert.SerializeObject(new { log = "CapNhatThongTinKH", newtdata = serviceCustomer }, Newtonsoft.Json.Formatting.Indented, new JsonSerializerSettings {
NullValueHandling = NullValueHandling.Ignore
}));
return(Json(new { result }, JsonRequestBehavior.AllowGet));
}
public ActionResult DeleteMenuInRoleAccount(int id)
{
// kiểm tra quyền thêm sửa xóa của từng menu , nhớ truyền type tương ứng
var sys = CheckActiveMenu.ReturnActive(SystemMessageConst.TypeAction.Delete);
if (sys.IsSuccess == false)
{
return(Json(new { result = sys }, JsonRequestBehavior.AllowGet));
}
var db = new RoleUserBusiness();
EditSelectMenu item = new EditSelectMenu();
item.id = id;
var result = db.Delete_Select_Menu(item);
return(Json(new { result }, JsonRequestBehavior.AllowGet));
}
public ActionResult _AddAccountIntoRole(int idAccount, int idRole)
{
// kiểm tra quyền thêm sửa xóa của từng menu , nhớ truyền type tương ứng
var sys = CheckActiveMenu.ReturnActive(SystemMessageConst.TypeAction.Addnew);
if (sys.IsSuccess == false)
{
return(Json(new { result = sys }, JsonRequestBehavior.AllowGet));
}
var db = new RoleUserBusiness();
MenuPermission item = new MenuPermission();
item.RoleId = idRole;
item.UserId = idAccount;
var result = db.Add_Account_Into_Role(item);
return(Json(new { result }, JsonRequestBehavior.AllowGet));
}
public ActionResult UpdateSelectInMenu(int id, string type, bool gt)
{
// kiểm tra quyền thêm sửa xóa của từng menu , nhớ truyền type tương ứng
var sys = CheckActiveMenu.ReturnActive(SystemMessageConst.TypeAction.Update);
if (sys.IsSuccess == false)
{
return(Json(new { result = sys }, JsonRequestBehavior.AllowGet));
}
var db = new RoleUserBusiness();
EditSelectMenu item = new EditSelectMenu();
item.id = id;
item.type = type;
item.gt = gt;
var result = db.Edit_Select_Menu(item);
return(Json(new { result }, JsonRequestBehavior.AllowGet));
}
public ActionResult DeleteUnit(int id)
{
// kiểm tra quyền thêm xóa
var sys = CheckActiveMenu.ReturnActive(SystemMessageConst.TypeAction.Delete);
if (sys.IsSuccess == false)
{
return(Json(new { result = sys }, JsonRequestBehavior.AllowGet));
}
var db = new quanlydonviBusiness();
var result = db.DeleteUnitById(id);
// luu log - xóa
CheckRuleAndSaveLog.ReturnCheckRuleAndSaveLog(DbLogType.Delete.ToString(), result.IsSuccess, JsonConvert.SerializeObject(new { data = new { id = id } }, Newtonsoft.Json.Formatting.Indented, new JsonSerializerSettings {
NullValueHandling = NullValueHandling.Ignore
}));
return(Json(new { result }, JsonRequestBehavior.AllowGet));
}