public JsonResult UpdateEmployess(EmployeeModel model)
{
var Messaging = new RenderMessaging();
try
{
if (User == null)
{
Messaging.isError = true;
Messaging.messaging = "Phiên đăng nhập đã hết hạn.";
return(Json(Messaging, JsonRequestBehavior.AllowGet));
}
if (model.Id <= 0 && (string.IsNullOrEmpty(model.Pwd) || model.Pwd.Length <= 5))
{
Messaging.isError = true;
Messaging.messaging = "Mật khẩu không hợp lệ.";
return(Json(Messaging, JsonRequestBehavior.AllowGet));
}
if (string.IsNullOrEmpty(model.Email))
{
Messaging.isError = true;
Messaging.messaging = "Email không được rỗng!";
return(Json(Messaging, JsonRequestBehavior.AllowGet));
}
var objEmployee = Mapper.Map <sys_Employee>(model);
if (model.Id <= 0)
{
objEmployee.DateCreate = DateTime.Now;
objEmployee.EmployeeCreate = User.UserId;
objEmployee.DateUpdate = null;
_crud.Add <sys_Employee>(objEmployee);
}
else
{
var employee = _context.sys_Employee.Find(model.Id);
objEmployee.DateCreate = employee.DateCreate;
objEmployee.DateUpdate = DateTime.Now;
objEmployee.EmployeeUpdate = User.UserId;
//objEmployee.IsDisable = model.IsDisable;
objEmployee.Pwd = !string.IsNullOrEmpty(model.Pwd) ? model.Pwd : employee.Pwd;
_crud.Update <sys_Employee>(objEmployee, o => o.Titles, o => o.IsDisable, o => o.Pwd, o => o.Address, o => o.Email, o => o.Name, o => o.Phone, o => o.Phone, o => o.DateUpdate, o => o.EmployeeUpdate, o => o.Roles, o => o.Titles);
}
_crud.SaveChanges();
Messaging.messaging = "Cập nhật nhân viên thành công!";
}
catch (Exception ex)
{
Messaging.isError = true;
Messaging.messaging = "Cập nhật nhân viên không thành công!";
}
return(Json(Messaging, JsonRequestBehavior.AllowGet));
}
public ResourceRule Create(Resource resource, Rule rule)
{
var lnk = LinkLookup.First(l => l.ResourceId == resource.ResourceId);
if (lnk == null)
{
return(null);
}
var rl = RuleLookup.First(r => r.RuleId == rule.RuleId);
if (rl == null)
{
return(null);
}
var lnkr = new ResourceRule()
{
Resource = lnk, Rule = rl
};
CRUD.Add(lnkr);
return(lnkr);
}
public JsonResult Create(string model)
{
CategoryModel newCategory = JsonConvert.DeserializeObject <CategoryModel>(model);
var newDBCategory = CreateCategoryDBModel(newCategory);
CategoriesCRUD.Add(newDBCategory, true);
ClearReadCache();
return(Json(JsonConvert.SerializeObject(new { id = newDBCategory.Id }), JsonRequestBehavior.AllowGet));
}
public JsonResult Create(string model)
{
TargetGroupsModel newTargetGroups = JsonConvert.DeserializeObject <TargetGroupsModel>(model);
var newDBTargetGroups = CreateTargetGroupsDBModel(newTargetGroups);
TargetGroupsCRUD.Add(newDBTargetGroups, true);
ClearReadCache();
return(Json(JsonConvert.SerializeObject(new { id = newDBTargetGroups.Id }), JsonRequestBehavior.AllowGet));
}
public JsonResult CreateProductsSwitch(OrderModel model)
{
var Messaging = new RenderMessaging();
try
{
if (User == null)
{
Messaging.isError = true;
Messaging.messaging = "Phiên đăng nhập đã hết hạn.";
return(Json(Messaging, JsonRequestBehavior.AllowGet));
}
if (model.Detail.Count <= 0)
{
Messaging.isError = true;
Messaging.messaging = "Dữ liệu không hợp lệ, vui lòng kiểm tra lại";
return(Json(Messaging, JsonRequestBehavior.AllowGet));
}
var objOrder = Mapper.Map <soft_Order>(model);
objOrder.Id_From = User.BranchesId;
objOrder.Id_To = User.BranchesId;
objOrder.DateCreate = DateTime.Now;
objOrder.EmployeeCreate = User.UserId;
objOrder.TypeOrder = (int)TypeOrder.Switch;
objOrder.Status = (int)StatusOrder_Switch.Done;
_crud.Add <soft_Order>(objOrder);
UpdateStockByBranches(objOrder);
_crud.SaveChanges();
Messaging.messaging = "Đã tạo phiếu điều chỉnh thành công!";
}
catch (Exception ex)
{
Messaging.isError = true;
Messaging.messaging = "Tạo phiếu điều chỉnh không thành công!";
}
return(Json(Messaging, JsonRequestBehavior.AllowGet));
}
public Resource AddLink(string userId, string URL)
{
var link = new Resource()
{
URL = URL,
UserId = userId
};
CRUD.Add(link);
return(link);
}
public void CRUD_Insertion_And_ReadingTest_Exception()
{
Specialization specialization = new Specialization()
{
ID = 1, Name = "Phisic1"
};
CRUD <Specialization> crud = new CRUD <Specialization>();
crud.Add(specialization, "ID");
Specialization t_specialization = crud.Get(t => t.ID == specialization.ID);
}
public JsonResult CreateProduct(ProductSampleModel model)
{
var Messaging = new RenderMessaging();
try
{
if (User == null || User.UserId < 0)
{
Messaging.isError = true;
Messaging.messaging = "Vui lòng đăng nhập lại!";
return(Json(Messaging, JsonRequestBehavior.AllowGet));
}
model.masp = model.masp.Replace(" ", "");
var msError = Validate_Product(model);
if (msError != null)
{
return(Json(msError, JsonRequestBehavior.AllowGet));
}
var data = new shop_sanpham
{
tensp = model.tensp,
masp = model.masp,
Barcode = model.Barcode,
PriceCompare = 0,
PriceBase = 0,
PriceBase_Old = 0,
PriceInput = 0,
hide = false,
Status = model.Status,
Note = model.Note,
DateCreate = DateTime.Now,
FromCreate = (int)TypeFromCreate.Soft
};
_crud.Add <shop_sanpham>(data);
_crud.SaveChanges();
Messaging.isError = false;
Messaging.messaging = "Thêm sản phẩm thành công.";
}
catch (Exception ex)
{
Messaging.isError = true;
Messaging.messaging = "Tạo sản phẩm không thành công!";
}
return(Json(Messaging, JsonRequestBehavior.AllowGet));
}
public static bool Create(T user)
{
try
{
user.Password = BLEncrypt.Encrypt(user.Password);
CRUD <T> .Add(user);
return(true);
}
catch (Exception)
{
return(false);
}
}
public void CRUD_Delete_Test()
{
Specialization specialization = new Specialization()
{
ID = 99, Name = "Phisic"
};
CRUD <Specialization> crud = new CRUD <Specialization>();
crud.Add(specialization, "ID");
crud.Delete(item => item.ID == specialization.ID);
Specialization t_specialization = crud.Get(t => t.ID == specialization.ID);
Assert.IsNull(t_specialization);
}
public JsonResult CreateOrder_Suppliers(OrderModel model)
{
var Messaging = new RenderMessaging();
try
{
if (User == null)
{
Messaging.isError = true;
Messaging.messaging = "Phiên đăng nhập đã hết hạn.";
return(Json(Messaging, JsonRequestBehavior.AllowGet));
}
foreach (var item in model.Detail)
{
var product = _context.shop_sanpham.Find(item.ProductId);
if (product == null)
{
Messaging.isError = true;
Messaging.messaging = "Sản phẩm không tồn tại, vui lòng thử lại.";
return(Json(Messaging, JsonRequestBehavior.AllowGet));
}
}
var objOrder = Mapper.Map <soft_Order>(model);
objOrder.Status = (int)StatusOrder_Suppliers.Process;
objOrder.DateCreate = DateTime.Now;
objOrder.EmployeeCreate = User.UserId;
objOrder.TypeOrder = (int)TypeOrder.OrderProduct;
objOrder.Id_From = User.BranchesId;
objOrder.Id_To = null;
foreach (var item in objOrder.soft_Order_Child)
{
item.Status = (int)StatusOrder_Suppliers.Process;
}
_crud.Add <soft_Order>(objOrder);
_crud.SaveChanges();
Messaging.messaging = "Đã tạo phiếu đặt hàng.";
}
catch
{
Messaging.isError = true;
Messaging.messaging = "Tạo phiếu đặt hàng nhà phân phối không thành công!";
}
return(Json(Messaging, JsonRequestBehavior.AllowGet));
}
public void CRUD_Insertion_And_ReadingTest()
{
Specialization specialization = new Specialization()
{
ID = 99, Name = "Phisic"
};
CRUD <Specialization> crud = new CRUD <Specialization>();
crud.Add(specialization, "ID");
Specialization t_specialization = crud.Get(t => t.ID == specialization.ID);
Assert.AreEqual(t_specialization.ID, specialization.ID);
Assert.AreEqual(t_specialization.Name.Trim(), specialization.Name);
crud.Delete(item => item.ID == t_specialization.ID);
}
public void CRUD_Update_Test()
{
Specialization specialization = new Specialization()
{
ID = 99, Name = "Phisic"
};
Specialization newSpecialization = new Specialization()
{
ID = 99, Name = "Chemical-engeneer"
};
CRUD <Specialization> crud = new CRUD <Specialization>();
crud.Add(specialization, "ID");
crud.Update(newSpecialization, e => e.ID == newSpecialization.ID);
Specialization t_specialization = crud.Get(t => t.ID == specialization.ID);
Assert.AreEqual(t_specialization.ID, newSpecialization.ID);
Assert.AreEqual(t_specialization.Name.Trim(), newSpecialization.Name);
crud.Delete(item => item.ID == t_specialization.ID);
}
public MVCResult <string> InsertCustomers(Customers model)
{
return(CRUD <Customers> .Add(model));
}
static void Main(string[] args)
{
CRUD cRUD = new CRUD();
do
{
Console.Clear();
Console.WriteLine("**************************EMPLOYEE MANAGEMENT SYSTEM MENU******************************");
Console.WriteLine("1. Add an Employee");
Console.WriteLine("2. View Employee details");
Console.WriteLine("3. Search Employee details");
Console.WriteLine("4. Modify Employee details");
Console.WriteLine("5. Remove Employee details");
Console.WriteLine("6. Exit");
Console.WriteLine("----------------------------------------------------------------------------------------");
Console.Write("Enter Your Choice Here:-");
int choose_number = Convert.ToInt32(Console.ReadLine());
int search_Id;
switch (choose_number)
{
case 1:
Console.WriteLine("Add staff input 1");
Console.WriteLine("Add manager input 2");
Console.WriteLine("Add boss input 3");
int input = Convert.ToInt32(Console.ReadLine());
cRUD.Add(input);
break;
case 2:
cRUD.Show();
break;
case 3:
Console.WriteLine("Enter your search type:");
Console.WriteLine("Input 1 to search id");
Console.WriteLine("Input 2 to search name");
Console.WriteLine("Input 3 to search chucvu");
int search_type = Convert.ToInt32(Console.ReadLine());
switch (search_type)
{
case 1:
Console.WriteLine("Enter search ID");
var id = Convert.ToInt32(Console.ReadLine());
cRUD.FindID(id);
break;
case 2:
Console.WriteLine("Enter search name");
var name = Console.ReadLine();
cRUD.FindName(name);
break;
case 3:
Console.WriteLine("Enter search chuc vu");
var chucvu = Console.ReadLine();
cRUD.FindChucVu(chucvu);
break;
}
Console.WriteLine("No validated choice...!!!");
break;
case 4:
Console.WriteLine("Enter Employee Id Which You Want To Search:");
search_Id = Convert.ToInt32(Console.ReadLine());
if (search_Id != null)
{
cRUD.Update(search_Id);
}
else
{
Console.WriteLine("Record Not Found...!!!");
}
break;
case 5:
Console.WriteLine("Enter Employee Id Which You Want To delete:");
search_Id = Convert.ToInt32(Console.ReadLine());
if (search_Id != null)
{
cRUD.Delete(search_Id);
}
else
{
Console.WriteLine("Record Not Found...!!!");
}
break;
case 6:
Environment.Exit(0);
break;
default:
Console.WriteLine("Invalid Choice....!!! Please Enter Correct Choice...!!!");
break;
}
Console.Write("Would You Like To Continue(Y/N):");
ans = Convert.ToChar(Console.ReadLine());
} while (ans == 'y' || ans == 'Y');
}
public MVCResult <string> InsertTerritories(Territories model)
{
return(CRUD <Territories> .Add(model));
}
public MVCResult <string> InsertEmployees(Employees model)
{
return(CRUD <Employees> .Add(model));
}
public async Task <JsonResult> CreateOrder_Output(OrderModel model)
{
var Messaging = new RenderMessaging();
try
{
if (User == null || User.BranchesId <= 0 || User.ChannelId <= 0)
{
Messaging.isError = true;
Messaging.messaging = "Phiên đăng nhập đã hết hạn.";
return(Json(Messaging, JsonRequestBehavior.AllowGet));
}
model.Id_From = User.BranchesId;
if (model.Id_To <= 0)
{
Messaging.isError = true;
Messaging.messaging = "Vui lòng chọn Kho bạn xuất đến.";
return(Json(Messaging, JsonRequestBehavior.AllowGet));
}
var Braches = _context.soft_Branches.Where(o => o.BranchesId == model.Id_To || o.BranchesId == User.BranchesId).ToList();
var BrachesTo = Braches.FirstOrDefault(o => o.BranchesId == model.Id_To);
if (model.Id_To == User.BranchesId || BrachesTo == null)
{
Messaging.isError = true;
Messaging.messaging = "Kho xuất không hơp lệ";
return(Json(Messaging, JsonRequestBehavior.AllowGet));
}
if (model.Detail.Count <= 0)
{
Messaging.isError = true;
Messaging.messaging = "Vui lòng chọn sản phẩm xuất.";
return(Json(Messaging, JsonRequestBehavior.AllowGet));
}
foreach (var item in model.Detail)
{
var product = _context.shop_sanpham.Find(item.ProductId);
if (product == null)
{
Messaging.isError = true;
Messaging.messaging = "Sản phẩm không tồn tại, vui lòng thử lại.";
return(Json(Messaging, JsonRequestBehavior.AllowGet));
}
var productstock = _context.soft_Branches_Product_Stock.FirstOrDefault(o => o.BranchesId == User.BranchesId && o.ProductId == item.ProductId);
if (productstock != null)
{
if (productstock.Stock_Total < item.Total)
{
Messaging.isError = true;
Messaging.messaging = "Số lượng sản phẩm " + product.tensp + " không đủ để xuất, vui lòng thử lại.";
return(Json(Messaging, JsonRequestBehavior.AllowGet));
}
}
else
{
Messaging.isError = true;
Messaging.messaging = "Số lượng sản phẩm " + product.tensp + " không đủ để xuất, vui lòng thử lại.";
return(Json(Messaging, JsonRequestBehavior.AllowGet));
}
}
var objOrder = Mapper.Map <soft_Order>(model);
objOrder.Code = "PX" + DateTime.Now.ToString("dd/MM/yy").Replace("/", "") + "-" + BrachesTo.Code;
objOrder.Status = (int)StatusOrder_Output.Process;
objOrder.DateCreate = DateTime.Now;
objOrder.EmployeeCreate = User.UserId;
objOrder.TypeOrder = (int)TypeOrder.Output;
_crud.Add <soft_Order>(objOrder);
_crud.SaveChanges();
objOrder.Code = "PX" + DateTime.Now.ToString("dd/MM/yy").Replace("/", "") + "-" + BrachesTo.Code + "-" + objOrder.Id;
if (model.OrderFromId.HasValue)
{
var orderFromBranches = _unitOW.OrderBranchesRepository.FindBy(o => o.Id == model.OrderFromId.Value && o.TypeOrder == (int)TypeOrder.OrderBranches).FirstOrDefault();
if (orderFromBranches != null)
{
orderFromBranches.Status = (int)StatusOrder_Branches.Exported;
_unitOW.OrderBranchesRepository.Update(orderFromBranches, o => o.Status);
await _unitOW.SaveChanges();
}
}
_unitOW.NotificationRepository.Add(new soft_Notification
{
Contents = "Đơn hàng xuất " + objOrder.Code + " từ kho " + Braches.FirstOrDefault(o => o.BranchesId == User.BranchesId).BranchesName + " đến kho " + BrachesTo.BranchesName + " cần được xử lý",
Branch = model.Id_To,
DateCreate = DateTime.Now,
Type = (int)TypeNotification.OrderOut,
Href = "/Order_Input/RenderView"
});
await _unitOW.SaveChanges();
Messaging.messaging = "Đã tạo phiếu xuất hàng.";
}
catch
{
Messaging.isError = true;
Messaging.messaging = "Tạo phiếu xuất không thành công!";
}
return(Json(Messaging, JsonRequestBehavior.AllowGet));
}
public MVCResult <string> InsertShippers(Shippers model)
{
return(CRUD <Shippers> .Add(model));
}
public MVCResult <string> InsertCustomerDemographics(CustomerDemographics model)
{
return(CRUD <CustomerDemographics> .Add(model));
}
public MVCResult <string> InsertOrders(Orders model)
{
return(CRUD <Orders> .Add(model));
}
public void Add(Rule rule)
{
CRUD.Add(rule);
}
private void UpdateStockByBranches(OrderModel order)
{
foreach (var item in order.Detail)
{
var StockProduct = _context.soft_Branches_Product_Stock.Where(o => o.ProductId == item.ProductId).ToList();
if (order.TypeOrder == (int)TypeOrder.Input)
{
#region Product
var product = _context.shop_sanpham.Find(item.ProductId);
if (product != null)
{
var productObj = new shop_sanpham
{
id = product.id,
PriceBase_Old = product.PriceBase,
PriceInput = (int)item.Price,
PriceCompare = item.PriceCompare
};
var stockbySum = StockProduct != null && StockProduct.Count > 0 ? StockProduct.Sum(o => o.Stock_Total) : 0;
var pricebase_old = product.PriceBase != null ? product.PriceBase : 0;
var chia = (item.Total + stockbySum);
productObj.PriceBase = (int)(((stockbySum * pricebase_old) + (item.Total * (int)item.Price)) / (chia != 0 ? chia : 1));
_crud.Update(productObj, o => o.PriceBase, o => o.PriceInput, o => o.PriceBase_Old, o => o.PriceCompare);
#endregion
#region Stcok
var stockTo = StockProduct.FirstOrDefault(o => o.ProductId == item.ProductId && o.BranchesId == order.Id_To);
if (stockTo != null)
{
var newstock = new soft_Branches_Product_Stock
{
BranchesId = stockTo.BranchesId,
ProductId = stockTo.ProductId,
Stock_Total = stockTo.Stock_Total + item.Total,
DateCreate = stockTo.DateCreate,
EmployeeCreate = stockTo.EmployeeCreate,
DateUpdate = DateTime.Now,
EmployeeUpdate = User.UserId,
};
_crud.Update <soft_Branches_Product_Stock>(newstock, o => o.Stock_Total, o => o.EmployeeUpdate, o => o.DateUpdate);
}
else
{
var stockNewTo = new soft_Branches_Product_Stock
{
BranchesId = order.Id_To,
ProductId = item.ProductId,
Stock_Total = item.Total,
DateCreate = DateTime.Now,
EmployeeCreate = order.EmployeeCreate
};
_crud.Add <soft_Branches_Product_Stock>(stockNewTo);
}
#endregion
}
}
if (order.TypeOrder == (int)TypeOrder.Output)
{
var stockTo = StockProduct.FirstOrDefault(o => o.ProductId == item.ProductId && o.BranchesId == order.Id_To);
var stockFrom = StockProduct.FirstOrDefault(o => o.ProductId == item.ProductId && o.BranchesId == order.Id_From);
if (stockTo != null)
{
var newstock = new soft_Branches_Product_Stock
{
BranchesId = stockTo.BranchesId,
ProductId = stockTo.ProductId,
Stock_Total = stockTo.Stock_Total + item.Total,
DateCreate = stockTo.DateCreate,
EmployeeCreate = stockTo.EmployeeCreate,
DateUpdate = DateTime.Now,
EmployeeUpdate = User.UserId,
};
_crud.Update <soft_Branches_Product_Stock>(newstock, o => o.Stock_Total, o => o.EmployeeUpdate, o => o.DateUpdate);
}
else
{
stockTo = new soft_Branches_Product_Stock
{
ProductId = item.ProductId,
BranchesId = User.BranchesId,
DateCreate = DateTime.Now,
Stock_Total = item.Total,
EmployeeCreate = User.UserId
};
_crud.Add(stockTo);
}
if (stockFrom != null)
{
var newstock = new soft_Branches_Product_Stock
{
BranchesId = stockFrom.BranchesId,
ProductId = stockFrom.ProductId,
Stock_Total = stockFrom.Stock_Total - item.Total,
DateCreate = stockFrom.DateCreate,
EmployeeCreate = stockFrom.EmployeeCreate,
DateUpdate = order.DateCreate,
EmployeeUpdate = order.EmployeeCreate,
};
_crud.Update(newstock, o => o.Stock_Total, o => o.EmployeeUpdate, o => o.DateUpdate);
}
else
{
var stockNewTo = new soft_Branches_Product_Stock
{
BranchesId = order.Id_From,
ProductId = item.ProductId,
Stock_Total = 0 - item.Total,
DateCreate = order.DateCreate,
EmployeeCreate = order.EmployeeCreate,
DateUpdate = null,
EmployeeUpdate = null
};
_crud.Add <soft_Branches_Product_Stock>(stockNewTo);
}
}
}
}
public MVCResult <string> InsertRegion(Region model)
{
return(CRUD <Region> .Add(model));
}
public MVCResult <string> InsertProducts(Products model)
{
return(CRUD <Products> .Add(model));
}
public MVCResult <string> InsertSuppliers(Suppliers model)
{
return(CRUD <Suppliers> .Add(model));
}
public MVCResult <string> InsertCategories(Categories model)
{
return(CRUD <Categories> .Add(model));
}
