public int GetImageTypeID(string Type)
{
baioEntities db = new baioEntities();
var ImgType = db.ImageType.Where(x => x.Name == Type).FirstOrDefault();
if (ImgType != null)
return ImgType.ID;
else
return 1;
}
public string Handle(int TypeId, int ImgId,string filename,string ext, System.Drawing.Image image,int Rank)
{
baioEntities db = new baioEntities();
ImageType it = db.ImageType.Where(x => x.IsDelete == false & x.ID == TypeId).FirstOrDefault();
if (it != null)
{
photoWidth = Convert.ToInt32(it.Width);
photoHeight = Convert.ToInt32(it.Height);
photoMaxWidth = Convert.ToInt32(it.MaxWidth);
}
else
{
photoWidth = 100;
photoHeight = 100;
photoMaxWidth = 1000;
}
if (ImgId == 0) // Ekleme İşlemi, değilse güncellenecek
{
//Images i = new Images();
////i.SiteID = SiteID;
//i.Src = filename;
//i.ImageTypeID = TypeId;
//i.Date = DateTime.Now;
//i.IsDelete = false;
//i.Rank = Rank;
//i.Src = filename;
//db.Images.Add(i);
//db.SaveChanges();
ImgId = (int)db.sp_ImagesAdd(filename, TypeId, Rank).FirstOrDefault();
}
else
{
// Güncelleme İşlemi
//string oldFile = db.sp_ImageGetSrc(ImgId).FirstOrDefault();
db.sp_ImageSrcUpdate(ImgId, filename);
//tryToDelete(oldFile, "~/Assets/photo/r/");
//tryToDelete(oldFile, "~/Assets/photo/u/");
}
int newwidthimg = photoMaxWidth;
float AspectRatio = (float)image.Size.Width / (float)image.Size.Height;
int newHeight = Convert.ToInt32(newwidthimg / AspectRatio);
Bitmap bmPhoto;
Graphics grPhoto;
ImageCodecInfo ici;
isTransparent = ContainsTransparent((Bitmap)image);
if (isTransparent)
{
ici = GetEncoderInfo("image/png");
bmPhoto = new Bitmap(newwidthimg, newHeight, PixelFormat.Format32bppArgb);
bmPhoto.SetResolution(72, 72);
grPhoto = Graphics.FromImage(bmPhoto);
grPhoto.Clear(Color.Transparent);
}
else {
ici = GetEncoderInfo("image/jpeg");
bmPhoto = new Bitmap(newwidthimg, newHeight, PixelFormat.Format24bppRgb);
bmPhoto.SetResolution(72, 72);
grPhoto = Graphics.FromImage(bmPhoto);
}
grPhoto.CompositingQuality = CompositingQuality.HighQuality;
grPhoto.SmoothingMode = SmoothingMode.HighQuality;
grPhoto.InterpolationMode = InterpolationMode.HighQualityBicubic;
grPhoto.PixelOffsetMode = PixelOffsetMode.HighQuality;
grPhoto.DrawImage
(
image,
new Rectangle(0, 0, newwidthimg, newHeight),
0,
0,
image.Width,
image.Height,
GraphicsUnit.Pixel
);
//Filigran
//grPhoto.DrawImage(System.Drawing.Image.FromFile(System.Web.HttpContext.Current.Server.MapPath("~/www/seyir/Assets/photo/filigran.png")), new Point(0, (int)((newHeight - 900) / 2)));
EncoderParameters ep = new EncoderParameters(1);
ep.Param[0] = new EncoderParameter(Encoder.Quality, (long)100);
//Graphics g = Graphics.FromImage(bmPhoto);
grPhoto.Dispose();
string path1 = HttpContext.Current.Server.MapPath("~/Assets/photo/r/" + filename + "_b.jpg");
string path2 = HttpContext.Current.Server.MapPath("~/Assets/photo/r/" + filename + "_b.png");
bmPhoto.Save(path1, ici, ep);
bmPhoto.Save(path2, ici, ep);
bmPhoto.Dispose();
image.Dispose();
if (isTransparent)
{
getAspectRatioPng(HttpContext.Current.Server.MapPath("~/Assets/photo/r/" + filename + "_b.png"),
HttpContext.Current.Server.MapPath("~/Assets/photo/r/" + filename + "_t.jpg"),
HttpContext.Current.Server.MapPath("~/Assets/photo/r/" + filename + "_t.png"), photoWidth, photoHeight, photoWidth, photoHeight, ext);
}
else
{
getAspectRatio(HttpContext.Current.Server.MapPath("~/Assets/photo/r/" + filename + "_b.jpg"),
HttpContext.Current.Server.MapPath("~/Assets/photo/r/" + filename + "_t.png"),
HttpContext.Current.Server.MapPath("~/Assets/photo/r/" + filename + "_t.jpg"), photoWidth, photoHeight, photoWidth, photoHeight, ext);
}
tryToDelete(SpecialDate(DateTime.Now.AddDays(-1)), "~/Assets/photo/u/");
string result = filename + "|%|" + ImgId.ToString();
return result;
}
public ActionResult Index()
{
baioEntities db = new baioEntities();
ViewData["Categories"] = db.sp_ProductGetAllbyPaging(1,50,0,false,FirmID);
return View();
}
public JsonResult GetCategories(string Type)
{
baioEntities db = new baioEntities();
return Json(db.sp_CategoryGetAll(GetFirmID(), Type));
}
public JsonResult GetProducts(DataTableParameters param)
{
baioEntities db = new baioEntities();
//string CategoryType = param.pageType;
//IEnumerable<sp_ProductGetAllbyPaging_Result> data = db.sp_ProductGetAllbyPaging(1, param.iDisplayLength, 0,false).ToList();
IEnumerable<sp_ProductGetAllbyPaging_Result> data = db.sp_ProductGetAllbyPaging((param.iDisplayStart / param.iDisplayLength) + 1, param.iDisplayLength, 0, false,1).ToList();
string sKey;
if (!string.IsNullOrEmpty(param.sSearch))
{
sKey = param.sSearch.ToLower();
data = data.Where(x => !string.IsNullOrEmpty(x.Name) ? x.Name.ToLower().Contains(sKey) : true);
}
var sortColumnIndex = Convert.ToInt32(Request["iSortCol_0"]);
Func<sp_ProductGetAllbyPaging_Result, string> orderingFunction = (p => sortColumnIndex == 1 ? p.Name :
sortColumnIndex == 2 ? p.Stock.ToString() :
p.Price.ToString());
var pagedData = data.OrderBy(x => x.Rank);
var sortDirection = Request["sSortDir_0"];
if (sortDirection == "asc")
pagedData = pagedData.OrderBy(orderingFunction);
else
pagedData = pagedData.OrderByDescending(orderingFunction);
//string CacheKey = CategoryType + param.iDisplayLength + param.iDisplayStart + param.sSearch + param.iDisplayLength + sortColumnIndex + sortDirection;
//var _Context = System.Web.HttpContext.Current;
//var PageCache = _Context.Cache.Get(CacheKey) as List<sp_GetPagesLite_Result>;
var lastData = new List<sp_ProductGetAllbyPaging_Result>();
//if (PageCache == null)
//if (true)
//{
lastData = pagedData
// .Skip(param.iDisplayStart / param.iDisplayLength * param.iDisplayLength)
//.Take(param.iDisplayLength)
.Select(x => new sp_ProductGetAllbyPaging_Result
{
ImageSrc = x.ImageSrc,
Total = x.Total,
ID = x.ID,
Name = x.Name,
IsActive = x.IsActive,
Stock = x.Stock,
OrderCount = x.OrderCount,
Variant = x.Variant,
Price = x.Price
}).ToList();
//_Context.Cache.Add(CacheKey, lastData, null, System.Web.Caching.Cache.NoAbsoluteExpiration, new TimeSpan(6, 0, 0), System.Web.Caching.CacheItemPriority.Default, null);
//}
//else
//{
// lastData = PageCache;
//}
return Json(new
{
sEcho = param.sEcho,
iTotalRecords = data.Count(),
iTotalDisplayRecords = data.FirstOrDefault() != null ? data.FirstOrDefault().Total : 0,
aaData = lastData
},
JsonRequestBehavior.AllowGet);
}
public bool SetPageRank(int[] IDs, int firstIndex, int lastIndex
//, string CacheKey
)
{
try
{
baioEntities db = new baioEntities();
int a = 0;
for (int i = firstIndex; i <= lastIndex; i++)
{
int ID = IDs[a];
Product p = db.Product.Where(x => x.ID == ID).FirstOrDefault();
if (p != null)
{
p.Rank = i;
}
a++;
}
db.SaveChanges();
//string[] CacheKeys = { CacheKey };
//HelpClass.RemoveCaches(CacheKeys);
return true;
}
catch
{
return false;
}
}
public void SetAP(int ID, bool AP)
{
baioEntities db = new baioEntities();
db.sp_ProductSetAP(ID, AP);
}
public JsonResult ProductFeatureAdd(int ProductID, string[] FeatureNames, decimal[] PriceDifferences)
{
baioEntities db = new baioEntities();
for (int i = 0; i < FeatureNames.Length; i++)
{
db.sp_ProductFeatureAdd(FirmID, ProductID, FeatureNames[i], PriceDifferences[i]);
}
return Json(1);
}
public JsonResult ProductAdd(Product p)
{
baioEntities db = new baioEntities();
List<int> ImageIDs = new List<int>();
List<string> ImageFilenames = new List<string>();
string filename = "";
for (int j = 0; j < Request.Files.Count; j++)
{
var file = Request.Files[j];
Guid gd = Guid.NewGuid();
filename = gd.ToString();
var _Server = System.Web.HttpContext.Current.Server;
file.SaveAs(_Server.MapPath("~/Assets/photo/u/" + filename + ".jpg"));
Image img = Image.FromFile(_Server.MapPath("~/Assets/photo/u/" + filename + ".jpg"));
imageProcessor ip = new imageProcessor();
int ImgTypeID = GetImageTypeID("Product");
string imgInfo = ip.Handle(ImgTypeID, 0, filename, "jpg", img, j + 1);
int ImageID = Convert.ToInt32(imgInfo.Split(new[] { "|%|" }, StringSplitOptions.RemoveEmptyEntries)[1]);
ImageIDs.Add(ImageID);
//ImageFilenames.Add(filename);
}
int ProductID = (int)db.sp_ProductAdd(FirmID,
p.CategoryID,
p.Name,
p.Ingredients,
p.Cost,
p.Price,
p.Stock, filename, p.CriticalStock).FirstOrDefault();
foreach (var imgID in ImageIDs)
{
db.sp_ProductImagesAdd(ProductID, imgID);
}
return Json(ProductID);
}