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 IActionResult Index(UserResultViewModel UserReult)
{
ViewBag.Name = HttpContext.Session.GetString(SessionName);
ViewBag.Title = "User";
UserResultViewModel _userResultViewModels = new UserResultViewModel();
_userResultViewModels.SearchDate = new SearchModel();
//Get Customer Details
_userResultViewModels.UserResultviewCustomer = new List <CustomerFollowUp>();
int SalesPersonId = Convert.ToInt32(HttpContext.Session.GetString(SessionId));
//int SalesPersonId = 2;
string Curr_date = System.DateTime.Now.ToShortDateString();
DateTime Cur_date = Convert.ToDateTime(Curr_date);
if (UserReult.SearchDate != null)
{
_userResultViewModels.UserResultviewCustomer = _followupsContext.CustomerFollowUp.Where(x => x.DateOfContact >= UserReult.SearchDate.FromDate && x.DateOfContact <= UserReult.SearchDate.ToDate || x.CreateDate >= Cur_date && x.SalesPersonId == SalesPersonId).ToList();
_userResultViewModels.CountryResult = new List <Countries>();
_userResultViewModels.CountryResult = (from d in _followupsContext.Countries select d).ToList();
_userResultViewModels.CountryResult.Insert(0, new Countries {
Id = 0, Name = "--Select--"
});
ViewBag.Country = _userResultViewModels.CountryResult;
//Bind Sales Person
_userResultViewModels.ResultSalesPerson = new List <Employee>();
_userResultViewModels.ResultSalesPerson = (from c in _followupsContext.Employee select c).ToList();
_userResultViewModels.ResultSalesPerson.Insert(0, new Employee {
Id = 0, Name = "--Select--"
});
ViewBag.SalesPerson = _userResultViewModels.ResultSalesPerson;
}
else
{
if (UserReult.UserResultviewCustomer != null)
{
foreach (var item in UserReult.UserResultviewCustomer)
{
CustomerFollowUp objCust = new CustomerFollowUp();
objCust = _followupsContext.CustomerFollowUp.Find(item.FollowId);
objCust.CountryId = item.CountryId;
objCust.CustomerInterest = item.CustomerInterest;
objCust.DateOfContact = item.DateOfContact;
objCust.Idstatus = item.Idstatus;
objCust.Phone = objCust.Phone;
objCust.SalesPersonId = objCust.SalesPersonId;
string d = DateTime.Now.ToShortDateString();
DateTime cur_date = Convert.ToDateTime(d);
objCust.ModifiedDate = cur_date;
_followupsContext.Entry(objCust).State = EntityState.Modified;
_followupsContext.SaveChanges();
}
}
}
//Bind Country
return(View(_userResultViewModels));
}
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"));
}
}