public static GovernmentOfficial GetDetailsByContactNumber(string ContactNumber)
{
GovernmentOfficial info = null;
info = BaseDataAccess.GetRecords <GovernmentOfficial>(string.Format("select * from GovernmentOfficials where ContactNumber='{0}'", ContactNumber));
return(info);
}
public static GovernmentOfficial GetDetails(string officialCode)
{
GovernmentOfficial info = null;
info = BaseDataAccess.GetRecords <GovernmentOfficial>(string.Format("select * from GovernmentOfficials where OfficialCode='{0}'", officialCode));
if (info != null)
{
info.DepartmentDesignation = DepartmentDesignationDA.GetDetails(info.DesignationId);
}
return(info);
}
/// <summary>
/// THis function is to be edited. Once the Logic is done.
/// </summary>
/// <param name="username"></param>
/// <returns></returns>
public static List <Department> GetAllByUseraname(string username)
{
List <Department> listDepartment = new List <Department>();
GovernmentOfficial info = null;
info = GovernmentOfficialDA.GetDetailsByContactNumber(username);
List <DepartmentXOfficial> listoff = new List <DepartmentXOfficial>();
if (info != null)
{
listoff = DepartmentXOfficialsDA.GetAllForOfficial(info.Id);
}
foreach (DepartmentXOfficial i in listoff)
{
Department dept = null;
dept = GetDetails(i.DepartmentId);
listDepartment.Add(dept);
}
return(listDepartment);
}
/// <summary>
/// This Function is used to Delete previously added GovernmentOfficials from database and is performed by SuperAdmin Only.
/// </summary>
public static bool Delete(GovernmentOfficial info)
{
return(GovernmentOfficialDA.Delete(info));
}
/// <summary>
/// This Function is used to Update previously added GovernmentOfficials in database and is performed by SuperAdmin Only.
/// </summary>
public static bool Update(GovernmentOfficial info)
{
return(GovernmentOfficialDA.Update(info));
}
/// <summary>
/// This Function is used to add new GovernmentOfficials to database and is performed by SuperAdmin Only.
/// </summary>
public static bool Add(GovernmentOfficial info)
{
return(GovernmentOfficialDA.Add(info));
}
public static bool Delete(GovernmentOfficial info)
{
return(BaseDataAccess.ExecuteSQL(String.Format("delete from GovernmentOfficials where Id='{0}'", info.Id)));
}
public static bool Update(GovernmentOfficial info)
{
return(BaseDataAccess.ExecuteSQL(String.Format("update GovernmentOfficials set Name='{0}', ContactNumber='{1}', ContactEmail='{2}', Picture='{3}', DesignationId='{4}', OfficialCode='{5}' where Id='{6}'", info.Name, info.ContactNumber, info.ContactEmail, info.Picture, info.DesignationId, info.OfficialCode, info.Id)));
}
public static bool Add(GovernmentOfficial info)
{
return(BaseDataAccess.ExecuteSQL(String.Format("insert into GovernmentOfficials(Name, ContactNumber, ContactEmail, Picture, DesignationId, OfficialCode) values('{0}', '{1}', '{2}', '{3}', '{4}', '{5}') ", info.Name, info.ContactNumber, info.ContactEmail, info.Picture, info.DesignationId, info.OfficialCode)));
}
