public ActionResult DeleteConfirmed(Guid id)
{
acts acts = db.acts.Find(id);
db.acts.Remove(acts);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult ViewPhoto(Guid id)
{
acts act = db.acts.Find(id);
if (act == null)
{
return(HttpNotFound());
}
return(File(act.photo, "image/png"));
}
public ActionResult Edit([Bind(Include = "act_id,number,date,name,location,geo_location,photo,doc,extra_info,user_id")] acts acts)
{
if (ModelState.IsValid)
{
db.Entry(acts).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.user_id = new SelectList(db.users, "user_id", "name", acts.user_id);
return(View(acts));
}
// GET: acts/Details/5
public ActionResult Details(Guid?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
acts acts = db.acts.Find(id);
if (acts == null)
{
return(HttpNotFound());
}
return(View(acts));
}
// GET: acts/Edit/5
public ActionResult Edit(Guid?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
acts acts = db.acts.Find(id);
if (acts == null)
{
return(HttpNotFound());
}
ViewBag.user_id = new SelectList(db.users, "user_id", "name", acts.user_id);
return(View(acts));
}
public ActionResult ExportToWord(Guid id)
{
acts act = db.acts.Find(id);
var NumberAct1 = db.acts.Where(p => p.act_id == id).Select(p => p.number);
string[] tempNA = NumberAct1.ToArray();
string NumberAct = tempNA[0];
var Date1 = db.acts.Where(o => o.act_id == id).Select(o => o.date);
var Name1 = db.acts.Where(l => l.act_id == id).Select(l => l.name);
string[] tempN = Name1.ToArray();
string Name = tempN[0];
var Coordinates1 = db.acts.Where(m => m.act_id == id).Select(m => m.location);
string[] tempC = Coordinates1.ToArray();
string Coordinates = tempC[0];
var Information1 = db.acts.Where(n => n.act_id == id).Select(n => n.extra_info);
string[] tempI = Information1.ToArray();
string Information = tempI[0];
var Resp1 = db.acts.Where(k => k.act_id == id).Select(k => k.users.name);
string[] tempR = Resp1.ToArray();
string Resp = tempR[0];
var WordApp = new Word.Application();
WordApp.Visible = false;
var wordDocument = WordApp.Documents.Open(TemplateFileName);
ReplaceWordStub("{NumberAct}", NumberAct, wordDocument);
//ReplaceWordStub("{Date}", Date, wordDocument);
ReplaceWordStub("{Name}", Name, wordDocument);
ReplaceWordStub("{Coordinates}", Coordinates, wordDocument);
ReplaceWordStub("{Information}", Information, wordDocument);
ReplaceWordStub("{Resp}", Resp, wordDocument);
wordDocument.SaveAs("/Content/Act.docx");
wordDocument.Close();
byte[] wordDocumentBytes = System.IO.File.ReadAllBytes("/Content/Act.docx");
WordApp.Visible = true;
return(File(wordDocumentBytes, "application/vnd.openxmlformats-officedocument.wordprocessingml.document", "Act.docx"));
}
public ActionResult Create([Bind(Include = "act_id,number,date,name,location,geo_location,photo,doc,extra_info,user_id")] acts acts, HttpPostedFileBase file)
{
if (ModelState.IsValid)
{
acts.act_id = Guid.NewGuid();
acts.photo = new byte[file.ContentLength];
file.InputStream.Read(acts.photo, 0, file.ContentLength);
db.acts.Add(acts);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.user_id = new SelectList(db.users, "user_id", "name", acts.user_id);
return(View(acts));
}
/// <summary>
/// Converts this instance of <see cref="acts"/> to an instance of <see cref="actsDTO"/>.
/// </summary>
/// <param name="entity"><see cref="acts"/> to convert.</param>
public static actsDTO ToDTO(this acts entity)
{
if (entity == null)
{
return(null);
}
var dto = new actsDTO();
dto.id_act = entity.id_act;
dto.name_act = entity.name_act;
dto.create_date = entity.create_date;
dto.status = entity.status;
dto.description_small = entity.description_small;
dto.description_large = entity.description_large;
dto.id_user_create = entity.id_user_create;
entity.OnDTO(dto);
return(dto);
}
/// <summary>
/// Converts this instance of <see cref="actsDTO"/> to an instance of <see cref="acts"/>.
/// </summary>
/// <param name="dto"><see cref="actsDTO"/> to convert.</param>
public static acts ToEntity(this actsDTO dto)
{
if (dto == null)
{
return(null);
}
var entity = new acts();
entity.id_act = dto.id_act;
entity.name_act = dto.name_act;
entity.create_date = dto.create_date;
entity.status = dto.status;
entity.description_small = dto.description_small;
entity.description_large = dto.description_large;
entity.id_user_create = dto.id_user_create;
dto.OnEntity(entity);
return(entity);
}
/// <summary> /// Invoked when <see cref="ToEntity"/> operation is about to return. /// </summary> /// <param name="entity"><see cref="acts"/> converted from <see cref="actsDTO"/>.</param> static partial void OnEntity(this actsDTO dto, acts entity);
/// <summary> /// Invoked when <see cref="ToDTO"/> operation is about to return. /// </summary> /// <param name="dto"><see cref="actsDTO"/> converted from <see cref="acts"/>.</param> static partial void OnDTO(this acts entity, actsDTO dto);
