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);
}
}