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