public bool AddDepartmentServices(string ServCode, string DeptCode)
{
var db = new dbsmappEntities();
var sdept = db.sdepartmentservices.FirstOrDefault(s => s.deptcode.Equals(DeptCode) && s.servicecode.Equals(ServCode));
if (sdept == null)
{
db.sdepartmentservices.Add(new sdepartmentservice
{
deptcode = DeptCode,
servicecode = ServCode,
remarks = "",
status = "ACTIVATED"
});
db.SaveChanges();
return(true);
}
else
{
return(false);
}
}
public bool AddBranch(xbranch branch)
{
var db = new dbsmappEntities();
var brn = db.xbranches.FirstOrDefault(s => s.branchcode.Equals(branch.branchcode));
if (brn == null)
{
NullFiller.FillNullFields <xbranch>(branch);
Capitalize.UppercaseClassFields <xbranch>(branch);
db.xbranches.Add(branch);
}
else
{
NullFiller.FillNullFields <xbranch>(branch);
Capitalize.UppercaseClassFields <xbranch>(branch);
brn.branchname = branch.branchname;
brn.remarks = branch.remarks;
}
db.SaveChanges();
return(true);
}
public bool UserBranchSubmit(rStaffBranch model)
{
var db = new dbsmappEntities();
var isExist = db.userappbranches.FirstOrDefault(s => s.userid.Equals(model.userid) && s.branchcode.Equals(model.branchcode));
if (isExist != null)
{
return(false);
}
else
{
db.userappbranches.Add(new userappbranch
{
branchcode = model.branchcode,
userid = model.userid,
remarks = "",
status = "ACTIVATED"
});
db.SaveChanges();
return(true);
}
}
public bool UserRoleSubmit(rStaffRole model)
{
var db = new dbsmappEntities();
var account = db.userapps.FirstOrDefault(s => s.userid.Equals(model.userid));
var currentUser = db.C_User.FirstOrDefault(s => s.UserName.Equals(account.userid));
var isExist = db.userapproles.FirstOrDefault(s => s.userid.Equals(model.userid) && s.role.Equals(model.role));
if (isExist != null)
{
return(false);
}
db.userapproles.Add(new userapprole()
{
userid = model.userid,
role = model.role,
remarks = "",
status = "activated"
});
db.SaveChanges();
return(true);
}
public bool RemoveDepartment(string DeptCode)
{
var db = new dbsmappEntities();
var sdept = db.sdepartments.FirstOrDefault(s => s.deptcode.Equals(DeptCode));
if (sdept != null)
{
var sdepts = db.sdepartmentservices.Where(s => s.deptcode.Equals(DeptCode)).ToList();
foreach (var item in sdepts)
{
db.sdepartmentservices.Remove(item);
}
db.sdepartments.Remove(sdept);
db.SaveChanges();
return(true);
}
else
{
return(false);
}
}
public bool AddProductToServices(string ServCode, string itemcode)
{
var db = new dbsmappEntities();
var serv = db.nservicesproducts.FirstOrDefault(s => s.itemcode.Equals(itemcode) && s.servicescode.Equals(ServCode));
if (serv == null)
{
db.nservicesproducts.Add(new nservicesproduct
{
servicescode = ServCode,
itemcode = itemcode,
usage = "",
remarks = "",
status = "Acivated"
});
db.SaveChanges();
return(true);
}
else
{
return(false);
}
}
public bool AddProductToOrder(string itemcode, string ordercode, string quantity)
{
var db = new dbsmappEntities();
var serv = db.xbranchorderslists.FirstOrDefault(s => s.itemcode.Equals(itemcode) && s.ordercode.Equals(ordercode));
if (serv == null)
{
db.xbranchorderslists.Add(new xbranchorderslist
{
ordercode = ordercode,
itemcode = itemcode,
quantity = quantity,
status = "ordered"
});
db.SaveChanges();
return(true);
}
else
{
return(false);
}
}
public bool AddProductPrice(iproductprice price)
{
var db = new dbsmappEntities();
var pprice = db.iproductprices.FirstOrDefault(s => s.itemcode.Equals(price.itemcode));
if (pprice == null)
{
price.status = "new";
NullFiller.FillNullFields <iproductprice>(price);
Capitalize.UppercaseClassFields <iproductprice>(price);
db.iproductprices.Add(price);
}
else
{
pprice.sellingprice = price.sellingprice;
pprice.purchasingprice = price.purchasingprice;
pprice.vatprice = price.vatprice;
pprice.remarks = price.remarks;
}
db.SaveChanges();
return(true);
}
public bool AddProduct(iproduct product)
{
var db = new dbsmappEntities();
var prod = db.iproducts.FirstOrDefault(s => s.barcode.Equals(product.barcode));
if (prod == null)
{
product.status = "activated";
NullFiller.FillNullFields <iproduct>(product);
Capitalize.UppercaseClassFields <iproduct>(product);
db.iproducts.Add(product);
var files = Request.Files;
if (files.Count != 0)
{
new ImageFunc().UploadProductPic(Request.Files, product.itemcode + "P");
}
db.SaveChanges();
return(true);
}
else
{
return(false);
}
}
public bool AddBranchOrder(xbc branch)
{
var db = new dbsmappEntities();
var newGeneratedId = new NewId()._GenerateId("xbranchorders");
var NewIDD = "B00" + newGeneratedId + "H" + DateTime.Today.ToString("yyyy");
var username = User.Identity.GetUserName();
db.xbranchorders.Add(new xbranchorder
{
branchcode = branch.brn,
servicecode = branch.servicecode,
ordercode = NewIDD,
orderby = username,
datecreated = DateTime.Now,
approvedby = "",
dateapproved = DateTime.Now,
remarks = branch.remarks,
status = "blank",
});
db.SaveChanges();
return(true);
}
public bool AddServicesProduct(string datalist)
{
var db = new dbsmappEntities();
foreach (var item in datalist.Split(','))
{
var xo = item.Split('-');
var sscode = xo[0].ToString();
var ssitemcode = xo[1].ToString();
var ssprice = xo[2].ToString();
var serv = db.nservicesproductprices.FirstOrDefault(s => s.itemcode.Equals(sscode) && s.servicescode.Equals(ssitemcode));
db.nservicesproductprices.Add(new nservicesproductprice
{
servicescode = sscode,
itemcode = ssitemcode,
price = ssprice,
remarks = "",
status = "ACTIVATED"
});
}
db.SaveChanges();
return(true);
}
public ActionResult EditProduct(string itemcode)
{
var db = new dbsmappEntities();
var isProduct = db.iproducts.FirstOrDefault(s => s.itemcode.Equals(itemcode));
if (isProduct != null)
{
ViewBag.Product = isProduct;
var isImg = db.ysysphotoes.FirstOrDefault(s => s.imgcode.Equals(itemcode + "P"));
if (isImg != null)
{
ViewBag.ProductImg = isImg.imgcode;
}
else
{
ViewBag.ProductImg = null;
}
}
else
{
ViewBag.Product = null;
ViewBag.ProductImg = null;
}
return(View());
}
public static void FillFieldFiller <T>(T theInstance)
{
dbsmappEntities db = new dbsmappEntities();
if (theInstance == null)
{
throw new ArgumentNullException();
}
var vin = theInstance.GetType().GetProperty("vin");
var vinValue = vin.GetValue(theInstance, null);
var whatstable = vin.DeclaringType.Name;
foreach (var property in theInstance.GetType().GetProperties(BindingFlags.Public | BindingFlags.Instance))
{
var theValue = property.GetValue(theInstance, null);
var whatName = property.Name;
if (string.IsNullOrEmpty(theValue.ToString()))
{
var oldValue = db.Database.SqlQuery <string>("select " + whatName + " from " + whatstable + " where vehicleid = '" + vinValue + "'").FirstOrDefault();
if (!string.IsNullOrEmpty(oldValue.ToString()))
{
property.SetValue(theInstance, (oldValue.ToString()), null);
}
else
{
property.SetValue(theInstance, (""), null);
}
}
}
}
public bool AddDepartment(sdepartment Department)
{
var db = new dbsmappEntities();
var dept = db.sdepartments.FirstOrDefault(s => s.deptcode.Equals(Department.deptcode));
if (dept == null)
{
Department.status = "activated";
NullFiller.FillNullFields <sdepartment>(Department);
Capitalize.UppercaseClassFields <sdepartment>(Department);
db.sdepartments.Add(Department);
}
else
{
NullFiller.FillNullFields <sdepartment>(Department);
Capitalize.UppercaseClassFields <sdepartment>(Department);
dept.deptcode = Department.deptcode;
dept.deptname = Department.deptname;
dept.remarks = Department.remarks;
dept.status = "ACTIVATED";
}
db.SaveChanges();
return(true);
}
public ActionResult EditServices(string servicescode)
{
var db = new dbsmappEntities();
var elem = db.nservices.FirstOrDefault(s => s.servicescode.Equals(servicescode));
if (elem != null)
{
ViewBag.Services = elem;
var isImg = db.ysysphotoes.FirstOrDefault(s => s.imgcode.Equals(servicescode + "S"));
if (isImg != null)
{
ViewBag.ServicesImg = isImg.imgcode;
}
else
{
ViewBag.ServicesImg = null;
}
}
else
{
ViewBag.Services = null;
ViewBag.ServicesImg = null;
}
return(View());
}
public JsonResult GetCombiAllBranchOrders(string brn)
{
var db = new dbsmappEntities();
var listQQ = db.xbranchorders.Where(s => s.branchcode.Equals(brn)).ToList();
return(Json(listQQ, JsonRequestBehavior.AllowGet));
}
public JsonResult GetDepartmentCombiAll()
{
var db = new dbsmappEntities();
var QQList = db.sdepartments.ToList();
return(Json(QQList, JsonRequestBehavior.AllowGet));
}
public JsonResult GetServicesCombiAll()
{
var db = new dbsmappEntities();
var QQList = db.nservices.ToList();
return(Json(QQList, JsonRequestBehavior.AllowGet));
}
public ActionResult NewBranchOrder()
{
var db = new dbsmappEntities();
ViewBag.RequestVeh = db.nservices.ToList();
return(View());
}
public JsonResult GetCombiAllBranchOrdersOA()
{
var db = new dbsmappEntities();
var listQQ = db.xbranchorders.Where(s => s.status.Equals("pending") || s.status.Equals("approved")).ToList();
return(Json(listQQ, JsonRequestBehavior.AllowGet));
}
public async Task <bool> UserSubmit(rUser model)
{
NullFiller.FillNullFields <rUser>(model);
Capitalize.UppercaseClassFields <rUser>(model);
var db = new dbsmappEntities();
var isExist = db.userapps.FirstOrDefault(s => s.userid.Equals(model.userid));
if (isExist != null)
{
return(false);
}
var emailAdd = model.userid + "@danubeco.com";
var newuserid = model.userid + "JED";
var user = new User {
UserName = newuserid, Email = emailAdd, Region = "JED"
};
//var rnpw = System.Web.Security.Membership.GeneratePassword(6, 0);
var result = await UserManager.CreateAsync(user, "12345678");
if (!result.Succeeded)
{
return(false);
}
var currentUser = await UserManager.FindByEmailAsync(emailAdd);
await UserManager.AddToRolesAsync(currentUser.Id, model.role);
db.userapps.Add(new userapp()
{
userid = newuserid,
empid = model.userid,
name = model.name,
role = model.role,
status = "activated",
login = DateTime.Today,
password = "******"
});
var files = Request.Files;
if (files.Count != 0)
{
new ImageFunc().UploadProductPic(Request.Files, newuserid);
}
db.SaveChanges();
return(true);
}
public JsonResult GetUserCombiAllBranchAvailable(string userid)
{
var db = new dbsmappEntities();
var QQListAvailable = db.userappbranches.Where(s => s.userid.Equals(userid)).ToList();
var QQListNotAvailable = db.xbranches.ToList();
var QQList = QQListNotAvailable.Where(i => !QQListAvailable.Any(e => i.branchcode.Equals(e.branchcode))).ToList();
return(Json(QQList, JsonRequestBehavior.AllowGet));
}
public JsonResult GetDepartmentCombiAllServicesAvailable(string deptcode)
{
var db = new dbsmappEntities();
var QQListAvailable = db.sdepartmentservices.Where(s => s.deptcode.Equals(deptcode)).ToList();
var QQListNotAvailable = db.nservices.ToList();
var QQList = QQListNotAvailable.Where(i => !QQListAvailable.Any(e => i.servicescode.Equals(e.servicecode))).ToList();
return(Json(QQList, JsonRequestBehavior.AllowGet));
}
public JsonResult GetProductCombiAllServicesAvailable(string servicecode)
{
var db = new dbsmappEntities();
var QQListAvailable = db.nservicesproducts.Where(s => s.servicescode.Equals(servicecode)).ToList();
var QQListNotAvailable = db.iproducts.ToList();
var QQList = QQListNotAvailable.Where(i => !QQListAvailable.Any(e => i.itemcode.Equals(e.itemcode))).ToList();
return(Json(QQList, JsonRequestBehavior.AllowGet));
}
public JsonResult GetProductOrderCombiAllAvailable(string ordercode)
{
var db = new dbsmappEntities();
var QQListAvailable = db.xbranchorderslists.Where(s => s.ordercode.Equals(ordercode)).ToList();
var QQListNotAvailable = db.iproducts.ToList();
var QQList = QQListNotAvailable.Where(i => !QQListAvailable.Any(e => i.itemcode.Equals(e.itemcode))).ToList();
return(Json(QQList, JsonRequestBehavior.AllowGet));
}
public string UploadProductPic(HttpFileCollectionBase Files, string imgcode)
{
dbsmappEntities db = new dbsmappEntities();
var filepath = "";
if (Files == null)
{
filepath = "";
}
for (int i = 0; i < Files.Count; i++)
{
var file = Files[i].FileName;
var imgQQ = imgcode + ".jpg";
var absolutePath = HostingEnvironment.MapPath("~/Uploadpic/" + imgQQ);
// Trash Garbage Collection
if (File.Exists(absolutePath))
{
System.GC.Collect();
System.GC.WaitForPendingFinalizers();
File.Delete(absolutePath);
}
filepath = HostingEnvironment.MapPath("~/Uploadpic/") + imgQQ;
// Save Original Image
Files[i].SaveAs(filepath);
// Thumbnail
ImagePro(filepath, imgQQ);
// Save Pic Information
db.ysysphotoes.Add(new ysysphoto()
{
imgcode = imgcode,
picthmb = "",
remarks = "",
status = "",
});
db.SaveChanges();
}
return(filepath);
}
public static bool hasSessionRole(string userid)
{
var db = new dbsmappEntities();
var isExist = db.userappsessions.Any(s => s.userid.Equals(userid));
if (isExist)
{
return(true);
}
else
{
return(false);
}
}
public JsonResult GetDepartmentCombiAllServices(string deptcode)
{
var db = new dbsmappEntities();
var QQList = (from s in db.sdepartmentservices
join cs in db.nservices on s.servicecode equals cs.servicescode
where s.deptcode.Equals(deptcode)
select new sdepartmentserviceX
{
servicecode = s.servicecode,
servicename = cs.servicename,
status = s.status
}).ToList();
return(Json(QQList, JsonRequestBehavior.AllowGet));
}
public JsonResult GetProductCombiAll()
{
var db = new dbsmappEntities();
var QQList = (from s in db.iproducts
select new xProduct
{
itemcode = s.itemcode,
barcode = s.barcode,
arname = s.arname,
enname = s.enname,
remarks = s.remarks
}).ToList();
return(Json(QQList, JsonRequestBehavior.AllowGet));
}
public JsonResult GetProductPriceList()
{
var db = new dbsmappEntities();
var QQList = (from s in db.iproducts
select new xProductPrice
{
itemcode = s.itemcode,
priceinfo = db.iproductprices.FirstOrDefault(e => e.itemcode.Equals(s.itemcode)),
arname = s.arname,
enname = s.enname,
barcode = s.barcode
}).ToList();
return(Json(QQList, JsonRequestBehavior.AllowGet));
}
