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