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)); }