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))); }