public DesignationBO GetDesignation(int Id)
{
DBEgine dbEgine = new DBEgine();
DesignationBO des = new DesignationBO();
try
{
dbEgine.DBOpen();
SqlParameter[] parms = new SqlParameter[1];
SqlParameter p1 = new SqlParameter();
p1.ParameterName = "in_DesignationId";
p1.SqlDbType = SqlDbType.Int;
p1.Direction = ParameterDirection.Input;
p1.Value = Id;
parms[0] = p1;
SqlDataReader drDesig = dbEgine.ExecuteReader("UserManagement.UM_LoadDesignationById", parms);
if (drDesig != null && drDesig.HasRows)
{
while (drDesig.Read())
{
des= FillDesignation(drDesig);
}
// this.ScreenList = LoadUserPermissionByUserId();
}
return des;
}
catch
{
throw;
}
finally
{
dbEgine.DBClose();
}
}
private DesignationBO FillDesignation(SqlDataReader dr)
{
var designationBO = new DesignationBO();
designationBO.DesignationId = dr.GetInt32(dr.GetOrdinal("DesignationId"));
designationBO.DesignationName = dr.GetValue(dr.GetOrdinal("Designation")).ToString();
designationBO.Desciption = dr.GetValue(dr.GetOrdinal("Description")).ToString();
designationBO.IsActive = dr.GetBoolean(dr.GetOrdinal("IsActive"));
return designationBO;
}
public int SaveDesignation(out int Id, DesignationBO obj)
{
DBEgine dbEgine = new DBEgine();
try
{
dbEgine.DBOpen();
SqlParameter[] parms = new SqlParameter[4];
SqlParameter designationIdParm = new SqlParameter();
designationIdParm.ParameterName = "DesignationId";
designationIdParm.SqlDbType = SqlDbType.Int;
designationIdParm.Direction = ParameterDirection.InputOutput;
designationIdParm.Value = obj.DesignationId;
parms[0] = designationIdParm;
SqlParameter designationParm = new SqlParameter();
designationParm.ParameterName = "Designation";
designationParm.SqlDbType = SqlDbType.NVarChar;
designationParm.Direction = ParameterDirection.Input;
designationParm.Value = obj.DesignationName;
parms[1] = designationParm;
SqlParameter descriptionParm = new SqlParameter();
descriptionParm.ParameterName = "Description";
descriptionParm.SqlDbType = SqlDbType.NVarChar;
descriptionParm.Direction = ParameterDirection.Input;
descriptionParm.Value = obj.Desciption;
parms[2] = descriptionParm;
SqlParameter IsActiveParm = new SqlParameter();
IsActiveParm.ParameterName = "IsActive";
IsActiveParm.SqlDbType = SqlDbType.Bit;
IsActiveParm.Direction = ParameterDirection.Input;
IsActiveParm.Value = obj.IsActive;
parms[3] = IsActiveParm;
dbEgine.ExecNonQueryStoredProc("UM_AddDesignations", parms);
Id = Int32.Parse(designationIdParm.Value.ToString());
return Id;
}
catch
{
throw;
}
finally
{
dbEgine.DBClose();
}
}
