Exemplo n.º 1
0
        // Get area list
        public List <AreaList> GetAreaList(string areaOf)
        {
            List <AreaList> areaLists = new List <AreaList>();

            try
            {
                DBConnectionClass dBConnection = new DBConnectionClass
                {
                    DatabaseName = "StayInEatIn"
                };

                string Col_Area = areaOf;

                if (dBConnection.IsConnect())
                {
                    var            cmd    = new SqlCommand("SIEI_AREA_GetAreaList", dBConnection.Connection);
                    SqlDataAdapter reader = new SqlDataAdapter(cmd);
                    reader.SelectCommand.CommandType = CommandType.StoredProcedure;
                    reader.SelectCommand.Parameters.AddWithValue("@H_T", Col_Area);



                    reader.SelectCommand = cmd;
                    if (reader != null)
                    {
                        DataTable dt = new DataTable();
                        reader.Fill(dt);

                        foreach (DataRow areas in dt.Rows)
                        {
                            AreaList d = new AreaList();
                            d.Area = (string)areas["Area"];
                            areaLists.Add(d);
                        }
                        return(areaLists);
                    }
                    else
                    {
                        System.Diagnostics.Debug.WriteLine("Empty Reader");
                    }

                    dBConnection.Close();
                    return(null);
                }
                else
                {
                    System.Diagnostics.Debug.WriteLine("Conn Failed");
                    return(null);
                }
            }
            catch (Exception e)
            {
                System.Diagnostics.Debug.WriteLine("Unsuccessful Query Excution");
                throw e;
            }
            finally
            {
            }
        }
Exemplo n.º 2
0
        // Save hostel details
        public void SaveHostelDetails(HostelDetails hostelDetails)
        {
            try
            {
                DBConnectionClass dBConnection = new DBConnectionClass
                {
                    DatabaseName = "StayInEatIn"
                };

                string Col_Name          = hostelDetails.Name;
                string Col_Area          = hostelDetails.Area;
                string Col_Address       = hostelDetails.Address;
                string Col_City          = hostelDetails.City;
                string Col_Pin           = hostelDetails.Pin;
                string Col_Mobile1       = hostelDetails.Mobile1;
                string Col_Mobile2       = hostelDetails.Mobile2;
                string Col_RoomFor       = hostelDetails.RoomFor;
                int    Col_Type          = hostelDetails.Type;
                int    Col_Furnished     = hostelDetails.Furnished;
                string Col_StartingPrice = hostelDetails.StartingPrice;
                int    Col_FoodAvail     = hostelDetails.FoodAvail;

                if (dBConnection.IsConnect())
                {
                    var cmd = new SqlCommand("SIEI_HOST_SaveHostelDetails", dBConnection.Connection);
                    cmd.Parameters.AddWithValue("@Col_Name", Col_Name);
                    cmd.Parameters.AddWithValue("@Col_Area", Col_Area);
                    cmd.Parameters.AddWithValue("@Col_Address", Col_Address);
                    cmd.Parameters.AddWithValue("@Col_City", Col_City);
                    cmd.Parameters.AddWithValue("@Col_Pin", Col_Pin);
                    cmd.Parameters.AddWithValue("@Col_Mobile1", Col_Mobile1);
                    cmd.Parameters.AddWithValue("@Col_Mobile2", Col_Mobile2);
                    cmd.Parameters.AddWithValue("@Col_RoomFor", Col_RoomFor);
                    cmd.Parameters.AddWithValue("@Col_Furnished", Col_Furnished);
                    cmd.Parameters.AddWithValue("@Col_StartingPrice", Col_StartingPrice);
                    cmd.Parameters.AddWithValue("@Col_FoodAvail", Col_FoodAvail);

                    string value = cmd.ExecuteNonQuery().ToString();

                    dBConnection.Close();
                    //return value;
                }
                else
                {
                    System.Diagnostics.Debug.WriteLine("Conn Failed");
                    //return null;
                }
            }
            catch (Exception e)
            {
                System.Diagnostics.Debug.WriteLine("Unsuccessful Query Excution");
                throw e;
            }
        }