public BookStatus GetBookName(int id)
{
SqlDBdataAccess da = new SqlDBdataAccess();
SqlCommand cmd = da.GetCommand("select * from Lib_Book_Details where Lib_Book_Id = '" + id+ "'");
BookStatus ob = GetData(cmd);
return ob;
}
public bool InsertBook(BookStatus obj)
{
SqlDBdataAccess da = new SqlDBdataAccess();
SqlCommand cmd = da.GetCommand("insert into [dbo].[Lib_Book_Details] ([Book_Title],[Lib_Book_Author_Name],[Lib_Book_In_Inventory],[Category_Name])" + "values(@Title,@Author,@Quantity,@Category)");
SqlParameter p = new SqlParameter("@Title", SqlDbType.VarChar, 50);
p.Value = obj.BookTitle;
SqlParameter p1 = new SqlParameter("@Author", SqlDbType.VarChar, 50);
p1.Value = obj.AuthorName;
SqlParameter p2 = new SqlParameter("@Quantity", SqlDbType.Int);
p2.Value = obj.BookInventory;
SqlParameter p3 = new SqlParameter("@Category", SqlDbType.VarChar, 50);
p3.Value = obj.Catagory;
cmd.Parameters.Add(p);
cmd.Parameters.Add(p1);
cmd.Parameters.Add(p2);
cmd.Parameters.Add(p3);
cmd.Connection.Open();
int val = cmd.ExecuteNonQuery();
cmd.Connection.Close();
return(val > 0);
}
public BookStatus GetBookName(string name)
{
SqlDBdataAccess da = new SqlDBdataAccess();
SqlCommand cmd = da.GetCommand("select * from Lib_Book_Details where Book_title like '%" + name + "%'");
BookStatus ob = GetData(cmd);
return ob;
}
public UserInfo GetUserName(String name)
{
SqlDBdataAccess db = new SqlDBdataAccess();
SqlCommand cmd = db.GetCommand("select * from Lib_Users where User_Name like '%" + name + "%'");
UserInfo ob = GetData(cmd);
return ob;
}
public List<CatagoryInfo> GetCategoryName()
{
SqlDBdataAccess da = new SqlDBdataAccess();
SqlCommand cmd = da.GetCommand("select * from Lib_Book_Category");
List<CatagoryInfo> ob = GetData(cmd);
return ob;
}
public UserInfo GetUserName(String name)
{
SqlDBdataAccess db = new SqlDBdataAccess();
SqlCommand cmd = db.GetCommand("select * from Lib_Users where User_Name like '%" + name + "%'");
UserInfo ob = GetData(cmd);
return(ob);
}
public BookStatus GetBookName(int id)
{
SqlDBdataAccess da = new SqlDBdataAccess();
SqlCommand cmd = da.GetCommand("select * from Lib_Book_Details where Lib_Book_Id = '" + id + "'");
BookStatus ob = GetData(cmd);
return(ob);
}
public BookStatus GetBookName(string name)
{
SqlDBdataAccess da = new SqlDBdataAccess();
SqlCommand cmd = da.GetCommand("select * from Lib_Book_Details where Book_title like '%" + name + "%'");
BookStatus ob = GetData(cmd);
return(ob);
}
public List <CatagoryInfo> GetCategoryName()
{
SqlDBdataAccess da = new SqlDBdataAccess();
SqlCommand cmd = da.GetCommand("select * from Lib_Book_Category");
List <CatagoryInfo> ob = GetData(cmd);
return(ob);
}
public List <BookIssueInfo> GetIssueInfo(int id)
{
SqlDBdataAccess da = new SqlDBdataAccess();
SqlCommand cmd = da.GetCommand("select * from Lib_Book_Issued_Details where Lib_Book_Id = '" + id + "'");
List <BookIssueInfo> ob = GetData(cmd);
return(ob);
}
public CatagoryInfo GetCategoryName(String name)
{
SqlDBdataAccess db = new SqlDBdataAccess();
SqlCommand cmd = db.GetCommand("select * from Lib_Book_Category where Category_Name like '%" + name + "%'");
CatagoryInfo ob = GetData(cmd);
return(ob);
}
public bool DeleteIssue(int id)
{
SqlDBdataAccess da = new SqlDBdataAccess();
SqlCommand cmd = da.GetCommand("delete from [dbo].[Lib_Book_Issued_Details] where Lib_Book_Issued_Id=@id ");
SqlParameter p = new SqlParameter("@id", SqlDbType.Int);
p.Value = id;
cmd.Parameters.Add(p);
cmd.Connection.Open();
int val = cmd.ExecuteNonQuery();
cmd.Connection.Close();
return val > 0;
}
public bool InsertCategory(CatagoryInfo obj)
{
SqlDBdataAccess da = new SqlDBdataAccess();
SqlCommand cmd = da.GetCommand("insert into [dbo].[Lib_Book_Category] ([Category_Name])" + "values(@CategoryName)");
SqlParameter p = new SqlParameter("@CategoryName", SqlDbType.VarChar, 50);
p.Value = obj.CatagoryName;
cmd.Parameters.Add(p);
cmd.Connection.Open();
int val = cmd.ExecuteNonQuery();
cmd.Connection.Close();
return val > 0;
}
public bool DeleteIssue(int id)
{
SqlDBdataAccess da = new SqlDBdataAccess();
SqlCommand cmd = da.GetCommand("delete from [dbo].[Lib_Book_Issued_Details] where Lib_Book_Issued_Id=@id ");
SqlParameter p = new SqlParameter("@id", SqlDbType.Int);
p.Value = id;
cmd.Parameters.Add(p);
cmd.Connection.Open();
int val = cmd.ExecuteNonQuery();
cmd.Connection.Close();
return(val > 0);
}
public bool InsertCategory(CatagoryInfo obj)
{
SqlDBdataAccess da = new SqlDBdataAccess();
SqlCommand cmd = da.GetCommand("insert into [dbo].[Lib_Book_Category] ([Category_Name])" + "values(@CategoryName)");
SqlParameter p = new SqlParameter("@CategoryName", SqlDbType.VarChar, 50);
p.Value = obj.CatagoryName;
cmd.Parameters.Add(p);
cmd.Connection.Open();
int val = cmd.ExecuteNonQuery();
cmd.Connection.Close();
return(val > 0);
}
public bool ReturnBook(int id, int quantity)
{
SqlDBdataAccess da = new SqlDBdataAccess();
SqlCommand cmd = da.GetCommand("update [dbo].[Lib_Book_Details] set Lib_Book_In_Inventory=@quantity where Lib_Book_Id=@id");
SqlParameter p = new SqlParameter("@quantity", SqlDbType.Int);
p.Value = quantity; ;
SqlParameter p1 = new SqlParameter("@id", SqlDbType.Int);
p1.Value = id ;
cmd.Parameters.Add(p);
cmd.Parameters.Add(p1);
cmd.Connection.Open();
int val = cmd.ExecuteNonQuery();
cmd.Connection.Close();
return val > 0;
}
public bool ReturnBook1(string name, int quantity)
{
SqlDBdataAccess da = new SqlDBdataAccess();
SqlCommand cmd = da.GetCommand("update [dbo].[Lib_Book_Details] set Lib_Book_In_Inventory=@quantity where Book_Title=@name");
SqlParameter p = new SqlParameter("@quantity", SqlDbType.Int);
p.Value = quantity; ;
SqlParameter p1 = new SqlParameter("@name", SqlDbType.VarChar, 50);
p1.Value = name; ;
cmd.Parameters.Add(p);
cmd.Parameters.Add(p1);
cmd.Connection.Open();
int val = cmd.ExecuteNonQuery();
cmd.Connection.Close();
return val > 0;
}
public bool ChangePassword(string name, string password)
{
SqlDBdataAccess da = new SqlDBdataAccess();
SqlCommand cmd = da.GetCommand("update [dbo].[Lib_Users] set User_Password=@password where User_Name=@name");
SqlParameter p = new SqlParameter("@password", SqlDbType.VarChar,50);
p.Value = password;
SqlParameter p1 = new SqlParameter("@name", SqlDbType.VarChar, 50);
p1.Value = name; ;
cmd.Parameters.Add(p);
cmd.Parameters.Add(p1);
cmd.Connection.Open();
int val = cmd.ExecuteNonQuery();
cmd.Connection.Close();
return val > 0;
}
public bool ReturnBook(int id, int quantity)
{
SqlDBdataAccess da = new SqlDBdataAccess();
SqlCommand cmd = da.GetCommand("update [dbo].[Lib_Book_Details] set Lib_Book_In_Inventory=@quantity where Lib_Book_Id=@id");
SqlParameter p = new SqlParameter("@quantity", SqlDbType.Int);
p.Value = quantity;;
SqlParameter p1 = new SqlParameter("@id", SqlDbType.Int);
p1.Value = id;
cmd.Parameters.Add(p);
cmd.Parameters.Add(p1);
cmd.Connection.Open();
int val = cmd.ExecuteNonQuery();
cmd.Connection.Close();
return(val > 0);
}
public bool ChangePassword(string name, string password)
{
SqlDBdataAccess da = new SqlDBdataAccess();
SqlCommand cmd = da.GetCommand("update [dbo].[Lib_Users] set User_Password=@password where User_Name=@name");
SqlParameter p = new SqlParameter("@password", SqlDbType.VarChar, 50);
p.Value = password;
SqlParameter p1 = new SqlParameter("@name", SqlDbType.VarChar, 50);
p1.Value = name;;
cmd.Parameters.Add(p);
cmd.Parameters.Add(p1);
cmd.Connection.Open();
int val = cmd.ExecuteNonQuery();
cmd.Connection.Close();
return(val > 0);
}
public bool InsertIssue(BookIssueInfo obj)
{
SqlDBdataAccess da = new SqlDBdataAccess();
SqlCommand cmd = da.GetCommand("insert into [dbo].[Lib_Book_Issued_Details] ([Lib_Book_Id],[Lib_Book_Issued_To],[Lib-Book_Issued_On])" + "values(@id,@IssueDate,@Name)");
SqlParameter p = new SqlParameter("@id", SqlDbType.Int);
p.Value = obj.Id;
SqlParameter p1 = new SqlParameter("@IssueDate", SqlDbType.DateTime);
p1.Value = DateTime.Now;
SqlParameter p2 = new SqlParameter("@Name", SqlDbType.VarChar,50);
p2.Value = obj.Name;
cmd.Parameters.Add(p);
cmd.Parameters.Add(p1);
cmd.Parameters.Add(p2);
cmd.Connection.Open();
int val = cmd.ExecuteNonQuery();
cmd.Connection.Close();
return val > 0;
}
public bool Insert(UserInfo obj)
{
SqlDBdataAccess da = new SqlDBdataAccess();
SqlCommand cmd = da.GetCommand("insert into [dbo].[Lib_Users] ([User_Name],[User_Password],[Lib_Book_Issued_Id])" + "values(@Name,@Password,@Status)");
SqlParameter p = new SqlParameter("@Name", SqlDbType.VarChar,50);
p.Value = obj.UserName;
SqlParameter p1 = new SqlParameter("@Password", SqlDbType.VarChar, 50);
p1.Value = obj.UserPassword;
SqlParameter p2 = new SqlParameter("@Status", SqlDbType.Int);
p2.Value = obj.Status;
cmd.Parameters.Add(p);
cmd.Parameters.Add(p1);
cmd.Parameters.Add(p2);
cmd.Connection.Open();
int val = cmd.ExecuteNonQuery();
cmd.Connection.Close();
return val > 0;
}
public bool RemoveBook1(string name, int quantity)
{
SqlDBdataAccess da = new SqlDBdataAccess();
SqlCommand cmd = da.GetCommand("update [dbo].[Lib_Book_Details] set Lib_Book_In_Inventory=@quantity where Book_Title=@name");
SqlParameter p = new SqlParameter("@quantity", SqlDbType.Int);
p.Value = quantity;;
SqlParameter p1 = new SqlParameter("@name", SqlDbType.VarChar, 50);
p1.Value = name;;
cmd.Parameters.Add(p);
cmd.Parameters.Add(p1);
cmd.Connection.Open();
int val = cmd.ExecuteNonQuery();
cmd.Connection.Close();
return(val > 0);
}
public bool InsertBook(BookStatus obj)
{
SqlDBdataAccess da = new SqlDBdataAccess();
SqlCommand cmd = da.GetCommand("insert into [dbo].[Lib_Book_Details] ([Book_Title],[Lib_Book_Author_Name],[Lib_Book_In_Inventory],[Category_Name])" + "values(@Title,@Author,@Quantity,@Category)");
SqlParameter p = new SqlParameter("@Title", SqlDbType.VarChar, 50);
p.Value = obj.BookTitle;
SqlParameter p1 = new SqlParameter("@Author", SqlDbType.VarChar, 50);
p1.Value = obj.AuthorName;
SqlParameter p2 = new SqlParameter("@Quantity", SqlDbType.Int);
p2.Value = obj.BookInventory;
SqlParameter p3 = new SqlParameter("@Category", SqlDbType.VarChar, 50);
p3.Value = obj.Catagory;
cmd.Parameters.Add(p);
cmd.Parameters.Add(p1);
cmd.Parameters.Add(p2);
cmd.Parameters.Add(p3);
cmd.Connection.Open();
int val = cmd.ExecuteNonQuery();
cmd.Connection.Close();
return val > 0;
}
public bool InsertIssue(BookIssueInfo obj)
{
SqlDBdataAccess da = new SqlDBdataAccess();
SqlCommand cmd = da.GetCommand("insert into [dbo].[Lib_Book_Issued_Details] ([Lib_Book_Id],[Lib_Book_Issued_To],[Lib-Book_Issued_On])" + "values(@id,@IssueDate,@Name)");
SqlParameter p = new SqlParameter("@id", SqlDbType.Int);
p.Value = obj.Id;
SqlParameter p1 = new SqlParameter("@IssueDate", SqlDbType.DateTime);
p1.Value = DateTime.Now;
SqlParameter p2 = new SqlParameter("@Name", SqlDbType.VarChar, 50);
p2.Value = obj.Name;
cmd.Parameters.Add(p);
cmd.Parameters.Add(p1);
cmd.Parameters.Add(p2);
cmd.Connection.Open();
int val = cmd.ExecuteNonQuery();
cmd.Connection.Close();
return(val > 0);
}
public bool Insert(UserInfo obj)
{
SqlDBdataAccess da = new SqlDBdataAccess();
SqlCommand cmd = da.GetCommand("insert into [dbo].[Lib_Users] ([User_Name],[User_Password],[Lib_Book_Issued_Id])" + "values(@Name,@Password,@Status)");
SqlParameter p = new SqlParameter("@Name", SqlDbType.VarChar, 50);
p.Value = obj.UserName;
SqlParameter p1 = new SqlParameter("@Password", SqlDbType.VarChar, 50);
p1.Value = obj.UserPassword;
SqlParameter p2 = new SqlParameter("@Status", SqlDbType.Int);
p2.Value = obj.Status;
cmd.Parameters.Add(p);
cmd.Parameters.Add(p1);
cmd.Parameters.Add(p2);
cmd.Connection.Open();
int val = cmd.ExecuteNonQuery();
cmd.Connection.Close();
return(val > 0);
}