public void SaveImgChange(int Id, string Name, string Descrip, int Order) { Descrip = DecodeUrlString(Descrip); DbInter db = new DbInter(); db.UpdateFile(Id, Name, Descrip, Order); }
public PartialViewResult EditImg(int id) { DbInter db = new DbInter(); var Model = db.DownLoadFileinfo(id); return(PartialView("EditImg", Model)); }
private async void Button_Click_5(object sender, RoutedEventArgs e) { await DbInter.UpdateAsync(Connection, "orders", new DBEntityObject() { Column = "PaymentType", Value = PaymentMethod_Combo.SelectedValue.ToString() }); _orders = await DbInter.SelectAsync <Order>("orders", Connection); ExistingOrders_List.ItemsSource = _orders.Where(a => a.PaymentType == "null").Select(x => $"Order ID: {x.Id} | Customer ID: {x.CustomerId}"); tbctrl.SelectedIndex = 2; }
public void UploadFile(string descr, int id, int oInd) { descr = DecodeUrlString(descr); foreach (string file in Request.Files) { HttpPostedFileBase hpf = Request.Files[file] as HttpPostedFileBase; if (hpf.ContentLength == 0) { continue; } DbInter db = new DbInter(); FileReader fr = new FileReader(); db.UpLoadFile(hpf.FileName, fr.ReadFully(hpf.InputStream), id, descr, oInd); } }
private async void Confirm_Button_Click(object sender, RoutedEventArgs e) { var arr = new string[] { FNText.Text, SNText.Text, TelText.Text, AddressText.Text }; if (arr.Any(x => x == null || new Regex(@"(?i)((?:'\);)|(?:DROP (?:DATABASE|TABLE|COLUMN)?)(?: (?:public\.)?[\w]+))").IsMatch(x)) || TelText.Text.Length != 11) { MessageBox.Show("There was an error when validating the information"); return; } await DbInter.InsertAsync(Connection, "customers", new[] { null, FNText.Text, SNText.Text, TelText.Text, AddressText.Text }); MessageBox.Show("Customer Added", "Alert", MessageBoxButton.OK, MessageBoxImage.Information); tbctrl.SelectedIndex = 4; }
private async void Delete_Button_Click(object sender, RoutedEventArgs e) { var data = ExistingOrders_List?.SelectedItem?.ToString(); if (data == null) { return; } var id = int.Parse(new Regex(@"(Order ID: [0-9]+)").Match(data).Value.Replace("Order ID: ", "")); await DbInter.DeleteAsync(Connection, "orders", new DBEntityObject() { Column = "OrderId", Value = id.ToString() }); _orders = await DbInter.SelectAsync <Order>("orders", Connection); ExistingOrders_List.ItemsSource = _orders.Where(a => a.PaymentType == "null").Select(x => $"Order ID: {x.Id} | Customer ID: {x.CustomerId}"); }
public ActionResult Download(int FileId) { DbInter dbData = new DbInter(); var Model = dbData.DownLoadFile(FileId); Response.AppendHeader("Content-Disposition", "inline; filename=" + Model.TitleFile); if (Model == null || string.IsNullOrEmpty(Model.TitleFile)) { return(null); } if (Model.TitleFile.LastIndexOf('.') != -1) { if (Model.TitleFile.Substring(Model.TitleFile.LastIndexOf('.')).ToLower() == ".pdf") { return(File(Model.content, System.Net.Mime.MediaTypeNames.Application.Pdf)); } else if (Model.TitleFile.Substring(Model.TitleFile.LastIndexOf('.')).ToLower() == ".jpg") { return(File(Model.content, System.Net.Mime.MediaTypeNames.Image.Jpeg)); } else if (Model.TitleFile.Substring(Model.TitleFile.LastIndexOf('.')).ToLower() == ".gif") { return(File(Model.content, System.Net.Mime.MediaTypeNames.Image.Gif)); } else if (Model.TitleFile.Substring(Model.TitleFile.LastIndexOf('.')).ToLower() == ".txt") { return(File(Model.content, System.Net.Mime.MediaTypeNames.Text.RichText)); } else { return(File(Model.content, Model.TitleFile.Substring(Model.TitleFile.LastIndexOf('.')).ToLower())); } } else { return(File(Model.content, System.Net.Mime.MediaTypeNames.Application.Zip)); } }
private async void AddButton_Click(object sender, RoutedEventArgs e) { if (string.IsNullOrWhiteSpace(CustID.Text) || string.IsNullOrWhiteSpace(StaffID.Text)) { MessageBox.Show("Must Enter IDs", "Warning", MessageBoxButton.OK, MessageBoxImage.Warning); return; } decimal total = 0; foreach (var item in _orderedItems) { total += item.Price; } var entries = new string[] { "0", CustID.Text, StaffID.Text, "null", string.Join(",", _orderedItems.Select(x => x.Name)), total.ToString() }; var rows = await DbInter.InsertAsync(Connection, "orders", entries); _orders = await DbInter.SelectAsync <Order>("orders", Connection); MessageBox.Show("Order Added", "Alert", MessageBoxButton.OK, MessageBoxImage.Information); await ResetCreateWindow(); tbctrl.SelectedIndex = 4; }
public Location RenderModelHome(Location page, int id) { DbInter db = new DbInter(); bool isActive = db.IsActive(); if (!isActive) { return(page); } if (page.Alias.ToLower() == "home") { var FileImgL = db.DownLoadFiles(0); List <FileImg> TopBannerImgList = null; List <FileImg> CategoryImgList = null; //English if (id == 7) { TopBannerImgList = FileImgL.Where(x => x.GroupName.ToLower() == "главная страница (top banner eng)").ToList(); CategoryImgList = FileImgL.Where(x => x.GroupName.ToLower() == "главная страница (items eng)").ToList(); } //Russian else if (id == 19) { TopBannerImgList = FileImgL.Where(x => x.GroupName.ToLower() == "главная страница (top banner ru)").ToList(); CategoryImgList = FileImgL.Where(x => x.GroupName.ToLower() == "главная страница (items ru)").ToList(); } if (TopBannerImgList == null) { return(page); } foreach (var block in page.Blocks) { if (block.Alias == "top-banner") { string StartHeader = "<div id = \"top-page-slider\" class=\"owl-carousel top-page-slider\">"; string EndHeader = "</div>"; string TopBannerCode = StartHeader; foreach (var MyBlock in TopBannerImgList) { TopBannerCode += "<div class=\"top-page-slider_item\" style=\"background: url(/DbImg/Download?FileId=" + MyBlock.id + ") no-repeat 50% 50% / cover\">" + "<div class=\"section\">" + "<div class=\"top-page-slider_item-content\">" + MyBlock.Description + "</div>" + "</div>" + "</div>"; } TopBannerCode += EndHeader; block.Content = TopBannerCode; } else if (block.Alias == "item-category") { string StartHeader = "<div class=\"home-category-promo section\">"; string EndHeader = "</div>"; foreach (var myBlock in CategoryImgList) { StartHeader += myBlock.Description; } StartHeader += EndHeader; block.Content = StartHeader; } } } return(page); }
public JsonResult GetFileGroups() { DbInter db = new DbInter(); return(Json(db.GetGroups())); }
public void DeleteFile(int id) { DbInter db = new DbInter(); db.DeleteFile(id); }
public PartialViewResult ImgList(int id) { DbInter db = new DbInter(); return(PartialView("ImgList", db.DownLoadFiles(id))); }
private async void Window_Loaded(object sender, RoutedEventArgs e) { _orders = await DbInter.SelectAsync <Order>("orders", Connection); _items = await DbInter.SelectAsync <Item>("items", Connection); }