public ActionResult NewCommend(String description, int ticketID, HttpPostedFileBase file)
{
try
{
SSMEntities se = new SSMEntities();
if (file != null)
{
TicketFile ticketFile = new TicketFile();
Storage storeage = new Storage();
ticketFile.Url = storeage.uploadMyfile("ticket" + ticketID, "file" + ticketID, file);
ticketFile.FileName = file.FileName;
se.TicketFiles.Add(ticketFile);
ticketFile.TicketID = ticketID;
se.SaveChanges();
}
TicketComment commend = new TicketComment();
commend.Creator = User.Identity.GetUserId();
commend.Description = description;
commend.createddate = DateTime.Today;
commend.point = 1;
commend.ticketID = ticketID;
commend.Accepted = false;
se.TicketComments.Add(commend);
se.SaveChanges();
return(RedirectToAction("Detail", new { id = ticketID }));
}
catch (Exception e) { }
return(RedirectToAction("Index"));
}
public void deleteCalendarByUserID(String userid)
{
try
{
List <MasterSchedule_User> lst = context.MasterSchedule_User.SqlQuery("SELECT * FROM MasterSchedule_User where userID='" + userid + "'").ToList();
context.MasterSchedule_User.RemoveRange(lst);
context.SaveChanges();
}
catch (Exception e) {
}
}
public ActionResult CreateNewProgress(FollowupProgressModel model)
{
PrePurchase_FollowUp_Plan plan = new PrePurchase_FollowUp_Plan();
plan.Description = model.Desription;
plan.name = model.Name;
plan.isActive = true;
plan.isOperation = false;
plan.productID = model.productID;
plan.createDate = DateTime.Today;
SSMEntities se = new SSMEntities();
se.PrePurchase_FollowUp_Plan.Add(plan);
se.SaveChanges();
foreach (Plan_Step step in model.steps.ToList())
{
if (step.StepEmailContent == null)
{
model.steps.Remove(step);
}
else if (step.StepEmailContent.Trim().Length == 0)
{
model.steps.Remove(step);
}
}
for (int i = 0; i < model.steps.Count(); i++)
{
Plan_Step step = model.steps[i];
step.stepNo = (i + 1);
step.planID = plan.id;
se.Plan_Step.Add(step);
se.SaveChanges();
}
for (int i = 0; i < model.steps.Count(); i++)
{
Plan_Step step = model.steps[i];
if (i != 0)
{
step.previousStep = model.steps[i - 1].id;
}
if (i != model.steps.Count() - 1)
{
step.nextStep = model.steps[i + 1].id;
}
se.SaveChanges();
}
return(RedirectToAction("Detail", new { id = model.productID }));
}
public void CreateNewEmailTemplate(EmailTemplateEntity template)
{
var dbTemplate = new Email_Template();
dbTemplate.isActive = template.isActive;
dbTemplate.lastUpdate = template.lastUpdate;
dbTemplate.MailContent = template.MailContent;
dbTemplate.Name = template.Name;
dbTemplate.CateID = template.EmailCategoryId;
dbTemplate.createdDate = template.createdDate;
dbTemplate.creatorID = template.creatorID;
context.Email_Template.Add(dbTemplate);
context.SaveChanges();
}
public void DealWon(int id, String userID)
{
SSMEntities se = new SSMEntities();
DealRepository dealrepo = new DealRepository(se);
Deal deal = dealrepo.getByID(id);
if (deal != null)
{
deal.Status = 3;
customer cus = new customer();
cus.userID = userID;
cus.cusAddress = deal.contact.Street + " " + deal.contact.City + " " + deal.contact.Region + " ";
cus.cusCompany = 1;
cus.cusEmail = deal.contact.emails;
cus.cusName = deal.contact.FirstName + " " + deal.contact.MiddleName + " " + deal.contact.LastName;
cus.cusPhone = deal.contact.Phone;
se.customers.Add(cus);
se.SaveChanges();
try {
order order = new order();
order.customerID = cus.id;
float price = 0;
order.orderNumber = 123123123;
order.subtotal = deal.Value;
order.status = 1;
order.total = (double)order.subtotal * 1.1;
order.VAT = (double)order.subtotal * 0.1;
Storage storeage = new Storage();
se.orders.Add(order);
se.SaveChanges();
order.Contract = storeage.uploadfile(userID, "order" + order.id);
se.SaveChanges();
MarketPlanPurchased mp = new MarketPlanPurchased();
mp.orderID = order.id;
mp.planID = deal.productMarketPlan.id;
mp.productID = deal.productMarketPlan.productID;
mp.SoldPrice = (double)deal.Value;
mp.quantity = deal.Quantity;
se.MarketPlanPurchaseds.Add(mp);
se.SaveChanges();
deal.Status = 5; se.SaveChanges();
}
catch (Exception e) {
}
}
}
public ActionResult CreateDeal(Deal deal, int plan)
{
SSMEntities se = new SSMEntities();
deal.planID = plan;
deal.Creator = User.Identity.GetUserId();
deal.StartDate = DateTime.Today;
deal.Stage = 1;
deal.Probability = 0;
deal.CompleteOn = null;
deal.LastUpdateStage = null;
deal.Status = 1;
se.Deals.Add(deal);
se.SaveChanges();
contact contact = se.contacts.Find(deal.Client);
int day = 0;
if (contact != null)
{
foreach (Plan_Step tep in se.PrePurchase_FollowUp_Plan.Find(plan).Plan_Step)
{
if (tep.TimeFromLastStep == null)
{
tep.TimeFromLastStep = 0;
}
day = day + (int)tep.TimeFromLastStep;
DealTask task = new DealTask();
task.dealID = deal.id;
task.TaskDescription = tep.StepEmailContent;
task.status = 1;
if (tep.RequireMoreDetail)
{
task.status = 7;
}
task.Deadline = DateTime.Today.AddDays(day);
task.CreateDate = DateTime.Today;
task.TaskContent = tep.subject;
task.TaskName = "Progress";
task.type = 8;
se.DealTasks.Add(task);
se.SaveChanges();
}
}
return(RedirectToAction("Detail", new { id = deal.id }));
}
public ActionResult makenewRequest(int planID, String firstname, String lastname, String email, String businessname, String BussinessAddress, String website, String role, String description, String dates)
{
System.Diagnostics.Debug.WriteLine("em ay day " + dates);
SSMEntities se = new SSMEntities();
productMarketPlan plan = se.productMarketPlans.Find(planID);
contact con = new contact();
con.FirstName = firstname;
con.MiddleName = " ";
con.Phone = "Not available";
con.Photo = "Not available";
con.DateOfBirth = DateTime.Today;
con.Street = BussinessAddress;
con.LastName = lastname;
con.emails = email;
con.Comment = description;
company com = new company();
com.companyName = businessname;
com.Street = BussinessAddress;
com.logo = "Not available";
com.sites = website;
se.companies.Add(com);
se.SaveChanges();
con.CompanyID = com.id;
se.contacts.Add(con);
se.SaveChanges();
Customer_Request request = new Customer_Request();
request.RequestNo = con.id + "" + com.id + "";
request.PlanID = planID;
request.ProductID = plan.softwareProduct.id;
request.CusID = con.id;
request.CreatedDate = DateTime.Today;
request.RequestDemoDay = dates;
se.Customer_Request.Add(request);
se.SaveChanges();
Notification noti = new Notification();
noti.NotiName = "New Request";
noti.NotiContent = con.FirstName + " " + "has new request for " + plan.softwareProduct.name;
noti.userID = "3d23016d-074f-474e-a6b7-225de90b0cae";
noti.CreateDate = DateTime.Now;
noti.viewed = false;
noti.hreflink = "/Request/";
se.Notifications.Add(noti);
se.SaveChanges();
return(View("Success"));
}
public ActionResult CreateNewProfile(ProfileModel model)
{
if (ModelState.IsValid)
{
AccountController ac = new AccountController();
String id = ac.RegisterNewAccount(model.username, model.password, System.Web.HttpContext.Current, "SalesRep");
SaleRepProfile srp = new SaleRepProfile();
srp.userID = id;
srp.FirstName = model.firstname;
srp.LastName = model.lastname;
srp.FullName = model.firstname + " " + model.fullname + " " + model.lastname;
srp.Email = model.email;
srp.City = model.city;
srp.Phone = model.phone;
Storage storeage = new Storage();
srp.Avatar = storeage.uploadMyfile(id, "avatar", model.avatar);
srp.EmployedScine = DateTime.Today;
srp.Country = model.country;
srp.dateOfBirth = model.birthday;
SSMEntities se = new SSMEntities();
se.SaleRepProfiles.Add(srp);
se.SaveChanges();
return(RedirectToAction("Detail", new { id = id }));
}
return(RedirectToAction("NewProfile"));
}
public ActionResult AddItemToDeal(int planID, float suggestprice, int quantity, int dealID)
{
SSMEntities se = new SSMEntities();
Deal deal = se.Deals.Find(dealID);
if (deal != null)
{
Deal_Item item = new Deal_Item();
item.planID = planID;
item.dealID = dealID;
item.price = suggestprice;
item.Quantity = quantity;
if (deal.Value == null)
{
deal.Value = suggestprice * quantity;
}
else
{
deal.Value = deal.Value + suggestprice * quantity;
}
se.Deal_Item.Add(item);
se.SaveChanges();
}
return(RedirectToAction("Detail", new { id = dealID }));
}
public ActionResult UpdateMail(string username, string password)
{
SSMEntities se = new SSMEntities();
se.ConfigureSys.Where(u => u.id == 1).First().value = username + "";
se.ConfigureSys.Where(u => u.id == 2).First().value = password + "";
se.SaveChanges();
return(RedirectToAction("SystemConfig"));
}
public void CreateNewContact(contact cont, String responsible)
{
string[] stringSeparators = new string[] { ";" };
String[] salerepid = responsible.Split(stringSeparators, StringSplitOptions.None);
context.contacts.Add(cont);
context.SaveChanges();
for (int i = 0; i < salerepid.Length; i++)
{
try {
contact_resposible cr = new contact_resposible();
cr.contactID = cont.id;
cr.userID = salerepid[i];
context.contact_resposible.Add(cr);
}
catch (Exception e) { }
}
context.SaveChanges();
}
public ActionResult UdpateMetric(int sc, int act, int ncm, int wr, int asv)
{
SSMEntities se = new SSMEntities();
se.ConfigureSys.Where(u => u.id == 15).First().value = sc + "";
se.ConfigureSys.Where(u => u.id == 16).First().value = act + "";
se.ConfigureSys.Where(u => u.id == 17).First().value = ncm + "";
se.ConfigureSys.Where(u => u.id == 19).First().value = wr + "";
se.ConfigureSys.Where(u => u.id == 20).First().value = asv + "";
se.SaveChanges();
return(RedirectToAction("SystemConfig"));
}
public ActionResult LicenseImport(HttpPostedFileBase excelfile, int planID)
{
SSMEntities se = new SSMEntities();
if (excelfile == null || excelfile.ContentLength == 0)
{
ViewBag.Error = "Please select an Excel file<br>";
return(View("Index"));
}
else
{
if (excelfile.FileName.EndsWith("xls") || excelfile.FileName.EndsWith("xlsx"))
{
string path = Server.MapPath("~/Content/" + excelfile.FileName);
System.Diagnostics.Debug.WriteLine("noa ne: " + path);
if (System.IO.File.Exists(path))
{
System.IO.File.Delete(path);
}
excelfile.SaveAs(path);
// Read data from excel file
Excel.Application application = new Excel.Application();
Excel.Workbook workbook = application.Workbooks.Open(path);
Excel.Worksheet worksheet = workbook.ActiveSheet;
Excel.Range range = worksheet.UsedRange;
List <TrialAccount> listAccounts = new List <TrialAccount>();
// row = 3 is the row data begin with - 1
for (int row = 3; row <= range.Rows.Count; row++)
{
License lic = new License();
lic.LicenseKey = ((Excel.Range)range.Cells[row, 1]).Text;
lic.PlanID = planID;
lic.licenseDuration = ((Excel.Range)range.Cells[row, 2]).Text;
lic.LinkUse = ((Excel.Range)range.Cells[row, 3]).Text;
lic.AdminAccount = ((Excel.Range)range.Cells[row, 4]).Text;
lic.AdminPassword = ((Excel.Range)range.Cells[row, 5]).Text;
//account.PlanID = int.Parse(((Excel.Range)range.Cells[row, 3]).Text);
//DateTime createdDate = Convert.ToDateTime(((Excel.Range)range.Cells[row, 4]).Text);
//account.createdDate = createdDate;
se.Licenses.Add(lic);
}
application.Workbooks.Close();
se.SaveChanges();
return(RedirectToAction("MarketPlanDetail", new { id = planID }));
}
else
{
return(RedirectToAction("MarketPlanDetail", new { id = planID }));
}
}
}
public ActionResult NewTrialAccount(String username, String password, int planID)
{
SSMEntities se = new SSMEntities();
TrialAccount trail = new TrialAccount();
trail.UserName = username;
trail.Password = password;
trail.PlanID = planID;
trail.Status = 1;
se.TrialAccounts.Add(trail);
se.SaveChanges();
return(RedirectToAction("MarketPlanDetail", new { id = planID }));
}
public JsonResult viewedNotification(int id)
{
SSMEntities se = new SSMEntities();
Notification noti = se.Notifications.Find(id);
if (noti != null)
{
noti.viewed = true;
se.SaveChanges();
return(Json(new { succeed = noti.hreflink }, JsonRequestBehavior.AllowGet));
}
return(Json(new { ffail = "fail" }, JsonRequestBehavior.AllowGet));
}
public ActionResult NewLicense(String key, int duration, int planID, String url, String adminaccount, string adminpassword)
{
SSMEntities se = new SSMEntities();
License lic = new License();
lic.PlanID = planID;
lic.licenseDuration = duration;
lic.LicenseKey = key;
lic.LinkUse = url;
lic.AdminAccount = adminaccount;
lic.AdminPassword = adminpassword;
se.Licenses.Add(lic);
se.SaveChanges();
return(RedirectToAction("MarketPlanDetail", new { id = planID }));
}
public JsonResult MarketPlanSwitchStatus(int id)
{
try
{
SSMEntities se = new SSMEntities();
productMarketPlan myplan = se.productMarketPlans.Find(id);
myplan.operating = !myplan.operating;
se.SaveChanges();
return(Json(new { result = "succeed" }, JsonRequestBehavior.AllowGet));
}
catch (Exception e)
{
}
return(Json(new { result = "fail" }, JsonRequestBehavior.AllowGet));
}
public JsonResult paid(float money, int commisionID)
{
SSMEntities se = new SSMEntities();
SaleRepCommision com = se.SaleRepCommisions.Find(commisionID);
if (com != null)
{
if (money > 0)
{
com.Paid = com.Paid + money;
se.SaveChanges();
return(Json(new { result = "true", paid = ((double)com.Paid).ToString("C"), percentage = com.Paid * 100 / com.Total }, JsonRequestBehavior.AllowGet));
}
}
return(null);
}
public ActionResult SetInactiveMarketPlan(int planid, int productID)
{
try
{
SSMEntities se = new SSMEntities();
productMarketPlan plan = se.productMarketPlans.Find(planid);
plan.isActive = false;
se.SaveChanges();
System.Diagnostics.Debug.WriteLine("cccccccc " + productID);
return(RedirectToAction("Detail", new { id = productID }));
}
catch (Exception e)
{
}
return(RedirectToAction("Index"));
}
public ActionResult Newticket(String title, int serverity, int category, String description)
{
Ticket tick = new Ticket();
tick.Creator = User.Identity.GetUserId();
tick.CreatedDay = DateTime.Today;
tick.Description = description;
tick.TicketCategory = category;
tick.TicketServerity = serverity;
tick.TicketName = title;
tick.TicketStatus = 1;
tick.ViewCounted = 0;
SSMEntities se = new SSMEntities();
se.Tickets.Add(tick);
se.SaveChanges();
return(RedirectToAction("Index"));
}
public JsonResult EditPlanMail(int taskid, String newcontent)
{
SSMEntities se = new SSMEntities();
DealTask task = se.DealTasks.Find(taskid);
try
{
if (task != null)
{
task.TaskDescription = newcontent;
task.status = 1;
se.SaveChanges();
return(Json(new { result = "success" }, JsonRequestBehavior.AllowGet));
}
}
catch (Exception e) { }
return(Json(new { result = "fail" }, JsonRequestBehavior.AllowGet));
}
public JsonResult SendEarlyMail(int mailid)
{
SSMEntities se = new SSMEntities();
DealTask task = se.DealTasks.Find(mailid);
if (task != null)
{
if (task.Deal.Stage + 1 < (int.Parse(task.TaskContent)))
{
return(Json(new { sentresult = "fail" }, JsonRequestBehavior.AllowGet));
}
else
{
task.Deadline = DateTime.Now;
se.SaveChanges();
return(Json(new { sentresult = "suceed" }, JsonRequestBehavior.AllowGet));
}
}
return(Json(new { sentresult = "fail" }, JsonRequestBehavior.AllowGet));
}
public ActionResult UpdateKeyword(String fn, string pn, string mdd, string mt, string lk, string news, string pf, string cc, string links, string username, string password)
{
SSMEntities se = new SSMEntities();
se.ConfigureSys.Where(u => u.id == 3).First().value = fn + "";
se.ConfigureSys.Where(u => u.id == 4).First().value = pn + "";
se.ConfigureSys.Where(u => u.id == 5).First().value = mdd + "";
se.ConfigureSys.Where(u => u.id == 7).First().value = mt + "";
se.ConfigureSys.Where(u => u.id == 8).First().value = lk + "";
se.ConfigureSys.Where(u => u.id == 9).First().value = news + "";
se.ConfigureSys.Where(u => u.id == 10).First().value = pf + "";
se.ConfigureSys.Where(u => u.id == 11).First().value = cc + "";
se.ConfigureSys.Where(u => u.id == 12).First().value = links + "";
se.ConfigureSys.Where(u => u.id == 13).First().value = username + "";
se.ConfigureSys.Where(u => u.id == 14).First().value = password + "";
se.SaveChanges();
return(RedirectToAction("SystemConfig"));
}
public ActionResult NewEmail(String mailcontent, int dealID)
{
SSMEntities se = new SSMEntities();
Deal deal = se.Deals.Find(dealID);
if (deal != null)
{
DealTask task = new Models.DealTask();
task.type = 8;
task.TaskName = deal.DealTasks.Where(u => u.type == 8).First().TaskName;
task.status = 1;
task.Deadline = DateTime.Now;
task.CreateDate = DateTime.Now;
task.TaskDescription = mailcontent;
task.dealID = dealID;
task.TaskContent = "ReplyEmail";
se.DealTasks.Add(task);
se.SaveChanges();
}
return(RedirectToAction("Detail", new { id = dealID }));
}
public ActionResult CreateNewTask(int dealID, String title, String description, int type, String deadline)
{
try
{
SSMEntities se = new SSMEntities();
DealTask task = new DealTask();
task.dealID = dealID;
task.Deadline = DateTime.Parse(deadline);
task.CreateDate = DateTime.Today;
task.status = 1;
task.type = type;
task.TaskDescription = description;
task.TaskName = title;
se.DealTasks.Add(task);
se.SaveChanges();
return(RedirectToAction("Detail", new { id = dealID }));
}
catch (Exception e)
{
}
return(RedirectToAction("Index"));
}
public JsonResult removeEmail(int mailid)
{
SSMEntities se = new SSMEntities();
DealTask task = se.DealTasks.Find(mailid);
if (task != null)
{
try {
foreach (DealTask alltask in task.Deal.DealTasks.Where(u => u.type == 8 && u.Deadline > task.Deadline).ToList())
{
alltask.TaskContent = (int.Parse(alltask.TaskContent) - 1) + "";
}
se.DealTasks.Remove(task);
se.SaveChanges();
return(Json(new { sentresult = "succeed" }, JsonRequestBehavior.AllowGet));
}
catch (Exception e) {
}
}
return(Json(new { sentresult = "fail" }, JsonRequestBehavior.AllowGet));
}
public JsonResult PrePlanSwitchStatus(int id)
{
try
{
SSMEntities se = new SSMEntities();
PrePurchase_FollowUp_Plan myplan = se.PrePurchase_FollowUp_Plan.Find(id);
softwareProduct software = myplan.softwareProduct;
foreach (PrePurchase_FollowUp_Plan plan in software.PrePurchase_FollowUp_Plan.ToList())
{
if (plan.id != id)
{
plan.isOperation = false;
}
}
myplan.isOperation = !myplan.isOperation;
se.SaveChanges();
return(Json(new { result = "succeed" }, JsonRequestBehavior.AllowGet));
}
catch (Exception e)
{
}
return(Json(new { result = "fail" }, JsonRequestBehavior.AllowGet));
}
public ActionResult savechangesSchedule(String date)
{
SSMEntities se = new SSMEntities();
String userID = User.Identity.GetUserId();
AspNetUser user = se.AspNetUsers.Find(userID);
string[] busyDates = date.Split(new[] { "start" }, StringSplitOptions.RemoveEmptyEntries);
foreach (String thisdate in busyDates)
{
string[] startend = thisdate.Split(new[] { "end" }, StringSplitOptions.RemoveEmptyEntries);
Calendar cal = new Calendar();
cal.repeat = true;
cal.startTime = new DateTime(1970, 1, 1, 0, 0, 0, DateTimeKind.Utc)
.AddMilliseconds(double.Parse(startend[0]))
.ToLocalTime();
cal.endTime = new DateTime(1970, 1, 1, 0, 0, 0, DateTimeKind.Utc)
.AddMilliseconds(double.Parse(startend[1]))
.ToLocalTime();
cal.userID = userID;
se.Calendars.Add(cal);
se.SaveChanges();
}
return(RedirectToAction("Index"));
}
public int createAndGetDealID(Deal deal, int productID, int plann)
{
SSMEntities se = new SSMEntities();
softwareProduct product = se.softwareProducts.Find(productID);
if (product != null)
{
deal.ProductID = productID;
}
deal.Creator = User.Identity.GetUserId();
deal.StartDate = DateTime.Today;
deal.Stage = 1;
deal.Probability = 0;
deal.CompleteOn = null;
deal.LastUpdateStage = null;
deal.Status = 1;
deal.CurrentPlanID = product.PrePurchase_FollowUp_Plan.Where(u => u.isOperation).FirstOrDefault().id;
se.Deals.Add(deal);
se.SaveChanges();
Deal_Item ite = new Deal_Item();
productMarketPlan pla = se.productMarketPlans.Find(plann);
ite.planID = plann;
ite.price = pla.ceilPrice;
ite.Quantity = 1;
ite.dealID = deal.id;
se.Deal_Item.Add(ite);
deal.Value = ite.price;
se.SaveChanges();
Deal_SaleRep_Respon dealrespont = new Deal_SaleRep_Respon();
dealrespont.dealID = deal.id;
dealrespont.userID = deal.Creator;
se.Deal_SaleRep_Respon.Add(dealrespont);
se.SaveChanges();
contact contact = se.contacts.Find(deal.Client);
int day = 0;
PrePurchase_FollowUp_Plan plan = deal.softwareProduct.PrePurchase_FollowUp_Plan.Where(u => u.isOperation == true).FirstOrDefault();
if (contact != null)
{
foreach (Plan_Step tep in plan.Plan_Step)
{
if (tep.TimeFromLastStep == null)
{
tep.TimeFromLastStep = 0;
}
day = day + (int)tep.TimeFromLastStep;
DealTask task = new DealTask();
task.dealID = deal.id;
task.TaskDescription = tep.StepEmailContent;
task.status = 1;
if (tep.RequireMoreDetail)
{
task.status = 7;
}
task.Deadline = DateTime.Now.AddDays(day);
task.CreateDate = DateTime.Now;
task.TaskContent = tep.stepNo + "";
task.TaskName = tep.subject + " [#:" + deal.id + "]";
task.type = 8;
se.DealTasks.Add(task);
se.SaveChanges();
if (task.TaskDescription.Contains(se.ConfigureSys.Find(13).value))
{
String replaceall = "";
foreach (Deal_Item item in task.Deal.Deal_Item)
{
TrialAccount trial = item.productMarketPlan.TrialAccounts.Where(u => u.contactID == null).FirstOrDefault();
replaceall = replaceall + '\n' + "User Name for " + item.productMarketPlan.Name + ": " + trial.UserName + " Password: " + trial.Password;
TrialAccount trialupdate = se.TrialAccounts.Find(trial.AccountID);
trialupdate.contactID = task.Deal.contact.id;
se.SaveChanges();
}
task.TaskDescription = task.TaskDescription.Replace(se.ConfigureSys.Find(13).value, replaceall);
}
se.SaveChanges();
}
}
return(deal.id);
}
public ActionResult DealWon(int id)
{
SSMEntities se = new SSMEntities();
DealRepository dealrepo = new DealRepository(se);
Deal deal = dealrepo.getByID(id);
if (deal != null)
{
customer cus = new customer();
if (se.AspNetUsers.Where(us => us.UserName.Equals(deal.contact.emails)).FirstOrDefault() == null)
{
cus.cusAddress = deal.contact.Street + " " + deal.contact.City + " " + deal.contact.Region + " ";
cus.cusCompany = 1;
cus.cusEmail = deal.contact.emails;
cus.cusName = deal.contact.FirstName + " " + deal.contact.MiddleName + " " + deal.contact.LastName;
cus.cusPhone = deal.contact.Phone;
se.customers.Add(cus);
se.SaveChanges();
AccountController ac = new AccountController();
String cusAccountID = ac.RegisterNewAccount(cus.cusEmail, "320395@qwE", System.Web.HttpContext.Current, "Customer");
cus.userID = cusAccountID;
se.SaveChanges();
}
else
{
AspNetUser thiscus = se.AspNetUsers.Where(us => us.UserName.Equals(deal.contact.emails)).First();
cus = thiscus.customers.First();
}
deal.Status = 3;
order order = new order();
order.customerID = cus.id;
float price = 0;
order.orderNumber = se.orders.ToList().Count() + 1;
order.subtotal = deal.Value;
order.status = 1;
order.total = (double)order.subtotal * 1.1;
order.VAT = (double)order.subtotal * 0.1;
order.fromDeal = deal.id;
order.createDate = DateTime.Now;
Storage storeage = new Storage();
se.orders.Add(order);
se.SaveChanges();
order.Contract = storeage.uploadfile(cus.userID, "order" + order.id);
se.SaveChanges();
deal.Status = 3;
se.SaveChanges();
bool validLicense = true;
foreach (Deal_Item dealitem in deal.Deal_Item)
{
int lcount = se.Licenses.Where(u => u.PlanID == dealitem.planID && u.status == null && u.SaleRepResponsible == null).Count();
if (lcount < dealitem.Quantity)
{
validLicense = false;
}
}
if (validLicense)
{
foreach (Deal_Item dealitem in deal.Deal_Item)
{
for (int i = 0; i < dealitem.Quantity; i++)
{
License license = se.Licenses.Where(u => u.PlanID == dealitem.planID && u.status == null && u.SaleRepResponsible == null).FirstOrDefault();
if (license != null)
{
license.customerID = cus.id;
license.SaleRepResponsible = deal.Deal_SaleRep_Respon.LastOrDefault().userID;
license.status = 1;
OrderItem orderItem = new OrderItem();
orderItem.orderID = order.id;
orderItem.planID = dealitem.planID;
orderItem.SoldPrice = (double)dealitem.price;
orderItem.LicenseID = license.id;
se.OrderItems.Add(orderItem);
}
else
{
return(RedirectToAction("Detail", new { id = deal.id }));
}
}
}
se.SaveChanges();
}
else
{
return(RedirectToAction("Detail", new { id = deal.id }));
}
Notification noti = new Notification();
noti.NotiName = "Contract successfully created";
noti.NotiContent = "Deal No." + deal.id + ": has finished with a contract and order";
noti.userID = deal.Deal_SaleRep_Respon.LastOrDefault().userID;
noti.CreateDate = DateTime.Now;
noti.viewed = false;
noti.hreflink = "/Deal/Detail?id=" + deal.id;
se.Notifications.Add(noti);
se.SaveChanges();
deal.Status = 5;
se.SaveChanges();
//}
//catch (Exception e) {
// return Json(new { result = "sad" }, JsonRequestBehavior.AllowGet);
//}
}
return(RedirectToAction("Detail", new { id = deal.id }));
}