public void AddToEnumerable() { // Arrange var list = new List <int> { 1, 2, 3, 4 }; var element = 10; // Act var withElement = EnumerableExtension.Add(list, element); // Assert Assert.Contains(element, withElement); }
/// <summary> /// 获取propertiesBriefcase,其中包含该 1.该平板中所有的课程 2.班级表 /// 第一次在哪下载的课程 就得在哪里用.学院之间不能混用. /// 若briefcase不存在 则创建一个briefcase /// </summary> /// <returns></returns> public static FileBriefcase InitPropertiesBriefcase(long collageNo) { if (File.Exists(GlobalParams.BriefcasePath + @"Properties.daBriefcase")) //does properties briefcase exists? { var propertiesBriefcase = new FileBriefcase(GlobalParams.BriefcasePath + @"Properties.daBriefcase", true); //if yes ,return that briefcase(侯晨琛非要让我用英语注释) var fDataModule = new DataModule(); //新建briefcase的时候要下载班级表咯 var bjTable = from c in fDataModule.GetBjTable() //获取数据 where c.XYID == collageNo select c; var bjDataTable = EnumerableExtension.ListToDataTable(bjTable.ToList(), "BJTABLE"); //将班级表转换成datatable propertiesBriefcase.AddTable(bjDataTable); //将班级表添加到briefcase中 propertiesBriefcase.WriteBriefcase(); return(propertiesBriefcase);//返回该briefcase } else { var propertiesBriefcase = new FileBriefcase(GlobalParams.BriefcasePath + @"Properties.daBriefcase"); //如果没有的话 那就新建一个briefcase var courseInfoTable = new DataTable("CourseInfo"); // courseInfoTable.Columns.Add("课程名称", typeof(string)); courseInfoTable.Columns.Add("课程编号", typeof(string)); propertiesBriefcase.AddTable(courseInfoTable); //新建一张表 表中存的是该平板中所有课程的信息 但表是空的. var fDataModule = new DataModule(); //新建briefcase的时候要下载班级表咯 var bjTable = from c in fDataModule.GetBjTable() //获取班级表数据 where c.XYID == collageNo select c; var bjDataTable = EnumerableExtension.ListToDataTable(bjTable.ToList(), "BJTABLE"); //将班级表转换成datatable propertiesBriefcase.AddTable(bjDataTable); //将班级表添加到briefcase中 propertiesBriefcase.WriteBriefcase(); return(propertiesBriefcase);//返回该briefcase } }
public static void FromOperator(IOperator op) { var permList = new List <List <IObject> >(); foreach (Term variable in op.Terms) { permList.Add(typeDict[variable.Type] as List <IObject>); } foreach (var combination in EnumerableExtension.GenerateCombinations(permList)) { // Add bindings var opClone = op.Clone() as Operator; var termStringList = from term in opClone.Terms select term.Variable; var constantStringList = from objConst in combination select objConst.Name; opClone.AddBindings(termStringList.ToList(), constantStringList.ToList()); var legal = true; foreach (var precon in opClone.Preconditions) { if (!NonStaticPredicates.Contains(precon.Name)) { // this predicate is static if (!Init.Contains(precon)) { legal = false; break; } } } if (!legal) { continue; } // this ensures that this ground operator has a unique ID var groundOperator = new Operator(opClone.Name, opClone.Terms, opClone.Bindings, opClone.Preconditions, opClone.Effects); if (GroundLibrary.ContainsKey(groundOperator.ID)) { throw new System.Exception(); } GroundActions.Add(groundOperator as IOperator); GroundLibrary[groundOperator.ID] = groundOperator; } }
public void StrJoin() { // Arrange var list = new List <string> { "1", "2", "3" }; var separator = ""; // Act var joined = EnumerableExtension.StrJoin(list, separator); // Assert var correct = string.Join(separator, list); Assert.Equal(correct, joined); }
public static List <IOperator> FromOperatorWithReturn(IOperator op) { var listToReturn = new List <IOperator>(); var permList = new List <List <string> >(); foreach (Term variable in op.Terms) { permList.Add(TypeDict[variable.Type] as List <string>); } foreach (var combination in EnumerableExtension.GenerateCombinations(permList)) { // Add bindings var opClone = op.Clone() as Operator; var termStringList = from term in opClone.Terms select term.Variable; var constantStringList = combination; opClone.AddBindings(termStringList.ToList(), constantStringList.ToList()); if (!opClone.NonEqualTermsAreNonequal()) { continue; } //Debug.Log("operator: " + opClone.ToString()); // this ensures that this ground operator has a unique ID var groundOperator = new Operator(opClone.Name, opClone.Terms, opClone.Bindings, opClone.Preconditions, opClone.Effects); if (GroundActionFactory.GroundActions.Contains(groundOperator)) { continue; } if (GroundLibrary.ContainsKey(groundOperator.ID)) { throw new System.Exception(); } InsertOperator(groundOperator as IOperator); listToReturn.Add(groundOperator as IOperator); } return(listToReturn); }
public ActionResult Commision() { if (string.IsNullOrEmpty((string)Session["DealerCode"])) { return(RedirectToAction("Login", "Home")); } dealerCode = Session["DealerCode"].ToString(); DataTable Empdt, Productdt, Commisondt; List <EmployeeVM> item = new List <EmployeeVM>(); Empdt = GeneralMethods.GetDataForModal("SP_Select_DealerEmpForCommision", dealerCode); if (Empdt.Rows.Count > 0) { item = EnumerableExtension.ToList <EmployeeVM>(Empdt); } ViewBag.AssignTo = item; List <GetProductSpVM> Productlist = new List <GetProductSpVM>(); Productdt = GeneralMethods.GetDataForModal("SP_Select_ProductForCommision", dealerCode); if (Productdt.Rows.Count > 0) { Productlist = EnumerableExtension.ToList <GetProductSpVM>(Productdt); } ViewBag.Product = Productlist; List <CommisionVM> CommisionList = new List <CommisionVM>(); Commisondt = GeneralMethods.GetDataForModal("SP_Select_CommisionMaster", dealerCode); if (Commisondt.Rows.Count > 0) { CommisionList = EnumerableExtension.ToList <CommisionVM>(Commisondt); } ViewBag.Commision = CommisionList; List <SelectListItem> ddlColor = new List <SelectListItem>(); ddlColor = GeneralMethods.GetColor(Session["VehicleCategory"].ToString()); ViewBag.Color = ddlColor; return(View()); }
public ActionResult Profile() { var model = new ProfileViewModel(); using (var ctx = new testModel()) { var gc = ctx.GameCollection.ToList(); var g = ctx.Game.ToList(); var cc = ctx.Console.ToList(); var user = ctx.User.FirstOrDefault(x => x.UserID == 1); model.UserID = user.UserID; model.GamerName = user.Username; var games = user.Collection.Games.ToList(); model.RandGames = EnumerableExtension.PickRandom(games, 5).ToList(); } return(View(model)); }
public void Prepend_Successful() { var item = new { Id = 1, Value = "string1" }; var originalList = new List <object> { new { Id = 2, Value = "string2" }, null, new { Id = 3, Value = "string3" }, }; var result = EnumerableExtension.Prepend(originalList, item).ToList(); Assert.AreEqual(originalList.Count + 1, result.Count); AssertExtension.AreObjectsValuesEqual(item, result[0]); for (int i = 0; i < originalList.Count; i++) { AssertExtension.AreObjectsValuesEqual(originalList[i], result[i + 1]); } }
public JsonResult GetLocations(string search) { try { SqlParameter[] parameters = { new SqlParameter("@location_Name", SqlDbType.NVarChar) { Value = search } }; DataSet ds = DataAccess.GetDataSet(AppConfigurations.ConnectionString, "Autocomplete_Search_Location", parameters); var LocationList = EnumerableExtension.ToList <LocationS>(ds.Tables[0]); return(Json(LocationList, JsonRequestBehavior.AllowGet)); } catch (Exception) { return(Json(null, JsonRequestBehavior.AllowGet)); } }
public ActionResult Index() { if (string.IsNullOrEmpty((string)Session["DealerCode"])) { return(RedirectToAction("NewLogin", "Home")); } dealerCode = Session["DealerCode"].ToString(); List <ISIInstallmentReceiptVM> ISIReceiptData = new List <ISIInstallmentReceiptVM>(); dt = GeneralMethods.GetDataForModal("Sp_GetDataForInstallmentLedger", dealerCode); if (dt.Rows.Count > 0) { ISIReceiptData = EnumerableExtension.ToList <ISIInstallmentReceiptVM>(dt); } ViewBag.ISIIRDetail = ISIReceiptData; return(View()); }
// In case you need to make this separately. public static void CreateTypeDict(Domain domain, Problem problem) { TypeDict = new Dictionary <string, List <string> >(); var ops = domain.Operators; var objectHierarchy = EnumerableExtension.HashtableToDictionary <string, List <string> >(domain.objectTypes); var typeToObjectDict = EnumerableExtension.HashtableToDictionary <string, List <string> >(problem.ObjectsByType); foreach (var keyvalue in typeToObjectDict) { TypeDict[keyvalue.Key] = keyvalue.Value; } // Foreach object key that isn't a typedict key var excludedObjectKeys = objectHierarchy.Keys.Where(okey => !typeToObjectDict.ContainsKey(okey)); foreach (var okey in excludedObjectKeys) { var newValues = typeToObjectDict.Keys.Where(tkey => objectHierarchy[okey].Contains(tkey)).Select(tkey => typeToObjectDict[tkey]); TypeDict[okey] = newValues.SelectMany(x => x).ToList(); } }
public static List <SelectListItem> Get_BrandProductData(string enquiryId, string dealerCode, string vehiclecategory) { string json = ""; List <SelectListItem> item = new List <SelectListItem>(); var Serializer = new JavaScriptSerializer(); List <PrdouctVM> lst = new List <PrdouctVM>(); try { SqlParameter[] sqlParam = { new SqlParameter("@EnquiryId", enquiryId), //0 new SqlParameter("@DealerCode", dealerCode), //1 new SqlParameter("@VehicleCategory", vehiclecategory) //1 }; dt = DataAccess.getDataTable("SP_BrandProduct_Select", sqlParam, General.GetBMSConString()); if (dt.Rows.Count > 0) { lst = EnumerableExtension.ToList <PrdouctVM>(dt); } //json = Serializer.Serialize(lst); item = lst.Select(i => new SelectListItem() { Value = i.ProdCode.ToString(), Text = i.ProdDesc.ToString() + " | " + i.VersionCode.ToString() + " | " + i.ProdDesc.ToString() }).ToList(); item.Insert(0, new SelectListItem() { Value = "0", Text = "Select" }); } catch (Exception ex) { throw; } return(item); }
public static List <SelectListItem> GetVehicaleType() { List <SelectListItem> item = new List <SelectListItem>(); DataTable dt = new DataTable(); SysFunction sysfun = new SysFunction(); string dealerCode = ""; List <StringNameValueClass> lst = new List <StringNameValueClass>(); try { //var Serializer = new JavaScriptSerializer(); SqlParameter[] sqlParam = { new SqlParameter("@DealerCode", dealerCode) }; dt = DataAccess.getDataTable("Select_VehicleType", sqlParam, General.GetBMSConString()); if (dt.Rows.Count > 0) { lst = EnumerableExtension.ToList <StringNameValueClass>(dt); } //json = Serializer.Serialize(lst); item = lst.Select(i => new SelectListItem() { Value = i.Id.ToString(), Text = i.Title }).ToList(); item.Insert(0, new SelectListItem() { Value = "0", Text = "Select" }); } catch (Exception ex) { //throw; } return(item); }
public ActionResult MonthlyCommisionDateWise() { if (string.IsNullOrEmpty((string)Session["DealerCode"])) { return(RedirectToAction("Login", "Home")); } dealerCode = Session["DealerCode"].ToString(); DataTable Empdt = new DataTable(); List <EmployeeVM> item = new List <EmployeeVM>(); Empdt = GeneralMethods.GetDataForModal("SP_Select_DealerEmpForCommision", dealerCode); if (Empdt.Rows.Count > 0) { item = EnumerableExtension.ToList <EmployeeVM>(Empdt); } ViewBag.AssignTo = item; return(View()); }
// GET: MonthlyCommision public ActionResult Main() { DataTable dt = new DataTable(); if (string.IsNullOrEmpty((string)Session["DealerCode"])) { return(RedirectToAction("Login", "Home")); } dealerCode = Session["DealerCode"].ToString(); List <MonthlyCommisionVM> CommisionList = new List <MonthlyCommisionVM>(); dt = GeneralMethods.GetDataForModal("SP_Select_MonthlyCommisionMaster", dealerCode); if (dt.Rows.Count > 0) { CommisionList = EnumerableExtension.ToList <MonthlyCommisionVM>(dt); } ViewBag.MonthlyComm = CommisionList; return(View()); }
// psElites.Models.DAL.psElitesEntities dbContext = new Models.DAL.psElitesEntities(); public ActionResult Index() { var model = new StartPageViewModel(); using (var ctx = new testModel()) { var gc = ctx.GameCollection.ToList(); var g = ctx.Game.ToList(); var cc = ctx.Console.ToList(); var users = ctx.User.ToList(); if (users.Any()) { var user = users.First(x => x.Username.ToLower() == "radx"); model.User = user; model.Members = EnumerableExtension.PickRandom(users, 2).ToList(); model.OurGames = EnumerableExtension.PickRandom(g, 1).ToList(); } } return(View(model)); }
public ActionResult Index() { if (string.IsNullOrEmpty((string)Session["DealerCode"])) { return(RedirectToAction("Login", "Home")); } dealerCode = Session["DealerCode"].ToString(); dt = ReversalMethods.GetDataForModal(dealerCode); List <AccountTransactionVM> lstAccount = new List <AccountTransactionVM>(); if (dt.Rows.Count > 0) { lstAccount = EnumerableExtension.ToList <AccountTransactionVM>(dt); } ViewBag.AccountTrans = lstAccount; return(View()); }
public static List <OptionalFeatureVM> Get_OptionalFeatureData_VS(string enquiryId, string dealerCode, string chassis) { string json = ""; List <SelectListItem> item = new List <SelectListItem>(); var Serializer = new JavaScriptSerializer(); List <OptionalFeatureVM> lst = new List <OptionalFeatureVM>(); try { SqlParameter[] sqlParam = { new SqlParameter("@EnquiryId", enquiryId), //0 new SqlParameter("@DealerCode", dealerCode), //1 new SqlParameter("@Chassis", chassis) //1 }; dt = DataAccess.getDataTable("SP_OptionalFeature_Select_VS", sqlParam, General.GetBMSConString()); if (dt.Rows.Count > 0) { lst = EnumerableExtension.ToList <OptionalFeatureVM>(dt); } //json = Serializer.Serialize(lst); //item = lst.Select(i => new SelectListItem() //{ // Value = i.FID.ToString(), // Text = i.FDesc.ToString(), // Price = i.FDesc.ToString() //}).ToList(); // item.Insert(0, new SelectListItem() { Value = "0", Text = "Select" }); } catch (Exception ex) { throw; } return(lst); }
public async Task <IActionResult> DeleteAsync([FromBody] List <AdminConfigBaseModel> subjectRequestsData) { this.RecordEvent("Subject - HTTP Delete call to delete subjects.", RequestType.Initiated); this.logger.LogInformation("Call to delete subject details."); try { if (EnumerableExtension.IsNullOrEmpty(subjectRequestsData)) { this.RecordEvent("No subject details data passed in request", RequestType.Failed); this.logger.LogInformation("No subject details data passed in delete request"); return(this.BadRequest("Delete request data should not be null")); } IEnumerable <Subject> subjectCollection = new List <Subject>(); subjectCollection = subjectRequestsData .Select(subject => new Subject { Id = subject.Id, }); this.unitOfWork.SubjectRepository.DeleteSubjects(subjectCollection); await this.unitOfWork.SaveChangesAsync(); this.RecordEvent("Subject - HTTP Delete call succeeded.", RequestType.Succeeded); return(this.Ok(true)); } catch (DbUpdateException ex) { var errorCode = ((SqlException)ex.InnerException).Number; return(this.StatusCode(errorCode)); } catch (Exception ex) { this.RecordEvent("Subject - HTTP Delete call failed for saving subject data", RequestType.Failed); this.logger.LogError(ex, "Error while deleting subject details"); throw; } }
public static List <DealerInfoVM> LoginRequestSecurity(string user, string pass, ref string msg) { SysFunction myFunc = new SysFunction(); SecurityBll sec = new SecurityBll(); string json = ""; var Serializer = new JavaScriptSerializer(); List <DealerInfoVM> lst = new List <DealerInfoVM>(); DataTable dtLoginVerification = new DataTable(); if (!sec.LoginVerification(user, pass, ref dtLoginVerification)) { msg = "Invalid User ID or Password, Try again or You are not Allowed to Login. Please contact to administrator"; //msg.ForeColor = System.Drawing.Color.Red; } else { try { DataTable dt = dtLoginVerification; if (dt == null) { msg = "Invalid Connection Please Contact to Administrator"; return(lst); } if (dt.Rows.Count > 0) { lst = EnumerableExtension.ToList <DealerInfoVM>(dt); json = Serializer.Serialize(lst); } } catch (Exception ex) { throw; } } return(lst); }
public static List <SelectListItem> GetDataFromSPWithDealerCode(string sp, string DealerCode, string index = "N") { List <SelectListItem> item = new List <SelectListItem>(); List <StringNameValueClass> lst = new List <StringNameValueClass>(); try { SqlParameter[] sqlParam = { new SqlParameter("@DealerCode", DealerCode) }; dt = DataAccess.getDataTable(sp, sqlParam, General.GetBMSConString()); if (dt.Rows.Count > 0) { lst = EnumerableExtension.ToList <StringNameValueClass>(dt); } item = lst.Select(i => new SelectListItem() { Value = i.Id.ToString(), Text = i.Title }).ToList(); if (index == "Y") { item.Insert(0, new SelectListItem() { Value = "0", Text = "All" }); } } catch (Exception ex) { throw; } return(item); }
/// <summary> /// 改变点名表的一条记录 /// </summary> /// <param name="kkno">开课编号</param> /// <param name="dmTable">引用!!! 点名表</param> /// <param name="studentNo">学生学号</param> /// <param name="status">签到状态</param> /// <param name="dmsj">签到时间</param> /// <param name="rollcallNo">哪一次签到</param> public static void ChangeDmRecord(ref DataTable dmTable, string studentNo, short status, DateTime dmsj, short rollcallNo) { var dmTableList = dmTable.ToList <DMTABLE_08_NOPIC_VIEW> (); var dmRecord = from c in dmTableList where c.XSID == studentNo select c; var index = dmTableList.FindIndex(s => s.XSID == studentNo); if (-1 != index) { dmTableList[index].DKZT = status; switch (rollcallNo) //根据签到次数来指定点名时间 { case 1: { dmTableList[index].DMSJ1 = dmsj; break; } case 2: { dmTableList[index].DMSJ2 = dmsj; break; } case 3: { dmTableList[index].DMSJ3 = dmsj; break; } } dmTable = EnumerableExtension.ListToDataTable(dmTableList, dmTable.TableName); // list转datatable 并这张表带出去. } }
public static List <VehicleStockVM> GetVehicleStockModal(string dealerCode) { List <VehicleStockVM> lst = new List <VehicleStockVM>(); try { SqlParameter[] sqlParam = { new SqlParameter("@DealerCode", dealerCode) }; dt = DataAccess.getDataTable("SP_ChassisNoForVehicleReturn", sqlParam, General.GetBMSConString()); if (dt.Rows.Count > 0) { lst = EnumerableExtension.ToList <VehicleStockVM>(dt); } } catch (Exception ex) { throw; } return(lst); }
public IEnumerable <HighlightedField> GetHighlightedFields() { var highlightedFieldStrings = EnumerableExtension.EmptyIfNull(GetQueryStringValues("highlight")); var fields = new HashSet <string>(); foreach (var highlightedFieldString in highlightedFieldStrings) { HighlightedField highlightedField; if (HighlightedField.TryParse(highlightedFieldString, out highlightedField)) { if (!fields.Add(highlightedField.Field)) { throw new BadRequestException("Duplicate highlighted field has found: " + highlightedField.Field); } yield return(highlightedField); } else { throw new BadRequestException("Could not parse highlight query parameter as field highlight options"); } } }
public virtual bool Equals(IndexQueryBase other) { if (ReferenceEquals(null, other)) { return(false); } if (ReferenceEquals(this, other)) { return(true); } return(PageSizeSet.Equals(other.PageSizeSet) && string.Equals(Query, other.Query) && Start == other.Start && IsDistinct == other.IsDistinct && EnumerableExtension.ContentEquals(FieldsToFetch, other.FieldsToFetch) && WaitForNonStaleResultsTimeout == other.WaitForNonStaleResultsTimeout && WaitForNonStaleResultsAsOfNow.Equals(other.WaitForNonStaleResultsAsOfNow) && WaitForNonStaleResults.Equals(other.WaitForNonStaleResults) && Equals(CutoffEtag, other.CutoffEtag) && string.Equals(DefaultField, other.DefaultField) && DefaultOperator == other.DefaultOperator); }
public static List <DeliveryCheckListVM> Get_DelChkList(string dealerCode) { List <DeliveryCheckListVM> lst = new List <DeliveryCheckListVM>(); try { string sql = "Select * from DelChkList A where A.DealerCode = '" + dealerCode + "' order by Type "; dt = sysfun.GetDatas(sql, "BMS0517ConnectionString"); if (dt.Rows.Count > 0) { lst = EnumerableExtension.ToList <DeliveryCheckListVM>(dt); } //json = Serializer.Serialize(lst); } catch (Exception ex) { throw; } return(lst); }
public static List <SupplierVM> GetSupplierModal(string dealerCode) { List <SupplierVM> lst = new List <SupplierVM>(); try { SqlParameter[] sqlParam = { new SqlParameter("@DealerCode", dealerCode) }; dt = DataAccess.getDataTable("SP_Get_SupplierModal", sqlParam, General.GetBMSConString()); if (dt.Rows.Count > 0) { lst = EnumerableExtension.ToList <SupplierVM>(dt); } } catch (Exception ex) { //throw; } return(lst); }
public static List <AccountVM> GetAccountModal(string dealerCode) { List <AccountVM> lst = new List <AccountVM>(); try { SqlParameter[] sqlParam = { new SqlParameter("@CompCode", dealerCode) }; dt = DataAccess.getDataTable("SP_Select_AccountCode", sqlParam, General.GetFAMConString()); if (dt.Rows.Count > 0) { lst = EnumerableExtension.ToList <AccountVM>(dt); } } catch (Exception ex) { //throw; } return(lst); }
protected void Page_Init(object sender, EventArgs e) { string DealerCode = Session["DealerCode"].ToString(); var TransCode = Session["TransCode"]; DataTable dt = new DataTable(); ReportDocument Rd = new ReportDocument(); string json = ""; var Serializer = new JavaScriptSerializer(); List <VehicleSaleDetailReportVM> lst = new List <VehicleSaleDetailReportVM>(); try { SqlParameter[] sqlParam = { new SqlParameter("@DealerCode", DealerCode), //0 new SqlParameter("@TransCode", TransCode) }; dt = DataAccess.getDataTable("SP_Report_VehicleSaleDetail", sqlParam, General.GetBMSConString()); if (dt.Rows.Count > 0) { lst = EnumerableExtension.ToList <VehicleSaleDetailReportVM>(dt); } json = Serializer.Serialize(lst); } catch (Exception ex) { throw; } Rd.Load(Path.Combine(Server.MapPath("~/Reports/Sale/SaleOrder.rpt"))); Rd.SetDataSource(lst); CrystalReportViewerSO.ReportSource = Rd; }
public async Task <IActionResult> DeleteAsync([FromBody] List <AdminConfigBaseModel> gradeRequestsData) { this.RecordEvent("Grade - HTTP Delete call to delete grades is initiated.", RequestType.Initiated); this.logger.LogInformation("Call to delete grade details."); try { if (EnumerableExtension.IsNullOrEmpty(gradeRequestsData)) { this.RecordEvent("Grade - No grade details data passed in request", RequestType.Failed); this.logger.LogInformation("No grade details data passed in delete request"); return(this.BadRequest("Delete request data should not be null")); } var grades = gradeRequestsData .Select(grade => new Grade { Id = grade.Id, }); this.unitOfWork.GradeRepository.DeleteGrades(grades); await this.unitOfWork.SaveChangesAsync(); this.RecordEvent("Grade - HTTP Delete call succeeded.", RequestType.Succeeded); return(this.Ok(true)); } catch (DbUpdateException ex) { var errorCode = ((SqlException)ex.InnerException).Number; return(this.StatusCode(errorCode)); } catch (Exception ex) { this.RecordEvent("Grade - HTTP Delete call failed for grade data", RequestType.Failed); this.logger.LogError(ex, "Error while deleting grade details"); throw; } }