public bool Post_user() { string comand = "insert into [tbl_post] (title,subject,subject2,user_id,roman_id,roman_zhaner,url) values(@title,@subject,@subject2,@user_id,@roman_id,@roman_zhaner,@url)"; List <SqlParameter> parametrlist = new List <SqlParameter>(); var title_parametr = new SqlParameter("@title", this.Title); var sub1_parametr = new SqlParameter("@subject", this.Subject1); var sub2_parametr = new SqlParameter("@subject2", this.Subject2); var uid_parametr = new SqlParameter("@user_id", this.Uid); var rid_parametr = new SqlParameter("@roman_id", this.Rid); var zh_parametr = new SqlParameter("@roman_zhaner", this.Zhaner); var url_parametr = new SqlParameter("@url", this.Url); parametrlist.Add(title_parametr); parametrlist.Add(sub1_parametr); parametrlist.Add(sub2_parametr); parametrlist.Add(uid_parametr); parametrlist.Add(rid_parametr); parametrlist.Add(zh_parametr); parametrlist.Add(url_parametr); var db = new dal(); var result = db.Executecomand(comand, parametrlist); return(result); }
public bool Delete_users() { string comand = "delete from Users where Id=@Id"; List <SqlParameter> parametrlist = new List <SqlParameter>(); var id_parametr = new SqlParameter("@Id", this.Id); parametrlist.Add(id_parametr); var db = new dal(); var result = db.Executecomand(comand, parametrlist); return(result); }
public bool Update_Aenre() { string comand = "update [Aenre] set Name=@Name where Id=@Id"; List <SqlParameter> parametrlist = new List <SqlParameter>(); var id_parametr = new SqlParameter("@Id", this.Id); var name_parametr = new SqlParameter("@Name", this.Name); parametrlist.Add(id_parametr); parametrlist.Add(name_parametr); var db = new dal(); var result = db.Executecomand(comand, parametrlist); return(result); }
public bool Insert_Aenre() { string comand = "insert into [Aenre](Name)values(@Name)"; List <SqlParameter> parametrlist = new List <SqlParameter>(); var name_parametr = new SqlParameter("@Name", this.Name); parametrlist.Add(name_parametr); var db = new dal(); var result = db.Executecomand(comand, parametrlist); return(result); }
public bool ok_ersal() { string comand = "update tbl_users set user_rank=@user_rank where uid=@uid"; List <SqlParameter> parametrlist = new List <SqlParameter>(); var rank_parametr = new SqlParameter("@user_rank", this.Rank); var uid_parametr = new SqlParameter("@uid", this.Uid); parametrlist.Add(rank_parametr); parametrlist.Add(uid_parametr); var db = new dal(); var result = db.Executecomand(comand, parametrlist); return(result); }
public bool Insert_roman() { string comand = "insert into [tbl_noveljenre] (title,zhaner)values(@title,@zhaner)"; List <SqlParameter> parametrlist = new List <SqlParameter>(); var title_parametr = new SqlParameter("@title", this.Title); var zh_parametr = new SqlParameter("@zhaner", this.Zhaner); parametrlist.Add(title_parametr); parametrlist.Add(zh_parametr); var db = new dal(); var result = db.Executecomand(comand, parametrlist); return(result); }
public bool Insert_comand() { string comand = "insert into [tbl_comment] (user_id,post_id,comment)values(@user_id,@post_id,@comment)"; List <SqlParameter> parametrlist = new List <SqlParameter>(); var uid_parametr = new SqlParameter("@user_id", this.Uid); var pid_parametr = new SqlParameter("@post_id", this.Pid); var comand_parametr = new SqlParameter("@comment", this.Comand); parametrlist.Add(uid_parametr); parametrlist.Add(pid_parametr); parametrlist.Add(comand_parametr); var db = new dal(); var result = db.Executecomand(comand, parametrlist); return(result); }
public bool Insert_book() { string comand = "insert into [Book](Name,Author,Aenre_id)values(@Name,@Author,@Aenre_id)"; List <SqlParameter> parametrlist = new List <SqlParameter>(); var name_parametr = new SqlParameter("@Name", this.Name); var author_parametr = new SqlParameter("@Author", this.Author); var au_id_parametr = new SqlParameter("@Aenre_id", this.AuthorId); parametrlist.Add(name_parametr); parametrlist.Add(author_parametr); parametrlist.Add(au_id_parametr); var db = new dal(); var result = db.Executecomand(comand, parametrlist); return(result); }
public bool Insert_users() { string comand = "insert into [Users](Name,Uname,Password,Rol_id)values(@Name,@Uname,@Password,@Rol_id)"; List <SqlParameter> parametrlist = new List <SqlParameter>(); var name_parametr = new SqlParameter("@Name", this.Name); var Uname_parametr = new SqlParameter("@Uname", this.Uname); var Password_parametr = new SqlParameter("@Password", this.Password); var Rol_parametr = new SqlParameter("@Rol_id", this.Rol_id); parametrlist.Add(name_parametr); parametrlist.Add(Uname_parametr); parametrlist.Add(Password_parametr); parametrlist.Add(Rol_parametr); var db = new dal(); var result = db.Executecomand(comand, parametrlist); return(result); }
public bool update_reques() { string comand = "update Request_book set Uid=@Uid,Bid=@Bid,Sid=@Sid where Id=@Id"; List <SqlParameter> parametrlist = new List <SqlParameter>(); var id_parametr = new SqlParameter("@id", this.Id); var uid_parametr = new SqlParameter("@Uid", this.Userid); var bid_parametr = new SqlParameter("@Bid", this.Bookid); var sid_parametr = new SqlParameter("@Sid", this.Statusid); parametrlist.Add(uid_parametr); parametrlist.Add(bid_parametr); parametrlist.Add(sid_parametr); var db = new dal(); var result = db.Executecomand(comand, parametrlist); return(result); }
public bool Insert_reques() { string comand = "insert into [Request_book](Uid,Bid,Sid)values(@Uid,@Bid,@Sid)"; List <SqlParameter> parametrlist = new List <SqlParameter>(); var uid_parametr = new SqlParameter("@Uid", this.Userid); var bid_parametr = new SqlParameter("@Bid", this.Bookid); var sid_parametr = new SqlParameter("@Sid", this.Statusid); parametrlist.Add(uid_parametr); parametrlist.Add(bid_parametr); parametrlist.Add(sid_parametr); var db = new dal(); var result = db.Executecomand(comand, parametrlist); return(result); }
public bool Update_book() { string comand = "update [Book] set Name=@Name,Author=@Author,Aenre_id=@Aenre_id where Id=@Id"; List <SqlParameter> parametrlist = new List <SqlParameter>(); var id_parametr = new SqlParameter("@Id", this.Id); var name_parametr = new SqlParameter("@Name", this.Name); var author_parametr = new SqlParameter("@Author", this.Author); var au_id_parametr = new SqlParameter("@Aenre_id", this.AuthorId); parametrlist.Add(id_parametr); parametrlist.Add(name_parametr); parametrlist.Add(author_parametr); parametrlist.Add(au_id_parametr); var db = new dal(); var result = db.Executecomand(comand, parametrlist); return(result); }
public bool Regester_user() { string comand = "insert into [tbl_users] (name,user_name,password,user_rank)values(@name,@user_name,@password,'False')"; List <SqlParameter> parametrlist = new List <SqlParameter>(); var name_parametr = new SqlParameter("@name", this.Name); var user_parametr = new SqlParameter("@user_name", this.Uname); var pass_parametr = new SqlParameter("@password", this.Password); parametrlist.Add(name_parametr); parametrlist.Add(user_parametr); parametrlist.Add(pass_parametr); var db = new dal(); var result = db.Executecomand(comand, parametrlist); return(result); }
public bool Update_users() { string comand = "update [Users] set Name=@Name,Uname=@Uname,Password=@Password,Rol_id=@Rol_id where Id=@Id"; List <SqlParameter> parametrlist = new List <SqlParameter>(); var id_parametr = new SqlParameter("@Id", this.Id); var name_parametr = new SqlParameter("@Name", this.Name); var Uname_parametr = new SqlParameter("@Uname", this.Uname); var Password_parametr = new SqlParameter("@Password", this.Password); var Rol_parametr = new SqlParameter("@Rol_id", this.Rol_id); parametrlist.Add(id_parametr); parametrlist.Add(name_parametr); parametrlist.Add(Uname_parametr); parametrlist.Add(Password_parametr); parametrlist.Add(Rol_parametr); var db = new dal(); var result = db.Executecomand(comand, parametrlist); return(result); }