public JsonResult AjaxCall()
{
ResponseJson response = new ResponseJson();
response.IsError = true;
response.Id = -10;
return Json(response, JsonRequestBehavior.AllowGet);
}
//[ValidateAntiForgeryToken]
public async Task<ActionResult> Login(LoginViewModel model, string returnUrl)
{
ResponseJson response = new ResponseJson();
try
{
if (ModelState.IsValid)
{
using (UserDB db = new UserDB())
{
var user = db.LogIn(model.UserName, Globals.Encrypt(model.Password)).SingleOrDefault();
if (user != null)
{
await SignInAsync(new ApplicationUser() { UserName = model.UserName }, model.RememberMe);
//return RedirectToLocal(returnUrl);
}
else
{
response.IsError = true;
response.Id = -3;
}
}
}
}
catch (Exception ex)
{
response.IsError = true;
response.Id = -6;
}
return Json(response, JsonRequestBehavior.AllowGet);
}
public static ResponseJson Send(string to, string subject, string body)
{
ResponseJson response = new ResponseJson();
try
{
MailMessage mail = new MailMessage();
mail.To.Add(to);
mail.From = new MailAddress("*****@*****.**");
mail.Subject = subject;
string Body = body;
mail.Body = Body;
mail.IsBodyHtml = true;
SmtpClient smtp = new SmtpClient();
smtp.Host = "smtp.gmail.com";
smtp.Port = 587;
smtp.UseDefaultCredentials = false;
smtp.Credentials = new System.Net.NetworkCredential("*****@*****.**", "NsVtEa1&Ei+iGbZK");// Enter seders User name and password
smtp.EnableSsl = true;
smtp.Send(mail);
}
catch (Exception e)
{
response.IsError = true;
response.Id = -6;
}
return response;
}
public ActionResult Get(Page model)
{
ResponseJson response = new ResponseJson() { Data = new List<object>() };
var data = new Pagger<dynamic>();
using (AppDB db = new AppDB())
{
response = IEnumerableData.GetPageResponse<StyleModel>(model, (from s in db.Styles
join b in db.Buyers on s.BuyerId equals b.Id
join st in db.Status on s.Status equals st.Id
select new StyleModel() {
BarCode=s.BarCode,
Buyer=b.Name,
BuyerId=s.BuyerId,
Id=s.Id,
Name=s.Name,
Quantity=s.Quantity,
Status=st.Name,
StatusId=st.Id,
ShippingDate=s.ShippingDate,
Description=s.Description,
YarnType=s.YarnType,
Size=s.Size,
}));
}
return Json(response, JsonRequestBehavior.AllowGet);
}
public ActionResult Get(Page model)
{
ResponseJson response = new ResponseJson() { Data = new List<object>() };
var data = new Pagger<dynamic>();
using (AppDB db = new AppDB())
{
response = IEnumerableData.GetPageResponse<BundleModel>(model, (from b in db.Bundles
join s in db.Styles on b.StyleId equals s.Id
join st in db.Status on b.Status equals st.Id
join o in db.Employees on b.OperatorId equals o.Id
join l in db.Employees on b.LinkingBy equals l.Id
where b.Status == 2
select new BundleModel()
{
BarCode = b.BarCode,
Style = s.Name,
StyleId = b.StyleId,
Id = b.Id,
Quantity = b.Quantity,
Status = st.Name,
StatusId = st.Id,
KnittingMachine = b.KnittingMachine,
LinkingEndAt = b.LinkingEndAt,
OperatorId = b.OperatorId,
Operator = o.Name,
LinkingBy = l.Name,
LinkingById = l.Id
}));
}
return Json(response, JsonRequestBehavior.AllowGet);
}
public ActionResult Details(Guid id)
{
ResponseJson response = new ResponseJson();
using (AppDB db = new AppDB())
{
response.Data = (from o in db.Orders
join b in db.Buyers on o.BuyerId equals b.Id
where o.Status != 10
select new OrderModel()
{
Id = b.Id,
Buyer = b.Name,
BuyerId = o.BuyerId,
CodeNumber = o.CodeNumber,
Color = o.Color,
DeliveryDate = o.DeliveryDate,
Description = o.Description,
Size = o.Size,
Style = o.Style,
Quantity = o.TotalQuantity,
Completed = o.TotalCompleted,
ProductionStartAT = o.ProductionStartAT,
CurrentDate = DateTime.Now
}).ToList();
}
return Json(response, JsonRequestBehavior.AllowGet);
}
//
// GET: /Menu/
public ActionResult Get()
{
ResponseJson response = new ResponseJson() { };
if (IsLogedIn)
{
response.Data = Menu.Get(Roles);
}
return Json(response, JsonRequestBehavior.AllowGet);
}
public ActionResult Seller()
{
ResponseJson response = new ResponseJson();
using (AppDB db = new AppDB())
{
response.Data = db.Sellers.OrderBy(c => c.Name).Select(s => new { text = s.Name, value = s.Id }).ToList();
}
return Json(response, JsonRequestBehavior.AllowGet);
}
public ActionResult Designations()
{
ResponseJson response = new ResponseJson();
using (AppDB db = new AppDB())
{
var currentRole = db.Roles.Where(r => CurrentUser.Roles.Contains(r.Code)).Min(r => r.Priority);
response.Data = db.Roles.Where(r => r.Priority > currentRole).OrderBy(c => c.Priority).Select(s => new { text = s.Name, value = s.Code }).ToList();
}
return Json(response, JsonRequestBehavior.AllowGet);
}
public ActionResult Create(OrderModel model)
{
ResponseJson response = new ResponseJson();
try
{
if (!ModelState.IsValid)
{
return Json(Globals.SetValidationError(ModelState));
}
//response = Validation(response, model);
//if (response.IsError)
//{
// return Json(response);
//}
//ObjectParameter ErrorCode = new ObjectParameter("ErrorCode", 0);
UpdatedInfoModel updatedInfo = new UpdatedInfoModel() { Comment = "Order Created", Type = 1, UpdatedTime = DateTime.Now, UserId = CurrentUser.Id };
string login = "";
using (AppDB db = new AppDB())
{
DAL.Order order = new DAL.Order()
{
BuyerId = model.BuyerId,
CodeNumber = "",
Color = model.Color,
CreatedBy = CurrentUser.Id,
DeliveryDate = model.DeliveryDate,
Description = model.Description,
Id = Guid.NewGuid(),
OrderDate = DateTime.Now,
Size = model.Size,
Status = 0,
Style = model.Style,
TotalQuantity = model.Quantity,
UpdateInfo = new JavaScriptSerializer().Serialize(updatedInfo)
};
db.Orders.Add(order);
db.SaveChanges();
//EmailSender.SendToCHWUser(model.Email, login, login, model.Surname, "Sector Executive Officer");
}
}
catch (Exception ex)
{
response.IsError = true;
response.Id = -6;
}
return Json(response);
}
public ActionResult Create(SellerModel model)
{
ResponseJson response = new ResponseJson();
try
{
if (!ModelState.IsValid)
{
return Json(Globals.SetValidationError(ModelState));
}
//response = Validation(response, model);
//if (response.IsError)
//{
// return Json(response);
//}
//ObjectParameter ErrorCode = new ObjectParameter("ErrorCode", 0);
UpdatedInfoModel updatedInfo = new UpdatedInfoModel() { Comment = "Seller Created", Type = 1, UpdatedTime = DateTime.Now, UserId = CurrentUser.Id };
using (AppDB db = new AppDB())
{
DAL.Seller seller = new DAL.Seller()
{
CreatedBy = CurrentUser.Id,
Description = model.Description,
Id = Guid.NewGuid(),
Name=model.Name,
CreatedAt = DateTime.Now,
Phone = model.Phone,
Email = model.Email,
Address = model.Address,
UpdateInfo = new JavaScriptSerializer().Serialize(updatedInfo)
};
db.Sellers.Add(seller);
db.SaveChanges();
response.Data = new { Id = seller.Id, Name = seller.Name };
//EmailSender.SendToCHWUser(model.Email, login, login, model.Surname, "Sector Executive Officer");
}
}
catch (Exception ex)
{
response.IsError = true;
response.Id = -6;
}
return Json(response);
}
public ActionResult Save(string employeeBarCode, string bundleBarCode)
{
ResponseJson response = new ResponseJson();
try
{
if (!ModelState.IsValid)
{
return Json(Globals.SetValidationError(ModelState));
}
UpdatedInfoModel updatedInfo = new UpdatedInfoModel() { Comment = "Linking Started", Type = 4, UpdatedTime = DateTime.Now, UserId = CurrentUser.Id };
using (AppDB db = new AppDB())
{
var bundle = db.Bundles.Where(s => s.BarCode == bundleBarCode).SingleOrDefault();
var employee = db.Employees.Where(s => s.BarCode == employeeBarCode).SingleOrDefault();
if (bundle != null && bundle.Status !=2 && employee != null)
{
bundle.LinkingStartAt = DateTime.Now;
bundle.LinkingBy = employee.Id;
bundle.Status = 2;
bundle.UpdateInfo += "," + new JavaScriptSerializer().Serialize(updatedInfo);
db.SaveChanges();
}
else if (bundle == null)
{
response.IsError = true;
response.Id = -11;
}
else if (bundle.Status == 2)
{
response.IsError = true;
response.Id = -12;
}
else
{
response.IsError = true;
response.Id = -13;
}
}
}
catch (Exception ex)
{
response.IsError = true;
response.Id = -6;
}
return Json(response);
}
public ActionResult Create(StyleModel model)
{
ResponseJson response = new ResponseJson();
try
{
if (!ModelState.IsValid)
{
return Json(Globals.SetValidationError(ModelState));
}
//response = Validation(response, model);
//if (response.IsError)
//{
// return Json(response);
//}
//ObjectParameter ErrorCode = new ObjectParameter("ErrorCode", 0);
UpdatedInfoModel updatedInfo = new UpdatedInfoModel() { Comment = "Style Created", Type = 1, UpdatedTime = DateTime.Now, UserId = CurrentUser.Id };
using (AppDB db = new AppDB())
{
DAL.Style style = new DAL.Style()
{
Id=Guid.NewGuid(),
BuyerId = model.BuyerId,
BarCode = Globals.GetBarCode(),
Name = model.Name,
CreatedBy = CurrentUser.Id,
YarnType = model.YarnType,
Size = model.Size,
Description = model.Description,
ShippingDate = model.ShippingDate,
Status = 0,
CreatedAt = DateTime.Now,
Quantity = model.Quantity,
UpdateInfo = new JavaScriptSerializer().Serialize(updatedInfo)
};
db.Styles.Add(style);
db.SaveChanges();
//EmailSender.SendToCHWUser(model.Email, login, login, model.Surname, "Sector Executive Officer");
}
}
catch (Exception ex)
{
response.IsError = true;
response.Id = -6;
}
return Json(response);
}
public ActionResult Save(string bundleBarCode)
{
ResponseJson response = new ResponseJson();
try
{
if (!ModelState.IsValid)
{
return Json(Globals.SetValidationError(ModelState));
}
UpdatedInfoModel updatedInfo = new UpdatedInfoModel() { Comment = "Linking Ended", Type = 5, UpdatedTime = DateTime.Now, UserId = CurrentUser.Id };
using (AppDB db = new AppDB())
{
var bundle = db.Bundles.Where(s => s.BarCode == bundleBarCode).SingleOrDefault();
if (bundle != null && bundle.Status==2)
{
bundle.LinkingEndAt = DateTime.Now;
//bundle.LinkingEndAt = employee.Id;
bundle.UpdateInfo += "," + new JavaScriptSerializer().Serialize(updatedInfo);
bundle.Status = 3;
db.SaveChanges();
} else if (bundle == null)
{
response.IsError = true;
response.Id = -11;
}
else if (bundle.Status != 2)
{
response.IsError = true;
response.Id = -12;
} else
{
response.IsError = true;
response.Id = -13;
}
//EmailSender.SendToCHWUser(model.Email, login, login, model.Surname, "Sector Executive Officer");
}
}
catch (Exception ex)
{
response.IsError = true;
response.Id = -6;
}
return Json(response);
}
public ActionResult Create(EmployeeModel model)
{
ResponseJson response = new ResponseJson();
try
{
if (!ModelState.IsValid)
{
return Json(Globals.SetValidationError(ModelState));
}
UpdatedInfoModel updatedInfo = new UpdatedInfoModel() { Comment = "Employee Created", Type = 1, UpdatedTime = DateTime.Now, UserId = CurrentUser.Id };
using (AppDB db = new AppDB())
{
DAL.Employee bundle = new DAL.Employee()
{
Id = Guid.NewGuid(),
Name = model.Name,
BarCode = Globals.GetBarCode(),
CreatedBy = CurrentUser.Id,
UserName = model.UserName,
Password = Globals.Encrypt(model.Password),
Phone = model.Phone,
Email = model.Email,
IsActive = true,
Address = model.Address,
Role = model.Role,
CreatedAt = DateTime.Now,
UpdateInfo = new JavaScriptSerializer().Serialize(updatedInfo)
};
db.Employees.Add(bundle);
db.SaveChanges();
//EmailSender.SendToCHWUser(model.Email, login, login, model.Surname, "Sector Executive Officer");
}
}
catch (Exception ex)
{
response.IsError = true;
response.Id = -6;
}
return Json(response);
}
public ActionResult Create(MaterialModel model)
{
ResponseJson response = new ResponseJson();
try
{
if (!ModelState.IsValid)
{
return Json(Globals.SetValidationError(ModelState));
}
UpdatedInfoModel updatedInfo = new UpdatedInfoModel() { Comment = "Material Created", Type = 1, UpdatedTime = DateTime.Now, UserId = CurrentUser.Id };
using (AppDB db = new AppDB())
{
DAL.Material seller = new DAL.Material()
{
SellerId=model.SellerId,
OrderId=model.OrderId,
Amount=model.Amount,
OrderDate=DateTime.Now,
DeliveryDate=model.DeliveryDate,
CreatedBy = CurrentUser.Id,
Description = model.Description,
Id = Guid.NewGuid(),
CreatedAt = DateTime.Now,
UpdateInfo = new JavaScriptSerializer().Serialize(updatedInfo)
};
db.Materials.Add(seller);
db.SaveChanges();
}
}
catch (Exception ex)
{
response.IsError = true;
response.Id = -6;
}
return Json(response);
}
public ActionResult Details(Guid id)
{
ResponseJson response = new ResponseJson();
using (AppDB db = new AppDB())
{
response.Data = (from b in db.Employees
join e in db.Employees on b.CreatedBy equals e.Id
join r in db.Roles on b.Role equals r.Code
where b.Id == id
select new
{
Name = b.Name,
Email = b.Email,
Phone = b.Phone,
CreatedBy = e.Name,
CreatedAt = b.CreatedAt,
IsActive = b.IsActive,
Role = r.Name
}).SingleOrDefault();
}
return Json(response, JsonRequestBehavior.AllowGet);
}
public ActionResult Details(Guid id)
{
ResponseJson response = new ResponseJson();
using(AppDB db=new AppDB())
{
response.Data = (from b in db.Buyers
join e in db.Employees on b.CreatedBy equals e.Id
where b.Id == id
select new
{
Name = b.Name,
Email = b.Email,
Phone = b.Phone,
CreatedBy=e.Name,
CreatedById=b.CreatedBy,
Description=b.Description,
UpdateInfo=b.UpdateInfo,
CreatedAt = b.CreatedAt
}).SingleOrDefault();
}
return Json(response, JsonRequestBehavior.AllowGet);
}
public ActionResult Create(BundleModel model)
{
ResponseJson response = new ResponseJson();
try
{
if (!ModelState.IsValid)
{
return Json(Globals.SetValidationError(ModelState));
}
UpdatedInfoModel updatedInfo = new UpdatedInfoModel() { Comment = "Bundle Created", Type = 1, UpdatedTime = DateTime.Now, UserId = CurrentUser.Id };
using (AppDB db = new AppDB())
{
DAL.Bundle bundle = new DAL.Bundle()
{
Id = Guid.NewGuid(),
StyleId = model.StyleId,
BarCode = Globals.GetBarCode(),
CreatedBy = CurrentUser.Id,
KnittingMachine = model.KnittingMachine,
OperatorId = model.OperatorId,
Status = 0,
CreatedAt = DateTime.Now,
Quantity = model.Quantity,
UpdateInfo = new JavaScriptSerializer().Serialize(updatedInfo)
};
db.Bundles.Add(bundle);
db.SaveChanges();
//EmailSender.SendToCHWUser(model.Email, login, login, model.Surname, "Sector Executive Officer");
}
}
catch (Exception ex)
{
response.IsError = true;
response.Id = -6;
}
return Json(response);
}
public ActionResult Get(Page model)
{
ResponseJson response = new ResponseJson() { Data = new List<object>() };
using (AppDB db = new AppDB())
{
response = IEnumerableData.GetPageResponse<OrderModel>(model, (from o in db.Orders
join b in db.Buyers on o.BuyerId equals b.Id
where o.Status != 10
select new OrderModel()
{
Id = o.Id,
Buyer = b.Name,
BuyerId = o.BuyerId,
CodeNumber = o.CodeNumber,
Color = o.Color,
DeliveryDate = o.DeliveryDate,
Description = o.Description,
Size = o.Size,
Style = o.Style,
Quantity = o.TotalQuantity,
Completed = o.TotalCompleted,
ProductionStartAT = o.ProductionStartAT,
OrderDate = o.OrderDate,
CurrentDate = DateTime.Now
}).ToList());
}
return Json(response, JsonRequestBehavior.AllowGet);
}
public ActionResult Get(Page model)
{
ResponseJson response = new ResponseJson() { Data = new List<object>() };
using (AppDB db = new AppDB())
{
var currentRole = db.Roles.Where(r => CurrentUser.Roles.Contains(r.Code)).Min(r => r.Priority);
response = IEnumerableData.GetPageResponse<EmployeeModel>(model, (from b in db.Employees
join
r in db.Roles on b.Role equals r.Code
where r.Priority > currentRole
select new EmployeeModel()
{
Id = b.Id,
BarCode = b.BarCode,
Name = b.Name,
Phone = b.Phone,
Email = b.Email,
Address = b.Address,
Role = r.Name,
CreatedAt = b.CreatedAt,
IsActive = b.IsActive
}));
}
return Json(response, JsonRequestBehavior.AllowGet);
}
public ActionResult SaveChange(EmployeeModel model)
{
ResponseJson response = new ResponseJson();
try
{
if (!ModelState.IsValid)
{
return Json(Globals.SetValidationError(ModelState));
}
UpdatedInfoModel updatedInfo = new UpdatedInfoModel() { Comment = "Update Employee", Type = 2, UpdatedTime = DateTime.Now, UserId = CurrentUser.Id };
using (AppDB db = new AppDB())
{
var bundle = db.Employees.Where(s => s.Id == model.Id).SingleOrDefault();
if (bundle != null)
{
bundle.Name = model.Name;
bundle.Phone = model.Phone;
bundle.Email = model.Email;
bundle.Address = model.Address;
bundle.Role = model.Role;
bundle.UpdateInfo += "," + new JavaScriptSerializer().Serialize(updatedInfo);
db.SaveChanges();
}
else
{
response.IsError = true;
response.Id = -3;
}
//EmailSender.SendToCHWUser(model.Email, login, login, model.Surname, "Sector Executive Officer");
}
}
catch (Exception ex)
{
response.IsError = true;
response.Id = -6;
}
return Json(response);
}
public ActionResult Operators()
{
ResponseJson response = new ResponseJson();
using (AppDB db = new AppDB())
{
response.Data = db.Employees.Where(e=>e.Role=="OPT").OrderBy(c => c.Name).Select(s => new { text = s.Name, value = s.Id }).ToList();
}
return Json(response, JsonRequestBehavior.AllowGet);
}
public ActionResult Get(Page model)
{
ResponseJson response = new ResponseJson() { Data = new List<object>() };
using (AppDB db = new AppDB())
{
response = IEnumerableData.GetPageResponse<BuyerModel>(model, (from b in db.Buyers
select new BuyerModel()
{
Id = b.Id,
Name = b.Name,
Phone = b.Phone,
Email = b.Email,
Address = b.Address,
CreatedAt = b.CreatedAt
}));
}
return Json(response, JsonRequestBehavior.AllowGet);
}
public ActionResult SaveChange(StyleModel model)
{
ResponseJson response = new ResponseJson();
try
{
if (!ModelState.IsValid)
{
return Json(Globals.SetValidationError(ModelState));
}
UpdatedInfoModel updatedInfo = new UpdatedInfoModel() { Comment = "Update Style", Type = 2, UpdatedTime = DateTime.Now, UserId = CurrentUser.Id };
using (AppDB db = new AppDB())
{
var style = db.Styles.Where(s => s.Id == model.Id).SingleOrDefault();
if (style != null)
{
style.BuyerId = model.BuyerId;
style.Name = model.Name;
style.YarnType = model.YarnType;
style.Size = model.Size;
style.Description = model.Description;
style.ShippingDate = model.ShippingDate;
style.Quantity = model.Quantity;
style.UpdateInfo += "," + new JavaScriptSerializer().Serialize(updatedInfo);
//db.Styles.Add(style);
db.SaveChanges();
}
else
{
response.IsError = true;
response.Id = -3;
}
//EmailSender.SendToCHWUser(model.Email, login, login, model.Surname, "Sector Executive Officer");
}
}
catch (Exception ex)
{
response.IsError = true;
response.Id = -6;
}
return Json(response);
}