public async Task <ActionResult> Edit([Bind(Include = "Id,OuterKeyId,MediaFor,MediaName,MediaUrl")] CompanyMedia companyMedia) { if (ModelState.IsValid) { db.Entry(companyMedia).State = EntityState.Modified; await db.SaveChangesAsync(); return(RedirectToAction("Index")); } return(View(companyMedia)); }
public async Task <ActionResult> Edit(OtaSalesReport otaSalesReport) { if (ModelState.IsValid) { db.Entry(otaSalesReport).State = EntityState.Modified; await db.SaveChangesAsync(); return(RedirectToAction("Index")); } return(View(otaSalesReport)); }
public async Task <ActionResult> Edit([Bind(Include = "Id,CompanyId,CertificateName,CompanyName,PictureUrl,CreateTime,CreateUserName")] CompanyCertificate companyCertificate) { if (ModelState.IsValid) { db.Entry(companyCertificate).State = EntityState.Modified; await db.SaveChangesAsync(); return(RedirectToAction("Index")); } return(View(companyCertificate)); }
public async Task <ActionResult> Edit([Bind(Include = "Id,CompanyBusinessDailyId,PhotoUrl,PhotoName")] CompanyBusinessDailyPhoto companyBusinessDailyPhoto) { if (ModelState.IsValid) { db.Entry(companyBusinessDailyPhoto).State = EntityState.Modified; await db.SaveChangesAsync(); return(RedirectToAction("Index")); } return(View(companyBusinessDailyPhoto)); }
public async Task <ActionResult> Create([Bind(Include = "Id,ParamName,SubItemName")] ParamDict paramDict) { if (ModelState.IsValid) { db.ParamDict.Add(paramDict); await db.SaveChangesAsync(); return(RedirectToAction("Index")); } return(View(paramDict)); }
public async Task <ActionResult> Create([Bind(Include = "ID,UserName,ServeAreaName")] ServeArea serveArea) { if (ModelState.IsValid) { db.ServeArea.Add(serveArea); await db.SaveChangesAsync(); return(RedirectToAction("Index")); } return(View(serveArea)); }
public async Task <ActionResult> Create([Bind(Include = "Id,CompanyMeetingId,Subject,Problem,Resolve,CreateTime,ResolveTime")] CompanyMeetingSubject companyMeetingSubject) { if (ModelState.IsValid) { db.CompanyMeetingSubject.Add(companyMeetingSubject); await db.SaveChangesAsync(); return(RedirectToAction("Index")); } return(View(companyMeetingSubject)); }
public async Task <ActionResult> Create([Bind(Include = "Id,CompanySalesDailyId,SaleSource,EmployeeCount,TicketCount,EmployeePayment")] CompanySalesDailySalesSource companySalesDailySalesSource) { if (ModelState.IsValid) { db.CompanySalesDailySalesSource.Add(companySalesDailySalesSource); await db.SaveChangesAsync(); return(RedirectToAction("Index")); } return(View(companySalesDailySalesSource)); }
public async Task <ActionResult> Create([Bind(Include = "Id,CompanySalesDailyId,SalesSource,FreezeFund,WorkingFund,NeededFund")] CompanySalesDailyFund companySalesDailyFund) { if (ModelState.IsValid) { db.CompanySalesDailyFund.Add(companySalesDailyFund); await db.SaveChangesAsync(); return(RedirectToAction("Index")); } return(View(companySalesDailyFund)); }
public async Task <ActionResult> Create([Bind(Include = "Id,CompanyId,CompanyName,ManagerName,ManagerPhone,SalesType,CreateUserName,CreateTime,SalesLogDate")] CompanySalesDaily companySalesDaily) { if (ModelState.IsValid) { db.CompanySalesDaily.Add(companySalesDaily); await db.SaveChangesAsync(); return(RedirectToAction("Edit", new { id = companySalesDaily.Id })); } return(View(companySalesDaily)); }
public async Task <ActionResult> Create([Bind(Include = "ID,ProvinceName,CityName")] ChinaCity chinaCity) { if (ModelState.IsValid) { db.ChinaCity.Add(chinaCity); await db.SaveChangesAsync(); return(RedirectToAction("Index")); } return(View(chinaCity)); }
public async Task <ActionResult> Create([Bind(Include = "Id,CompanySalesDailyId,SalesSource,SalesProduct,SalesCount")] CompanySalesDailyProductDesp companySalesDailyProductDesp) { if (ModelState.IsValid) { db.CompanySalesDailyProductDesp.Add(companySalesDailyProductDesp); await db.SaveChangesAsync(); return(RedirectToAction("Index")); } return(View(companySalesDailyProductDesp)); }
public async Task <ActionResult> Create([Bind(Include = "id,agentDomain,agentName,promotion,agentManager,totalTicketNum,totalTicket,passRate,less60minRate,orderAlterRate,voluntaryRate,involuntaryRate,complainRate,qapassRate,phoneAnswerRate,messageTimeoutRate,qualification,whiteList,totalScore,status,statDate,statMonth,grade,CurDateTicketCount,CreateTime")] AgentGradeOperation agentGradeOperation) { if (ModelState.IsValid) { db.AgentGradeOperation.Add(agentGradeOperation); await db.SaveChangesAsync(); return(RedirectToAction("Index")); } return(View(agentGradeOperation)); }
public async Task <ActionResult> Create([Bind(Include = "Id,CompanySalesDailyId,ParamName,SubParamItem,ItemAmount")] CompanySalesDailyParam companySalesDailyParam) { if (ModelState.IsValid) { db.CompanySalesDailyParam.Add(companySalesDailyParam); await db.SaveChangesAsync(); return(RedirectToAction("Index")); } return(View(companySalesDailyParam)); }
public async Task <ActionResult> Create(OtaCompany otaCompany) { if (ModelState.IsValid) { db.OtaCompany.Add(otaCompany); await db.SaveChangesAsync(); return(RedirectToAction("Index")); } return(View(otaCompany)); }
public ActionResult UpdateSalesName(string paramdata) { string[] lines = paramdata.Split(new char[] { '\r', '\n' }, StringSplitOptions.RemoveEmptyEntries); Dictionary <string, string> companyDict = new Dictionary <string, string>(); foreach (string line in lines) { string[] fields = line.Split(new char[] { '\t' }); string companyName = fields[0].Trim(); string salesName = fields[1].Trim(); if (!companyDict.ContainsKey(companyName)) { companyDict.Add(companyName, salesName); } } OtaCrmModel db = new OtaCrmModel(); var q = from p in db.OtaCompany select p; List <OtaCompany> cList = q.ToList(); foreach (OtaCompany item in cList) { if (companyDict.ContainsKey(item.CompanyName)) { item.SalesUserName = companyDict[item.CompanyName]; } } db.SaveChangesAsync(); return(Content("完成")); }
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)); }
public void InsertCompanyCms(List <CompanyCmsData> itemList, string md5Key) { if (md5Key == GetMd5Str(DateTime.Now.ToString("yyyyMMddHHmm00") + md5hashstr)) { OtaCrmModel db = new OtaCrmModel(); db.CompanyCmsData.AddRange(itemList); db.SaveChangesAsync(); } }
public void InsertAgentGradeOprations(List <AgentGradeOperation> itemList, string md5Key) { if (md5Key == GetMd5Str(DateTime.Now.ToString("yyyyMMddHHmm00") + md5hashstr)) { //计算每一条具体的当天票量,用当前的减去比它日期早一天的票量 OtaCrmModel db = new OtaCrmModel(); db.AgentGradeOperation.AddRange(itemList); db.SaveChangesAsync(); } }
public ActionResult UpdateCompanyStatus() { OtaCrmModel db = new OtaCrmModel(); var q = from p in db.OtaCompany select p; foreach (OtaCompany item in q) { if (string.IsNullOrEmpty(item.LegalPerson) || item.LegalPerson == "未知") { item.LegalPerson = "空"; } } db.SaveChangesAsync(); return(Content("更新完成.")); }
public ActionResult Update(string paramdata) { string[] fields = paramdata.Split(new char[] { '-' }); string OrgName = fields[0]; string curName = fields[1]; // OtaCrmModel db = new OtaCrmModel(); var q = from p in db.OtaCompany where p.SalesUserName == OrgName select p; foreach (OtaCompany item in q) { item.SalesUserName = curName; } db.SaveChangesAsync(); return(Content("完成")); }
public ActionResult UpdateLegal() { OtaCrmModel db = new OtaCrmModel(); var companycmss = from p in db.CompanyCmsData select p; Dictionary <string, string> cmsDict = new Dictionary <string, string>(); foreach (CompanyCmsData cmsItem in companycmss) { if (!cmsDict.ContainsKey(cmsItem.CompanyName)) { cmsDict.Add(cmsItem.CompanyName, cmsItem.LegalPerson); } } db = new OtaCrmModel(); var q = from o in db.OtaCompany select o; List <OtaCompany> otacompanys = q.ToList(); foreach (OtaCompany cItem in otacompanys) { if (string.IsNullOrEmpty(cItem.LegalPerson) || cItem.LegalPerson == "未知") { if (cmsDict.ContainsKey(cItem.CompanyName)) { cItem.LegalPerson = cmsDict[cItem.CompanyName]; } } if (string.IsNullOrEmpty(cItem.LegalPerson) || cItem.LegalPerson == "ww") { cItem.LegalPerson = "未知"; } } db.SaveChangesAsync(); return(Content("完成")); }
public ActionResult UpdateOtaCompany() { OtaCrmModel db = new OtaCrmModel(); var companycmss = from p in db.CompanyCmsData select p; Dictionary <string, CompanyCmsData> cmsDict = new Dictionary <string, CompanyCmsData>(); foreach (CompanyCmsData cmsItem in companycmss) { if (!cmsDict.ContainsKey(cmsItem.CompanyName)) { cmsDict.Add(cmsItem.CompanyName, cmsItem); } } var q = from o in db.OtaCompany select o; List <OtaCompany> otacompanys = q.ToList(); int updateCount = 0; bool isUpdate = false; foreach (OtaCompany cItem in otacompanys) { if (cmsDict.ContainsKey(cItem.CompanyName)) { CompanyCmsData cmsItem = cmsDict[cItem.CompanyName]; //需要修改得地方是这些 if (!string.IsNullOrEmpty(cmsItem.SalesName)) { cItem.SalesUserName = cmsItem.SalesName; } if (string.IsNullOrEmpty(cItem.RegisterAddress) && !string.IsNullOrEmpty(cmsItem.RegisterAddress)) { isUpdate = true; cItem.RegisterAddress = cmsItem.RegisterAddress; } if (string.IsNullOrEmpty(cItem.RealAddress) && !string.IsNullOrEmpty(cmsItem.RealAddress)) { isUpdate = true; cItem.RealAddress = cmsItem.RealAddress; } if (string.IsNullOrEmpty(cItem.BossBackground) && !string.IsNullOrEmpty(cmsItem.BossBackground)) { isUpdate = true; cItem.BossBackground = cmsItem.BossBackground; } if (string.IsNullOrEmpty(cItem.BossName) && !string.IsNullOrEmpty(cmsItem.ContactPerson)) { isUpdate = true; cItem.BossName = cmsItem.ContactPerson; } if (string.IsNullOrEmpty(cItem.BusinessStatus) && !string.IsNullOrEmpty(cmsItem.TTSStatusDesp)) { isUpdate = true; cItem.BusinessStatus = cmsItem.TTSStatusDesp; } if (string.IsNullOrEmpty(cItem.LegalPerson) && !string.IsNullOrEmpty(cmsItem.LegalPerson)) { isUpdate = true; cItem.LegalPerson = cmsItem.LegalPerson; } if (string.IsNullOrEmpty(cItem.LegalPersonPhone) && !string.IsNullOrEmpty(cmsItem.ContactPhone)) { isUpdate = true; cItem.LegalPersonPhone = cmsItem.ContactPhone; } if (isUpdate) { updateCount++; } } isUpdate = false; } db.SaveChangesAsync(); string result = "成功更新:" + updateCount.ToString(); return(Content(result)); }