public void Find_DID(Department_Details d_id)
{
SqlConnection connection = new SqlConnection(cls.setConnectionString());
connection.Open();
SqlCommand command = new SqlCommand("SELECT Dep_Id FROM Dep_Details WHERE Dep_Id=@did", connection);
command.CommandType = CommandType.Text;
try
{
command.Parameters.AddWithValue("@did", d_id.DEPID);
SqlDataReader reader = command.ExecuteReader();
if (reader.HasRows)
{
MessageBox.Show("Department ID already exists", "Exists", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
// return
}
catch (Exception)
{
throw;
}
finally
{
command.Dispose();
connection.Close();
}
}
public int Update(Department_Details Dpm)
{
SqlConnection connection = new SqlConnection(cls.setConnectionString());
connection.Open();
String selectStr = "UPDATE Dep_Details SET Dep_Name = @Dep_Name,Dep_Head=@Dep_Head,Dep_Description=@Dep_Description WHERE (Dep_Id = @Dep_Id)";
SqlCommand command = new SqlCommand(selectStr, connection);
command.CommandType = CommandType.Text;
try
{
command.Parameters.AddWithValue("@Dep_Id", Dpm.DEPID);
command.Parameters.AddWithValue("@Dep_Name", Dpm.DepName);
command.Parameters.AddWithValue("@Dep_Head", Dpm.DepHead);
command.Parameters.AddWithValue("@Dep_Description", Dpm.DSC);
return(command.ExecuteNonQuery());
}
catch (Exception)
{
throw;
}
finally
{
command.Dispose();
connection.Close();
}
}
public int Delete_Dep(Department_Details Dpm)
{
SqlConnection connection = new SqlConnection(cls.setConnectionString());
connection.Open();
String selectStr = "DELETE FROM Dep_Details WHERE (Dep_Id = @Dep_Id)";
SqlCommand command = new SqlCommand(selectStr, connection);
command.CommandType = CommandType.Text;
try
{
command.Parameters.AddWithValue("@Dep_Id", Dpm.DEPID);
return(command.ExecuteNonQuery());
}
catch (Exception)
{
throw;
}
finally
{
command.Dispose();
connection.Close();
}
}
public int Insert(Department_Details Dpm)
{
SqlConnection connection = new SqlConnection(cls.setConnectionString());
connection.Open();
SqlCommand command = new SqlCommand("INSERT INTO Dep_Details VALUES(@Dep_Id,@Dep_Name,@Dep_Head,@Dep_Description,'A')", connection);
command.CommandType = CommandType.Text;
try
{
command.Parameters.AddWithValue("@Dep_Id", Dpm.DEPID);
command.Parameters.AddWithValue("@Dep_Name", Dpm.DepName);
command.Parameters.AddWithValue("@Dep_Head", Dpm.DepHead);
command.Parameters.AddWithValue("@Dep_Description", Dpm.DSC);
return(command.ExecuteNonQuery());
}
catch (Exception)
{
throw;
}
finally
{
command.Dispose();
connection.Close();
}
}
public DataTable Bind_Grid_with(Department_Details p_id)
{
DepartmentDAL DDAL = new DepartmentDAL();
try
{
return(DDAL.GetDataWith(p_id));
}
catch (Exception)
{
throw;
}
finally
{
DDAL = null;
}
}
public int Insert(Department_Details Dpm)
{
DepartmentDAL PDAL = new DepartmentDAL();
try
{
return(PDAL.Insert(Dpm));
}
catch (Exception)
{
throw;
}
finally
{
PDAL = null;
}
}
public void Find_DID(Department_Details p_id)
{
DepartmentDAL DDAL = new DepartmentDAL();
try
{
DDAL.Find_DID(p_id);
}
catch (Exception)
{
throw;
}
finally
{
DDAL = null;
}
}
public DataTable GetDataWith(Department_Details dep)
{
string query = "SELECT * FROM Dep_Details WHERE Dep_Name LIKE '%" + dep.DepName + "%'";
SqlCommand cmd = new SqlCommand(query);
using (SqlConnection con = new SqlConnection(cls.setConnectionString()))
{
using (SqlDataAdapter sda = new SqlDataAdapter())
{
cmd.Connection = con;
sda.SelectCommand = cmd;
using (DataTable ds = new DataTable())
{
sda.Fill(ds);
return(ds);
}
}
}
}
