/// <summary> /// The method updates a Brand in the Database. /// </summary> /// <param name="productCL">Details of Brand to be updated in the database.</param> /// <returns>Updated Brand Communication Layer Class.</returns> public BrandCL updateBrand(BrandCL brandCL) { Brand brand = (from x in dbcontext.Brands where x.Id == brandCL.id select x).FirstOrDefault(); //Initialises the query of fetching the Brand from the Data Base. brand.IsDeleted = brandCL.isDeleted; brand.DateCreated = brandCL.dateCreated; brand.DateModified = brandCL.dateModified; brand.Name = brandCL.name; brand.Promotions = brandCL.promotions; brand.BrandRating = brandCL.brandRating; brand.ImageURL = brandCL.imageURL; //Updating the instance of DataBase to a Inputed Communication Layer class instance by the user. dbcontext.SaveChanges(); //Updating the Database. brandCL.dateCreated = brand.DateCreated; brandCL.brandCode = brand.BrandCode; brandCL.imageURL = brand.ImageURL; brandCL.dateModified = brand.DateModified; brandCL.promotions = brand.Promotions; brandCL.brandRating = Convert.ToInt32(brand.BrandRating); brandCL.isDeleted = brand.IsDeleted; brandCL.name = brand.Name; brandCL.id = brand.Id; //Updating the Communication Layer class instance by the user data by the instance of DataBase. return(brandCL); //Returning the Communication Layer Class with Updated Brand data on it. }
protected void btnDelBrand_Click(object sender, EventArgs e) { BrandCL brandCL = new BrandCL(); BrandBLL brandBLL = new BrandBLL(); brandCL.id = id; brandBLL.deleteBrand(brandCL); Response.Redirect("ProductManagement.aspx"); }
private void bindBrands(int brandId) { BrandCL brandCL = new BrandCL(); BrandBLL brandBLL = new BrandBLL(); brandCL = brandBLL.getBrands(brandId); txtBName.Text = brandCL.name; ddlBRating.Text = brandCL.brandRating.ToString(); txtBDiscount.Text = brandCL.promotions.ToString(); }
/// <summary> /// This method creates a Brand in the Database. /// </summary> /// <param name="brandCL">Details of Brand to be created in database.</param> /// <returns>Class of Brand created in this method.</returns> public BrandCL createBrand(BrandCL brandCL) { Brand brand = dbcontext.Brands.Add(new Brand { Id = 0, Name = brandCL.name, BrandCode = "", BrandRating = brandCL.brandRating, Promotions = brandCL.promotions, DateCreated = brandCL.dateCreated, DateModified = brandCL.dateModified, IsDeleted = brandCL.isDeleted, ImageURL = brandCL.imageURL, }); //Adding the data recieved in parameters to DB and to a temporary DataAccess Layer Class. dbcontext.SaveChanges(); string productCode = ""; if (brand.Id.ToString().Length == 1) { productCode = "000" + brand.Id; } if (brand.Id.ToString().Length == 2) { productCode = "00" + brand.Id; } if (brand.Id.ToString().Length == 3) { productCode = "0" + brand.Id; } if (brand.Id.ToString().Length == 4) { productCode = brand.Id.ToString(); } brand.BrandCode = brand.Name.Substring(0, 3) + productCode; dbcontext.SaveChanges(); //Updating the Database. BrandCL brandCl = new BrandCL() { id = brand.Id, brandRating = brand.Id, name = brand.Name, promotions = brand.Promotions, dateCreated = brand.DateCreated, dateModified = brand.DateModified, isDeleted = brand.IsDeleted, brandCode = brand.BrandCode, imageURL = brand.ImageURL }; //Adding the temporary DataAccess Layer Class data to Communication Layer class. return(brandCl); //Returning the Communication Layer Class with Created Brand data on it. }
/// <summary> /// The method deletes a Brand in the Database. /// </summary> /// <param name="brandCL">Details of Brand to be deleted in the database.</param> /// <returns>Deleted Brand Communication Layer </returns> public BrandCL deleteBrand(BrandCL brandCL) { Brand brand = (from x in dbcontext.Brands where x.Id == brandCL.id select x).FirstOrDefault(); //Initialises the query of fetching the Brand from the Data Base. brand.IsDeleted = true; //Updating the instance of DataBase to a Inputed Communication Layer class instance by the user. dbcontext.SaveChanges(); //Updating the Database. brandCL.isDeleted = brand.IsDeleted; //Updating the Communication Layer class instance by the user data by the instance of DataBase. return(brandCL); //Returning the Communication Layer Class with Deleted Brand data on it. }
protected void btnBrand_Click(object sender, EventArgs e) { BrandCL brandCL = new BrandCL(); BrandBLL brandBLL = new BrandBLL(); brandCL.id = id; brandCL.name = txtBName.Text; brandCL.dateCreated = DateTime.Now; brandCL.dateModified = DateTime.Now; brandCL.brandRating = Convert.ToInt32(ddlBRating.Text); brandCL.isDeleted = false; brandCL.promotions = Convert.ToDecimal(txtBDiscount.Text); brandBLL.updateBrand(brandCL); lblSuccessfulBrand.Text = "Brand Updated Successfully"; }
/// <summary> /// This method fetchs the values from Brand table By ID /// </summary> /// <param name="brandID"></param> /// <returns></returns> public BrandCL getBrands(int brandID) { Brand brandDB = (from brandInfo in dbcontext.Brands where brandInfo.Id == brandID && brandInfo.IsDeleted == false select brandInfo).FirstOrDefault(); BrandCL brandget = new BrandCL() { id = brandDB.Id, name = brandDB.Name, promotions = brandDB.Promotions, brandRating = Convert.ToInt32(brandDB.BrandRating), dateCreated = brandDB.DateCreated, dateModified = brandDB.DateModified, isDeleted = brandDB.IsDeleted, brandCode = brandDB.BrandCode, imageURL = brandDB.ImageURL, }; return(brandget); }
//Initialises when the Create Category Button is clicked. protected void btnBrand_Click(object sender, EventArgs e) { BrandCL brandCL = new BrandCL(); //Instantiates the Brand Communication Layer Class. BrandBLL brandBLL = new BrandBLL(); //Instantiates the Brand BusinessLogic Layer Class. brandCL.brandRating = Convert.ToInt32(ddlBRating.SelectedValue); brandCL.name = txtBName.Text; brandCL.promotions = Convert.ToDecimal(txtBDiscount.Text); brandCL.dateCreated = DateTime.Now; brandCL.dateModified = DateTime.Now; brandCL.isDeleted = false; //Adds the data entered from the Inputs to the Communication Layer Class instance. brandBLL.createBrand(brandCL); //This method sends the data of the Communication Layer class instance to the Database. lblSuccessfulBrand.Text = "Brand Created Successfully."; }