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