public static OfficialXComplaintsAssigned GetDetails(int id)
{
OfficialXComplaintsAssigned info = null;
info = BaseDataAccess.GetRecords <OfficialXComplaintsAssigned>(String.Format("select * from OfficialXComplaintsAssigned where Id='{0}'", id));
info.GovernmentOfficial = GovernmentOfficialDA.GetDetails(info.OfficialId);
info.Complaint = ComplaintDA.GetDetails(info.ComplaintId);
return(info);
}
/// <summary>
/// This Function is used to Delete previously added OfficialXComplaintsAssigned from database and is performed by SuperAdmin Only.
/// </summary>
public static bool Delete(OfficialXComplaintsAssigned info)
{
return(OfficialXComplaintsAssignedDA.Delete(info));
}
/// <summary>
/// This Function is used to add new OfficialXComplaintsAssigned to database and is performed by SuperAdmin Only.
/// </summary>
public static bool Add(OfficialXComplaintsAssigned info)
{
return(OfficialXComplaintsAssignedDA.Add(info));
}
public static bool Delete(OfficialXComplaintsAssigned info)
{
return(BaseDataAccess.ExecuteSQL(String.Format("delete from OfficialXComplaintsAssigned where Id='{0}'", info.Id)));
}
public static bool Update(OfficialXComplaintsAssigned info)
{
return(BaseDataAccess.ExecuteSQL(String.Format("update OfficialXComplaintsAssigned set OfficialId='{0}',ComplaintId='{1}',AssignedOn='{2}',IsEscalated='{3}' where Id='{4}'", info.OfficialId, info.ComplaintId, info.AssignedOn, info.IsEscalated, info.Id)));
}
public static bool Add(OfficialXComplaintsAssigned info)
{
return(BaseDataAccess.ExecuteSQL(String.Format("insert into OfficialXComplaintsAssigned (OfficialId, ComplaintId, AssignedOn, IsEscalated) values ('{0}','{1}','{2}','{3}')", info.OfficialId, info.ComplaintId, DateTime.Now, info.IsEscalated)));
}