public ActionResult ViewSalesperson()
{
CASDatabaseEntities db = new CASDatabaseEntities();
List <SalesDataModel> list = new List <SalesDataModel>();
SalesDataModel dt = new SalesDataModel();
var getData = from s in db.Salespersons
join u in db.Users
on s.UserID equals u.UserID
where s.FirstName != null
select new
{
s.SalespersonID,
s.FirstName,
s.LastName,
s.CurrentStatus,
u.EmailID
};
foreach (var item in getData)
{
list.Add(new SalesDataModel
{
SalespersonID = item.SalespersonID,
FirstName = item.FirstName,
LastName = item.LastName,
CurrentStatus = item.CurrentStatus,
EmailID = item.EmailID,
});
}
dt.ListSalesperson = list;
return(View(dt));
}
public SalesDataSearchViewModel(AbstractWindowFactory mainWindowFactory)
: base(mainWindowFactory)
{
SalesDataModel = new SalesDataModel();
DisplayTheSelectedYearsDataCommand = new RelayCommand(DisplayTheSelectedYearsData);
DeleteSelectedRowCommand = new RelayCommand(DeleteSelectedSalesDatum);
}
public SalesDataInputViewModel(AbstractWindowFactory mainWindowFactory, AbstractWindowFactory saleDataConfirmWindowFactory)
: base(mainWindowFactory)
{
_saleDataConfirmWindowFactory = saleDataConfirmWindowFactory;
SalesDataModel = new SalesDataModel();
ConfirmSalesDataCommand = new RelayCommand(ConfirmSalesData, canExecute: () => SalesDataModel.IsValidData);
}
public ActionResult view()
{
SalesDataModel salesDataModel = new SalesDataModel();
salesDataModel.SalesFile = null;
return(View("View", salesDataModel));
}
private SalesDataModel.Sales ToEntity(DAL.Models.Sales source)
{
return(new SalesDataModel.Sales()
{
Date = source.Date,
Manager = context.ManagerSet.FirstOrDefault(x => x.Id == source.Manager.Id),
Client = context.ClientSet.FirstOrDefault(x => x.Id == source.Client.Id),
Goods = context.GoodsSet.FirstOrDefault(x => x.Id == source.Goodds.Id),
Cost
});
public int Update(DateTime SALES_ORDER_DATE, string Company, double AMOUNT, double PLANNED, string UPDATED_BY)
{
SalesDataModel salesDataModel = new SalesDataModel();
salesDataModel.SALES_ORDER_DATE = SALES_ORDER_DATE;
salesDataModel.Company = Company;
salesDataModel.AMOUNT = AMOUNT;
salesDataModel.PLANNED = PLANNED;
salesDataModel.UPDATED_BY = UPDATED_BY;
salesDataModel.UPDATED_ON = DateTime.Now;
return(ISalesRepositoty.Update(salesDataModel));
}
public void UploadFiletxtTest()
{
SalesDataModel salesDataModel = new SalesDataModel();
FileStream fs = System.IO.File.OpenRead(@"..\..\" + "\\testfiles\\test.txt");
MyTestPostedFileBase fileBase = new MyTestPostedFileBase(fs, "txt", "test.txt");
salesDataModel.SalesFile = fileBase;
var result = controller.UploadFile(salesDataModel) as ViewResult;
SalesDataModel resultSalesDataModel = (SalesDataModel)result.Model;
Assert.AreEqual(resultSalesDataModel.IsValid, false);
Assert.AreEqual(resultSalesDataModel.Message, "'test.txt' file has incorrect data. ");
Assert.AreEqual(result.ViewName, "View");
}
public void UploadFileTest()
{
SalesDataModel salesDataModel = new SalesDataModel();
FileStream fs = System.IO.File.OpenRead(@"..\..\" + "\\testfiles\\Dealertrack-CSV-Example.csv");
MyTestPostedFileBase fileBase = new MyTestPostedFileBase(fs, "csv", "Dealertrack-CSV-Example.csv");
salesDataModel.SalesFile = fileBase;
var result = controller.UploadFile(salesDataModel) as ViewResult;
SalesDataModel resultSalesDataModel = (SalesDataModel)result.Model;
Assert.AreEqual(resultSalesDataModel.IsValid, true);
Assert.AreEqual(result.ViewName, "View");
}
public void Add(SalesDataModel salesDataModel)
{
SALE saleObj = new SALE();
//write a common logic to assign value from one type object to other type object in Utils class lib project.
saleObj.ID = salesDataModel.ID;
saleObj.SALES_ORDER_DATE = salesDataModel.SALES_ORDER_DATE;
saleObj.Company = salesDataModel.Company;
saleObj.AMOUNT = salesDataModel.AMOUNT;
saleObj.PLANNED = salesDataModel.PLANNED;
saleObj.COST = salesDataModel.COST;
saleObj.CREATED_BY = salesDataModel.CREATED_BY;
saleObj.CREATED_ON = salesDataModel.CREATED_ON;
saleObj.UPDATED_BY = salesDataModel.UPDATED_BY;
saleObj.UPDATED_ON = salesDataModel.UPDATED_ON;
this.extraaEdgeCRMEntities.SALES.Add(saleObj);
}
public void Update(SalesDataModel salesDataModel)
{
//write a common logic to assign value from one type object to other type object in Utils class lib project.
SALE saleObj = this.extraaEdgeCRMEntities.SALES.Where(x => x.ID == salesDataModel.ID).FirstOrDefault();
if (saleObj != null)
{
saleObj.SALES_ORDER_DATE = salesDataModel.SALES_ORDER_DATE;
saleObj.Company = salesDataModel.Company;
saleObj.AMOUNT = salesDataModel.AMOUNT;
saleObj.PLANNED = salesDataModel.PLANNED;
saleObj.COST = salesDataModel.COST;
saleObj.CREATED_BY = salesDataModel.CREATED_BY;
saleObj.CREATED_ON = salesDataModel.CREATED_ON;
saleObj.UPDATED_BY = salesDataModel.UPDATED_BY;
saleObj.UPDATED_ON = salesDataModel.UPDATED_ON;
}
}
public ActionResult EditDetails()
{
CASDatabaseEntities db = new CASDatabaseEntities();
SalesDataModel dt = new SalesDataModel();
var id = Convert.ToInt32(Session["UserID"]);
var getData = db.Salespersons.Where(a => a.UserID == id).FirstOrDefault();
if (getData != null)
{
dt.FirstName = getData.FirstName;
dt.LastName = getData.LastName;
dt.CurrentStatus = getData.CurrentStatus;
}
else
{
dt.FirstName = null;
}
return(View(dt));
}
public ActionResult EditDetails(SalesDataModel dt)
{
CASDatabaseEntities db = new CASDatabaseEntities();
Salesperson objSalesperson = new Salesperson();
var id = Convert.ToInt32(Session["UserID"]);
var getData = db.Salespersons.Where(a => a.UserID == id).FirstOrDefault();
if (ModelState.IsValid)
{
if (getData != null)
{
getData.FirstName = dt.FirstName;
getData.LastName = dt.LastName;
getData.CurrentStatus = dt.CurrentStatus;
}
else
{
objSalesperson.FirstName = dt.FirstName;
objSalesperson.LastName = dt.LastName;
objSalesperson.CurrentStatus = dt.CurrentStatus;
db.Salespersons.Add(objSalesperson);
}
db.SaveChanges();
}
var checkName = db.Salespersons.Where(a => a.UserID == id).FirstOrDefault();
if (checkName.FirstName != null)
{
Session["Name"] = checkName.FirstName;
}
else
{
Session["Name"] = null;
}
Session["ID"] = checkName.SalespersonID;
return(View(dt));
}
public SalesDataConfirmViewModel(SalesDataModel salesDataModel)
{
SalesDataModel = salesDataModel;
GoBackToSalesInputWindowCommand = new RelayCommand <IClosableWindow>(GoBackToSalesInputWindow);
InsertSalesDataCommand = new RelayCommand(InsertSalesData);
}
public ActionResult UploadFile(SalesDataModel salesDataModel)
{
if (salesDataModel == null || salesDataModel.SalesFile == null)
{
if (HttpContext?.Application?.Get("SalesFile") != null)
{
ModelState.Clear();
salesDataModel = (SalesDataModel)HttpContext.Application.Get("SalesFile");
if (salesDataModel.deals.Count > 0)
{
return(View("View", salesDataModel));
}
}
else
{
salesDataModel = new SalesDataModel();
salesDataModel.SalesFile = null;
return(View("View", salesDataModel));
}
}
else if (HttpContext != null)
{
HttpContext.Application.Clear();
HttpContext.Application.Add("SalesFile", salesDataModel);
}
try
{
if (ModelState.IsValid)
{
StreamReader reader = new StreamReader(salesDataModel.SalesFile.InputStream, Encoding.Default);
string csvFormat = "DealNumber,CustomerName,DealershipName,Vehicle,Price,Date";
string line = reader.ReadLine();
if (line == csvFormat)
{
while (!reader.EndOfStream)
{
line = reader.ReadLine();
DealInfo dealInfo = new DealInfo(line);
if (dealInfo.IsValid)
{
salesDataModel.deals.Add(dealInfo);
}
else
{
salesDataModel.Message = "'" + salesDataModel.SalesFileName + "' file has incorrect data.";
salesDataModel.IsValid = false;
return(View("View", salesDataModel));
}
}
salesDataModel.Message = "'" + salesDataModel.SalesFileName + "' file details are below";
salesDataModel.IsValid = true;
}
else
{
salesDataModel.Message = "'" + salesDataModel.SalesFileName + "' file has incorrect data. ";
salesDataModel.IsValid = false;
}
}
else
{
salesDataModel.Message = "'" + salesDataModel.SalesFileName + "' file is not supported. ";
salesDataModel.IsValid = false;
}
return(View("View", salesDataModel));
}
catch
{
return(View("View"));
}
}
