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