internal static ObservableCollection<CommonReportViewModel> GetClientReportData(string sql, AssignedBy criteria)
{
ObservableCollection<CommonReportViewModel> reportItems = new ObservableCollection<CommonReportViewModel>();
try
{
var result = DBHelper.GetSelectDataSet(sql);
if (result == null)
return null;
string byAttorneyColumn = string.Empty;
switch (criteria)
{
case AssignedBy.AssignedAttorney:
byAttorneyColumn = Constants.CLIENT_ASSIGNEDATTORNY_COLUMN;
break;
case AssignedBy.OriginatingAttorney:
byAttorneyColumn = Constants.CLIENT_ORIGINATINGATTORNY_COLUMN;
break;
case AssignedBy.Referral:
byAttorneyColumn = Constants.CLIENT_REFERRAL_COLUMN;
break;
}
for (int rowIndex = 0; rowIndex < result.Tables[0].Rows.Count; rowIndex++)
{
//CommonReportViewModel newTransaction = new CommonReportViewModel()
//{
// ClientName = result.Tables[0].Rows[rowIndex][Constants.CLIENT_NAME].ToString(),
// FileNo = result.Tables[0].Rows[rowIndex][Constants.FILE_ID].ToString(),
// ByAttorney = result.Tables[0].Rows[rowIndex][byAttorneyColumn].ToString(),
// AccidentDate = DateTime.Parse(result.Tables[0].Rows[rowIndex][Constants.ACCIDENT_DATE_COLUMN].ToString()).ToShortDateString(),
// CaseNo = result.Tables[0].Rows[rowIndex][Constants.CLIENT_COURT_CASE_NUMBER_COLUMN].ToString()
//};
CommonReportViewModel newTransaction = new CommonReportViewModel();
newTransaction.ClientName = result.Tables[0].Rows[rowIndex][Constants.CLIENT_NAME].ToString();
newTransaction.FileNo = result.Tables[0].Rows[rowIndex][Constants.FILE_ID].ToString();
newTransaction.ByAttorney = result.Tables[0].Rows[rowIndex][byAttorneyColumn].ToString();
string date = result.Tables[0].Rows[rowIndex][Constants.ACCIDENT_DATE_COLUMN].ToString();
if (false == string.IsNullOrEmpty(date))
{
newTransaction.AccidentDate = DateTime.Parse(date).ToShortDateString();
}
newTransaction.CaseNo = result.Tables[0].Rows[rowIndex][Constants.CLIENT_COURT_CASE_NUMBER_COLUMN].ToString();
reportItems.Add(newTransaction);
}
}
catch (Exception ex)
{
throw ex;
}
return reportItems;
}
public void AddAssignedBy(IEnumerable <MemberInfo> m)
{
lock (assignedByLock) AssignedBy.AddRange(m);
}
public void Add(MountedCourse type)
{
lock (type)
{
if (Count == MountedCoureId.Length)
{
var newLength = MountedCoureId.Length + 1000;
var _MountedCoureId = new string[newLength];
MountedCoureId.CopyTo(_MountedCoureId);
MountedCoureId = _MountedCoureId;
var _EnrollmentOption = new string[newLength];
EnrollmentOption.CopyTo(_EnrollmentOption);
EnrollmentOption = _EnrollmentOption;
var _Level = new string[newLength];
Level.CopyTo(_Level);
Level = _Level;
var _MaxLimit = new int[newLength];
MaxLimit.CopyTo(_MaxLimit);
MaxLimit = _MaxLimit;
var _MinLimit = new int[newLength];
MinLimit.CopyTo(_MinLimit);
MinLimit = _MinLimit;
var _Semester = new string[newLength];
Semester.CopyTo(_Semester);
Semester = _Semester;
var _AcademicYear = new string[newLength];
AcademicYear.CopyTo(_AcademicYear);
AcademicYear = _AcademicYear;
var _ProgramId = new string[newLength];
ProgramId.CopyTo(_ProgramId);
ProgramId = _ProgramId;
var _AssignedBy = new string[newLength];
AssignedBy.CopyTo(_AssignedBy);
AssignedBy = _AssignedBy;
var _Date = new System.DateTime[newLength];
Date.CopyTo(_Date);
Date = _Date;
var _CourseName = new string[newLength];
CourseName.CopyTo(_CourseName);
CourseName = _CourseName;
var _CourseCode = new string[newLength];
CourseCode.CopyTo(_CourseCode);
CourseCode = _CourseCode;
var _AssignedTo = new string[newLength];
AssignedTo.CopyTo(_AssignedTo);
AssignedTo = _AssignedTo;
var _Specialization = new string[newLength];
Specialization.CopyTo(_Specialization);
Specialization = _Specialization;
var _Category = new string[newLength];
Category.CopyTo(_Category);
Category = _Category;
var _Scoring = new bool[newLength];
Scoring.CopyTo(_Scoring);
Scoring = _Scoring;
var _Credit = new int[newLength];
Credit.CopyTo(_Credit);
Credit = _Credit;
}
MountedCoureId.Span[Count] = type.MountedCoureId;
EnrollmentOption.Span[Count] = type.EnrollmentOption;
Level.Span[Count] = type.Level;
MaxLimit.Span[Count] = type.MaxLimit;
MinLimit.Span[Count] = type.MinLimit;
Semester.Span[Count] = type.Semester;
AcademicYear.Span[Count] = type.AcademicYear;
ProgramId.Span[Count] = type.ProgramId;
AssignedBy.Span[Count] = type.AssignedBy;
Date.Span[Count] = type.Date;
CourseName.Span[Count] = type.CourseName;
CourseCode.Span[Count] = type.CourseCode;
AssignedTo.Span[Count] = type.AssignedTo;
Specialization.Span[Count] = type.Specialization;
Category.Span[Count] = type.Category;
Scoring.Span[Count] = type.Scoring;
Credit.Span[Count] = type.Credit;
Count++;
}
}
public void AddAssignedBy(MemberInfo m)
{
lock (assignedByLock) AssignedBy.Add(m);
}
public override string ToString()
{
return("PermissionId = " + PermissionId.ToString() + ",RoleId = " + RoleId.ToString() + ",PageId = " + PageId.ToString() + ",CanCreate = " + CanCreate.ToString() + ",CanDelete = " + CanDelete.ToString() + ",CanUpdate = " + CanUpdate.ToString() + ",CanSelect = " + CanSelect.ToString() + ",AssignedBy = " + AssignedBy.ToString() + ",CompanyId = " + CompanyId.ToString());
}
