// 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 { } }
// 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; } }