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