public ActionResult AddNew(CompanySalesDailyParam model) { db.CompanySalesDailyParam.Add(model); db.SaveChanges(); return(RedirectToAction("Edit", "CompanySalesDailies", new { id = model.CompanySalesDailyId })); }
public ActionResult Create([Bind(Include = "Id,CompanyId,CertificateName,CompanyName,PictureUrl,CreateTime,CreateUserName")] CompanyCertificate companyCertificate, HttpPostedFileBase imageFile) { if (ModelState.IsValid) { //上传图片先 string pathForSaving = Server.MapPath("~/CompanyImages/Certificates/" + companyCertificate.CompanyName); if (this.CreateFolderIfNeeded(pathForSaving)) { try { string fileName = companyCertificate.CompanyName + "_" + companyCertificate.CertificateName + "_" + DateTime.Now.ToString("yyyyMMddHHmmss"); string fileExtension = Path.GetExtension(imageFile.FileName); imageFile.SaveAs(Path.Combine(pathForSaving, fileName + fileExtension)); companyCertificate.PictureUrl = fileName + fileExtension; //保存图片名 db.CompanyCertificate.Add(companyCertificate); db.SaveChanges(); } catch (Exception ex) { ViewBag.ErrorMessage = string.Format("File upload failed: {0}", ex.Message); } } return(RedirectToAction("Index", new { companyId = companyCertificate.CompanyId })); } ViewData["CertificateNameList"] = GetCertificateNameList("营业执照"); return(View(companyCertificate)); }
public async Task <ActionResult> EditUser(EditUserViewModel model) { if (ModelState.IsValid) { var Db = new ApplicationDbContext(); var user = Db.Users.First(u => u.UserName == model.UserName); user.TrueName = model.TrueName; user.QQ = model.QQ; user.Email = model.Email; user.PhoneNumber = model.PhoneNumber; Db.Entry(user).State = System.Data.Entity.EntityState.Modified; await Db.SaveChangesAsync(); //保存区域 OtaCrmModel crmdb = new OtaCrmModel(); var serveArea = crmdb.ServeArea.FirstOrDefault(p => p.UserName == model.UserName); if (serveArea == null) { ServeArea newItem = new ServeArea(); newItem.UserName = model.UserName; newItem.ServeAreaName = model.ServeAreaName; crmdb.ServeArea.Add(newItem); } else { serveArea.ServeAreaName = model.ServeAreaName; } crmdb.SaveChanges(); return(RedirectToAction("UserList")); } return(View(model)); }
public ActionResult AddNew(CompanyMeetingSubject model) { db.CompanyMeetingSubject.Add(model); db.SaveChanges(); return(RedirectToAction("Edit", "CompanyMeetings", new { id = model.CompanyMeetingId })); }
public ActionResult AddBusinessDailyParam(CompanyBusinessDailyParam model) { db.CompanyBusinessDailyParam.Add(model); db.SaveChanges(); return(RedirectToAction("Edit", new { id = model.CompanyBusinessDailyId })); }
public async Task <ActionResult> Create(CompanyMeeting companyMeeting) { ViewData["MeetingTypeList"] = GetMeetingTypeList("上门拜访"); if (ModelState.IsValid) { //更新公司的lastupdatedate var company = db.OtaCompany.FirstOrDefault(p => p.Id == companyMeeting.CompanyId); company.LastMeetingDate = DateTime.Now; db.SaveChanges(); db.CompanyMeeting.Add(companyMeeting); await db.SaveChangesAsync(); return(RedirectToAction("Edit", new { Id = companyMeeting.Id })); } return(View(companyMeeting)); }
private void UpdateCompanySalesDailyParam(int dailyId, List <CompanySalesDailyParam> items) { string sql = "Delete From CompanySalesDailyParam Where CompanySalesDailyId=@CompanySalesDailyId"; SqlParameter[] paras = new SqlParameter[] { new SqlParameter("@CompanySalesDailyId", dailyId) }; db.Database.ExecuteSqlCommand(sql, paras); foreach (CompanySalesDailyParam item in items) { if (!string.IsNullOrEmpty(item.SubParamItem)) { db.CompanySalesDailyParam.Add(item); } } db.SaveChanges(); }
public ActionResult ImportCompanyFromAgentGrade() { OtaCrmModel db = new OtaCrmModel(); var cityList = (from cc in db.ChinaCity select cc).ToList(); var exsitNames = (from c in db.OtaCompany select c.CompanyName).Distinct(); List <string> exsitNameList = exsitNames.ToList(); var q = (from p in db.AgentGradeOperation select p.agentName).Distinct(); int count = 0; foreach (string companyName in q) { if (string.IsNullOrEmpty(companyName) || exsitNameList.Contains(companyName)) { continue; } OtaCompany newItem = new OtaCompany(); newItem.BossBackground = ""; newItem.BossBusinessDesp = ""; newItem.BossIdNo = ""; newItem.CompanyName = companyName; newItem.CreateTime = DateTime.Now; newItem.BossName = ""; newItem.BusinessRange = "国内"; newItem.BusinessStatus = "在线"; newItem.CapitalAsserts = ""; newItem.CityName = ""; foreach (var city in cityList) { if (companyName.Contains(city.CityName.Replace("市", ""))) { newItem.CityName = city.ProvinceName + "-" + city.CityName; break; } } newItem.LegalPerson = "未知"; newItem.LegalPersonIdNo = ""; newItem.LegalPersonPhone = ""; newItem.OfficeNo = ""; newItem.OtherInvest = ""; newItem.RealAddress = ""; newItem.RegisterAddress = ""; newItem.SalesUserName = "******"; db.OtaCompany.Add(newItem); count++; } db.SaveChanges(); return(Content("导入成功:" + count.ToString())); }
public ActionResult EditCompanySingle(int id, string businessRange, string businessStatus, string salesName) { var OtaCompany = db.OtaCompany.FirstOrDefault(p => p.Id == id); OtaCompany.BusinessRange = businessRange; OtaCompany.BusinessStatus = businessStatus; OtaCompany.SalesUserName = salesName; OtaCompany.CreateTime = DateTime.Now; db.SaveChanges(); return(Content("更新完成.")); }
public string GetAndSaveMobilePassword(string mobileNum) { string password = GetRandomPassword(6); OtaCrmModel db = new OtaCrmModel(); MobilePassword item = new MobilePassword(); item.CreateTime = DateTime.Now; item.MobileNum = mobileNum; item.Password = password; db.MobilePassword.Add(item); db.SaveChanges(); return(password); }
public ActionResult Create(OtaSalesReport otaSalesReport) { if (ModelState.IsValid) { //自动根据时间读取拜访记录生成周报,有html的格式 otaSalesReport.ReportContent = GenerateReport(otaSalesReport.UserName, otaSalesReport.StartDate.Value, otaSalesReport.EndDate.Value); db.OtaSalesReport.Add(otaSalesReport); db.SaveChanges(); //生成周报的时候,要同时生成相应的报表统计图表存放到对应的id的文件夹里面 SavePersonCompanyTicketChart(otaSalesReport.UserName, otaSalesReport.ID, otaSalesReport.StartDate.Value, otaSalesReport.EndDate.Value); return(RedirectToAction("Edit", new { id = otaSalesReport.ID })); } return(View(otaSalesReport)); }
public async Task <ActionResult> Register(RegisterViewModel model) { if (ModelState.IsValid) { var user = new ApplicationUser { UserName = model.UserName, Email = model.Email, TrueName = model.TrueName, QQ = model.QQ, PhoneNumber = model.PhoneNumber }; var result = await UserManager.CreateAsync(user, model.Password); if (result.Succeeded) { await SignInManager.SignInAsync(user, isPersistent : false, rememberBrowser : false); // 有关如何启用帐户确认和密码重置的详细信息,请访问 http://go.microsoft.com/fwlink/?LinkID=320771 // 发送包含此链接的电子邮件 // string code = await UserManager.GenerateEmailConfirmationTokenAsync(user.Id); // var callbackUrl = Url.Action("ConfirmEmail", "Account", new { userId = user.Id, code = code }, protocol: Request.Url.Scheme); // await UserManager.SendEmailAsync(user.Id, "确认你的帐户", "请通过单击 <a href=\"" + callbackUrl + "\">這裏</a>来确认你的帐户"); var roleName = "Guest"; if (RoleManager.RoleExists(roleName) == false) { var role = new ApplicationRole(roleName, "访客", ""); await RoleManager.CreateAsync(role); } await UserManager.AddToRoleAsync(user.Id, roleName); //加入区域 if (string.IsNullOrEmpty(model.ServeAreaName)) { ServeArea serveArea = new ServeArea(); serveArea.UserName = model.UserName; serveArea.ServeAreaName = model.ServeAreaName; OtaCrmModel db = new OtaCrmModel(); db.ServeArea.Add(serveArea); db.SaveChanges(); } return(RedirectToAction("Index", "Home")); } AddErrors(result); } // 如果我们进行到这一步时某个地方出错,则重新显示表单 return(View(model)); }
public ActionResult Create(CompanyMedia companyMedia) { if (ModelState.IsValid) { //上传图片先 string pathForSaving = Server.MapPath("~/CompanyImages/Meetings/" + companyMedia.OuterKeyId); if (this.CreateFolderIfNeeded(pathForSaving)) { try { List <CompanyMedia> insertList = new List <CompanyMedia>(); var imageFiles = Request.Files; for (int i = 0; i < imageFiles.Count; i++) { HttpPostedFileBase imageFile = imageFiles[i]; CompanyMedia insertItem = new CompanyMedia(); insertItem.MediaFor = companyMedia.MediaFor; insertItem.MediaName = companyMedia.MediaName + i.ToString(); insertItem.OuterKeyId = companyMedia.OuterKeyId; insertItem.MediaUrl = ""; string fileName = insertItem.OuterKeyId + "_" + insertItem.MediaName + "_" + DateTime.Now.ToString("yyyyMMddHHmmss"); string fileExtension = Path.GetExtension(imageFile.FileName); imageFile.SaveAs(Path.Combine(pathForSaving, fileName + fileExtension)); insertItem.MediaUrl = fileName + fileExtension; //保存图片名 insertList.Add(insertItem); } db.CompanyMedia.AddRange(insertList); db.SaveChanges(); } catch (Exception ex) { ViewBag.ErrorMessage = string.Format("File upload failed: {0}", ex.Message); } } return(RedirectToAction("Edit", "CompanyMeetings", new { id = companyMedia.OuterKeyId })); } return(View(companyMedia)); }
public ActionResult ImportCompanyFromCms() { OtaCrmModel db = new OtaCrmModel(); var cityList = (from cc in db.ChinaCity select cc).ToList(); var exsitNames = (from c in db.OtaCompany select c.CompanyName).Distinct(); List <string> exsitNameList = exsitNames.ToList(); var q = (from p in db.CompanyCmsData select p); int count = 0; foreach (CompanyCmsData cmsItem in q) { string companyName = cmsItem.CompanyName; if (string.IsNullOrEmpty(companyName) || exsitNameList.Contains(companyName)) { continue; } OtaCompany newItem = new OtaCompany(); newItem.BossBackground = cmsItem.BossBackground; newItem.BossBusinessDesp = ""; newItem.BossIdNo = ""; newItem.CompanyName = companyName; newItem.CreateTime = DateTime.Now; newItem.BossName = cmsItem.ContactPerson; string businessRange = ""; if (!string.IsNullOrEmpty(cmsItem.GuojiWebName)) { businessRange = "国内"; } if (!string.IsNullOrEmpty(cmsItem.GuojiWebName)) { businessRange = "国际"; } if (!string.IsNullOrEmpty(cmsItem.GuojiWebName) && !string.IsNullOrEmpty(cmsItem.GuojiWebName)) { businessRange = "国内,国际"; } newItem.BusinessRange = businessRange; string businessStatus = "在线"; if (!string.IsNullOrEmpty(cmsItem.TTSStatusDesp) && cmsItem.TTSStatusDesp.Contains("终止")) { businessStatus = "终止"; } newItem.BusinessStatus = businessStatus; newItem.CapitalAsserts = ""; newItem.CityName = ""; foreach (var city in cityList) { if (!string.IsNullOrEmpty(cmsItem.RealAddress) && cmsItem.RealAddress.Contains(city.CityName.Replace("市", ""))) { newItem.CityName = city.ProvinceName + "-" + city.CityName; break; } } newItem.LegalPerson = string.IsNullOrEmpty(cmsItem.LegalPerson) ? "未知" : cmsItem.LegalPerson; newItem.LegalPersonIdNo = ""; newItem.LegalPersonPhone = cmsItem.ContactPhone; newItem.OfficeNo = ""; newItem.OtherInvest = ""; newItem.RealAddress = cmsItem.RealAddress; newItem.RegisterAddress = cmsItem.RegisterAddress; newItem.SalesUserName = cmsItem.SalesName; db.OtaCompany.Add(newItem); count++; } db.SaveChanges(); return(Content("导入成功:" + count.ToString())); }