public static DepartmentEscalationLevel GetDetailsByDepartmentId(int id, int LevelNumber)
{
DepartmentEscalationLevel info = null;
info = BaseDataAccess.GetRecords <DepartmentEscalationLevel>(String.Format("select * from DepartmentEscalationLevels where DepartmentId='{0}' and LevelNumber = '{1}'", id, LevelNumber));
if (info != null)
{
info.Department = DepartmentDA.GetDetails(info.DepartmentId);
info.GovernmentOfficial = GovernmentOfficialDA.GetDetails(info.DesignatedOfficialId);
}
return(info);
}
public static bool Delete(DepartmentEscalationLevel info)
{
return(BaseDataAccess.ExecuteSQL(String.Format("delete from DepartmentEscalationLevels where Id='{0}'", info.Id)));
}
public static bool Update(DepartmentEscalationLevel info)
{
return(BaseDataAccess.ExecuteSQL(String.Format("update DepartmentEscalationLevels set DepartmentId='{0}', EscalationLevelName='{1}', DesignatedOfficialId='{2}', LevelNumber='{3}' where Id='{4}'", info.DepartmentId, info.EscalationLevelName, info.DesignatedOfficialId, info.LevelNumber, info.Id)));
}
public static bool Add(DepartmentEscalationLevel info)
{
return(BaseDataAccess.ExecuteSQL(String.Format("insert into DepartmentEscalationLevels(DepartmentId,EscalationLevelName, DesignatedOfficialId, LevelNumber) values('{0}','{1}','{2}','{3}')", info.DepartmentId, info.EscalationLevelName, info.DesignatedOfficialId, info.LevelNumber)));
}
/// <summary>
/// This Function is used to Delete previously added DepartmentEscalationLevel from database and is performed by SuperAdmin Only.
/// </summary>
public static bool Delete(DepartmentEscalationLevel info)
{
return(DepartmentEscalationLevelDA.Delete(info));
}
/// <summary>
/// This Function is used to Update previously added DepartmentEscalationLevel in database and is performed by SuperAdmin Only.
/// </summary>
public static bool Update(DepartmentEscalationLevel info)
{
return(DepartmentEscalationLevelDA.Update(info));
}
/// <summary>
/// This Function is used to add new DepartmentEscalationLevel to database and is performed by SuperAdmin Only.
/// </summary>
public static bool Add(DepartmentEscalationLevel info)
{
return(DepartmentEscalationLevelDA.Add(info));
}
