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