public Response <ImageModel> InsertImage(ImageModel ImageModel) { try { using (var unitOfWorkStore = new UnitOfWorkStore(dbFactory)) { var rpImage = unitOfWorkStore.GetRepository <Image>(); Image ImageEntity = new Image(); ImageEntity.Image_ID = ImageModel.Image_ID; ImageEntity.Name = ImageModel.Name; ImageEntity.Url = ImageModel.Url; rpImage.Add(ImageEntity); if (unitOfWorkStore.Save() >= 1) { ImageModel.Name = ImageEntity.Name; return(new Response <ImageModel>((int)StatusResponses.Success, MessageResConst.Success, ImageModel)); } else { return(new Response <ImageModel>((int)StatusResponses.ErrorSystem, MessageResConst.ErrorCommonRequestParam, ImageModel)); } } } catch (Exception ex) { return(new Response <ImageModel>((int)StatusResponses.ErrorSystem, ex.Message, null)); } }
public Response <BranchModel> GetBranchByID(int iBranchID) { try { using (var unitOfWorkStore = new UnitOfWorkStore(dbFactory)) { var rpBranch = unitOfWorkStore.GetRepository <Branch>(); var obBranch = rpBranch.GetById(iBranchID); BranchModel BranchModel = new BranchModel() { Branch_ID = obBranch.Branch_ID, Branch_Name = obBranch.Branch_Name, Region = obBranch.Region, CommuneWard = obBranch.CommuneWard, Email = obBranch.Email, Phone = obBranch.Phone, Address = obBranch.Address, }; return(new Response <BranchModel>((int)StatusResponses.Success, MessageResConst.Success, BranchModel)); } } catch (Exception ex) { return(new Response <BranchModel>((int)StatusResponses.ErrorSystem, ex.Message, null)); } }
//Lấy danh sách list nhóm hang hóa cha public Response <List <GroupItemModel> > GetGroupItemsForParent() { try { using (var unitOfWorkStore = new UnitOfWorkStore(dbFactory)) { var rpGroupItem = unitOfWorkStore.GetRepository <GroupItem>(); var listGroupItemEntity = rpGroupItem.GetAll(); var listGroupItemModel = (from obGroupItem in listGroupItemEntity select new GroupItemModel() { GroupItem_ID = obGroupItem.GroupItem_ID, GroupItem_Code = obGroupItem.GroupItem_Code, Name = obGroupItem.Name, TitleKey = obGroupItem.TitleKey, ParentId = obGroupItem.ParentId, ParenName = obGroupItem.ParenName }).ToList(); listGroupItemModel = listGroupItemModel.Where(x => x.ParentId == null).ToList(); // order return(new Response <List <GroupItemModel> >((int)StatusResponses.Success, 0, MessageResConst.Success, listGroupItemModel)); } } catch (Exception ex) { return(new Response <List <GroupItemModel> >((int)StatusResponses.ErrorSystem, 0, ex.Message, null)); } }
public Response <EmployeeModel> UpdateEmployee(EmployeeModel EmployeeModel) { try { using (var unitOfWorkStore = new UnitOfWorkStore(dbFactory)) { var rpEmployee = unitOfWorkStore.GetRepository <Employee>(); Employee EmployeeEntity = rpEmployee.GetById(EmployeeModel.Employee_ID); EmployeeEntity.Employee_ID = EmployeeModel.Employee_ID; EmployeeEntity.Employee_Code = EmployeeModel.Employee_Code; EmployeeEntity.Name = EmployeeModel.Name; EmployeeEntity.Address = EmployeeModel.Address; EmployeeEntity.Phone = EmployeeModel.Phone; EmployeeEntity.Possition = EmployeeModel.Possition; EmployeeEntity.Private_ID = EmployeeModel.Private_ID; EmployeeEntity.Branch_ID = EmployeeModel.Branch_ID; rpEmployee.Update(EmployeeEntity); if (unitOfWorkStore.Save() >= 1) { EmployeeModel.Employee_Code = EmployeeEntity.Employee_Code; return(new Response <EmployeeModel>((int)StatusResponses.Success, MessageResConst.Success, EmployeeModel)); } else { return(new Response <EmployeeModel>((int)StatusResponses.ErrorSystem, MessageResConst.ErrorCommonRequestParam, EmployeeModel)); } } } catch (Exception ex) { return(new Response <EmployeeModel>((int)StatusResponses.ErrorSystem, ex.Message, null)); } }
public Response <CountryModel> UpdateCountry(CountryModel CountryModel) { try { using (var unitOfWorkStore = new UnitOfWorkStore(dbFactory)) { var rpCountry = unitOfWorkStore.GetRepository <Country>(); Country CountryEntity = rpCountry.GetById(CountryModel.Country_ID); CountryEntity.Country_ID = CountryModel.Country_ID; CountryEntity.Name = CountryModel.Name; rpCountry.Update(CountryEntity); if (unitOfWorkStore.Save() >= 1) { CountryModel.Name = CountryEntity.Name; return(new Response <CountryModel>((int)StatusResponses.Success, MessageResConst.Success, CountryModel)); } else { return(new Response <CountryModel>((int)StatusResponses.ErrorSystem, MessageResConst.ErrorCommonRequestParam, CountryModel)); } } } catch (Exception ex) { return(new Response <CountryModel>((int)StatusResponses.ErrorSystem, ex.Message, null)); } }
// Hàm lấy chất liệu hàng hóa public Response <List <Item_MaterialModel> > GetItem_Material() { try { using (var unitOfWorkStore = new UnitOfWorkStore(dbFactory)) { var rpItem_Color = unitOfWorkStore.GetRepository <Item_Material>(); var listItem_ColorEntity = rpItem_Color.GetAll(); var listItem_ColorModel = (from Item_Material in listItem_ColorEntity select new Item_MaterialModel() { Item_Material_ID = Item_Material.Item_Material_ID, Name = Item_Material.Name }).ToList(); // search listItem_ColorModel = listItem_ColorModel.OrderByDescending(x => x.Name).ToList(); return(new Response <List <Item_MaterialModel> >((int)StatusResponses.Success, listItem_ColorModel.Count, MessageResConst.Success, listItem_ColorModel)); } } catch (Exception ex) { return(new Response <List <Item_MaterialModel> >((int)StatusResponses.ErrorSystem, 0, ex.Message, null)); } }
public Response <Item_ColorModel> InsertItem_Color(Item_ColorModel Item_ColorModel) { try { using (var unitOfWorkStore = new UnitOfWorkStore(dbFactory)) { var rpItem_Color = unitOfWorkStore.GetRepository <Item_Color>(); Item_Color Item_ColorEntity = new Item_Color(); Item_ColorEntity.Name = Item_ColorModel.Name; rpItem_Color.Add(Item_ColorEntity); if (unitOfWorkStore.Save() >= 1) { return(new Response <Item_ColorModel>((int)StatusResponses.Success, MessageResConst.Success, Item_ColorModel)); } else { return(new Response <Item_ColorModel>((int)StatusResponses.ErrorSystem, MessageResConst.ErrorCommonRequestParam, Item_ColorModel)); } } } catch (Exception ex) { return(new Response <Item_ColorModel>((int)StatusResponses.ErrorSystem, ex.Message, null)); } }
public Response <Item_SizeModel> UpdateItem_Size(Item_SizeModel Item_SizeModel) { try { using (var unitOfWorkStore = new UnitOfWorkStore(dbFactory)) { var rpItem_Size = unitOfWorkStore.GetRepository <Item_Size>(); Item_Size Item_SizeEntity = rpItem_Size.GetById(Item_SizeModel.Item_Size1); Item_SizeEntity.Name = Item_SizeModel.Name; rpItem_Size.Update(Item_SizeEntity); if (unitOfWorkStore.Save() >= 1) { Item_SizeModel.Name = Item_SizeEntity.Name; return(new Response <Item_SizeModel>((int)StatusResponses.Success, MessageResConst.Success, Item_SizeModel)); } else { return(new Response <Item_SizeModel>((int)StatusResponses.ErrorSystem, MessageResConst.ErrorCommonRequestParam, Item_SizeModel)); } } } catch (Exception ex) { return(new Response <Item_SizeModel>((int)StatusResponses.ErrorSystem, ex.Message, null)); } }
public Response <CustomerModel> GetCustomerByID(int iCustomerID) { try { using (var unitOfWorkStore = new UnitOfWorkStore(dbFactory)) { var rpCustomer = unitOfWorkStore.GetRepository <Customer>(); var obCustomer = rpCustomer.GetById(iCustomerID); CustomerModel CustomerModel = new CustomerModel() { Customer_ID = obCustomer.Customer_ID, Customer_Code = obCustomer.Customer_Code, Name = obCustomer.Name, Phone = obCustomer.Phone, Email = obCustomer.Email, Address = obCustomer.Address, Birthday = obCustomer.Birthday, Category = obCustomer.Category == null? "1": obCustomer.Category.Trim(), Company_Name = obCustomer.Company_Name, Tax_Code = obCustomer.Tax_Code, Url = obCustomer.Url == null? "#": obCustomer.Url, Sex = obCustomer.Sex == null? "1":obCustomer.Sex, Note = obCustomer.Note, }; return(new Response <CustomerModel>((int)StatusResponses.Success, MessageResConst.Success, CustomerModel)); } } catch (Exception ex) { return(new Response <CustomerModel>((int)StatusResponses.ErrorSystem, ex.Message, null)); } }
// hàm lấy dữ liệu theo id public Response <VendorModel> GetVendorByID(int iVendorID) { try { using (var unitOfWorkStore = new UnitOfWorkStore(dbFactory)) { var rpVendor = unitOfWorkStore.GetRepository <Vendor>(); var obRestaurant = rpVendor.GetById(iVendorID); VendorModel vendorModel = new VendorModel() { Vendor_ID = obRestaurant.Vendor_ID, Vendor_Code = obRestaurant.Vendor_Code, Name = obRestaurant.Name, Tax_Code = obRestaurant.Tax_Code, Phone = obRestaurant.Phone, Address = obRestaurant.Address, Region = obRestaurant.Region, CommuneWard = obRestaurant.CommuneWard, Email = obRestaurant.Email, Group_Vendor = obRestaurant.Group_Vendor, Note = obRestaurant.Note }; return(new Response <VendorModel>((int)StatusResponses.Success, MessageResConst.Success, vendorModel)); } } catch (Exception ex) { return(new Response <VendorModel>((int)StatusResponses.ErrorSystem, ex.Message, null)); } }
// tạo hàm xóa public Response <VendorModel> Delete(int iVendorID) { try { using (var unitOfWorkStore = new UnitOfWorkStore(dbFactory)) { var rpVendor = unitOfWorkStore.GetRepository <Vendor>(); Vendor vendorEntity = rpVendor.GetById(iVendorID); rpVendor.Delete(vendorEntity); //unitOfWorkStore.Save(); if (unitOfWorkStore.Save() >= 1) { return(new Response <VendorModel>((int)StatusResponses.Success, MessageResConst.Success, null)); } else { return(new Response <VendorModel>((int)StatusResponses.ErrorSystem, MessageResConst.ErrorCommonRequestParam, null)); } } } catch (Exception ex) { return(new Response <VendorModel>((int)StatusResponses.ErrorSystem, ex.Message, null)); } }
public Response <EmployeeModel> GetEmployeeByID(int iEmployeeID) { try { using (var unitOfWorkStore = new UnitOfWorkStore(dbFactory)) { var rpEmployee = unitOfWorkStore.GetRepository <Employee>(); var obEmployee = rpEmployee.GetById(iEmployeeID); EmployeeModel EmployeeModel = new EmployeeModel() { Employee_ID = obEmployee.Employee_ID, Employee_Code = obEmployee.Employee_Code, Name = obEmployee.Name, Address = obEmployee.Address, Phone = obEmployee.Phone, Possition = obEmployee.Possition, Private_ID = obEmployee.Private_ID, Branch_ID = obEmployee.Branch_ID, }; return(new Response <EmployeeModel>((int)StatusResponses.Success, MessageResConst.Success, EmployeeModel)); } } catch (Exception ex) { return(new Response <EmployeeModel>((int)StatusResponses.ErrorSystem, ex.Message, null)); } }
public Response <List <Item_MaterialModel> > GetItem_Materials(int pageSize, int pageCurrent, string orderid, string sortDecOrInc, Item_MaterialModel item_Material) { try { using (var unitOfWorkStore = new UnitOfWorkStore(dbFactory)) { var rpItem_Material = unitOfWorkStore.GetRepository <Item_Material>(); var listItem_MaterialEntity = rpItem_Material.GetAll(); var listItem_MaterialModel = (from Item_Material in listItem_MaterialEntity select new Item_MaterialModel() { Item_Material_ID = Item_Material.Item_Material_ID, Name = Item_Material.Name }).ToList(); // search int countData = listItem_MaterialModel.Count; listItem_MaterialModel = listItem_MaterialModel.Skip((pageCurrent - 1) * pageSize).Take(pageSize).ToList(); // order if (sortDecOrInc == MessageResConst.Increase) { listItem_MaterialModel = listItem_MaterialModel.OrderBy(x => x.Name).ToList(); } else { listItem_MaterialModel = listItem_MaterialModel.OrderByDescending(x => x.Name).ToList(); } return(new Response <List <Item_MaterialModel> >((int)StatusResponses.Success, countData, MessageResConst.Success, listItem_MaterialModel)); } } catch (Exception ex) { return(new Response <List <Item_MaterialModel> >((int)StatusResponses.ErrorSystem, 0, ex.Message, null)); } }
public Response <ItemModel> GetItemByID(int iItemID) { try { using (var unitOfWorkStore = new UnitOfWorkStore(dbFactory)) { var rpItem = unitOfWorkStore.GetRepository <Item>(); var obItem = rpItem.GetById(iItemID); ItemModel ItemModel = new ItemModel() { Item_ID = obItem.Item_ID, Item_Code = obItem.Item_Code, Name = obItem.Name, GroupItem_ID = obItem.GroupItem_ID, GroupItem_Sub_ID = obItem.GroupItem_Sub_ID, AmountSale = obItem.AmountSale, AmountOrigin = obItem.AmountOrigin, Blance = obItem.Blance, Item_Color_ID = obItem.Item_Color_ID, Item_Material_ID = obItem.Item_Material_ID, Item_Size_ID = obItem.Item_Size_ID, Unit = obItem.Unit, Note = obItem.Note, AmountShip = obItem.AmountShip, }; return(new Response <ItemModel>((int)StatusResponses.Success, MessageResConst.Success, ItemModel)); } } catch (Exception ex) { return(new Response <ItemModel>((int)StatusResponses.ErrorSystem, ex.Message, null)); } }
public Response <GroupItemModel> UpdateGroupItem(GroupItemModel GroupItemModel) { try { using (var unitOfWorkStore = new UnitOfWorkStore(dbFactory)) { var rpGroupItem = unitOfWorkStore.GetRepository <GroupItem>(); GroupItem GroupItemEntity = rpGroupItem.GetById(GroupItemModel.GroupItem_ID); GroupItemEntity.GroupItem_ID = GroupItemModel.GroupItem_ID; GroupItemEntity.GroupItem_Code = GroupItemModel.GroupItem_Code; GroupItemEntity.Name = GroupItemModel.Name; GroupItemEntity.GroupItem_ID = GroupItemModel.GroupItem_ID; rpGroupItem.Update(GroupItemEntity); if (unitOfWorkStore.Save() >= 1) { GroupItemModel.Name = GroupItemEntity.Name; return(new Response <GroupItemModel>((int)StatusResponses.Success, MessageResConst.Success, GroupItemModel)); } else { return(new Response <GroupItemModel>((int)StatusResponses.ErrorSystem, MessageResConst.ErrorCommonRequestParam, GroupItemModel)); } } } catch (Exception ex) { return(new Response <GroupItemModel>((int)StatusResponses.ErrorSystem, ex.Message, null)); } }
public Response <BranchModel> UpdateBranch(BranchModel BranchModel) { try { using (var unitOfWorkStore = new UnitOfWorkStore(dbFactory)) { var rpBranch = unitOfWorkStore.GetRepository <Branch>(); Branch BranchEntity = rpBranch.GetById(BranchModel.Branch_ID); BranchEntity.Branch_ID = BranchModel.Branch_ID; BranchEntity.Branch_Name = BranchModel.Branch_Name; BranchEntity.Region = BranchModel.Region; BranchEntity.CommuneWard = BranchModel.CommuneWard; BranchEntity.Email = BranchModel.Email; BranchEntity.Phone = BranchModel.Phone; BranchEntity.Address = BranchModel.Address; rpBranch.Update(BranchEntity); if (unitOfWorkStore.Save() >= 1) { BranchModel.Branch_Name = BranchEntity.Branch_Name; return(new Response <BranchModel>((int)StatusResponses.Success, MessageResConst.Success, BranchModel)); } else { return(new Response <BranchModel>((int)StatusResponses.ErrorSystem, MessageResConst.ErrorCommonRequestParam, BranchModel)); } } } catch (Exception ex) { return(new Response <BranchModel>((int)StatusResponses.ErrorSystem, ex.Message, null)); } }
public Response <GroupItemModel> InsertGroupItem(GroupItemModel GroupItemModel) { try { using (var unitOfWorkStore = new UnitOfWorkStore(dbFactory)) { var rpGroupItem = unitOfWorkStore.GetRepository <GroupItem>(); GroupItem GroupItemEntity = new GroupItem(); GroupItemEntity.GroupItem_ID = GroupItemModel.GroupItem_ID; GroupItemEntity.GroupItem_Code = GroupItemModel.GroupItem_Code; GroupItemEntity.Name = GroupItemModel.Name; GroupItemEntity.TitleKey = FormatData.RemoveUnicode(GroupItemModel.Name); if (!string.IsNullOrEmpty(GroupItemModel.ParentId) && GroupItemModel.ParentId != "undefined") { string prid = GroupItemModel.ParentId; var listGroupItemEntity = rpGroupItem.GetAll(); var listGroupItemModel = (from obGroupItem in listGroupItemEntity select new GroupItemModel() { GroupItem_ID = obGroupItem.GroupItem_ID, GroupItem_Code = obGroupItem.GroupItem_Code, Name = obGroupItem.Name, TitleKey = obGroupItem.TitleKey, ParentId = obGroupItem.ParentId, ParenName = obGroupItem.ParenName }).ToList(); GroupItemModel tg = listGroupItemModel.Where(x => x.TitleKey == prid).FirstOrDefault(); // _category_DocumentService.FindBy<Category_DocumentFormDTO>(sp => sp.TitleKey == prid && sp.isApprove != false).FirstOrDefault(); if (tg != null) { GroupItemEntity.ParenName = tg.Name; } } rpGroupItem.Add(GroupItemEntity); if (unitOfWorkStore.Save() >= 1) { GroupItemModel.Name = GroupItemEntity.Name; return(new Response <GroupItemModel>((int)StatusResponses.Success, MessageResConst.Success, GroupItemModel)); } else { return(new Response <GroupItemModel>((int)StatusResponses.ErrorSystem, MessageResConst.ErrorCommonRequestParam, GroupItemModel)); } } } catch (Exception ex) { return(new Response <GroupItemModel>((int)StatusResponses.ErrorSystem, ex.Message, null)); } }
public Response <List <GroupItemModel> > GetGroupItems(int pageSize, int pageCurrent, string orderid, string sortDecOrInc, GroupItemModel GroupItemModel) { try { using (var unitOfWorkStore = new UnitOfWorkStore(dbFactory)) { var rpGroupItem = unitOfWorkStore.GetRepository <GroupItem>(); var listGroupItemEntity = rpGroupItem.GetAll(); var listGroupItemModel = (from obGroupItem in listGroupItemEntity select new GroupItemModel() { GroupItem_ID = obGroupItem.GroupItem_ID, GroupItem_Code = obGroupItem.GroupItem_Code, Name = obGroupItem.Name, TitleKey = obGroupItem.TitleKey, ParentId = obGroupItem.ParentId, ParenName = obGroupItem.ParenName }).ToList(); // search if (GroupItemModel != null) { if (GroupItemModel.Name != null) { listGroupItemModel = listGroupItemModel.Where(x => x.Name.Contains(GroupItemModel.Name)).ToList(); } } int countData = listGroupItemModel.Count; listGroupItemModel = listGroupItemModel.Skip((pageCurrent - 1) * pageSize).Take(pageSize).ToList(); // order switch (orderid) { case "Name": if (sortDecOrInc == MessageResConst.Increase) { listGroupItemModel = listGroupItemModel.OrderBy(x => x.Name).ToList(); } else { listGroupItemModel = listGroupItemModel.OrderByDescending(x => x.Name).ToList(); } break; } return(new Response <List <GroupItemModel> >((int)StatusResponses.Success, countData, MessageResConst.Success, listGroupItemModel)); } } catch (Exception ex) { return(new Response <List <GroupItemModel> >((int)StatusResponses.ErrorSystem, 0, ex.Message, null)); } }
public Response <List <ImageModel> > GetImages(int pageSize, int pageCurrent, string orderid, string sortDecOrInc, ImageModel ImageModel) { try { using (var unitOfWorkStore = new UnitOfWorkStore(dbFactory)) { var rpImage = unitOfWorkStore.GetRepository <Image>(); var listImageEntity = rpImage.GetAll(); var listImageModel = (from image in listImageEntity select new ImageModel() { Image_ID = image.Image_ID, Name = image.Name, Url = image.Url }).ToList(); // search if (ImageModel != null) { if (ImageModel.Name != null) { listImageModel = listImageModel.Where(x => x.Name.Contains(ImageModel.Name)).ToList(); } } int countData = listImageModel.Count; listImageModel = listImageModel.Skip((pageCurrent - 1) * pageSize).Take(pageSize).ToList(); // order switch (orderid) { case "Name": if (sortDecOrInc == MessageResConst.Increase) { listImageModel = listImageModel.OrderBy(x => x.Name).ToList(); } else { listImageModel = listImageModel.OrderByDescending(x => x.Name).ToList(); } break; } return(new Response <List <ImageModel> >((int)StatusResponses.Success, countData, MessageResConst.Success, listImageModel)); } } catch (Exception ex) { return(new Response <List <ImageModel> >((int)StatusResponses.ErrorSystem, 0, ex.Message, null)); } }
public Response <List <Item_ColorModel> > GetItem_Colors(int pageSize, int pageCurrent, string orderid, string sortDecOrInc, Item_ColorModel item_Color) { try { using (var unitOfWorkStore = new UnitOfWorkStore(dbFactory)) { var rpItem_Color = unitOfWorkStore.GetRepository <Item_Color>(); var listItem_ColorEntity = rpItem_Color.GetAll(); var listItem_ColorModel = (from Item_Color in listItem_ColorEntity select new Item_ColorModel() { Item_Color_ID = Item_Color.Item_Color_ID, Name = Item_Color.Name }).ToList(); // search if (item_Color != null) { if (item_Color.Name != null) { listItem_ColorModel = listItem_ColorModel.Where(x => RemoveSign4VietnameseString(x.Name.ToLower()).Contains(RemoveSign4VietnameseString(item_Color.Name.ToLower()))).ToList(); } } int countData = listItem_ColorModel.Count; listItem_ColorModel = listItem_ColorModel.Skip((pageCurrent - 1) * pageSize).Take(pageSize).ToList(); // order if (sortDecOrInc == MessageResConst.Increase) { listItem_ColorModel = listItem_ColorModel.OrderBy(x => x.Name).ToList(); } else { listItem_ColorModel = listItem_ColorModel.OrderByDescending(x => x.Name).ToList(); } return(new Response <List <Item_ColorModel> >((int)StatusResponses.Success, countData, MessageResConst.Success, listItem_ColorModel)); } } catch (Exception ex) { return(new Response <List <Item_ColorModel> >((int)StatusResponses.ErrorSystem, 0, ex.Message, null)); } }
public Response <ItemModel> UpdateItem(ItemModel ItemModel) { try { using (var unitOfWorkStore = new UnitOfWorkStore(dbFactory)) { var rpItem = unitOfWorkStore.GetRepository <Item>(); Item ItemEntity = rpItem.GetById(ItemModel.Item_ID); //ItemEntity.Item_ID = ItemModel.Item_ID; ItemEntity.Item_Code = ItemModel.Item_Code; ItemEntity.Name = ItemModel.Name; ItemEntity.GroupItem_ID = ItemModel.GroupItem_ID; ItemEntity.GroupItem_Sub_ID = ItemModel.GroupItem_Sub_ID; ItemEntity.AmountSale = ItemModel.AmountSale; ItemEntity.AmountOrigin = ItemModel.AmountOrigin; ItemEntity.Blance = ItemModel.Blance; ItemEntity.Item_Color_ID = ItemModel.Item_Color_ID; ItemEntity.Item_Material_ID = ItemModel.Item_Material_ID; ItemEntity.Item_Size_ID = ItemModel.Item_Size_ID; ItemEntity.Unit = ItemModel.Unit; ItemEntity.Note = ItemModel.Note; ItemEntity.AmountShip = ItemModel.AmountShip; rpItem.Update(ItemEntity); if (unitOfWorkStore.Save() >= 1) { ItemModel.Item_Code = ItemEntity.Item_Code; return(new Response <ItemModel>((int)StatusResponses.Success, MessageResConst.Success, ItemModel)); } else { return(new Response <ItemModel>((int)StatusResponses.ErrorSystem, MessageResConst.ErrorCommonRequestParam, ItemModel)); } } } catch (Exception ex) { return(new Response <ItemModel>((int)StatusResponses.ErrorSystem, ex.Message, null)); } }
public Response <CountryModel> GetCountryByID(int iCountryID) { try { using (var unitOfWorkStore = new UnitOfWorkStore(dbFactory)) { var rpCountry = unitOfWorkStore.GetRepository <Country>(); var obCountry = rpCountry.GetById(iCountryID); CountryModel CountryModel = new CountryModel() { Country_ID = obCountry.Country_ID, Name = obCountry.Name, }; return(new Response <CountryModel>((int)StatusResponses.Success, MessageResConst.Success, CountryModel)); } } catch (Exception ex) { return(new Response <CountryModel>((int)StatusResponses.ErrorSystem, ex.Message, null)); } }
public Response <Item_SizeModel> GetItem_SizeByID(int iItem_SizeID) { try { using (var unitOfWorkStore = new UnitOfWorkStore(dbFactory)) { var rpItem_Size = unitOfWorkStore.GetRepository <Item_Size>(); var obItem_Size = rpItem_Size.GetById(iItem_SizeID); Item_SizeModel Item_SizeModel = new Item_SizeModel() { Item_Size1 = obItem_Size.Item_Size1, Name = obItem_Size.Name }; return(new Response <Item_SizeModel>((int)StatusResponses.Success, MessageResConst.Success, Item_SizeModel)); } } catch (Exception ex) { return(new Response <Item_SizeModel>((int)StatusResponses.ErrorSystem, ex.Message, null)); } }
public Response <CustomerModel> UpdateCustomer(CustomerModel CustomerModel) { try { using (var unitOfWorkStore = new UnitOfWorkStore(dbFactory)) { var rpCustomer = unitOfWorkStore.GetRepository <Customer>(); Customer CustomerEntity = rpCustomer.GetById(CustomerModel.Customer_ID); CustomerEntity.Customer_ID = CustomerModel.Customer_ID; CustomerEntity.Customer_Code = CustomerModel.Customer_Code; CustomerEntity.Name = CustomerModel.Name; CustomerEntity.Phone = CustomerModel.Phone; CustomerEntity.Email = CustomerModel.Email; CustomerEntity.Address = CustomerModel.Address; CustomerEntity.Birthday = CustomerModel.Birthday; CustomerEntity.Category = CustomerModel.Category; CustomerEntity.Company_Name = CustomerModel.Company_Name; CustomerEntity.Tax_Code = CustomerModel.Tax_Code; CustomerEntity.Url = CustomerModel.Url == null? CustomerEntity.Url : CustomerModel.Url; CustomerEntity.Sex = CustomerModel.Sex; CustomerEntity.Note = CustomerModel.Note; rpCustomer.Update(CustomerEntity); if (unitOfWorkStore.Save() >= 1) { CustomerModel.Customer_Code = CustomerEntity.Customer_Code; return(new Response <CustomerModel>((int)StatusResponses.Success, MessageResConst.Success, CustomerModel)); } else { return(new Response <CustomerModel>((int)StatusResponses.ErrorSystem, MessageResConst.ErrorCommonRequestParam, CustomerModel)); } } } catch (Exception ex) { return(new Response <CustomerModel>((int)StatusResponses.ErrorSystem, ex.Message, null)); } }
public Response <ImageModel> GetImageByID(int iImageID) { try { using (var unitOfWorkStore = new UnitOfWorkStore(dbFactory)) { var rpImage = unitOfWorkStore.GetRepository <Image>(); var obImage = rpImage.GetById(iImageID); ImageModel ImageModel = new ImageModel() { Image_ID = obImage.Image_ID, Name = obImage.Name, Url = obImage.Url }; return(new Response <ImageModel>((int)StatusResponses.Success, MessageResConst.Success, ImageModel)); } } catch (Exception ex) { return(new Response <ImageModel>((int)StatusResponses.ErrorSystem, ex.Message, null)); } }
public Response <GroupItemModel> GetGroupItemByID(int iGroupItemID) { try { using (var unitOfWorkStore = new UnitOfWorkStore(dbFactory)) { var rpGroupItem = unitOfWorkStore.GetRepository <GroupItem>(); var obGroupItem = rpGroupItem.GetById(iGroupItemID); GroupItemModel GroupItemModel = new GroupItemModel() { GroupItem_ID = obGroupItem.GroupItem_ID, GroupItem_Code = obGroupItem.GroupItem_Code, Name = obGroupItem.Name }; return(new Response <GroupItemModel>((int)StatusResponses.Success, MessageResConst.Success, GroupItemModel)); } } catch (Exception ex) { return(new Response <GroupItemModel>((int)StatusResponses.ErrorSystem, ex.Message, null)); } }
public Response <GroupItemModel> Delete(int idGroupItem) { try { using (var unitOfWorkStore = new UnitOfWorkStore(dbFactory)) { var rpGroupItem = unitOfWorkStore.GetRepository <GroupItem>(); GroupItem GroupItemEntity = rpGroupItem.GetById(idGroupItem); rpGroupItem.Delete(GroupItemEntity); if (unitOfWorkStore.Save() >= 1) { return(new Response <GroupItemModel>((int)StatusResponses.Success, MessageResConst.Success, null)); } else { return(new Response <GroupItemModel>((int)StatusResponses.ErrorSystem, MessageResConst.ErrorCommonRequestParam, null)); } } } catch (Exception ex) { return(new Response <GroupItemModel>((int)StatusResponses.ErrorSystem, ex.Message, null)); } }
public Response <Item_MaterialModel> Delete(int idItem_Material) { try { using (var unitOfWorkStore = new UnitOfWorkStore(dbFactory)) { var rpItem_Material = unitOfWorkStore.GetRepository <Item_Material>(); Item_Material Item_MaterialEntity = rpItem_Material.GetById(idItem_Material); rpItem_Material.Delete(Item_MaterialEntity); if (unitOfWorkStore.Save() >= 1) { return(new Response <Item_MaterialModel>((int)StatusResponses.Success, MessageResConst.Success, null)); } else { return(new Response <Item_MaterialModel>((int)StatusResponses.ErrorSystem, MessageResConst.ErrorCommonRequestParam, null)); } } } catch (Exception ex) { return(new Response <Item_MaterialModel>((int)StatusResponses.ErrorSystem, ex.Message, null)); } }
public Response <BranchModel> Delete(int idBranch) { try { using (var unitOfWorkStore = new UnitOfWorkStore(dbFactory)) { var rpBranch = unitOfWorkStore.GetRepository <Branch>(); Branch BranchEntity = rpBranch.GetById(idBranch); rpBranch.Delete(BranchEntity); if (unitOfWorkStore.Save() >= 1) { return(new Response <BranchModel>((int)StatusResponses.Success, MessageResConst.Success, null)); } else { return(new Response <BranchModel>((int)StatusResponses.ErrorSystem, MessageResConst.ErrorCommonRequestParam, null)); } } } catch (Exception ex) { return(new Response <BranchModel>((int)StatusResponses.ErrorSystem, ex.Message, null)); } }
// Hàm update dữ liệu public Response <VendorModel> UpdateVendor(VendorModel vendorModel) { try { using (var unitOfWorkStore = new UnitOfWorkStore(dbFactory)) { var rpVendor = unitOfWorkStore.GetRepository <Vendor>(); Vendor vendorEntity = rpVendor.GetById(vendorModel.Vendor_ID); vendorEntity.Vendor_ID = vendorModel.Vendor_ID; vendorEntity.Vendor_Code = vendorModel.Vendor_Code; vendorEntity.Name = vendorModel.Name; vendorEntity.Tax_Code = vendorModel.Tax_Code; vendorEntity.Phone = vendorModel.Phone; vendorEntity.Address = vendorModel.Address; vendorEntity.Region = vendorModel.Region; vendorEntity.CommuneWard = vendorModel.CommuneWard; vendorEntity.Email = vendorModel.Email; vendorEntity.Group_Vendor = vendorModel.Group_Vendor; vendorEntity.Note = vendorModel.Note; rpVendor.Update(vendorEntity); if (unitOfWorkStore.Save() >= 1) { vendorModel.Vendor_Code = vendorEntity.Vendor_Code; return(new Response <VendorModel>((int)StatusResponses.Success, MessageResConst.Success, vendorModel)); } else { return(new Response <VendorModel>((int)StatusResponses.ErrorSystem, MessageResConst.ErrorCommonRequestParam, vendorModel)); } } } catch (Exception ex) { return(new Response <VendorModel>((int)StatusResponses.ErrorSystem, ex.Message, null)); } }