public bool InsertBrandingTeamInfo(tblBrandingTeam brandingTeam) { try { _entities.tblBrandingTeams.Add(brandingTeam); _entities.SaveChanges(); return(true); } catch (Exception exception) { throw exception; } }
public bool InsertNewBrandOutletMasterDetailsInfo(List <NewBrandOutletModel> newBrandOutlet, Guid?tokenNumber) { try { using (var entity = new BrandOutletMonitoringEntities()) { foreach (var newBrandOutletModel in newBrandOutlet) { var outletMaster = new BrandOutletDetail(); outletMaster.BrandOutletToken = tokenNumber; outletMaster.RetailerId = newBrandOutletModel.RetailerId; outletMaster.BrandCategoryId = newBrandOutletModel.BrandCategoryId; outletMaster.BrandCategoryName = newBrandOutletModel.BrandCategoryName; outletMaster.BrandSubCategoryId = newBrandOutletModel.BrandSubCategoryId; outletMaster.BrandSubCategoryName = newBrandOutletModel.BrandSubCategoryName; outletMaster.Quantity = newBrandOutletModel.Quantity; outletMaster.AddedBy = 1; outletMaster.AddedDate = DateTime.Now; outletMaster.UpdatedBy = 1; outletMaster.UpdatedDate = DateTime.Now; entity.BrandOutletDetails.Add(outletMaster); } entity.SaveChanges(); } return(true); } catch (Exception exception) { return(false); } }
public bool InsertNewBrandOutletMasterInfo(List <NewBrandOutletModel> newBrandOutlet, Guid?tokenNumber) { try { using (var entity = new BrandOutletMonitoringEntities()) { var outletMaster = new BrandOutletMaster(); outletMaster.OutletToken = tokenNumber; outletMaster.RetailerId = newBrandOutlet[0].RetailerId; outletMaster.RetailerName = newBrandOutlet[0].RetailerName; outletMaster.RetailerAddress = newBrandOutlet[0].RetailerAddress; outletMaster.RetailerPhone = newBrandOutlet[0].RetailerPhone; outletMaster.AddedBy = 1; outletMaster.Active = true; outletMaster.AddedDate = DateTime.Now; entity.BrandOutletMasters.Add(outletMaster); entity.SaveChanges(); } return(true); } catch (Exception exception) { return(false); } }
public bool InsertBrandingIssueSolvedInfo(BrandingIssuesSolved brandingIssue) { try { _entities.BrandingIssuesSolveds.Add(brandingIssue); _entities.SaveChanges(); return(true); } catch (Exception exception) { throw exception; } finally { EntityDispose(); } }
//private readonly BrandOutletMonitoringEntities _entities = new BrandOutletMonitoringEntities(); public bool InsertBrandMonitorCategoryInfo(BrandMonitorCategory brandInfo) { try { _entities.BrandMonitorCategories.Add(brandInfo); _entities.SaveChanges(); return(true); } catch (Exception exception) { throw exception; } }
public bool InsertImage(ImageViewModel model) { var file = model.ImageFile; byte[] imagebyte = null; if (file != null) { BinaryReader reader = new BinaryReader(file.InputStream); imagebyte = reader.ReadBytes(file.ContentLength); tblImageUploader img = new tblImageUploader(); img.ImageTitle = file.FileName; img.ImageByte = imagebyte; _entities.tblImageUploaders.Add(img); _entities.SaveChanges(); return(true); } return(true); }
public bool UpdateBrandOutletMasterDetailsInfo(List <NewBrandOutletModel> reBrandItems) { try { using (var entity = new BrandOutletMonitoringEntities()) { foreach (var items in reBrandItems) { var shopInfoes = entity.BrandOutletDetails.FirstOrDefault(x => x.BrandOutletToken == items.Token && x.BrandCategoryId == items.BrandCategoryId && x.BrandSubCategoryId == items.BrandSubCategoryId); if (shopInfoes != null) { if (items.Quantity != 0) { shopInfoes.Quantity = items.Quantity; } shopInfoes.UpdatedBy = 1; shopInfoes.UpdatedDate = DateTime.Now; entity.Entry(shopInfoes).State = EntityState.Modified; } entity.SaveChanges(); } } } catch (Exception) { return(false); } return(true); }
public int UploadImageInDataBase(HttpPostedFileBase file, BrandingIssue contentViewModel) { var _entities = new BrandOutletMonitoringEntities(); //contentViewModel.IssueFile = ConvertToBytes(file); var Content = new BrandingIssue { //BrandId = contentViewModel.BrandId, //Description = contentViewModel.Description, //SubCategoryid = contentViewModel.SubCategoryid, IssueFile = contentViewModel.IssueFile }; _entities.BrandingIssues.Add(Content); int i = _entities.SaveChanges(); if (i == 1) { return(1); } else { return(0); } }
public Result PostDescription() { var masterResult = new Result(); var result = new Result(); var brandingIssue = new BrandingIssue(); var brandingIssueMaster = new BrandIssueMaster(); const string initialPath = @"~/Content/UploadImage"; try { //****Posted Files //****Posted Files var httpPostedFile = HttpContext.Current.Request.Files; // ReSharper disable once AssignNullToNotNullAttribute var strings = HttpContext.Current.Request.Form.GetValues("desc").ToList(); var stringsAddress = HttpContext.Current.Request.Form.GetValues("add"); var stringPhone = HttpContext.Current.Request.Form.GetValues("phone"); var stringSubcategoryId = HttpContext.Current.Request.Form.GetValues("subcategoryid"); var stringCategoryId = HttpContext.Current.Request.Form.GetValues("categoryid"); //Strings Bind //string bind string description = null; string address = null; string phone = null; long?categoryid = null; long?subcategoryid = null; if (strings != null) { description = strings[0]; } if (stringsAddress != null) { address = stringsAddress[0]; } if (stringPhone != null) { phone = stringPhone[0]; } if (stringSubcategoryId != null) { subcategoryid = Convert.ToInt64(stringSubcategoryId[0]); } if (stringCategoryId != null) { categoryid = Convert.ToInt64(stringCategoryId[0]); } //****Posted Files //****Posted Files // Get the uploaded image from the Files collection // Get the uploaded image from the Files collection var bmEntity = new BrandOutletMonitoringEntities(); var issueToken = Guid.NewGuid(); brandingIssueMaster.IssueId = issueToken; brandingIssueMaster.CategoryId = categoryid; brandingIssueMaster.SubCategoryId = subcategoryid; brandingIssueMaster.Description = description; brandingIssueMaster.RetailersPhone = phone; brandingIssueMaster.RetailersAddress = address; brandingIssueMaster.Active = true; brandingIssueMaster.AddedDate = DateTime.Now; bmEntity.BrandIssueMasters.Add(brandingIssueMaster); masterResult.issuccess = bmEntity.SaveChanges(); if (masterResult.issuccess == 1) { result.error = false; result.message = "Uploaded Successfully"; if (HttpContext.Current.Request.Files.AllKeys.Any()) { for (var iCnt = 0; iCnt <= httpPostedFile.Count - 1; iCnt++) { var postedFile = httpPostedFile[iCnt]; var fileName = Path.GetFileName(postedFile.FileName); if (fileName != null) { var todayTime = DateTime.Now; var time = new DateTime(todayTime.Year, todayTime.Month, todayTime.Day, todayTime.Hour, todayTime.Minute, todayTime.Second, todayTime.Millisecond); var timeFormat = string.Format("{0:yyyy-MM-dd_hh-mm-ss-fff}", time); fileName = timeFormat + "-" + fileName; var path = Path.Combine(HttpContext.Current.Server.MapPath(initialPath), fileName); postedFile.SaveAs(path); string finalPath = @"C:\uploads" + @"\" + 1 + @"\" + 2 + @"\" + 3; if (Directory.Exists(finalPath)) { File.Copy(path, finalPath + "\\" + fileName, true); } else { Directory.CreateDirectory(finalPath); File.Copy(path, finalPath + "\\" + fileName, true); } brandingIssue.BrandIssueId = issueToken; brandingIssue.IssueFile = finalPath + "\\" + fileName; bmEntity.BrandingIssues.Add(brandingIssue); bmEntity.SaveChanges(); result.error = false; result.message = "Uploaded Successfully"; } } } } else { result.error = true; result.message = "Uploaded Failed"; } //var httpPostedFile = HttpContext.Current.Request.Files["upload"]; // } catch (Exception) { result.error = true; result.message = "Uploaded Failed"; } return(result); }