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