public void Edit_STATE(int USER_ID)
{
SqlParameter[] pr = new SqlParameter[1];
pr[0] = new SqlParameter("USER_ID", USER_ID);
DAL.conopen();
DAL.Excute("SP_UPDATELOGIN", pr);
DAL.conclose();
}
//INSERT Data Treatments
public void Insert_PAT_INFO(string PAT_NAME, int PAT_AGE, string PAT_TYPE)
{
SqlParameter[] pr = new SqlParameter[3];
pr[0] = new SqlParameter("PAT_NAME", PAT_NAME);
pr[1] = new SqlParameter("PAT_AGE", PAT_AGE);
pr[2] = new SqlParameter("PAT_TYPE", PAT_TYPE);
DAL.conopen();
DAL.Excute("SP_INSERTPATINFO", pr);
DAL.conclose();
}
//INSERT Data Treatments
public void Insert_Treat(string Treat_Name)
{
SqlParameter[] pr = new SqlParameter[1];
pr[0] = new SqlParameter("TREAT_NAME", Treat_Name);
DAL.conopen();
DAL.Excute("SP_INSERTTREAT", pr);
DAL.conclose();
}