public string MakeEmployeeSCV()
{
List <MainUser> users = _empRepo.GetAllUser();
using (var memoryStream = new MemoryStream())
using (var streamWriter = new StreamWriter(memoryStream))
using (var csv = new CsvWriter(streamWriter))
{
csv.WriteRecords(users);
streamWriter.Flush();
memoryStream.Position = 0;
using (var reader = new StreamReader(memoryStream))
{
return(reader.ReadToEnd());
}
}
}
public ActionResult Index()
{
var mvcName = typeof(Controller).Assembly.GetName();
var isMono = Type.GetType("Mono.Runtime") != null;
ViewData["Version"] = mvcName.Version.Major + "." + mvcName.Version.Minor;
ViewData["Runtime"] = isMono ? "Mono" : ".NET";
try
{
_empRepo.GetAllUser();
}
catch (Exception ex)
{
string message = ex.Message;
}
return(View());
}
public string MakeCSV()
{
StringBuilder csv = new StringBuilder();
csv.Append(MakeCSVColumn() + Environment.NewLine);
List <MainUser> allUser = _empRepo.GetAllUser();
foreach (var u in allUser)
{
string row = string.Empty;
row = row + u.Id + ", ";
row = row + u.UserName + ", ";
row = row + u.UserType.ToString() + ", ";
row = row + u.IsActive + ", ";
row = row + u.Islock + ", ";
if (u.Details != null)
{
row = row + '"' + u.Details.LastName + '"' + ", ";
row = row + '"' + u.Details.FirstName + '"' + ", ";
row = row + '"' + u.Details.Language + '"' + ", ";
row = row + u.Details.BirthDate.ToString() + ", ";
row = row + u.Details.Age + ", ";
row = row + '"' + u.Details.HobbiesAndInterest + '"' + ", ";
row = row + u.Details.CivilStatus.ToString() + ", ";
row = row + u.Details.Gender.ToString() + ", ";
row = row + u.Details.PhoneNumber + ", ";
row = row + '"' + u.Details.Address + '"' + ", ";
row = row + '"' + u.Details.Country + '"' + ", ";
row = row + '"' + u.Details.State + '"';
}
row = row + Environment.NewLine;
csv.Append(row);
}
return(csv.ToString());
}