private DataTable GetData() { List <UserModel> userDatas = new List <UserModel>() { new UserModel() { Username = "******", FullName = "Fernando Christyanto", Age = 21 }, new UserModel() { Username = "******", FullName = "Yohanzen Christanto Alexander", Age = 21 }, new UserModel() { Username = "******", FullName = "Tegar Aryo Sulthon Musthofa", Age = 32 }, new UserModel() { Username = "******", FullName = "Nubli Hawari", Age = 28 }, new UserModel() { Username = "******", FullName = "Nadia Ita Purnamasari", Age = 20 } }; UserExcelModel userExcelModel = new UserExcelModel(userDatas); return(userExcelModel.ToDataTable()); }
//-------------------------------- excel---------------------------------- private List <UserExcelModel> GetExcelModel() { long totalModelCount = 0; var users = Search(ref totalModelCount, (Session["User_Name"] == null) ? null : Session["User_Name"].ToString(), (Session["User_Family"] == null) ? null : Session["User_Family"].ToString(), (Session["User_RoleId"] == null) ? 0 : Convert.ToInt64(Session["User_RoleId"]), (Session["User_FatherName"] == null) ? null : Session["User_FatherName"].ToString(), (Session["User_Gender"] == null) ? -1 : Convert.ToInt32(Session["User_Gender"]), (Session["User_NationalCode"] == null) ? null : Session["User_NationalCode"].ToString(), (Session["User_IdNo"] == null) ? null : Session["User_IdNo"].ToString(), (Session["User_Mobile"] == null) ? null : Session["User_Mobile"].ToString(), (Session["User_Tel"] == null) ? null : Session["User_Tel"].ToString(), (Session["User_Username"] == null) ? null : Session["User_Username"].ToString(), (Session["User_IsInsuranced"] == null) ? -1 : Convert.ToInt32(Session["User_IsInsuranced"]), (Session["User_Status"] == null) ? -1 : Convert.ToInt32(Session["User_Status"])); var model = new List <UserExcelModel>(); UserExcelModel excelModel; foreach (var item in users) { excelModel = new UserExcelModel(); excelModel.Name = item.Name; excelModel.Family = item.Family; excelModel.RoleName = item.Role.Name; excelModel.Gender = (item.Gender == true) ? "مرد" : "زن"; excelModel.FatherName = (string.IsNullOrEmpty(item.FatherName)) ? "-" : item.FatherName; excelModel.NationalCode = item.NationalCode; excelModel.IdNo = (string.IsNullOrEmpty(item.IdNo)) ? "-" : item.IdNo; excelModel.BirthDate = (item.BirthDate == null) ? "-" : Convert.ToDateTime(item.BirthDate).ToPersianDateString(); excelModel.IsInsuranced = (item.IsInsuranced == true) ? "بله" : "خیر"; excelModel.Mobile = (string.IsNullOrEmpty(item.Mobile)) ? "-" : item.Mobile; excelModel.Tel = (string.IsNullOrEmpty(item.Tel)) ? "-" : item.Tel; excelModel.Username = item.Username; excelModel.Status = item.Status; var trades = blRelation.Where(p => p.UserId == item.Id).ToList(); if (trades.Count() != 0) { int counter = 0; foreach (var t in trades) { if (counter == 0) { excelModel.TradesName = t.Trade.Name; } else { excelModel.TradesName += " / " + t.Trade.Name; } counter++; } } else { excelModel.TradesName = "-"; } var vehicles = blRelation.Where(p => p.UserId == item.Id).ToList(); if (vehicles.Count() != 0) { int counter = 0; int i = 0; foreach (var v in vehicles) { if (v.VehicleId != null) { if (i == 0) { excelModel.VehiclesName = v.Vehicle.Model; } else { excelModel.VehiclesName += " / " + v.Vehicle.Model; } i++; } counter++; } } else { excelModel.VehiclesName = "-"; } model.Add(excelModel); } return(model); }