public void DeletePhoto(PHOTO _photo)
{
_photo.IsDeleted = "Y";
_photo.LastModified = System.DateTime.UtcNow;
_databaseHelper.UpdatePhoto(_photo);
_databaseHelper.SetPlotSynch(_photo.PLOTID);
}
public ActionResult PHOTOEDIT([Bind(Include = "ID,SOTHUTU,HINHANH,HINHANHFile")] PHOTO pHOTO)
{
var dulieuphoto = new BAULEPROFOLIOEntities2(); // anh tạo 1 chuổi dulieucoán anh gọi nguyên cái DB của em lại. đổ vào đó
var modelclient = dulieuphoto.Photos.Single(e => e.ID == pHOTO.ID); // sau đó anh dùng biến modelimagecosan để hứng dữ liệu model tại nơi mà ID của nó bằng ID của thằng editmodel, để lấy ra đúng cái hình
if (pHOTO.HINHANHFile == null) // nếu file nó null
{
pHOTO.HINHANH = modelclient.HINHANH; //nó sẽ fill dữ liệu từ data vào lại để edit
}
else
{
string fileName = Path.GetFileNameWithoutExtension(pHOTO.HINHANHFile.FileName);
string extension = Path.GetExtension(pHOTO.HINHANHFile.FileName);
fileName = fileName + DateTime.Now.ToString("yymmssfff") + extension;
pHOTO.HINHANH = fileName;
fileName = Path.Combine(Server.MapPath("~/ContentWebmaster/img/"), fileName);//coi kỹ lại chỗ này nha.
pHOTO.HINHANHFile.SaveAs(fileName);
}
if (ModelState.IsValid)
{
db.Entry(pHOTO).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("PHOTOVIEW"));
}
return(View(pHOTO));
}
public void InsertPhoto(PHOTO photo)
{
photo.PHOTOID = Guid.NewGuid().ToString();
_databaseHelper.InsertPhoto(photo);
_databaseHelper.SetPlotSynch(photo.PLOTID);
}
public async Task <ActionResult> DeleteConfirmed(string id)
{
PHOTO pHOTO = await db.Photos.FindAsync(id);
db.Photos.Remove(pHOTO);
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
public async Task <ActionResult> DeleteConfirmed45(string id)
{
PHOTO lOGOKHACHHANG = await db.Photos.FindAsync(id);
db.Photos.Remove(lOGOKHACHHANG);
await db.SaveChangesAsync();
return(RedirectToAction("PHOTOVIEW"));
}
void CheckTable()
{
// run this to prepopulate table with photos the first time through
if (_photoRepository.IsPhotoTableEmpty(_selectedplotid))
{
PHOTO _newphoto = new PHOTO();
_newphoto.PHOTOTYPE = "Stand Information";
_newphoto.PHOTONUMBER = 1;
_newphoto.AZIMUTH = 0;
_newphoto.DISTANCE = 0;
_newphoto.PLOTID = _selectedplotid;
_newphoto.Created = System.DateTime.UtcNow;
_newphoto.LastModified = _newphoto.Created;
_newphoto.IsDeleted = "N";
_photoRepository.InsertPhoto(_newphoto);
PHOTO _newphoto2 = new PHOTO();
_newphoto2.PHOTOTYPE = "Stand Information";
_newphoto2.PHOTONUMBER = 18;
_newphoto2.AZIMUTH = 0;
_newphoto2.DISTANCE = 0;
_newphoto2.Created = System.DateTime.UtcNow;
_newphoto2.LastModified = _newphoto2.Created;
_newphoto2.IsDeleted = "N";
_newphoto2.PLOTID = _selectedplotid;
_photoRepository.InsertPhoto(_newphoto2);
// Insert records for the Stand Infor Photos
for (int i = 0; i < 8; i++)
{
PHOTO _newphoto3 = new PHOTO();
_newphoto3.PHOTOTYPE = "Stand Information";
_newphoto3.PHOTONUMBER = i + 2;
_newphoto3.AZIMUTH = 45 * i;
_newphoto3.DISTANCE = Constants.DefaultPhoto1Distance;
_newphoto3.PLOTID = _selectedplotid;
_newphoto3.Created = System.DateTime.UtcNow;
_newphoto3.LastModified = _newphoto3.Created;
_newphoto3.IsDeleted = "N";
_photoRepository.InsertPhoto(_newphoto3);
}
for (int i = 0; i < 8; i++)
{
PHOTO _newphoto4 = new PHOTO();
_newphoto4.PHOTOTYPE = "Stand Information";
_newphoto4.PHOTONUMBER = i + 10;
_newphoto4.AZIMUTH = 45 * i;
_newphoto4.DISTANCE = Constants.DefaultPhoto2Distance;
_newphoto4.PLOTID = _selectedplotid;
_newphoto4.Created = System.DateTime.UtcNow;
_newphoto4.LastModified = _newphoto4.Created;
_newphoto4.IsDeleted = "N";
_photoRepository.InsertPhoto(_newphoto4);
}
}
}
private void InsertToDB()
{
try
{
EMPLOYEE emp = new EMPLOYEE()
{
NAME_E = Name,
RATING = Convert.ToByte(Rating)
};
EMAIL eMAIL = new EMAIL()
{
ADRESS = Email
};
emp.EMAIL1 = eMAIL;
PHOTO pHOTO = new PHOTO()
{
IMAGEDATA = Photo,
};
emp.PHOTO1 = pHOTO;
emp.DEPARTMENT = (from i in ctx.DEPARTMENT
where i.D_NAME == Department
select i.ID).FirstOrDefault();
emp.CATHEDRA = (from i in ctx.CATHEDRA
where i.C_NAME == Cathedra && i.DEPARTMENT.D_NAME == Department
select i.ID).FirstOrDefault();
DEGREE dEGREE = new DEGREE()
{
YEAR_GOT = Int32.Parse(Year)
};
dEGREE.NAME_D = (from i in ctx.DEGREELIST
where i.D_NAME == Degree
select i.ID).FirstOrDefault();
emp.DEGREE1 = dEGREE;
ctx.EMPLOYEE.Add(emp);
}
catch (Exception)
{
MessageBox.Show("Fatal error while adding new employee");
return;
}
try
{
ctx.SaveChanges();
MessageBox.Show("Вітання! Співробітник доданий до БД успішно");
parentForm.Close();
}
catch (Exception)
{
MessageBox.Show("Can't save changes to DB");
}
}
public async Task <ActionResult> Edit([Bind(Include = "ID,SOTHUTU,HINHANH")] PHOTO pHOTO)
{
if (ModelState.IsValid)
{
db.Entry(pHOTO).State = EntityState.Modified;
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
return(View(pHOTO));
}
public async Task <ActionResult> Create([Bind(Include = "ID,SOTHUTU,HINHANH")] PHOTO pHOTO)
{
if (ModelState.IsValid)
{
db.Photos.Add(pHOTO);
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
return(View(pHOTO));
}
public PhotoListViewModel(INavigation navigation, string _fk)
{
_photo = new PHOTO();
_navigation = navigation;
_photoRepository = new PhotoRepository();
_selectedplotid = _fk;
AddCommand = new Command(async() => await ShowAdd(_fk));
ShowFilteredCommand = new Command <PHOTO>(async(x) => await ShowVegetation(x));
// CheckTable();
FetchVegetation();
}
// GET: Photos/Edit/5
public ActionResult PHOTOEDIT(string id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
PHOTO PHOTOEDIT = db.Photos.Find(id);
if (PHOTOEDIT == null)
{
return(HttpNotFound());
}
return(View(PHOTOEDIT));
}
//PHOTODEL
public async Task <ActionResult> PHOTOTDEL(string id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
PHOTO lOGOKHACHHANG = await db.Photos.FindAsync(id);
if (lOGOKHACHHANG == null)
{
return(HttpNotFound());
}
return(View(lOGOKHACHHANG));
}
// GET: Photos/Delete/5
public async Task <ActionResult> Delete(string id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
PHOTO pHOTO = await db.Photos.FindAsync(id);
if (pHOTO == null)
{
return(HttpNotFound());
}
return(View(pHOTO));
}
public PhotoDetailsViewModel(INavigation navigation, string selectedID)
{
_navigation = navigation;
_photo = new PHOTO();
_photo.PHOTOID = selectedID;
_photoRepository = new PhotoRepository();
_selectedplotid = selectedID;
AddCommand = new Command(async() => await Update());
DeleteCommand = new Command(async() => await Delete());
OnAppearingCommand = new Command(() => OnAppearing());
OnDisappearingCommand = new Command(() => OnDisappearing());
FetchDetails(_selectedplotid);
IsChanged = false;
}
public AddPhotoViewModel(INavigation navigation, string selectedID)
{
_navigation = navigation;
_photo = new PHOTO();
_photo.PLOTID = selectedID;
_photo.PHOTOTYPE = "Stand Information";
_photoRepository = new PhotoRepository();
_selectedplotid = selectedID;
AddCommand = new Command(async() => await Update());
DeleteCommand = new Command(async() => await Delete());
CheckTable();
OnAppearingCommand = new Command(() => OnAppearing());
OnDisappearingCommand = new Command(() => OnDisappearing());
IsChanged = false;
}
public ActionResult EmplopyeeEdit(int id, FormCollection collection)
{
var e = (from i in ctx.EMPLOYEE
where i.ID == id
select i).First();
if (Request.Files.Count > 0)
{
var file = Request.Files[0];
if (file != null && file.ContentLength > 0)
{
var stream = file.InputStream;
using (MemoryStream ms = new MemoryStream())
{
stream.CopyTo(ms);
PHOTO pHOTO = new PHOTO
{
IMAGEDATA = ms.ToArray()
};
e.PHOTO1 = pHOTO;
}
}
}
try
{
if (ModelState.IsValid)
{
UpdateModel(e);
ctx.SaveChanges();
return(RedirectToAction("Index"));
}
else
{
SelectList items = new SelectList(ctx.DEPARTMENT, "ID", "D_NAME");
ViewBag.Departments = items;
SelectList items2 = new SelectList(ctx.CATHEDRA, "ID", "C_NAME");
ViewBag.Cathedras = items2;
SelectList items3 = new SelectList(ctx.DEGREELIST, "ID", "D_NAME");
ViewBag.Degrees = items3;
}
}
catch
{
}
return(View(e));
}
public ActionResult AddProduct(PRODUCT model, HttpPostedFileBase photofile)
{
USERS myuser = new USERS();
var sessionUsername = Session["username"].ToString();
myuser = dbContext.USERS.Where(i => i.USERNAME == sessionUsername).FirstOrDefault();
PRODUCT product = new PRODUCT();
PHOTO myPhoto = new PHOTO();
try
{
product = model;
product.USER_ID = myuser.ID;
product.CATEGORY_ID = model.CATEGORY_ID;
//foreach (HttpPostedFileBase file in photofiles)
// {
if (photofile != null)
{
var _FileName = Path.GetFileName(photofile.FileName);
var _path = Path.Combine(Server.MapPath("~/imageServer/"), _FileName);
string dbPath = "/imageServer/" + _FileName;
photofile.SaveAs(_path);
ViewBag.Message = "File Uploaded Successfully!!";
myPhoto.URL = dbPath;
myPhoto.PRODUCT_ID = product.ID;
product.SINGLE_PHOTO = dbPath;
dbContext.PHOTO.Add(myPhoto);
}
//}
}
catch (Exception ex)
{
string msg = ex.Message;
ViewBag.PhotoMessage = "File upload failed!!" + msg;
}
dbContext.PRODUCT.Add(product);
dbContext.SaveChanges();
return(RedirectToAction("AddProduct"));
}
public async Task <ActionResult> PHOTOADD([Bind(Include = "ID,SOTHUTU,HINHANH,HINHANHFile")] PHOTO pHOTO)
{
string fileName = Path.GetFileNameWithoutExtension(pHOTO.HINHANHFile.FileName);
string extension = Path.GetExtension(pHOTO.HINHANHFile.FileName);
fileName = fileName + DateTime.Now.ToString("yymmssfff") + extension;
pHOTO.HINHANH = fileName;
fileName = Path.Combine(Server.MapPath("~/ContentWebmaster/img/"), fileName);
pHOTO.HINHANHFile.SaveAs(fileName);
pHOTO.ID = getGUID().ToString();
if (ModelState.IsValid)
{
db.Photos.Add(pHOTO);
await db.SaveChangesAsync();
return(RedirectToAction("PHOTOVIEW"));
}
return(View(pHOTO));
}
/// <summary>
/// Method used to add a property to the instance. Will be placed in the correct class Property.
/// </summary>
/// <param name="input">The vCard.Property to add.</param>
public void AddProperty(Props.IProperty input)
{
if (input == null || input.IsValueNull)
{
return;
}
switch (input.Property)
{
case KnownProperties.ADR:
ADR.AddIfNotNull(input as Props.ADR);
break;
case KnownProperties.ANNIVERSARY:
ANNIVERSARY = input as Props.ANNIVERSARY;
break;
case KnownProperties.BDAY:
BDAY = input as Props.BDAY;
break;
case KnownProperties.CALADRURI:
CALADRURI.AddIfNotNull(input as Props.CALADRURI);
break;
case KnownProperties.CALURI:
CALURI.AddIfNotNull(input as Props.CALURI);
break;
case KnownProperties.CATEGORIES:
CATEGORIES.AddIfNotNull(input as Props.CATEGORIES);
break;
case KnownProperties.CLIENTPIDMAP:
CLIENTPIDMAP.AddIfNotNull(input as Props.CLIENTPIDMAP);
break;
case KnownProperties.EMAIL:
EMAIL.AddIfNotNull(input as Props.EMAIL);
break;
case KnownProperties.FBURL:
FBURL.AddIfNotNull(input as Props.FBURL);
break;
case KnownProperties.FN:
FN.AddIfNotNull(input as Props.FN);
break;
case KnownProperties.GENDER:
GENDER = input as Props.GENDER;
break;
case KnownProperties.GEO:
GEO.AddIfNotNull(input as Props.GEO);
break;
case KnownProperties.IMPP:
IMPP.AddIfNotNull(input as Props.IMPP);
break;
case KnownProperties.KEY:
KEY.AddIfNotNull(input as Props.KEY);
break;
case KnownProperties.KIND: {
char k = (input as Props.KIND).Value.ToLower()[0];
if (k == 'i')
{
KIND = Kinds.Individual;
}
else if (k == 'g')
{
KIND = Kinds.Group;
}
else if (k == 'o')
{
KIND = Kinds.Org;
}
else if (k == 'l')
{
KIND = Kinds.Location;
}
else
{
KIND = Kinds.Individual;
}
break;
}
case KnownProperties.LANG:
LANG.AddIfNotNull(input as Props.LANG);
break;
case KnownProperties.LOGO:
LOGO.AddIfNotNull(input as Props.LOGO);
break;
case KnownProperties.MEMBER:
MEMBER.AddIfNotNull(input as Props.MEMBER);
break;
case KnownProperties.N:
N = input as Props.N;
break;
case KnownProperties.NICKNAME:
NICKNAME.AddIfNotNull(input as Props.NICKNAME);
break;
case KnownProperties.NOTE:
NOTE.AddIfNotNull(input as Props.NOTE);
break;
case KnownProperties.ORG:
ORG.AddIfNotNull(input as Props.ORG);
break;
case KnownProperties.PHOTO:
PHOTO.AddIfNotNull(input as Props.PHOTO);
break;
case KnownProperties.PRODID:
PRODID = input as Props.PRODID;
break;
case KnownProperties.RELATED:
RELATED.AddIfNotNull(input as Props.RELATED);
break;
case KnownProperties.REV:
REV = input as Props.REV;
break;
case KnownProperties.ROLE:
ROLE.AddIfNotNull(input as Props.ROLE);
break;
case KnownProperties.SOUND:
SOUND.AddIfNotNull(input as Props.SOUND);
break;
case KnownProperties.SOURCE:
SOURCE.AddIfNotNull(input as Props.SOURCE);
break;
case KnownProperties.TEL:
TEL.AddIfNotNull(input as Props.TEL);
break;
case KnownProperties.TITLE:
TITLE.AddIfNotNull(input as Props.TITLE);
break;
case KnownProperties.TZ:
TZ.AddIfNotNull(input as Props.TZ);
break;
case KnownProperties.UID:
UID = input as Props.UID;
break;
case KnownProperties.URL:
URL.AddIfNotNull(input as Props.URL);
break;
case KnownProperties.VERSION:
VERSION = input as Props.VERSION;
break;
case KnownProperties.XML:
XML.AddIfNotNull(input as Props.XML);
break;
default:
return;
}
}
async Task ShowVegetation(PHOTO _vegetation)
{
// launch the form - filtered to a specific projectid
await _navigation.PushAsync(new PhotoDetailsPage(_vegetation.PHOTOID));
}
public async Task CheckTable()
{
// run this to prepopulate table with photos the first time through
if (_photoRepository.IsPhotoTableEmpty(_selectedplotid))
{
bool isUserAccept = await Application.Current.MainPage.DisplayAlert("Add Photo Details", "Do you want to prepopulate the standard 18 Stand Information Photo Details?", "OK", "Cancel");
if (isUserAccept)
{
PHOTO _newphoto = new PHOTO();
_newphoto.PHOTOTYPE = "Stand Information";
_newphoto.PHOTONUMBER = 1;
_newphoto.AZIMUTH = 0;
_newphoto.DISTANCE = 0;
_newphoto.PLOTID = _selectedplotid;
_newphoto.Created = System.DateTime.UtcNow;
_newphoto.LastModified = _newphoto.Created;
_newphoto.IsDeleted = "N";
_photoRepository.InsertPhoto(_newphoto);
PHOTO _newphoto2 = new PHOTO();
_newphoto2.PHOTOTYPE = "Stand Information";
_newphoto2.PHOTONUMBER = 18;
_newphoto2.AZIMUTH = 0;
_newphoto2.DISTANCE = 0;
_newphoto2.Created = System.DateTime.UtcNow;
_newphoto2.LastModified = _newphoto2.Created;
_newphoto2.IsDeleted = "N";
_newphoto2.PLOTID = _selectedplotid;
_photoRepository.InsertPhoto(_newphoto2);
// Insert records for the Stand Infor Photos
int j = 1;
for (int i = 2; i < 18; i += 2)
{
PHOTO _newphoto3 = new PHOTO();
_newphoto3.PHOTOTYPE = "Stand Information";
_newphoto3.PHOTONUMBER = i;
_newphoto3.AZIMUTH = (i - (j + 1)) * 45;
if (j % 2 == 0)
{
_newphoto3.DISTANCE = Constants.DefaultPhoto2Distance;
}
else
{
_newphoto3.DISTANCE = Constants.DefaultPhoto1Distance;
}
_newphoto3.PLOTID = _selectedplotid;
_newphoto3.Created = System.DateTime.UtcNow;
_newphoto3.LastModified = _newphoto3.Created;
_newphoto3.IsDeleted = "N";
_photoRepository.InsertPhoto(_newphoto3);
j = j + 1;
}
j = 2;
for (int i = 3; i < 18; i += 2)
{
PHOTO _newphoto3 = new PHOTO();
_newphoto3.PHOTOTYPE = "Stand Information";
_newphoto3.PHOTONUMBER = i;
_newphoto3.AZIMUTH = (i - (j + 1)) * 45;
if (j % 2 == 0)
{
_newphoto3.DISTANCE = Constants.DefaultPhoto2Distance;
}
else
{
_newphoto3.DISTANCE = Constants.DefaultPhoto1Distance;
}
_newphoto3.PLOTID = _selectedplotid;
_newphoto3.Created = System.DateTime.UtcNow;
_newphoto3.LastModified = _newphoto3.Created;
_newphoto3.IsDeleted = "N";
_photoRepository.InsertPhoto(_newphoto3);
j = j + 1;
}
FetchVegetation();
}
}
}
public Task DeleteTaskAsync(PHOTO item)
{
return(restService.DeleteAsync(tablename, item.PHOTOID));
}
public void UpdatePhoto(PHOTO photo)
{
_databaseHelper.UpdatePhoto(photo);
_databaseHelper.SetPlotSynch(photo.PLOTID);
}
