public IActionResult AddUser(UserModel userModel)
{
using (var context = new FollowUpDbContext())
{
Employee employee = _mapper.Map <Employee>(userModel.Employee);
User user = _mapper.Map <User>(userModel.User);
context.Employee.Add(employee);
context.SaveChanges();
user.Empid = employee.Id;
user.Username = employee.Email;
user.IsActive = true;
user.IsDelete = false;
user.Type = userModel.User.type.ToString();
context.User.Add(user);
int a = context.SaveChanges();
if (a > 0)
{
userModel = null;
}
}
ViewBag.Name = HttpContext.Session.GetString(SessionName);
ViewBag.Title = "User";
return(View());
}
public TestController(FollowUpDbContext dbcontext, IMapper mapper)
{
_dbcontext = dbcontext;
_mapper = mapper;
}
public ReportsController(FollowUpDbContext context)
{
this.Context = context;
}
public UserController(ILogger <HomeController> logger, FollowUpDbContext followupsContext)
{
_logger = logger;
_followupsContext = followupsContext;
}
public IActionResult Index(CustomerResultViewModel customers, IFormFile file, [FromServices] IHostingEnvironment hostingEnvironment)
{
CustomerResultViewModel _custResult = new CustomerResultViewModel();
_custResult.ResultCustomer = new List <Customer>();
_custResult.ResultSalesPerson = new List <Employee>();
_custResult.Customer = new Customer();
//Sales Persons Details
_custResult.ResultSalesPerson = (from c in _followupsContext.Employee select c).ToList();
_custResult.ResultSalesPerson.Insert(0, new Employee {
Id = 0, Name = "--Select--"
});
ViewBag.SalesPerson = _custResult.ResultSalesPerson;
//Coutry Details
_custResult.ResultCountry = new List <Countries>();
_custResult.ResultCountry = (from d in _followupsContext.Countries select d).ToList();
_custResult.ResultCountry.Insert(0, new Countries {
PhoneCode = 0, Name = "--Select--"
});
ViewBag.Country = _custResult.ResultCountry;
//Upload Files
if (file != null)
{
int Countrycode = (int)customers.Customer.CountryId;
string filename = $"{hostingEnvironment.WebRootPath}\\files\\{ file.FileName}";
using (FileStream fileStream = System.IO.File.Create(filename))
{
file.CopyTo(fileStream);
fileStream.Flush();
}
_custResult.ResultCustomer = this.GetCustDetails(file.FileName, Countrycode);
return(View(_custResult));
}
//Save Details
else
{
DataTable dtUnassigned = new DataTable();
dtUnassigned.Columns.Add("Phone", typeof(string));
if (customers.ResultCustomer != null)
{
using (var context = new FollowUpDbContext())
{
foreach (var item in customers.ResultCustomer)
{
if (item.SalesPersonId != 0)
{
CustomerFollowUp CustResult = _mapper.Map <CustomerFollowUp>(item);
context.CustomerFollowUp.Add(CustResult);
context.SaveChanges();
}
else
{
dtUnassigned.Rows.Add(item.Phone);
}
}
}
if (dtUnassigned.Rows.Count > 0)
{
string contentType = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet";
string fileName = "UnAssignedPhone.xlsx";
using (var workbook = new XLWorkbook())
{
IXLWorksheet worksheet =
workbook.Worksheets.Add("Sheet1");
worksheet.Cell(1, 1).Value = "Phone";
for (int i = 0; i <= dtUnassigned.Rows.Count - 1; i++)
{
worksheet.Cell(i + 1, 1).Value = dtUnassigned.Rows[i]["Phone"].ToString();
}
using (var stream = new MemoryStream())
{
workbook.SaveAs(stream);
var content = stream.ToArray();
return(File(content, contentType, fileName));
}
}
}
}
//Save Details Mannually
if (customers.Customer != null)
{
string d1 = DateTime.Now.ToShortDateString();
DateTime Cur_date = Convert.ToDateTime(d1);
_custResult.Customer.CreateDate = Cur_date;
customers.Customer.CreateDate = Cur_date;
var details = customers.Customer;
CustomerFollowUp CustResult = _mapper.Map <CustomerFollowUp>(customers.Customer);
_followupsContext.CustomerFollowUp.Add(CustResult);
_followupsContext.SaveChanges();
}
return(RedirectToAction("Index"));
}
}
public HomeController(ILogger <HomeController> logger, FollowUpDbContext followupsContext, IMapper mapper)
{
_logger = logger;
_followupsContext = followupsContext;
_mapper = mapper;
}
public LoginController(FollowUpDbContext followupsContext)
{
_dbcontext = followupsContext;
}
