public List <Composite_Dep> GetComposite_DepList()
{
string Sql = "select * from [Composite_Dep]";
List <Composite_Dep> listComposite_Dep = null;
//Lets get the list of all Composite_Dep in a datatable
using (DataTable table = SqlDBHelper.ExecuteSelectCommand(Sql))
{
//check if any record exist or not
if (table.Rows.Count > 0)
{
//Lets go ahead and create the list of Composite_Dep
listComposite_Dep = new List <Composite_Dep>();
//Now lets populate the Composite_Dep details into the list of Composite_Dep
foreach (DataRow row in table.Rows)
{
Composite_Dep b1 = new Composite_Dep();
b1.Comp_id = Convert.ToInt32(row["Comp_id"]);
b1.Dep_id = Convert.ToInt32(row["Dep_id"]);
b1.College_id = Convert.ToInt32(row["College_id"]);
listComposite_Dep.Add(b1);
}
}
}
return(listComposite_Dep);
}
////////////////////////////
public Composite_Dep GetComposite_DepDetails(int x1)
{
string Sql = "select * from [Composite_Dep] where [Comp_id] =" + x1 + " ";
Composite_Dep b1 = null;
//Lets get the list of all employees in a datatable
using (DataTable table = SqlDBHelper.ExecuteSelectCommand(Sql))
{
//check if any record exist or not
if (table.Rows.Count == 1)
{
DataRow row = table.Rows[0];
//Lets go ahead and create the list of Composite_Dep
b1 = new Composite_Dep();
//Now lets populate the employee details into the list of Composite_Dep
b1.Comp_id = Convert.ToInt32(row["Comp_id"]);
b1.Dep_id = Convert.ToInt32(row["Dep_id"]);
b1.College_id = Convert.ToInt32(row["College_id"]);
}
}
return(b1);
}
public bool AddNewComposite_Dep(Composite_Dep b1)
{
b1.Comp_id = GetNewTBLID();
string sql = "insert into [Composite_Dep] ([Comp_id],[Dep_id],[College_id]) values(" + b1.Comp_id + ", " + b1.Dep_id + ", " + b1.College_id + " )";
return(SqlDBHelper.ExecuteNonQuery(sql));
}
////////////////////////////
public bool DeleteComposite_Dep(Composite_Dep x1)
{
string Sql = "delete from [Composite_Dep] where [Comp_id] =" + x1.Comp_id + " ";
return(SqlDBHelper.ExecuteNonQuery(Sql));
}
////////////////////////////
public bool UpdateComposite_Dep(Composite_Dep b1)
{
string sql = "update [Composite_Dep] set [Dep_id]=" + b1.Dep_id + " ,[College_id]=" + b1.College_id + " where [Comp_id] =" + b1.Comp_id + " ";
return(SqlDBHelper.ExecuteNonQuery(sql));
}