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 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 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 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 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 async Task <bool> AddSupplier(rX supplier) { var db = new dnbmssqlEntities(); NullFiller.FillNullFields <rX>(supplier); Capitalize.UppercaseClassFields <rX>(supplier); // Supplier Login var username = supplier.idd + supplier.region; var sup_user = db.C_User.FirstOrDefault(s => s.UserName.Equals(username)); if (sup_user == null) { var user = new User { UserName = username, Email = username + "@danubeco.com", Region = supplier.region }; try { var result = await UserManager.CreateAsync(user, supplier.password); if (!result.Succeeded) { return(false); } else { SupplierInfo(supplier); return(true); } } catch (Exception) { return(false); } } else { var user = await UserManager.FindByIdAsync(sup_user.UserId); user.PasswordHash = UserManager.PasswordHasher.HashPassword(supplier.password); await UserManager.UpdateAsync(user); SupplierInfo(supplier); return(true); } }
public bool AddServices(nservice services) { var db = new dbsmappEntities(); var serv = db.nservices.FirstOrDefault(s => s.servicescode.Equals(services.servicescode)); if (serv == null) { NullFiller.FillNullFields <nservice>(services); Capitalize.UppercaseClassFields <nservice>(services); db.nservices.Add(services); } else { NullFiller.FillNullFields <nservice>(services); Capitalize.UppercaseClassFields <nservice>(services); serv.servicename = services.servicename; serv.description = services.description; serv.departmentid = services.departmentid; serv.nprice = services.nprice; serv.sprice = services.sprice; serv.minutes = services.minutes; serv.hours = services.hours; serv.fixedcommission = services.fixedcommission; serv.remarks = services.remarks; serv.status = services.status; } var files = Request.Files; if (files.Count != 0) { new ImageFunc().UploadProductPic(Request.Files, services.servicescode + "S"); } db.SaveChanges(); return(true); }
public bool UpdateProduct(iproduct product) { var db = new dbsmappEntities(); var prod = db.iproducts.FirstOrDefault(s => s.itemcode.Equals(product.itemcode)); if (prod == null) { return(false); } else { NullFiller.FillNullFields <iproduct>(product); Capitalize.UppercaseClassFields <iproduct>(product); prod.itemcode = product.itemcode; prod.barcode = product.barcode; prod.modelno = product.modelno; prod.serialno = product.serialno; prod.arname = product.arname; prod.enname = product.enname; prod.arshortname = product.arshortname; prod.enshortname = product.enshortname; prod.size = product.size; prod.unit = product.unit; prod.remarks = product.remarks; prod.status = product.status; var files = Request.Files; if (files.Count != 0) { new ImageFunc().UploadProductPic(Request.Files, product.itemcode + "P"); } db.SaveChanges(); return(true); } }