public async Task <ActionResult> AddQuestion(Guid tenderGuid, RelatedTo relatedTo, string relatedId)
{
var tender = await TenderProvider.GetTender(tenderGuid);
QuestionViewModel viewModel = new QuestionViewModel(tenderGuid);
return(View(viewModel));
}
public async Task <IEnumerable <DocumentDTO> > GetDocuments(Guid tenderGuid, RelatedTo relatedTo,
string relatedId)
{
var documents = await Context.TenderDocuments
.Where(m => m.Tender.Guid == tenderGuid && m.DocumentOf == relatedTo && m.RelatedItem == relatedId)
.ToListAsync();
return(documents.Select(m => m.ToDTO()));
}
public ActionResult AddDocument(Guid tenderGuid, string relatedId, RelatedTo relatedTo)
{
var viewModel = new DocumentViewModel()
{
TenderGuid = tenderGuid,
RelatedId = relatedId == tenderGuid.ToString("N") ? null : relatedId,
DocumentOf = relatedTo
};
return(View(viewModel));
}
public void Update()
{
string strsql = "update Question set " + "Date= '" + Date.ToString("MM/dd/yyyy hh:mm:ss tt") + "', " + "QuestionName= '" + QuestionName.Replace("'", "''") + "', " + "RelatedTo= '" + RelatedTo.Replace("'", "''") + "', " + "CompanyId= " + CompanyId + " " + " where ID =" + Id;
SqlConnection ObjConnection = new SqlConnection(ConfigurationManager.ConnectionStrings["MyJobPortal"].ConnectionString);
ObjConnection.Open();
SqlCommand ObjCommand = new SqlCommand(strsql, ObjConnection);
ObjCommand.ExecuteNonQuery();
ObjConnection.Dispose();
ObjCommand.Dispose();
}