public void Update()
{
da.Connect();
old_name = da.select("select coursename from courses where (id=" + this.id + ")").Rows[0][0].ToString();
da.disconnect();
string s = "Update Courses set coursename=N'{0}' where id={1}";
s = string.Format(s, this.coursename, this.id);
da.Connect();
da.docommand(s);
s = "Update classes set artcourse=N'{0}' where artcourse=N'{1}'";
s = string.Format(s, this.coursename, this.old_name);
da.docommand(s);
s = "Update teachers set artcourse=N'{0}' where artcourse=N'{1}'";
s = string.Format(s, this.coursename, this.old_name);
da.docommand(s);
s = "Update hozoor set artcourse=N'{0}' where artcourse=N'{1}'";
s = string.Format(s, this.coursename, this.old_name);
da.docommand(s);
s = "Update ghabz set artcourse=N'{0}' where artcourse=N'{1}'";
s = string.Format(s, this.coursename, this.old_name);
da.docommand(s);
da.disconnect();
}
public DataTable Select()
{
string s = "SELECT * from payments ORDER BY id DESC";
da.Connect();
DataTable dt = new DataTable();
dt = da.select(s);
da.disconnect();
return(dt);
}
public DataTable Select()
{
string s = "select stdno,reg_date,name,birthdate,father,idno,job,degree,course,tel,mob, hesab, status,address,resume from std";
da.Connect();
DataTable dt = new DataTable();
dt = da.select(s);
da.disconnect();
return(dt);
}
public DataTable Selectforview()
{
string s = "select * from Amoozeshgah";
da.Connect();
DataTable dt = new DataTable();
dt = da.select(s);
da.disconnect();
return(dt);
}
public DataTable Select()
{
string s = "select row_number() over (order by date desc) as id ,* from hozoor ORDER BY date DESC";
s = string.Format(s, stdno);
da.Connect();
DataTable dt = new DataTable();
dt = da.select(s);
da.disconnect();
return(dt);
}
//public void Update()
//{
// da.Connect();
// old_name = da.select("select coursename from sms where (smsid=" + this.smsid + ")").Rows[0][0].ToString();
// da.disconnect();
// string s = "Update sms set coursename=N'{0}' where smsid={1}";
// s = string.Format(s, this.coursename, this.smsid);
// da.Connect();
// da.docommand(s);
// s = "Update classes set artcourse=N'{0}' where artcourse=N'{1}'";
// s = string.Format(s, this.coursename, this.old_name);
// da.docommand(s);
// s = "Update teachers set artcourse=N'{0}' where artcourse=N'{1}'";
// s = string.Format(s, this.coursename, this.old_name);
// da.docommand(s);
// s = "Update hozoor set artcourse=N'{0}' where artcourse=N'{1}'";
// s = string.Format(s, this.coursename, this.old_name);
// da.docommand(s);
// s = "Update ghabz set artcourse=N'{0}' where artcourse=N'{1}'";
// s = string.Format(s, this.coursename, this.old_name);
// da.docommand(s);
// da.disconnect();
//}
public DataTable Select()
{
string s = "select * from sms";
da.Connect();
DataTable dt = new DataTable();
dt = da.select(s);
da.disconnect();
return(dt);
}
public DataTable Select()
{
string s = "select * from classes order by payan_date, artcourse";
da.Connect();
DataTable dt = new DataTable();
dt = da.select(s);
da.disconnect();
return(dt);
}
public DataTable Select()
{
string s = "select * from acc where (user_code=N'{0}' and pass=N'{1}')";
s = string.Format(s, this.user_code, this.pass);
da.Connect();
DataTable dt = new DataTable();
dt = da.select(s);
da.disconnect();
return(dt);
}
public void Update()
{
da.Connect();
old_name = da.select("select name from teachers where (teacherno=" + this.teacherno + ")").Rows[0][0].ToString();
da.disconnect();
string s;
if (flag)
{
s = "Update teachers set name=N'{0}',artcourse=N'{1}',tel=N'{2}', resume=N'{3}' ,prof_img=@img_photo_file where teacherno={4}";
s = string.Format(s, this.name, this.artcourse, this.tel, this.resume, this.teacherno);
da.cmd.Parameters.Add("@img_photo_file", SqlDbType.Image, photo.Length).Value = photo;
}
else
{
s = "Update teachers set name=N'{0}',artcourse=N'{1}',tel=N'{2}', resume=N'{3}' where teacherno={4}";
s = string.Format(s, this.name, this.artcourse, this.tel, this.resume, this.teacherno);
}
da.Connect();
da.docommand(s);
s = "Update classes set teacher=N'{0}' where teacher=N'{1}'";
s = string.Format(s, this.name, this.old_name);
da.docommand(s);
s = "Update payments set name=N'{0}' where name=N'{1}'";
s = string.Format(s, this.name, this.old_name);
da.docommand(s);
da.disconnect();
}
public DataTable restoreheader()
{
string s = "RESTORE HEADERONLY FROM DISK =N'{0}'";
s = string.Format(s, this.Backup_name);
da.Connect();
DataTable dt = new DataTable();
dt = da.select(s);
da.disconnect();
return(dt);
}
public long Selectmaxid()
{
string s = "select max(id) from hazineh_types";
da.Connect();
DataTable dt = new DataTable();
dt = da.select(s);
da.disconnect();
string count;
try
{
count = dt.Rows[0][0].ToString();
return(long.Parse(count) + 1);
}
catch (Exception)
{
return(1);
}
}
public long Selectmaxid()
{
string s = "select max(radif) from std_history where (stdno=N'" + this.stdno + "')";
da.Connect();
DataTable dt = new DataTable();
dt = da.select(s);
da.disconnect();
string count;
try
{
count = dt.Rows[0][0].ToString();
return(long.Parse(count) + 1);
}
catch (Exception)
{
return(1);
}
}
