public ActionResult CGCDocumentEdit(int id = 0)
{
DocumentEditViewModel viewModel = new DocumentEditViewModel();
CropGermplasmCommitteeDocument document = null;
try
{
if (id > 0)
{
document = _cgcRepository.GetDocument(id);
viewModel.CommitteeID = document.Committee.ID;
viewModel.CommitteeName = document.Committee.Name;
viewModel.Title = document.Title;
viewModel.CategoryCode = document.CategoryCode;
viewModel.CategoryTitle = document.CategoryTitle;
viewModel.Year = document.DocumentYear;
viewModel.ID = document.ID;
viewModel.URL = document.URL;
}
}
catch (Exception ex)
{
Log.Error(ex, ex.Message);
string actionName = this.ControllerContext.RouteData.Values["action"].ToString();
string controllerName = this.ControllerContext.RouteData.Values["controller"].ToString();
string errorText = "<label>Controller:</label>" + controllerName;
errorText = errorText + "<br><label>Action:</label>" + actionName;
errorText = errorText + "<br><label>Details:</label>" + ex.TargetSite + ex.Message;
Session["ERROR_TEXT"] = errorText;
return(RedirectToAction("InternalServerError", "Error"));
}
return(View("~/Views/Admin/CGC/Edit.cshtml", viewModel));
}
public CropGermplasmCommitteeDocument GetDocument(int id)
{
CropGermplasmCommitteeDocument cropGermplasmCommitteeDocument = null;
try
{
var result = _dataContext.usp_ARS_CropGermplasmCommitteeDocument_Select(id).FirstOrDefault();
if (result != null)
{
cropGermplasmCommitteeDocument = new CropGermplasmCommitteeDocument();
cropGermplasmCommitteeDocument.ID = result.crop_germplasm_committee_document_id;
cropGermplasmCommitteeDocument.Title = result.document_title;
cropGermplasmCommitteeDocument.CategoryCode = result.category_code;
cropGermplasmCommitteeDocument.CategoryTitle = result.category_title;
cropGermplasmCommitteeDocument.URL = result.url;
cropGermplasmCommitteeDocument.DocumentYear = result.document_year.GetValueOrDefault();
cropGermplasmCommitteeDocument.Committee.ID = result.crop_germplasm_committee_id.GetValueOrDefault();
cropGermplasmCommitteeDocument.Committee.Name = result.crop_germplasm_committee_name;
cropGermplasmCommitteeDocument.CreatedDate = result.created_date.GetValueOrDefault();
cropGermplasmCommitteeDocument.ModifiedDate = result.modified_date.GetValueOrDefault();
}
}
catch (SqlException ex)
{
throw ex;
}
return(cropGermplasmCommitteeDocument);
}
public ResultContainer DeleteDocument(CropGermplasmCommitteeDocument document)
{
int? errorNumber = 0;
ResultContainer resultContainer = new ResultContainer();
try
{
_dataContext.usp_ARS_CropGermplasmCommitteeDocument_Delete(ref errorNumber, document.ID);
resultContainer.EntityID = document.ID;
resultContainer.ResultCode = errorNumber.GetValueOrDefault().ToString();
}
catch (SqlException ex)
{
throw ex;
}
return(resultContainer);
}
public List <CropGermplasmCommitteeDocument> GetDocuments(int cropGermplasmCommitteeId)
{
List <CropGermplasmCommitteeDocument> cropGermplasmCommitteeDocuments = new List <CropGermplasmCommitteeDocument>();
CropGermplasmCommitteeDocument document = null;
var results = _dataContext.usp_ARS_CropGermplasmCommitteeDocuments_Select(cropGermplasmCommitteeId);
foreach (var result in results)
{
document = new CropGermplasmCommitteeDocument();
document.ID = result.crop_germplasm_committee_document_id;
document.Title = result.document_title;
document.URL = result.url;
cropGermplasmCommitteeDocuments.Add(document);
}
return(cropGermplasmCommitteeDocuments);
}
public ResultContainer InsertDocument(CropGermplasmCommitteeDocument document)
{
int?errorNumber = 0;
int?id = 0;
ResultContainer resultContainer = new ResultContainer();
try
{
_dataContext.usp_ARS_CropGermplasmCommitteeDocument_Insert(ref errorNumber, ref id, document.Committee.ID, document.Title, document.DocumentYear, document.CategoryTitle, document.URL);
resultContainer.EntityID = id.GetValueOrDefault();
resultContainer.ResultCode = errorNumber.GetValueOrDefault().ToString();
}
catch (SqlException ex)
{
throw ex;
}
return(resultContainer);
}
public List <CropGermplasmCommitteeDocument> GetDocuments()
{
CropGermplasmCommitteeDocument document = null;
List <CropGermplasmCommitteeDocument> documents = new List <CropGermplasmCommitteeDocument>();
var results = _dataContext.usp_ARS_CropGermplasmCommitteeDocuments_SelectAll();
foreach (var result in results)
{
document = new CropGermplasmCommitteeDocument();
document.ID = result.crop_germplasm_committee_document_id;
document.Title = result.document_title;
document.URL = result.url;
document.CategoryTitle = result.category;
document.DocumentYear = result.document_year.GetValueOrDefault();
document.CreatedDate = result.created_date.GetValueOrDefault();
document.ModifiedDate = result.modified_date.GetValueOrDefault();
document.Committee.Name = result.crop_germplasm_committee_name; documents.Add(document);
}
return(documents);
}
public ActionResult CGCDocumentDelete(int id)
{
CropGermplasmCommitteeDocument cropGermplasmCommitteeDocument = null;
ResultContainer resultContainer = null;
try
{
cropGermplasmCommitteeDocument = _cgcRepository.GetDocument(id);
//Uri uri = new Uri(cropGermplasmCommitteeDocument.URL);
//string filename = System.IO.Path.GetFileName(cropGermplasmCommitteeDocument.URL);
//string rootPath = "~/documents/CGC";
//string fullPath = System.IO.Path.Combine(Server.MapPath(rootPath), filename);
//if (System.IO.File.Exists(uri.LocalPath))
//{
// System.IO.File.Delete(uri.LocalPath);
//}
//else
//{
// throw new IOException(String.Format("The file {0} does not exist and cannot be deleted.", filename));
//}
resultContainer = _cgcRepository.DeleteDocument(cropGermplasmCommitteeDocument);
}
catch (Exception ex)
{
Log.Error(ex, ex.Message);
string actionName = this.ControllerContext.RouteData.Values["action"].ToString();
string controllerName = this.ControllerContext.RouteData.Values["controller"].ToString();
string errorText = "<label>Controller:</label>" + controllerName;
errorText = errorText + "<br><label>Action:</label>" + actionName;
errorText = errorText + "<br><label>Details:</label>" + ex.TargetSite + ex.Message;
Session["ERROR_TEXT"] = errorText;
return(RedirectToAction("InternalServerError", "Error"));
}
return(RedirectToAction("Index", "Admin"));
}
public ActionResult CGCDocumentEdit(DocumentEditViewModel viewModel)
{
string uploadDir = "~/documents/cgc/";
string path = String.Empty;
CropGermplasmCommitteeDocument document = new CropGermplasmCommitteeDocument();
ResultContainer resultContainer = new ResultContainer();
try
{
document.ID = viewModel.ID;
document.Committee.ID = viewModel.CommitteeID;
document.Title = viewModel.Title;
document.DocumentYear = viewModel.Year;
document.CategoryCode = viewModel.CategoryCode;
document.URL = viewModel.URL;
if (viewModel.DocumentUpload != null && viewModel.DocumentUpload.ContentLength > 0)
{
if (document.CategoryTitle == "CVS")
{
uploadDir = uploadDir + "cvs";
}
else
{
if (document.CategoryTitle == "MIN")
{
uploadDir = uploadDir + "committee";
}
}
//NEEDED?
//path = Path.Combine(Server.MapPath(uploadDir), Path.GetFileName(viewModel.DocumentUpload.FileName));
var documentPath = Path.Combine(Server.MapPath(uploadDir), viewModel.DocumentUpload.FileName);
var documentUrl = Path.Combine(uploadDir, viewModel.DocumentUpload.FileName);
viewModel.DocumentUpload.SaveAs(documentPath);
var urlBuilder =
new System.UriBuilder(Request.Url.AbsoluteUri)
{
Path = Url.Content(documentUrl),
Query = null,
};
Uri uri = urlBuilder.Uri;
document.URL = urlBuilder.ToString();
}
if (viewModel.ID > 0)
{
resultContainer = _cgcRepository.UpdateDocument(document);
}
else
{
resultContainer = _cgcRepository.InsertDocument(document);
}
return(RedirectToAction("CGCDocumentView", "Admin", new { id = resultContainer.EntityID }));
}
catch (Exception ex)
{
Log.Error(ex, ex.Message);
string actionName = this.ControllerContext.RouteData.Values["action"].ToString();
string controllerName = this.ControllerContext.RouteData.Values["controller"].ToString();
string errorText = "<label>Controller:</label>" + controllerName;
errorText = errorText + "<br><label>Action:</label>" + actionName;
errorText = errorText + "<br><label>Details:</label>" + ex.TargetSite + ex.Message;
Session["ERROR_TEXT"] = errorText;
return(RedirectToAction("InternalServerError", "Error"));
}
}
