//To Check Duplicate Document
#region Check Duplicate Designation]
public int CheckDuplicateDesignation_DL(EWA_DepartmentDesignation objEWA)
{
try
{
prmList = new string[6];
prmList[0] = "@Action";
prmList[1] = "CheckData";
prmList[2] = "@DesignationName";
prmList[3] = objEWA.DesignationName;
prmList[4] = "@DepartmentId";
prmList[5] = Convert.ToString(objEWA.DepartmentId);
DataSet dsData = ObjHelper.FillControl(prmList, "SP_Designation");
if (dsData.Tables[0].Rows.Count > 0)
{
return(1);
}
else
{
return(0);
}
}
catch (Exception exp)
{
throw exp;
}
}
//Check Duplicate for Designation
#region [Check Duplicate Designation]
public int CheckDuplicateDesignation_BL(EWA_DepartmentDesignation objEWA)
{
try
{
DL_DepartmentDesignation objDL = new DL_DepartmentDesignation();
int i = objDL.CheckDuplicateDesignation_DL(objEWA);
return(i);
}
catch (Exception)
{
throw;
}
}
//To Call DepartmentGridBind
#region [Department Grid Bind]
public DataSet DepartmentGridBind_BL(EWA_DepartmentDesignation objEWA)
{
try
{
DL_DepartmentDesignation objDL = new DL_DepartmentDesignation();
DataSet ds = objDL.BindDepartmentGrid_DL(objEWA);
return(ds);
}
catch (Exception)
{
throw;
}
}
//ActionPerformed For Designation
#region [ActionPerformed For Designation]
public int DesignationAction_BL(EWA_DepartmentDesignation objEWA)
{
// DL_Documents objDL = new DL_Documents();
try
{
DL_DepartmentDesignation objDL = new DL_DepartmentDesignation();
int flag = objDL.DesignationAction_DL(objEWA);
return(flag);
}
catch (Exception)
{
throw;
}
}
//select dat of Designation Type
#region BindDDLDesignationType
private void BindDDLDesignationType()
{
try
{
EWA_DepartmentDesignation objEWA = new EWA_DepartmentDesignation();
DataSet dsDesignation = objBL.BindDDLDesignationType_BL();
ddlDesignationType.DataSource = dsDesignation;
ddlDesignationType.DataTextField = "DesignationType";
ddlDesignationType.DataValueField = "DesignationTypeId";
ddlDesignationType.DataBind();
ddlDesignationType.Items.Insert(0, "Select");
}
catch (Exception exp)
{
GeneralErr(exp.Message.ToString());
}
}
//Check Existing Data
#region [Check Data]
private int CheckDataD()
{
int i = 0;
try
{
EWA_DepartmentDesignation objEWA = new EWA_DepartmentDesignation();
objEWA.DesignationName = txtDesignationName.Text.Trim();
objEWA.DepartmentId = Convert.ToInt32(ddlDepartment.SelectedValue);
i = objBL.CheckDuplicateDesignation_BL(objEWA);
return(i);
}
catch (Exception exp)
{
GeneralErr(exp.Message.ToString());
}
return(i);
}
//Check Existing Data
#region [Check Data]
private int CheckData()
{
int i = 0;
try
{
EWA_DepartmentDesignation objEWA = new EWA_DepartmentDesignation();
objEWA.DepartmentName = txtDepartmentName.Text.Trim();
objEWA.OrgId = orgId;
i = objBL.CheckDuplicateDepartment_BL(objEWA);
return(i);
}
catch (Exception exp)
{
GeneralErr(exp.Message.ToString());
}
return(i);
}
//Perform Action
#region [Perform Actions On Designation]
public int DesignationAction_DL(EWA_DepartmentDesignation objEWA)
{
try
{
cmd = new SqlCommand("SP_Designation", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Action", objEWA.Action);
cmd.Parameters.AddWithValue("@DepartmentId", objEWA.DepartmentId);
cmd.Parameters.AddWithValue("@DesignationId", objEWA.DesignationId);
cmd.Parameters.AddWithValue("@DesignationCode", objEWA.DesignationCode);
cmd.Parameters.AddWithValue("@DesignationName", objEWA.DesignationName);
cmd.Parameters.AddWithValue("@DesignationTypeId", objEWA.DesignationTypeId);
cmd.Parameters.AddWithValue("@OrgId", objEWA.OrgId);
cmd.Parameters.AddWithValue("@UserId", objEWA.UserId);
cmd.Parameters.AddWithValue("@IsActive", objEWA.IsActive);
con.Open();
int flag = cmd.ExecuteNonQuery();
con.Close();
cmd.Dispose();
return(flag);
}
catch (Exception ex)
{
int err = ((System.Data.SqlClient.SqlException)(ex)).Number;
if (err == 547 && objEWA.Action == "Delete")
{
throw new SystemException("Record is in use !!!");
}
else
{
throw ex;
}
}
finally
{
con.Close();
cmd.Dispose();
}
}
//To Bind DesignationGrid
#region [Bind Designation Grid]
public DataSet BindDesignationGrid_DL(EWA_DepartmentDesignation objEWA)
{
DataSet ds = new DataSet();
try
{
prmList = new string[6];
prmList[0] = "@Action";
prmList[1] = "SelectData";
prmList[2] = "@OrgId";
prmList[3] = Convert.ToString(objEWA.OrgId);
prmList[4] = "@DepartmentId";
prmList[5] = Convert.ToString(objEWA.DepartmentId);
ds = ObjHelper.FillControl(prmList, "SP_Designation");
if (ds.Tables[0].Rows.Count > 0)
{
return(ds);
}
else
{
DataTable dt = new DataTable();
//dt.Columns.Add("DepartmentId");
dt.Columns.Add("DesignationCode");
dt.Columns.Add("DesignationName");
//dt.Rows.Add();
dt.Rows.Add();
dt.Rows.Add();
//return dsCode;
}
return(ds);
}
catch (Exception exp)
{
throw exp;
}
}
