public List <Document_Detail> BindDocumentDetail(string projID)
{
List <Document_Detail> objDocDetail = null;
try
{
SqlHelper sqlHelp = new SqlHelper();
string query = @"Select ReportCode, DokumenttiURL, Filename from QTOKEM_HankeDokumentit
where Hanke_ID=" + projID + "order by Filename";
SqlCommand sqCmd = sqlHelp.GetSqlQueryCommand(query);
SqlDataReader dr = sqlHelp.ExecuteReader(sqCmd);
objDocDetail = new List <Document_Detail>();
while (dr.Read())
{
Document_Detail DocDetail = new Document_Detail();
DocDetail.ReportCode = Convert.ToString(dr["ReportCode"]);
DocDetail.DokumenttiURL = Convert.ToString(dr["DokumenttiURL"]);
DocDetail.Filename = Convert.ToString(dr["Filename"]);
objDocDetail.Add(DocDetail);
}
dr.Close();
sqCmd = null;
}
catch (Exception ex)
{
}
return(objDocDetail);
}
public ActionResult DeleteConfirmed(int id)
{
Document_Detail document_Detail = db.Document_Detail.Find(id);
db.Document_Detail.Remove(document_Detail);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit(int id)
{
Document_Detail document_Detail = db.Document_Detail.Find(id);
ViewBag.documentDetail_document_id = new SelectList(db.Documents, "document_id", "document_data", document_Detail.documentDetail_document_id);
ViewBag.documentDetail_citizen_id = new SelectList(db.Citizens, "citizen_id", "citizen_national_id", document_Detail.documentDetail_citizen_id);
return(View(document_Detail));
}
public ActionResult Delete(int id)
{
Document_Detail document_Detail = db.Document_Detail.Find(id);
return(View(document_Detail));
}
public ActionResult Edit(Document_Detail document_Detail)
{
db.Entry(document_Detail).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Create(Document_Detail document_Detail)
{
db.Document_Detail.Add(document_Detail);
db.SaveChanges();
return(RedirectToAction("Index"));
}
