public void Add(DesignationHierarchy designationHeirarchy)
{
try
{
string clientName = DataBase.DBService.ExecuteCommandScalar(string.Format(GET_CLIENT_NAME_QUERY, 0));
int? id = (designationHeirarchy.ReportingToDesignationId == null) ? null : designationHeirarchy.ReportingToDesignationId;
if ((designationHeirarchy.ReportingToDesignationId == null))
{
DataBase.DBService.ExecuteCommand("INSERT INTO[dbo].[DesignationHierarchy] " +
"([Designation],[ReportingToDesignationId],[Description]) VALUES ('" + designationHeirarchy.Designation + "'," + "Null" + ",'" + designationHeirarchy.Description + "')");
}
else
{
DataBase.DBService.ExecuteCommand(string.Format(INSERT_QUERY,
designationHeirarchy.Designation, id, designationHeirarchy.Description));
}
}
catch (Exception ex)
{
StackTrace st = new StackTrace();
StackFrame sf = st.GetFrame(0);
MethodBase currentMethodName = sf.GetMethod();
LogDebug(currentMethodName.Name, ex);
throw ex;
}
}
public Result Update(DesignationHierarchy designationHeirarchy)
{
var result = new Result();
try
{
DesignationHeirarchyService designationHeirarchyService = new DesignationHeirarchyService();
designationHeirarchyService.Update(designationHeirarchy);
result.IsSuccess = true;
}
catch (Exception exception)
{
result.IsSuccess = false;
result.ExceptionInfo = exception;
}
return(result);
}
private DesignationHierarchy convertToDesignationHeirarchy(DataRow dr)
{
DesignationHierarchy designationHeirarchy = new DesignationHierarchy();
designationHeirarchy.Id = dr.Field <int>("ID");
designationHeirarchy.Designation = dr.Field <string>("Designation");
if (dr["ReportingToDesignationId"] != DBNull.Value)
{
designationHeirarchy.ReportingToDesignationId = dr.Field <int>("ReportingToDesignationId");
}
else
{
designationHeirarchy.ReportingToDesignationId = null;
}
designationHeirarchy.ReportTo = dr.Field <string>("ReportingTo");
designationHeirarchy.Description = dr.Field <string>("Description");
return(designationHeirarchy);
}
public void Update(DesignationHierarchy designationHeirarchy)
{
try
{
string clientName = DataBase.DBService.ExecuteCommandScalar(string.Format(GET_CLIENT_NAME_QUERY, 0));
DataBase.DBService.ExecuteCommand(string.Format(UPDATE_QUERY,
designationHeirarchy.Designation, designationHeirarchy.ReportingToDesignationId,
designationHeirarchy.Description, designationHeirarchy.Id));
}
catch (Exception ex)
{
StackTrace st = new StackTrace();
StackFrame sf = st.GetFrame(0);
MethodBase currentMethodName = sf.GetMethod();
LogDebug(currentMethodName.Name, ex);
throw ex;
}
}
public IList <DesignationHierarchy> GetAll()
{
try
{
Logger.LogInfo("Get: DesignationHierarchy steps process start");
IList <DesignationHierarchy> processSteps = new List <DesignationHierarchy>();
DataTable dtAppConfig = DataBase.DBService.ExecuteCommand(SELECT_All);
foreach (DataRow dr in dtAppConfig.Rows)
{
DesignationHierarchy processStep = convertToDesignationHeirarchy(dr);
processSteps.Add(processStep);
}
Logger.LogInfo("Get: DesignationHierarchy steps process completed.");
return(processSteps);
}
catch (Exception ex)
{
return(null);
}
}
