public void InsertProposal(Proposal item) { sqlProc.Clear(); sqlProc.CommandText = @"INSERT INTO [dbo].[Proposal] ([Name] ,[JobTitle] ,[Email] ,[Telephone] ,[CompanyName] ,[ProjectTitle] ,[Technology] ,[Description] ,[OtherComments] ,[UploadDocument1] ,[UploadDocument2]) VALUES (@Name ,@JobTitle ,@Email ,@Telephone ,@CompanyName ,@ProjectTitle ,@Technology ,@Description ,@OtherComments ,@UploadDocument1 ,@UploadDocument2)"; sqlProc.CommandType = CommandType.Text; AddSqlParameters(item); sqlProc.ExecuteNonQuery(); }
public ActionResult RequestForProposal(Proposal item, IEnumerable<HttpPostedFileBase> files) { if (ModelState.IsValid) { if (files != null && files.Count() > 0) { UploadFilesForProposal(item, files); } if (item.Id != 0) { bll.ProposalManager.UpdateProposal(item); TempData["message"] = new AlertMessage(string.Format("{0} has been saved", item.Name)); return RedirectToAction("Proposals", "Admin"); } else { bll.ProposalManager.InsertProposal(item); SendProposalNotification(item); TempData["message"] = new AlertMessage(string.Format("{0} has been saved", item.Name)); return RedirectToAction("ProposalSucceed"); } } else { return View(item); } }
public ActionResult RequestForProposal(int id = 0) { Proposal item; if (id != 0) { item = bll.ProposalManager.SelectProposal(id); } else { item = new Proposal(); } return View(item); }
public void UpdateProposal(Proposal item) { sqlProc.Clear(); sqlProc.CommandText = @"UPDATE [dbo].[Proposal] SET [Name] = @Name ,[JobTitle] = @JobTitle ,[Email] = @Email ,[Telephone] = @Telephone ,[CompanyName] = @CompanyName ,[ProjectTitle] = @ProjectTitle ,[Technology] = @Technology ,[Description] = @Description ,[OtherComments] = @OtherComments ,[UploadDocument1] = @UploadDocument1 ,[UploadDocument2] = @UploadDocument2 WHERE Id = @Id"; sqlProc.CommandType = CommandType.Text; AddSqlParameters(item); sqlProc.Parameters.AddWithValue("Id", item.Id); sqlProc.ExecuteNonQuery(); }
private void AddSqlParameters(Proposal item) { sqlProc.Parameters.AddWithValue("Name", item.Name); sqlProc.Parameters.AddWithValue("JobTitle", item.JobTitle); sqlProc.Parameters.AddWithValue("Email", item.Email); sqlProc.Parameters.AddWithValue("Telephone", item.Telephone); sqlProc.Parameters.AddWithValue("CompanyName", item.CompanyName); sqlProc.Parameters.AddWithValue("ProjectTitle", item.ProjectTitle); sqlProc.Parameters.AddWithValue("Technology", item.Technology); sqlProc.Parameters.AddWithValue("Description", item.Description); sqlProc.Parameters.AddWithValue("OtherComments", item.OtherComments); sqlProc.Parameters.AddWithValue("UploadDocument1", item.UploadDocument1); sqlProc.Parameters.AddWithValue("UploadDocument2", item.UploadDocument2); }
private void SendProposalNotification(Proposal item) { string body = System.IO.File.ReadAllText(Server.MapPath("~/App_Data/MailTemplate/ProposalMailTemplate.html"), System.Text.Encoding.UTF8); Dictionary<string, string> values = new Dictionary<string, string>(); values.Add("{Name}", item.Name); values.Add("{JobTitle}", item.JobTitle); values.Add("{Email}", item.Email); values.Add("{Telephone}", item.Telephone); values.Add("{CompanyName}", item.CompanyName); values.Add("{ProjectTitle}", item.ProjectTitle); values.Add("{Technology}", item.Technology); values.Add("{UploadDocument1}", item.UploadDocument1); values.Add("{UploadDocument2}", item.UploadDocument2); values.Add("{Description}", item.Description); values.Add("{OtherComments}", item.OtherComments); values.Add("{URL}", AppConfig.AppPath + "/Home/RequestForProposal/" + item.Id.ToString()); string subject = string.Format("投标申请/报价咨询:{0}", item.ProjectTitle); MailHelper.Send(AppConfig.MailFrom, AppConfig.MailFromPassword, AppConfig.NotificationEmail, subject, body, true, AppConfig.SMTPServer, values); }
private void UploadFilesForProposal(Proposal item, IEnumerable<HttpPostedFileBase> files) { int index = 0; foreach(var file in files) { if (file != null && file.ContentLength > 0) { var fileName = Path.GetFileName(file.FileName); var path = Path.Combine(AppConfig.UploadPath, "proposal", fileName); file.SaveAs(path); var fileURL = CombineURL(AppConfig.UploadURL, "proposal", fileName); if (index == 0) { item.UploadDocument1 = fileURL; } else if (index == 1) { item.UploadDocument2 = fileURL; } } index++; } }
public void UpdateProposal(Proposal item) { _dal.ProposalRepository.UpdateProposal(item); }
public void InsertProposal(Proposal item) { _dal.ProposalRepository.InsertProposal(item); }