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