public SchoolDetails Get(int Id) { SqlConnection con = new SqlConnection("Data Source=DESKTOP-3LQJUUD;Initial Catalog=SchoolDB;User ID=sa;Password=123"); string query = "Select * from dbo.SchoolDetails Where Id = @Id"; SqlCommand cmd = new SqlCommand(query, con); cmd.Parameters.AddWithValue("@Id", Id); con.Open(); SchoolDetails schoolDetails = null; SqlDataReader dr = cmd.ExecuteReader(); if (dr.Read()) { schoolDetails = new SchoolDetails { Id = (int)dr[0], SchoolName = dr[1].ToString(), SchoolTypeId = (int)dr[2], CreatedDateTime = (DateTime)dr[3], IsActive = (bool)dr[4], SchoolAddress = dr[5].ToString(), City = dr[6].ToString(), State = dr[7].ToString(), Country = dr[8].ToString(), CreatedBy = (int)dr[9] }; con.Close(); } return(schoolDetails); }
public bool Post(SchoolDetails schoolDetails) { SqlConnection con = new SqlConnection("Data Source=DESKTOP-3LQJUUD;Initial Catalog=SchoolDB;User ID=sa;Password=123"); string query = "Insert into dbo.SchoolDetails (SchoolName,SchoolTypeId,CreatedDateTime,IsActive,SchoolAddress,City,State,Country,CreatedBy) Values(@SchoolName,@SchoolTypeId,@CreatedDateTime,@IsActive,@SchoolAddress,@City,@State,@Country,@CreatedBy)"; SqlCommand cmd = new SqlCommand(query, con); cmd.Parameters.AddWithValue("@SchoolName", schoolDetails.SchoolName); cmd.Parameters.AddWithValue("@SchoolTypeId", schoolDetails.SchoolTypeId); cmd.Parameters.AddWithValue("@CreatedDateTime", schoolDetails.CreatedDateTime); cmd.Parameters.AddWithValue("@IsActive", schoolDetails.IsActive); cmd.Parameters.AddWithValue("@SchoolAddress", schoolDetails.SchoolAddress); cmd.Parameters.AddWithValue("@City", schoolDetails.City); cmd.Parameters.AddWithValue("@State", schoolDetails.State); cmd.Parameters.AddWithValue("@Country", schoolDetails.Country); cmd.Parameters.AddWithValue("@CreatedBy", schoolDetails.CreatedBy); con.Open(); int noOfRowAffected = cmd.ExecuteNonQuery(); con.Close(); if (noOfRowAffected > 0) { return(true); } else { return(false); } }
public List <SchoolDetails> GetAll() { SqlConnection con = new SqlConnection("Data Source=DESKTOP-3LQJUUD;Initial Catalog=SchoolDB;User ID=sa;Password=123"); string query = "Select * from dbo.SchoolDetails"; SqlCommand cmd = new SqlCommand(query, con); con.Open(); List <SchoolDetails> schools = new List <SchoolDetails>(); SqlDataReader dr = cmd.ExecuteReader(); while (dr.Read()) { SchoolDetails schoolDetails = new SchoolDetails() { Id = (int)dr[0], SchoolName = dr[1].ToString(), SchoolTypeId = (int)dr[2], CreatedDateTime = (DateTime)dr[3], IsActive = (bool)dr[4], SchoolAddress = dr[5].ToString(), City = dr[6].ToString(), State = dr[7].ToString(), Country = dr[8].ToString(), CreatedBy = (int)dr[9], }; schools.Add(schoolDetails); } con.Close(); return(schools); }