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