public ActionResult Assign(FormCollection col) { int enquiryId = Convert.ToInt32(col.GetValue("Enquiry").AttemptedValue); int projectId = Convert.ToInt32(col.GetValue("Project").AttemptedValue); int TeamType = Convert.ToInt32(col.GetValue("TeamType").AttemptedValue); string TeamTypeName = (TeamType == 1)?"Non Kenwood Team":"Kenwood Team"; string TeamName = String.Empty; if (TeamType == 1) { TeamName = col.GetValue("Non_Kenwood").AttemptedValue.ToString(); } else { TeamName = teamRepository.Find(Convert.ToInt32(col.GetValue("Team").AttemptedValue)).TeamName; } TeamProject team = new TeamProject(); team.ProjectID = projectId; team.TeamID = Convert.ToInt32(col.GetValue("Team").AttemptedValue); BusinessFlowContext context = new BusinessFlowContext(); context.TeamProjects.Add(team); context.SaveChanges(); return(RedirectToAction("TeamAssigned", team)); }
public static List <CustomerModel> CustomerListExport(IEnumerable <int> zipCodes, string site, bool isProduction) { BusinessFlowContext.SetContext(site, isProduction); var customerList = new List <CustomerModel>(); var customerSearch = new CustomerSearchRequest(); var stateCriterion = new AdditionalCriterion(); stateCriterion.CriterionID = "customer_postal_code"; stateCriterion.CriterionType = AdditionalCriterionType.Database; customerSearch.MaxRows = 20000; customerSearch.Filter = CustomerSearchFilter.Active; customerSearch.AddCriterion(stateCriterion); customerSearch.AddCriterion("lu_dt", AdditionalColumnType.Database, DateTime.Today.AddYears(-4).ToShortDateString(), AdditionalCriterionCondition.GreaterThan); for (var i = 0; i < zipCodes.Count(); i += 10) { stateCriterion.Parameters = zipCodes.Skip(i).Take(10).Select(z => z.ToString()).ToArray(); var customers = BusinessFlow.WebServices.Customer.Search(customerSearch); foreach (dsCustomerList.CustomersRow customer in customers.Customers) { customerList.Add(SafeCreate(customer)); } } return(customerList); }
public static List <CustomerModel> CustomerListExport(string state, string site, bool isProduction) { BusinessFlowContext.SetContext(site, isProduction); var customerList = new List <CustomerModel>(); var customerSearch = new CustomerSearchRequest(); var stateCriterion = new AdditionalCriterion(); stateCriterion.CriterionID = "customer_region_cd"; stateCriterion.CriterionType = AdditionalCriterionType.Database; stateCriterion.Parameters = new string[] { state }; customerSearch.MaxRows = 50000; customerSearch.Filter = CustomerSearchFilter.Active; customerSearch.AddCriterion(stateCriterion); customerSearch.AddCriterion("lu_dt", AdditionalColumnType.Database, DateTime.Today.AddYears(-3).ToShortDateString(), AdditionalCriterionCondition.GreaterThan); var customers = BusinessFlow.WebServices.Customer.Search(customerSearch); if (customers.Customers.Rows.Count == 50000) { throw new NotImplementedException(state + " is just TOO BIG!!"); } foreach (dsCustomerList.CustomersRow customer in customers.Customers) { customerList.Add(SafeCreate(customer)); } return(customerList); }
public static List <CustomerModel> CustomerPointInTimeExport(DateTime since, string site, bool isProduction) { BusinessFlowContext.SetContext(site, isProduction); var customerList = new List <CustomerModel>(); var customerSearch = new CustomerSearchRequest(); customerSearch.AddCriterion("customer_closed", AdditionalColumnType.Database, "0"); customerSearch.AddCriterion("customer_suspended", AdditionalColumnType.Database, "0"); customerSearch.AddCriterion("lu_dt", AdditionalColumnType.Database, since.ToShortDateString(), AdditionalCriterionCondition.GreaterThan); customerSearch.MaxRows = 10000; var customers = BusinessFlow.WebServices.Customer.Search(customerSearch); foreach (dsCustomerList.CustomersRow customer in customers.Customers) { customerList.Add(SafeCreate(customer)); } return(customerList); }