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