public string CSVStringConstructor(Tuple <bool, string>[] show, bool[] mask, List <Management> data) { List <string> headers = new List <string>(); int t = 0; for (int j = 0; j < show.Length; j++) { if (mask[j]) { headers.Add(SD.management[j]); } } List <List <string> > datas = new List <List <string> >(); foreach (var item in data) { List <string> row = new List <string>(); if (show[0].Item1) { row.Add(item.Name); } datas.Add(row); } string csv = SD.csvString(headers, datas); return(csv); }
public string CSVStringConstructor(Tuple <bool, string>[] show, bool[] mask, List <PhoneLineEmployee> data) { List <string> headers = new List <string>(); int t = 0; for (int j = 0; j < mask.Length; j++) { if (mask[j]) { headers.Add(SD.phoneLineEmployee[j]); } } List <List <string> > datas = new List <List <string> >(); foreach (var item in data) { List <string> row = new List <string>(); if (show[0].Item1) { row.Add(item.PhoneNumber); } if (show[1].Item1) { row.Add(item.Employee.Name); } datas.Add(row); } string csv = SD.csvString(headers, datas); return(csv); }
public string CSVStringConstructor(Tuple <bool, string>[] show, bool[] mask, List <MobilePhone> data) { List <string> headers = new List <string>(); int t = 0; for (int j = 0; j < mask.Length; j++) { if (mask[j]) { headers.Add(SD.mobilePhone[j]); } } List <List <string> > datas = new List <List <string> >(); foreach (var item in data) { List <string> row = new List <string>(); if (show[0].Item1) { row.Add(item.IMEI); } if (show[1].Item1) { row.Add(item.Model); } datas.Add(row); } string csv = SD.csvString(headers, datas); return(csv); }
public string CSVStringConstructor(Tuple <bool, string>[] show, List <ManagementsMobilePhoneExpense> data) { List <string> headers = new List <string>(); int t = 0; for (int j = 0; j < show.Length; j++) { if (show[j].Item1) { headers.Add(SD.managementMobilePhoneExpenses[j]); } } List <List <string> > datas = new List <List <string> >(); foreach (var item in data) { List <string> row = new List <string>(); if (show[0].Item1) { row.Add(item.Management); } if (show[1].Item1) { row.Add(item.Calls.ToString()); } if (show[3].Item1) { row.Add(item.SMS.ToString()); } if (show[5].Item1) { row.Add(item.GPRS.ToString()); } if (show[7].Item1) { row.Add(item.Total.ToString()); } if (show[9].Item1) { row.Add(item.Percent.ToString()); } if (show[11].Item1) { row.Add(SD.Months[item.Month]); } if (show[12].Item1) { row.Add(item.Year.ToString()); } datas.Add(row); } string csv = SD.csvString(headers, datas); return(csv); }
public string CSVStringConstructor(Tuple <bool, string>[] show, bool[] mask, List <SMS> data) { List <string> headers = new List <string>(); int t = 0; for (int j = 0; j < mask.Length; j++) { if (mask[j]) { headers.Add(SD.sms[j]); } } List <List <string> > datas = new List <List <string> >(); foreach (var item in data) { List <string> row = new List <string>(); if (show[0].Item1) { row.Add(item.PhoneNumber); } if (show[1].Item1) { row.Add(item.DateTime.ToString()); } if (show[4].Item1) { row.Add(item.E_R); } if (show[5].Item1) { row.Add(item.Location); } if (show[6].Item1) { row.Add(item.Destination); } if (show[7].Item1) { row.Add(item.Total.ToString()); } if (show[9].Item1) { row.Add(item.Roaming.ToString()); } datas.Add(row); } string csv = SD.csvString(headers, datas); return(csv); }
public string CSVStringConstructor(Tuple <bool, string>[] show, bool[] mask, List <MobilePhoneCall> data) { List <string> headers = new List <string>(); int t = 0; for (int j = 0; j < show.Length; j++) { if (mask[j]) { headers.Add(SD.mobilePhoneCalls[j]); } } List <List <string> > datas = new List <List <string> >(); foreach (var item in data) { List <string> row = new List <string>(); if (show[0].Item1) { row.Add(item.PhoneNumber); } if (show[1].Item1) { row.Add(item.DateTime.ToString()); } if (show[4].Item1) { row.Add(item.Addressee); } if (show[5].Item1) { row.Add(item.TotalCost.ToString()); } if (show[7].Item1) { row.Add(item.RoamingCall.ToString()); } datas.Add(row); } string csv = SD.csvString(headers, datas); return(csv); }
public string CSVStringConstructor(Tuple <bool, string>[] show, bool[] mask, List <CallingPlanAssignment> data) { List <string> headers = new List <string>(); int t = 0; for (int j = 0; j < mask.Length; j++) { if (mask[j]) { headers.Add(SD.callingPlanAssignment[j]); } } List <List <string> > datas = new List <List <string> >(); foreach (var item in data) { List <string> row = new List <string>(); if (show[0].Item1) { row.Add(item.PhoneNumber); } if (show[1].Item1) { row.Add(SD.Months[item.Month]); } if (show[2].Item1) { row.Add(item.Year.ToString()); } if (show[3].Item1) { row.Add(item.CallingPlanId); } datas.Add(row); } string csv = SD.csvString(headers, datas); return(csv); }
public string CSVStringConstructor(Tuple <bool, string>[] show, bool[] mask, List <Employee> data) { List <string> headers = new List <string>(); int t = 0; for (int j = 0; j < show.Length; j++) { if (mask[j]) { headers.Add(SD.employee[j]); } } List <List <string> > datas = new List <List <string> >(); foreach (var item in data) { List <string> row = new List <string>(); if (show[0].Item1) { row.Add(item.Name); } if (show[3].Item1) { row.Add(item.Email); } if (show[1].Item1) { row.Add(item.CostCenter.ToString()); } if (show[4].Item1) { row.Add(item.Extension); } datas.Add(row); } string csv = SD.csvString(headers, datas); return(csv); }
public string CSVStringConstructor(Tuple <bool, string>[] show, bool[] mask, List <CallingPlan> data) { List <string> headers = new List <string>(); int t = 0; for (int j = 0; j < show.Length; j++) { if (mask[j]) { headers.Add(SD.callingPlan[j]); } } List <List <string> > datas = new List <List <string> >(); foreach (var item in data) { List <string> row = new List <string>(); if (show[0].Item1) { row.Add(item.CallingPlanId); } if (show[1].Item1) { row.Add(item.Minutes.ToString()); } if (show[2].Item1) { row.Add(item.Cost.ToString()); } datas.Add(row); } string csv = SD.csvString(headers, datas); return(csv); }
public string CSVStringConstructor(Tuple <bool, string>[] show, bool[] mask, List <UserExceededDataPlan> data) { List <string> headers = new List <string>(); int t = 0; for (int j = 0; j < mask.Length; j++) { if (mask[j]) { headers.Add(SD.userExceededDataPlan[j]); } } List <List <string> > datas = new List <List <string> >(); foreach (var item in data) { List <string> row = new List <string>(); if (show[0].Item1) { row.Add(item.PhoneNumber); } if (show[1].Item1) { row.Add(item.EmployeeName); } if (show[2].Item1) { row.Add(item.DataPlanId); } if (show[3].Item1) { row.Add(item.CC); } if (show[4].Item1) { row.Add(item.CostCenter); } if (show[5].Item1) { row.Add(SD.Months[item.Month]); } if (show[6].Item1) { row.Add(item.Year.ToString()); } if (show[7].Item1) { row.Add(item.DataExceeded.ToString()); } if (show[9].Item1) { row.Add(item.PerCent.ToString()); } datas.Add(row); } string csv = SD.csvString(headers, datas); return(csv); }
public string CSVStringConstructor(Tuple <bool, string>[] show, bool[] mask, List <InternationalMobilePhoneCall> data) { List <string> headers = new List <string>(); int t = 0; for (int j = 0; j < show.Length; j++) { if (mask[j]) { headers.Add(SD.internationalCalls[j]); } } List <List <string> > datas = new List <List <string> >(); foreach (var item in data) { List <string> row = new List <string>(); if (show[0].Item1) { row.Add(item.PhoneNumber); } if (show[1].Item1) { row.Add(item.EmployeeName); } if (show[3].Item1) { row.Add(item.CostCenterCode); } if (show[2].Item1) { row.Add(item.CostCenterName); } if (show[4].Item1) { row.Add(item.Addresse); } if (show[5].Item1) { row.Add(SD.Months[item.Month]); } if (show[6].Item1) { row.Add(item.Year.ToString()); } if (show[7].Item1) { row.Add(item.Expense.ToString()); } if (show[9].Item1) { row.Add(item.PerCent.ToString()); } datas.Add(row); } string csv = SD.csvString(headers, datas); return(csv); }
public string CSVStringConstructorGeneral(Tuple <bool, string>[] show, bool[] mask, List <CostCenterMobilePhoneGeneralExpenses> data) { List <string> headers = new List <string>(); int t = 0; for (int j = 0; j < show.Length; j++) { if (mask[j]) { headers.Add(SD.costCenterMPGeneralExpenses[j]); } } List <List <string> > datas = new List <List <string> >(); foreach (var item in data) { List <string> row = new List <string>(); if (show[0].Item1) { row.Add(item.EmployeeName); } if (show[1].Item1) { row.Add(item.PhoneNumber); } if (show[2].Item1) { row.Add(item.CostCenterCode); } if (show[3].Item1) { row.Add(item.CostCenterName); } if (show[4].Item1) { row.Add(item.CallingPlanId.ToString()); } if (show[5].Item1) { row.Add(item.Minutes.ToString()); } if (show[7].Item1) { row.Add(item.SMS.ToString()); } if (show[9].Item1) { row.Add(item.Gprs.ToString()); } if (show[11].Item1) { row.Add(SD.Months[item.Month]); } if (show[12].Item1) { row.Add(item.Year.ToString()); } if (show[13].Item1) { row.Add(item.Total.ToString()); } datas.Add(row); } string csv = SD.csvString(headers, datas); return(csv); }
public string CSVStringConstructor(Tuple <bool, string>[] show, bool[] mask, List <CostCenterMobilePhoneExpense> data) { List <string> headers = new List <string>(); int t = 0; for (int j = 0; j < show.Length; j++) { if (mask[j]) { headers.Add(SD.costCenterMPExpenses[j]); } } List <List <string> > datas = new List <List <string> >(); foreach (var item in data) { List <string> row = new List <string>(); if (show[0].Item1) { row.Add(item.CostCenterCode); } if (show[1].Item1) { row.Add(item.CostCenterName); } if (show[2].Item1) { row.Add(item.Calls.ToString()); } if (show[4].Item1) { row.Add(item.SMS.ToString()); } if (show[6].Item1) { row.Add(item.GPRS.ToString()); } if (show[12].Item1) { row.Add(SD.Months[item.Month]); } if (show[13].Item1) { row.Add(item.Year.ToString()); } if (show[8].Item1) { row.Add(item.Total.ToString()); } if (show[10].Item1) { row.Add(item.Percent.ToString()); } datas.Add(row); } string csv = SD.csvString(headers, datas); return(csv); }