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(); }