Пример #1
0
        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);
        }
Пример #2
0
        /// <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
            }
        }
Пример #3
0
        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;
            }
        }
Пример #4
0
        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);
        }
Пример #6
0
        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());
        }
Пример #7
0
        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();
            }
        }
Пример #12
0
        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);
        }
Пример #13
0
        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);
        }
Пример #14
0
        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());
        }
Пример #15
0
        // 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());
        }
Пример #16
0
        // 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));
        }
Пример #17
0
        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());
        }
Пример #18
0
        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);
        }
Пример #19
0
        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;
            }
        }
Пример #20
0
        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);
        }
Пример #21
0
        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 并这张表带出去.
            }
        }
Пример #23
0
        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);
        }
Пример #24
0
        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");
                }
            }
        }
Пример #25
0
        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);
        }
Пример #26
0
        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);
        }
Пример #27
0
        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);
        }
Пример #28
0
        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);
        }
Пример #29
0
        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;
            }
        }