Exemplo n.º 1
0
        private DataTable GetParkingFee(string id)
        {
            dbConnection = DBConnect.getConnection();

            if (dbConnection.State.ToString() == "Closed")
            {
                dbConnection.Open();
            }

            DataTable  dt  = new DataTable();
            SqlCommand cmd = new SqlCommand("sp_GetParkingFee", dbConnection);

            cmd.CommandType = CommandType.StoredProcedure;
            cmd.Parameters.AddWithValue("@ParkingId", id);


            SqlDataAdapter adp = new SqlDataAdapter(cmd);

            try
            {
                adp.Fill(dt);
            }
            catch { }
            return(dt);
        }
Exemplo n.º 2
0
        private IEnumerable <ParkingLocations> GetAllParkingGoeLocation(LocationDetails details)
        {
            dbConnection = DBConnect.getConnection();

            if (dbConnection.State.ToString() == "Closed")
            {
                dbConnection.Open();
            }

            DataSet    dt  = new DataSet();
            SqlCommand cmd = new SqlCommand("getParkingLocationGeo", dbConnection);

            cmd.CommandType = CommandType.StoredProcedure;
            cmd.Parameters.AddWithValue("@Latitude", String.Format("{0:0.000}", details.Latitude));
            cmd.Parameters.AddWithValue("@Longitude", String.Format("{0:0.000}", details.Longitude));


            SqlDataAdapter adp = new SqlDataAdapter(cmd);

            try
            {
                adp.Fill(dt);


                Parking_List = new List <ParkingLocations>();
                for (int i = 0; i < dt.Tables[0].Rows.Count; i++)
                {
                    objPark = new ParkingLocations();
                    objPark.ParkingPlace    = dt.Tables[0].Rows[i]["ParkingPlace"].ToString();
                    objPark.Identifier      = dt.Tables[0].Rows[i]["Identifier"].ToString();
                    objPark.Longitude       = dt.Tables[0].Rows[i]["Longitude"].ToString();
                    objPark.Latitude        = dt.Tables[0].Rows[i]["Latitude"].ToString();
                    objPark.Image           = dt.Tables[0].Rows[i]["Image"].ToString();
                    objPark.Image1          = dt.Tables[0].Rows[i]["Image1"].ToString();
                    objPark.Image2          = dt.Tables[0].Rows[i]["Image2"].ToString();
                    objPark.Capacity        = dt.Tables[0].Rows[i]["Capacity"].ToString();
                    objPark.ContactNumber1  = dt.Tables[0].Rows[i]["ContactNumber1"].ToString();
                    objPark.ContactNumber2  = dt.Tables[0].Rows[i]["ContactNumber2"].ToString();
                    objPark.ContactNumber3  = dt.Tables[0].Rows[i]["ContactNumber3"].ToString();
                    objPark.ContactPerson1  = dt.Tables[0].Rows[i]["ContactPerson1"].ToString();
                    objPark.ContactPerson2  = dt.Tables[0].Rows[i]["ContactPerson2"].ToString();
                    objPark.ContactPerson3  = dt.Tables[0].Rows[i]["ContactPerson3"].ToString();
                    objPark.ParkingArea     = dt.Tables[0].Rows[i]["ParkingArea"].ToString();
                    objPark.SutedFor        = dt.Tables[0].Rows[i]["SutedFor"].ToString();
                    objPark.ThrashholdValue = dt.Tables[0].Rows[i]["ThrashholdValue"].ToString();
                    objPark.ParkingFullTag  = dt.Tables[0].Rows[i]["ParkingFullTag"].ToString();
                    Parking_List.Add(objPark);
                }
            }
            catch (Exception ex)
            {
                throw ex;
            }
            finally
            {
                adp.Dispose();
            }
            return(Parking_List);
        }
Exemplo n.º 3
0
        private IEnumerable <ParkingLocations> GetAllParking(string id)
        {
            dbConnection = DBConnect.getConnection();

            if (dbConnection.State.ToString() == "Closed")
            {
                dbConnection.Open();
            }

            DataSet    dt  = new DataSet();
            SqlCommand cmd = new SqlCommand("getParkingLocation", dbConnection);

            cmd.CommandType = CommandType.StoredProcedure;
            cmd.Parameters.AddWithValue("@TownId", id);


            SqlDataAdapter adp = new SqlDataAdapter(cmd);

            try
            {
                adp.Fill(dt);

                if (dt.Tables[0].Rows.Count > 0)
                {
                    Parking_List = new List <ParkingLocations>();
                    for (int i = 0; i < dt.Tables[0].Rows.Count; i++)
                    {
                        objPark = new ParkingLocations();
                        objPark.ParkingPlace    = dt.Tables[0].Rows[i]["ParkingPlace"].ToString();
                        objPark.Identifier      = dt.Tables[0].Rows[i]["Identifier"].ToString();
                        objPark.Longitude       = dt.Tables[0].Rows[i]["Longitude"].ToString();
                        objPark.Latitude        = dt.Tables[0].Rows[i]["Latitude"].ToString();
                        objPark.Image           = dt.Tables[0].Rows[i]["Image"].ToString();
                        objPark.Image1          = dt.Tables[0].Rows[i]["Image1"].ToString();
                        objPark.Image2          = dt.Tables[0].Rows[i]["Image2"].ToString();
                        objPark.Capacity        = dt.Tables[0].Rows[i]["Capacity"].ToString();
                        objPark.ContactNumber1  = dt.Tables[0].Rows[i]["ContactNumber1"].ToString();
                        objPark.ContactNumber2  = dt.Tables[0].Rows[i]["ContactNumber2"].ToString();
                        objPark.ContactNumber3  = dt.Tables[0].Rows[i]["ContactNumber3"].ToString();
                        objPark.ContactPerson1  = dt.Tables[0].Rows[i]["ContactPerson1"].ToString();
                        objPark.ContactPerson2  = dt.Tables[0].Rows[i]["ContactPerson2"].ToString();
                        objPark.ContactPerson3  = dt.Tables[0].Rows[i]["ContactPerson3"].ToString();
                        objPark.ParkingArea     = dt.Tables[0].Rows[i]["ParkingArea"].ToString();
                        objPark.SutedFor        = dt.Tables[0].Rows[i]["SutedFor"].ToString();
                        objPark.ThrashholdValue = dt.Tables[0].Rows[i]["ThrashholdValue"].ToString();
                        objPark.ParkingFullTag  = dt.Tables[0].Rows[i]["ParkingFullTag"].ToString();
                        objPark.Remarks         = "";
                        DataTable dtFee = GetParkingFee(dt.Tables[0].Rows[i]["ParkingLocationId"].ToString().Trim());
                        if (dtFee.Rows.Count > 0)
                        {
                            for (int t = 0; t < dtFee.Rows.Count; t++)
                            {
                                if (dtFee.Rows[t]["VehicalType"].ToString().Trim().ToUpper() == "Small Car".ToUpper())
                                {
                                    for (int j = 3; j < dtFee.Columns.Count; j++)
                                    {
                                        if (dtFee.Rows[t][j].ToString().Trim() != "0")
                                        {
                                            objPark.MinimumParkingFeeSmallCar = dtFee.Rows[t][j].ToString();
                                            objPark.MinimumParkingTime        = dtFee.Columns[j].ColumnName.ToString();
                                            break;
                                        }
                                    }
                                }
                                if (dtFee.Rows[t]["VehicalType"].ToString().Trim().ToUpper() == "Big Car".ToUpper())
                                {
                                    for (int j = 3; j < dtFee.Columns.Count; j++)
                                    {
                                        if (dtFee.Rows[t][j].ToString().Trim() != "0")
                                        {
                                            objPark.MinimumParkingFeebigCar = dtFee.Rows[t][j].ToString();

                                            break;
                                        }
                                    }
                                }
                            }
                        }
                        else
                        {
                            objPark.MinimumParkingFeeSmallCar = "";
                            objPark.MinimumParkingTime        = "";
                            objPark.MinimumParkingFeebigCar   = "";
                        }
                        Parking_List.Add(objPark);
                    }
                }
                else
                {
                    Parking_List    = new List <ParkingLocations>();
                    objPark         = new ParkingLocations();
                    objPark.Remarks = "No Record Found";
                    Parking_List.Add(objPark);
                }
            }
            catch (Exception ex)
            {
                throw ex;
            }
            finally
            {
                adp.Dispose();
            }
            return(Parking_List);
        }