public ActionResult EditProject(tblProject model, List <HttpPostedFileBase> listImage)
{
foreach (var item in listImage)
{
if (item == null)
{
continue;
}
var newName = item.FileName.Insert(item.FileName.LastIndexOf('.'), $"{DateTime.Now:_ddMMyyyy}");
var path = Server.MapPath("/Uploads/News/" + newName);
item.SaveAs(path);
var image = new tblImage
{
Image = newName,
URL = "/Uploads/News/" + newName,
ProjectId = model.Id,
DictionaryId = 47
};
db.tblImage.Add(image);
}
db.Entry(model).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Create(tblImage tblimages, FormCollection collection, int[] MutilMenu)
{
int idCate = int.Parse(collection["drMenu"]);
tblimages.idCate = idCate;
db.tblImages.Add(tblimages);
db.SaveChanges();
var ListManu = db.tblImages.OrderByDescending(p => p.id).Take(1).ToList();
int idimg = int.Parse(ListManu[0].id.ToString());
if (MutilMenu != null)
{
foreach (var idMenu in MutilMenu)
{
tblConnectImage tblconnectimages = new tblConnectImage();
tblconnectimages.idCate = idMenu;
tblconnectimages.idImg = idimg;
db.tblConnectImages.Add(tblconnectimages);
db.SaveChanges();
}
}
Updatehistoty.UpdateHistory("Add tblimages", Request.Cookies["Username"].Values["FullName"].ToString(), Request.Cookies["Username"].Values["UserID"].ToString());
if (collection["btnSave"] != null)
{
Session["Thongbao"] = "<div class=\"alert alert-info alert1\">Bạn đã thêm thành công !<button class=\"close\" data-dismiss=\"alert\">×</button></div>";
return(Redirect("/Imagesad/Index?idCate=" + idCate + ""));
}
if (collection["btnSaveCreate"] != null)
{
Session["Thongbao"] = "<div class=\"alert alert-info\">Bạn đã thêm thành công, mời bạn thêm mới !<button class=\"close\" data-dismiss=\"alert\">×</button></div>";
return(Redirect("/Imagesad/Create?id=" + idCate + ""));
}
return(Redirect("Index"));
}
public static void ExtractMetaData(tblImage image)
{
var path = string.Format("~/Images/Albums/{0}", image.tblAlbum.ALB_Name);
var mappedPath = System.Web.Hosting.HostingEnvironment.MapPath(path);
var imagePath = Path.Combine(mappedPath, Path.GetFileName(image.IMG_Name));
//string filePath = string.Format("~/Images/Albums/{0}", image.tblAlbum.ALB_Name);
//string relativePath = string.Format("Images/Albums/{0}/{1}", ddlAlbums, masterimage.FileName);
// string path = Path.Combine(Server.MapPath(filePath), Path.GetFileName(masterimage.FileName));
ExifTagCollection _exif = new ExifTagCollection(imagePath);
foreach (ExifTag tag in _exif)
{
tblMetaType metaType = new tblMetaType();
metaType.MTT_IDPkey = tag.Id;;
metaType.MTT_Name = tag.FieldName;
tblMetaData meta = new tblMetaData();
meta.MTD_Value = tag.Value.Length > 500 ? "" : tag.Value;
meta.MTT_IDFkey = tag.Id;
meta.tblImage = image;
image.tblMetaDatas.Add(meta);
}
}
protected void btnUpload_click(object sender, EventArgs e)
{
//if (Page.IsValid)
{
string filepath = Server.MapPath("~/Images/photogallery");
if (!Directory.Exists(filepath))
{
Directory.CreateDirectory(filepath);
}
filepath += "/" + fileImage.FileName;
fileImage.SaveAs(filepath);
tblImage newimage = new tblImage();
newimage.title = txtTitle.Text;
newimage.CreatedDate = DateTime.Now;
newimage.CreatedBy = HttpContext.Current.User.Identity.Name;
newimage.Imagepath = "~/Images/photogallery/" + fileImage.FileName;
tblPhotos.Save(newimage);
lblmessage.Text = "Information has been saved sucessfully!";
lblmessage.Visible = true;
tbluserhistory _userhistory = new tbluserhistory();
_userhistory.Action = "User creation";
_userhistory.description = _user.Username + " has created user with userid " + _user.Id;
_userhistory.time = DateTime.Now;
_userhistory.useraan = _user.AAN;
userHistory.Save(_userhistory);
}
//else
//{
// lblmessage.Text = "Only jpeg,gif and png allowed!";
// lblmessage.Visible = true;
//}
}
public ActionResult Edit(tblImage tblimages, int id, FormCollection collection, int[] MutilMenu, int[] drMenuCap)
{
if (ModelState.IsValid)
{
tblimages.idCate = int.Parse(collection["drMenu"]);
int idcate = int.Parse(collection["drMenu"]);
db.Entry(tblimages).State = EntityState.Modified;
db.SaveChanges();
#region [Updatehistory]
Updatehistoty.UpdateHistory("Edit tblimages", Request.Cookies["Username"].Values["FullName"].ToString(), Request.Cookies["Username"].Values["UserID"].ToString());
#endregion
if (collection["btnSave"] != null)
{
Session["Thongbao"] = "<div class=\"alert alert-info alert1\">Bạn đã sửa thành công !<button class=\"close\" data-dismiss=\"alert\">×</button></div>";
return(Redirect("/Imagesad/Index?idCate=" + idcate + ""));
}
if (collection["btnSaveCreate"] != null)
{
Session["Thongbao"] = "<div class=\"alert alert-info\">Bạn đã thêm thành công, mời bạn thêm mới !<button class=\"close\" data-dismiss=\"alert\">×</button></div>";
return(Redirect("/Imagesad/Create?id=" + idcate + ""));
}
}
return(View(tblimages));
}
public static void Save(tblImage lstinformatation)
{
DataClassesDataContext dataContext = new DataClassesDataContext();
dataContext.tblImages.InsertOnSubmit(lstinformatation);
dataContext.SubmitChanges();
}
public ActionResult Edit(tblImage tblimages, int id, FormCollection collection, int[] MutilMenu, int[] mutilManu)
{
if (ModelState.IsValid)
{
tblimages.idCate = int.Parse(collection["drMenu"]);
int idcate = int.Parse(collection["drMenu"]);
db.Entry(tblimages).State = EntityState.Modified;
db.SaveChanges();
var ListImages = db.tblConnectImages.Where(p => p.idImg == id).ToList();
for (int i = 0; i < ListImages.Count; i++)
{
db.tblConnectImages.Remove(ListImages[i]);
db.SaveChanges();
}
if (MutilMenu != null)
{
foreach (var idCates in MutilMenu)
{
tblConnectImage tbllistimages = new tblConnectImage();
tbllistimages.idCate = idCates;
tbllistimages.idImg = id;
db.tblConnectImages.Add(tbllistimages);
db.SaveChanges();
}
}
var listIdManu = db.tblConnectManuToImages.Where(p => p.idImage == id).ToList();
for (int i = 0; i < listIdManu.Count; i++)
{
db.tblConnectManuToImages.Remove(listIdManu[i]);
db.SaveChanges();
}
if (mutilManu != null)
{
foreach (var idMenu in mutilManu)
{
tblConnectManuToImage connectimage = new tblConnectManuToImage();
connectimage.idManu = idMenu;
connectimage.idImage = id;
db.tblConnectManuToImages.Add(connectimage);
db.SaveChanges();
}
}
#region [Updatehistory]
Updatehistoty.UpdateHistory("Edit tblimages", Request.Cookies["Username"].Values["FullName"].ToString(), Request.Cookies["Username"].Values["UserID"].ToString());
#endregion
if (collection["btnSave"] != null)
{
Session["Thongbao"] = "<div class=\"alert alert-info alert1\">Bạn đã sửa thành công !<button class=\"close\" data-dismiss=\"alert\">×</button></div>";
return(Redirect("/Imagesad/Index?idCate=" + idcate + ""));
}
if (collection["btnSaveCreate"] != null)
{
Session["Thongbao"] = "<div class=\"alert alert-info\">Bạn đã thêm thành công, mời bạn thêm mới !<button class=\"close\" data-dismiss=\"alert\">×</button></div>";
return(Redirect("/Imagesad/Create?id=" + idcate + ""));
}
}
return(View(tblimages));
}
// GET: /Store/Browse
public ActionResult Details(int albumId, int?imageId = null, int?processedImageId = null,
int?conditionId = null, int?featureId = null)
{
string message = HttpUtility.HtmlEncode("Store.Browse, Album = " + albumId);
tblAlbum selectedAlbum = null;
tblImage selectedMasterImage = null;
tblProcessedImage selectedProcessedImage = null;
selectedAlbum = imageDB.tblAlbums.SingleOrDefault(a => a.ALB_IDPkey == albumId);
var query = imageDB.tblImages.Where(i => i.ALB_IDFkey == albumId);
List <tblImage> images = query.ToList();
if (imageId != null)
{
selectedMasterImage = images.SingleOrDefault(i => i.IMG_IDPkey == imageId);
}
else
{
selectedMasterImage = images.FirstOrDefault();
}
int selectedIndex = images.IndexOf(selectedMasterImage);
int nextIndex = images.Count() - 1;
int previousIndex = 0;
if (images.Count() - 1 > selectedIndex)
{
nextIndex = selectedIndex + 1;
}
if (selectedIndex - 1 >= 0)
{
previousIndex = selectedIndex - 1;
}
if (processedImageId != null)
{
selectedProcessedImage = selectedMasterImage.tblProcessedImages.SingleOrDefault(p => p.PIM_IDPkey == processedImageId.Value);
}
else
{
selectedProcessedImage = selectedMasterImage.tblProcessedImages.SingleOrDefault(p => p.tblFilter.FLT_Name == "JPEG");
}
var viewModel = new ImageDetailsViewModel
{
Image = selectedMasterImage,
NextImage = images.ElementAt(nextIndex),
PreviousImage = images.ElementAt(previousIndex),
ProcessedImage = selectedProcessedImage,
AvailableConditions = selectedAlbum.tblImages.Select(i => i.tblEnvironmentalCondition).Distinct().ToList(),
AvailableFeatures = selectedAlbum.tblImages.Select(i => i.tblFeature).Distinct().ToList()
};
return(this.View(viewModel));
}
public ActionResult DeleteConfirmed(int id)
{
tblImage tblImage = db.tblImages.Find(id);
db.tblImages.Remove(tblImage);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public static bool IsExists(tblImage image)
{
var dbCtx = new CUATRGEntities4();
return(dbCtx.tblImages.Any <tblImage>(i => i.IMG_Name == image.IMG_Name &&
i.ALB_IDFkey == image.tblAlbum.ALB_IDPkey &&
i.FTR_IDFkey == image.tblFeature.FTR_IDPkey &&
i.ENC_IDFkey == image.tblEnvironmentalCondition.ENC_IDPkey));
}
public ActionResult Edit([Bind(Include = "imgId,imgLabel,imgDescription,imgFileName,imgContentType,imgWidth,imgHeight,imgCreationDate,imgIsInActive")] tblImage tblImage)
{
if (ModelState.IsValid)
{
db.Entry(tblImage).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(tblImage));
}
protected void btnnext_Click(object sender, EventArgs e)
{
try {
var dc = new DataClassesDataContext();
if (FileUpload1.HasFile)
{
var path = Server.MapPath("~/ServiceProvider/Upload/");
FileUpload1.SaveAs(path + "/" + FileUpload1.FileName);
tblImage objimg = new tblImage();
objimg.Name = FileUpload1.FileName;
objimg.AlbumID = 2;
objimg.IsActive = true;
objimg.IsDefault = false;
objimg.CreatedOn = DateTime.Now;
dc.tblImages.InsertOnSubmit(objimg);
dc.SubmitChanges();
}
Session["pass"] = txtpass.Text;
if (txtpass.Text == txtconpass.Text)
{
panel1.Visible = false;
panel2.Visible = true;
var check = (from us in dc.tblServiceProviders
where us.Email == txtmail.Text
select us.ServiceProviderID).Count();
var st1 = (from us in dc.tblServiceProviders
where us.Email == txtmail.Text
select us).FirstOrDefault();
if (check > 0)
{
Session["ServiceProviderID"] = st1.ServiceProviderID;
tblServiceProvider result = (from u in dc.tblServiceProviders
where u.ServiceProviderID == Convert.ToInt32(Session["ServiceProviderID"].ToString())
select u).Single();
result.Password = txtpass.Text;
dc.SubmitChanges();
}
}
else
{
lblerrorPwd.Visible = true;
}
}
catch (Exception ex)
{
//int session = Convert.ToInt32(Session["UserID"].ToString());
string PageName = System.IO.Path.GetFileName(Request.Url.AbsolutePath);
string MACAddress = GetMacAddress();
AddErrorLog(ref ex, PageName, "User", 0, 0, MACAddress);
ClientScript.RegisterStartupScript(GetType(), "abc", "alert('Something went wrong! Try again');", true);
}
}
public ActionResult Edit(int id = 0)
{
if ((Request.Cookies["Username"] == null))
{
return(RedirectToAction("LoginIndex", "Login"));
}
if (ClsCheckRole.CheckQuyen(8, 2, int.Parse(Request.Cookies["Username"].Values["UserID"])) == true)
{
tblImage tblimages = db.tblImages.Find(id);
var menuModel = db.tblGroupProducts.Where(m => m.ParentID == null).OrderBy(m => m.id).ToList();
carlist.Clear();
string strReturn = "---";
foreach (var item in menuModel)
{
carlist.Add(new SelectListItem {
Text = item.Name, Value = item.id.ToString()
});
StringClass.DropDownListFor(item.id, carlist, strReturn);
strReturn = "---";
}
var ListManu = db.tblConnectImages.Where(p => p.idImg == id).ToList();
List <int> mang = new List <int>();
for (int i = 0; i < ListManu.Count; i++)
{
mang.Add(int.Parse(ListManu[i].idCate.ToString()));
}
ViewBag.MutilMenu = new MultiSelectList(carlist, "Value", "Text", mang);
int idCate = int.Parse(tblimages.idCate.ToString());
var menuModels = db.tblGroupImages.Where(m => m.Active == true).OrderBy(m => m.Ord).ToList();
var lstMenus = new List <SelectListItem>();
lstMenus.Clear();
foreach (var menu in menuModels)
{
lstMenus.Add(new SelectListItem {
Text = menu.Name, Value = menu.id.ToString()
});
}
ViewBag.drMenu = new SelectList(lstMenus, "Value", "Text", idCate);
if (tblimages == null)
{
return(HttpNotFound());
}
return(View(tblimages));
}
else
{
return(Redirect("/Users/Erro"));
}
}
public ActionResult AddProduct_Post([Bind(Include = "productName, productDescription, productPrice, productCategory, productQuantity")] tblProduct tblProduct, List <HttpPostedFileBase> file)
{
List <tblImage> prodImages = new List <tblImage>();
// prodImages = null;
var path = "";
foreach (var item in file)
{
if (item != null)
{
tblImage img = new tblImage();
img.ImageFile = new byte[item.ContentLength];
img.ImageName = string.Format(@"{0}.JPG", Guid.NewGuid());
// img.prod_ID = latestProdID;
img.vend_ID = Convert.ToInt32(Session["userID"]);
item.InputStream.Read(img.ImageFile, 0, item.ContentLength);
path = Path.Combine(Server.MapPath("~/Content/img"), img.ImageName);
var pathForDB = "~/Content/img/" + img.ImageName;
item.SaveAs(path);
img.ImagePath = pathForDB;
prodImages.Add(img);
}
}
tblProduct.venodrID = Convert.ToInt32(Session["userID"]);
if (prodImages.Count != 0)
{
tblProduct.productThumbnailPath = prodImages.First().ImagePath;
tblProduct.tblImages = prodImages;
}
if (ModelState.IsValid)
{
db.tblProducts.Add(tblProduct);
db.SaveChanges();
int latestProdID = tblProduct.productID;
foreach (tblImage tblImg in tblProduct.tblImages)
{
tblImg.prod_ID = latestProdID;
db.Entry(tblImg).State = EntityState.Modified;
}
db.SaveChanges();
return(RedirectToAction("DashBoard"));
}
ViewBag.productCategory = new SelectList(db.tblCategories, "categoryID", "categoryName");
ViewBag.vendorGender = new SelectList(db.tblGenders, "genderId", "genderName");
return(View());
}
public static void Delete(long id)
{
DataClassesDataContext dataContext = new DataClassesDataContext();
var varmemembers = from mem in dataContext.tblImages where mem.id == id select mem;
tblImage _ima = varmemembers.FirstOrDefault();
if (_ima != null)
{
dataContext.tblImages.DeleteOnSubmit(_ima);
}
dataContext.SubmitChanges();
}
public void DeleteMovie(decimal id)
{
using (MoviesEntities db = new MoviesEntities())
{
DeleteMovieAndActors(id, db);
tblMovy tMovie = db.tblMovies.Find(id);
tblImage tblImage = tMovie.tblImage;
db.tblMovies.Remove(tMovie);
db.SaveChanges();
db.tblImages.Remove(tblImage);
db.SaveChanges();
}
}
// GET: tblImages/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
tblImage tblImage = db.tblImages.Find(id);
if (tblImage == null)
{
return(HttpNotFound());
}
return(View(tblImage));
}
protected void Button1_Click(object sender, EventArgs e)
{
try {
var dc = new DataClassesDataContext();
if (FileUpload1.HasFile)
{
var path = Server.MapPath("~/Admin/Upload");
FileUpload1.SaveAs(path + "/" + FileUpload1.FileName);
tblImage objimg = new tblImage();
objimg.Name = FileUpload1.FileName;
objimg.AlbumID = 1;
objimg.IsActive = true;
objimg.IsDefault = false;
objimg.CreatedOn = DateTime.Now;
dc.tblImages.InsertOnSubmit(objimg);
dc.SubmitChanges();
}
var img = (from im in dc.tblImages
orderby im.ImagesID descending
select im).FirstOrDefault();
tblAdmin objAd = new tblAdmin();
objAd.FirstName = txtfnm.Text;
objAd.LastName = txtlnm.Text;
objAd.Email = txtmail.Text;
objAd.Password = Encryptdata(txtpass.Text);
objAd.ContactNO = txtcno.Text;
objAd.ImageID = Convert.ToInt32(img.ImagesID);
//objAd.Image = FileUpload1.FileName;
objAd.IsInsert = CheckBox1.Checked;
objAd.IsUpdate = CheckBox2.Checked;
objAd.IsDelete = CheckBox3.Checked;
objAd.IsSuper = CheckBox4.Checked;
objAd.IsActive = true;
objAd.CreatedBy = Convert.ToInt32(Session["AdminID"]);
objAd.CreatedOn = DateTime.Now;
dc.tblAdmins.InsertOnSubmit(objAd);
dc.SubmitChanges();
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('Record Inserted Successfully')", true);
clear1();
binddata();
}
catch (Exception ex)
{
int session = Convert.ToInt32(Session["AdminID"].ToString());
string PageName = System.IO.Path.GetFileName(Request.Url.AbsolutePath);
string MACAddress = GetMacAddress();
AddErrorLog(ref ex, PageName, "Admin", 0, session, MACAddress);
ClientScript.RegisterStartupScript(GetType(), "abc", "alert('Something went wrong! Try again');", true);
}
}
public ActionResult EditImageS(tblImage model, HttpPostedFileBase Image)
{
// Image
if (Image != null)
{
String newName = Image.FileName.Insert(Image.FileName.LastIndexOf('.'), String.Format("{0:_ddMMyyyy}", DateTime.Now));
String path = Server.MapPath("~/Images/Sliders/" + newName);
Image.SaveAs(path);
model.Image = newName;
}
db.Entry(model).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
public decimal SaveImage(string imagePath, string title)
{
using (MoviesEntities db = new MoviesEntities())
{
tblImage tImage = new tblImage();
tImage.ImagePath = imagePath;
tImage.ImageTitle = title;
tImage.IsDeleted = false;
tImage.CreatedDateTime = DateTime.Now;
tImage.LastModifedDateTime = DateTime.Now;
db.tblImages.Add(tImage);
db.SaveChanges();
return(tImage.ImageId);
}
}
public ActionResult DeleteImages(int id)
{
if (ClsCheckRole.CheckQuyen(9, 3, int.Parse(Request.Cookies["Username"].Values["UserID"])) == true)
{
tblImage tblimages = db.tblImages.Find(id);
var result = string.Empty;
db.tblImages.Remove(tblimages);
db.SaveChanges();
result = "Bạn đã xóa thành công.";
return(Json(new { result = result }));
}
else
{
var result = string.Empty;
result = "Bạn không có quyền thay đổi tính năng này";
return(Json(new { result = result }));
}
}
public int DeleteActor(decimal id)
{
using (MoviesEntities db = new MoviesEntities())
{
var tActorMovy = db.tblActorMovies.Select(q => q.ActorId == id).ToList();
if (tActorMovy.Count == 0)
{
tblActor tblActor = db.tblActors.Find(id);
tblImage tblImage = tblActor.tblImage;
db.tblActors.Remove(tblActor);
db.SaveChanges();
db.tblImages.Remove(tblImage);
db.SaveChanges();
return(0);
}
return(-1);
}
}
public ActionResult CreateProject(tblProject model, IEnumerable <HttpPostedFileBase> ListImage)
{
if (Request["btnSave"] != null)
{
model.CreateDate = DateTime.Now;
db.tblProject.Add(model);
db.SaveChanges();
var idPro = model.Id;
if (ListImage == null)
{
return(RedirectToAction("Index"));
}
foreach (var item in ListImage)
{
if (item == null)
{
continue;
}
var newName = item.FileName.Insert(item.FileName.LastIndexOf('.'), $"{DateTime.Now:_ddMMyyyy_hhss}");
var path = Server.MapPath("~/Uploads/News/" + newName);
item.SaveAs(path);
var image = new tblImage
{
Image = newName,
URL = "/Uploads/News/" + newName,
ProjectId = idPro,
DictionaryId = 47
};
db.tblImage.Add(image);
}
db.SaveChanges();
return(RedirectToAction("Index"));
}
// loại dự án
ViewBag.TypeId = new SelectList(db.tblDictionary.Where(p => p.CategoryId == 14), "Id", "Title");
ViewBag.ProvinceId = new SelectList(db.tblProvince, "Id", "Name", model.ProvinceId);
//chọn quận huyện
ViewBag.DistrictId = new SelectList(db.tblDistrict, "Id", "Name", model.DistrictId);
return(View(model));
}
public ActionResult CreateImage(tblImage model, HttpPostedFileBase Image)
{
if (Request["btnSave"] != null)
{
// Image
if (Image != null)
{
String newName = Image.FileName.Insert(Image.FileName.LastIndexOf('.'), String.Format("{0:_ddMMyyyy}", DateTime.Now));
String path = Server.MapPath("~/Images/Sliders/" + newName);
Image.SaveAs(path);
model.Image = newName;
}
db.tblImage.Add(model);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.DictionaryId = new SelectList(db.tblDictionary.Where(n => n.Id == 44 || n.Id == 45 || n.Id == 46).ToList(), "Id", "Title", model.DictionaryId);
return(View());
}
public ActionResult Create(tblLand model, IEnumerable <HttpPostedFileBase> listImage)
{
if (Request["btnSave"] != null)
{
model.CreateDate = DateTime.Now;
model.Area = Request["DienTich"];
db.tblLand.Add(model);
db.SaveChanges();
var id = model.Id;
if (listImage != null)
{
foreach (var item in listImage)
{
if (item == null)
{
continue;
}
var newName = item.FileName.Insert(item.FileName.LastIndexOf('.'), $"{DateTime.Now:_ddMMyyyy}");
var path = Server.MapPath("~/Uploads/News/" + newName);
item.SaveAs(path);
var image = new tblImage
{
Image = newName,
URL = "/Uploads/News/" + newName,
LandId = id,
DictionaryId = 47
};
db.tblImage.Add(image);
}
}
db.SaveChanges();
return(RedirectToAction("Index"));
}
Load(model);
return(View());
}
public static void SaveFile(tblImage image, HttpPostedFileBase file, string fileName)
{
string filePath = string.Empty;
string relativePath = string.Empty;
if (file != null)
{
filePath = string.Format("~/Images/Albums/{0}", image.tblAlbum.ALB_Name);
//relativePath = string.Format("~/Images/Albums/{0}/{1}", image.tblAlbum.ALB_Name, fileName);
var mappedPath = System.Web.Hosting.HostingEnvironment.MapPath(filePath);
string path = Path.Combine(mappedPath, Path.GetFileName(file.FileName));
if (!Directory.Exists(filePath))
{
Directory.CreateDirectory(filePath);
}
file.SaveAs(path);
}
}
public bool AddNewGame(string UserEmail)
{
if (this.TitleGame.Length >= 3 && this.Description.Length >= 3)
{
if (this.ReleaseDate.ToShortDateString() == new DateTime().ToShortDateString())
{
this.ReleaseDate = DateTime.Now;
}
tblGame newGame = new tblGame()
{
Title = Verify.HtmlSpecialCharsFunction(this.TitleGame), Description = Verify.HtmlSpecialCharsFunction(this.Description), FK_Genre = this.GenreId, FK_Publisher = this.PublisherId, ReleaseDate = (DateTime)this.ReleaseDate, FK_User = UserEmail, Visible = true
};
connection.tblGame.Add(newGame);
connection.SaveChanges();
try {
tblGame readID = (tblGame)connection.tblGame.Where(x => x.Title == this.TitleGame).SingleOrDefault();
if (readID != null)
{
using (var streamreader = new MemoryStream())
{
this.Bild.InputStream.CopyTo(streamreader);
tblImage newImage = new tblImage()
{
FK_Game = readID.Game_ID, ImageData = streamreader.ToArray()
};
connection.tblImage.Add(newImage);
connection.SaveChanges();
return(true);
}
}
} catch
{
return(true);
}
}
return(false);
}
public ActionResult Update(tblLand model, IEnumerable <HttpPostedFileBase> listImage)
{
var dba = new LandSoftEntities();
var la = dba.tblLand.Find(model.Id);
if (la == null)
{
return(RedirectToAction("Update"));
}
foreach (var item in listImage)
{
if (item == null)
{
continue;
}
var newName = item.FileName.Insert(item.FileName.LastIndexOf('.'), $"{DateTime.Now:_ddMMyyyy}");
var path = Server.MapPath("~/Uploads/News/" + newName);
item.SaveAs(path);
var a = new tblImage
{
Image = newName,
URL = "/Uploads/News/" + newName,
LandId = model.Id,
DictionaryId = 47
};
db.tblImage.Add(a);
}
model.Area = string.Empty;
model.Area = Request["DienTich"];
model.CustomerId = la.CustomerId;
model.CreateDate = la.CreateDate;
db.Entry(model).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Create(tblImage tblimages, FormCollection collection, int[] MutilMenu, int[] drMenuCap)
{
int idCate = int.Parse(collection["drMenu"]);
tblimages.idCate = idCate;
db.tblImages.Add(tblimages);
db.SaveChanges();
Updatehistoty.UpdateHistory("Add tblimages", Request.Cookies["Username"].Values["FullName"].ToString(), Request.Cookies["Username"].Values["UserID"].ToString());
if (collection["btnSave"] != null)
{
Session["Thongbao"] = "<div class=\"alert alert-info alert1\">Bạn đã thêm thành công !<button class=\"close\" data-dismiss=\"alert\">×</button></div>";
return(Redirect("/Imagesad/Index?idCate=" + idCate + ""));
}
if (collection["btnSaveCreate"] != null)
{
Session["Thongbao"] = "<div class=\"alert alert-info\">Bạn đã thêm thành công, mời bạn thêm mới !<button class=\"close\" data-dismiss=\"alert\">×</button></div>";
return(Redirect("/Imagesad/Create?id=" + idCate + ""));
}
return(Redirect("Index"));
}
private void DisplayImage()
{
if (ViewState["ImgId"] != null)
{
ViewState["ImgId"] = Convert.ToInt64(ViewState["ImgId"]) + 1;
var gg = ImgAppHelper.Context.tblImages.Where(a => a.FK_User == Convert.ToInt64(Session["UserId"])).OrderByDescending(a => a.Id);
if (Convert.ToInt64(ViewState["ImgId"]) >= gg.First().Id)
{
DirectoryInfo dr = new DirectoryInfo(@"C:\ImgAppImages");
FileInfo[] fl = dr.GetFiles();
int i = 0;
foreach (FileInfo item in fl)
{
if (!File.Exists(Server.MapPath("~/ProcessedImages/" + item.Name)))
{
File.Copy(item.DirectoryName + "\\" + item.Name, Server.MapPath("~/ProcessedImages/" + item.Name));
imgSource.ImageUrl = "~/ProcessedImages/" + item.Name;
i = 1;
using (var obj = new ImgAppDataContext())
{
var tblimg = new tblImage();
tblimg.AltId = txtAltId.Text;
tblimg.BoxBarcode = txtBoxBarCode.Text;
tblimg.Date = DateTime.Now;
tblimg.Des1 = txtDes1.Text;
tblimg.Des2 = txtDes2.Text;
tblimg.Des3 = txtDes3.Text;
tblimg.Des4 = txtDes4.Text;
tblimg.DestroyDate = DateTime.Now;
txtDestroyDate.Text = DateTime.Now.ToShortDateString();
tblimg.FK_User = Convert.ToInt64(Session["UserId"]);
tblimg.FromDate = DateTime.Now;
txtFromDate.Text = DateTime.Now.ToShortDateString();
tblimg.ImageName = item.Name;
txtImageName.Text = item.Name;
tblimg.ImgaePath = imgSource.ImageUrl;
tblimg.ToDate = DateTime.Now;
txtToDate.Text = DateTime.Now.ToShortDateString();
obj.tblImages.InsertOnSubmit(tblimg);
obj.SubmitChanges();
ViewState["ImgId"] = tblimg.Id;
ViewState["ImgId"] = Convert.ToInt64(ViewState["ImgId"]) + 1;
}
return;
}
}
if (i == 0)
{
Label1.Visible = true;
imgSource.Visible = false;
}
}
else
{
ViewState["ImgId"] = Convert.ToInt64(ViewState["ImgId"]) + 1;
using (var obj = new ImgAppDataContext())
{
var tblimg = obj.tblImages.Single(a => a.Id == Convert.ToInt64(ViewState["ImgId"]) && a.FK_User == Convert.ToInt64(Session["UserId"]));
txtAltId.Text = tblimg.AltId;
txtBoxBarCode.Text = tblimg.BoxBarcode;
txtDes1.Text = tblimg.Des1;
txtDes2.Text = tblimg.Des2;
txtDes3.Text = tblimg.Des3;
txtDes4.Text = tblimg.Des4;
txtDestroyDate.Text = tblimg.DestroyDate.Value.ToShortDateString();
txtFromDate.Text = tblimg.FromDate.Value.ToShortDateString();
txtImageName.Text = tblimg.ImageName;
imgSource.ImageUrl = tblimg.ImgaePath;
Label1.Visible = false;
imgSource.Visible = true;
txtToDate.Text = tblimg.ToDate.Value.ToShortDateString();
}
}
}
}
partial void InserttblImage(tblImage instance);
partial void UpdatetblImage(tblImage instance);
partial void DeletetblImage(tblImage instance);
private void attach_tblImages(tblImage entity)
{
this.SendPropertyChanging();
entity.tblUsera = this;
}
private void detach_tblImages(tblImage entity)
{
this.SendPropertyChanging();
entity.tblUsera = null;
}
public string AddImage(string ddlAlbums, string ddlConditions,
string ddlFeatures)
{
var image = new tblImage();
try
{
var dbCtx = new CUATRGEntities4();
tblAlbum album = dbCtx.tblAlbums.FirstOrDefault(a => a.ALB_Name == ddlAlbums);
if (album == null)
{
album = dbCtx.tblAlbums.Create();
album.ALB_Name = ddlAlbums;
album.ALB_Description = ddlAlbums;
}
tblEnvironmentalCondition condition = dbCtx.tblEnvironmentalConditions.FirstOrDefault(a => a.ENC_Name == ddlConditions);
if (condition == null)
{
condition = dbCtx.tblEnvironmentalConditions.Create();
condition.ENC_Name = ddlConditions;
condition.ENC_Description = ddlConditions;
}
tblFeature feature = dbCtx.tblFeatures.FirstOrDefault(a => a.FTR_Name == ddlFeatures);
if (feature == null)
{
feature = dbCtx.tblFeatures.Create();
feature.FTR_Name = ddlFeatures;
}
image.tblAlbum = album;
image.tblEnvironmentalCondition = condition;
image.tblFeature = feature;
log.Info("Saving files started");
var files = HttpContext.Current.Request.Files.Count > 0 ?
HttpContext.Current.Request.Files : null;
log.InfoFormat("Files {0} , Album {1}, Condition {2}, Feature {3} ",
string.Join(",", files.AllKeys), ddlAlbums, ddlConditions, ddlFeatures);
if (files != null)
{
foreach (var file in files.AllKeys)
{
var path = string.Format("~/Images/Albums/{0}", ddlAlbums);
var relativePath = string.Format("Images/Albums/{0}", ddlAlbums);
var fileName = files[file].FileName;
if (fileName.Contains("Image") || fileName.Contains("IMG"))
{
image.IMG_Name = fileName;
image.IMG_Path = relativePath;
}
else if (fileName.Contains("Sensor"))
{
image.IMG_SensorDataPath = relativePath;
}
else if (fileName.Contains("Meta"))
{
image.IMG_MetaDataPath = relativePath;
}
if (ImageHelper.IsExists(image))
{
throw new InvalidOperationException("Image Exists");
}
var mappedPath = System.Web.Hosting.HostingEnvironment.MapPath(path);
var filePath = Path.Combine(mappedPath, Path.GetFileName(fileName));
if (!Directory.Exists(mappedPath))
{
log.Info("Creating directory");
Directory.CreateDirectory(mappedPath);
}
string user = System.Security.Principal.WindowsIdentity.GetCurrent().User.Value;
var uploadedFile = files[file];
uploadedFile.SaveAs(filePath);
}
}
log.Info("Saving files completed");
log.Info("Retriving Exif data started");
ImageHelper.ExtractMetaData(image);
log.Info("Saving db data started");
//Add newStudent entity into DbEntityEntry and mark EntityState to Added
dbCtx.Entry(image).State = EntityState.Added;
// call SaveChanges method to save new Student into database
dbCtx.SaveChanges();
log.Info("Saving db data completed");
return("OK");
}
catch (DbEntityValidationException ex)
{
var valErrors = ex.EntityValidationErrors.SelectMany(e => e.ValidationErrors);
var error = string.Join(",", valErrors.Select(e => e.ErrorMessage));
log.Error(string.Format("Error uploading image {0} - {1}", image.IMG_Name, error), ex);
return("ERROR:" + ex.Message.ToString());
}
catch (Exception ex)
{
log.Error(string.Format("Error saving image {0}", image.IMG_Name), ex);
return(ex.ToString());
}
}
