public static int SelectStatusId(EnumStatus enumstatus)
{
string status = ClassStatus.StatusString(enumstatus);
string querry = "USe db_Clinic SELECT Status_id FROM tbl_Status WHERE Status='" + status + "'";
SqlDataReader dr = ClassQuerry.ExecuteQuerry(querry);
int id = 0;
while (dr.Read())
{
id = dr.GetInt32("Status_id");
}
ClassQuerry.CloseConnection();
return(id);
}
public static List <ClassStatus> StatusList()
{
string querry = "Use[db_Clinic] SELECT[Status_id],[Status] FROM[dbo].[tbl_Status]";
SqlDataReader dr = ClassQuerry.ExecuteQuerry(querry);
List <ClassStatus> StatusList = new List <ClassStatus>();
while (dr.Read())
{
ClassStatus Status = new ClassStatus();
Status.StatusId = dr.GetInt32("Status_id");
Status.Status = dr.GetString("Status");
StatusList.Add(Status);
}
ClassQuerry.CloseConnection();
return(StatusList);
}
