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