public ActionResult PlaceOrders()
{
CASDatabaseEntities db = new CASDatabaseEntities();
List <SupplierDataModel> list = new List <SupplierDataModel>();
SupplierDataModel dt = new SupplierDataModel();
var getData = from s in db.Suppliers
where s.CurrentStatus == "Active"
select new
{
s.SupplierID,
s.FirstName,
s.LastName,
s.CompanyName,
s.CompanyAddress
};
foreach (var item in getData)
{
list.Add(new SupplierDataModel
{
SupplierID = item.SupplierID,
FirstName = item.FirstName,
LastName = item.LastName,
CompanyName = item.CompanyName,
CompanyAddress = item.CompanyAddress
});
}
dt.ListSupplier = list;
return(View(dt));
}
public ActionResult Add()
{
SupplierDataModel model = new SupplierDataModel();
model.RepaymentDate = DateTime.Now;
model.SupplierTypeList = _commonController.GetSupplierTypeList();
return(View(model));
}
public ActionResult Edit(SupplierDataModel model)
{
if (ModelState.IsValid)
{
SupplierData goodsData = model.MapTo <SupplierDataModel, SupplierData>();
_supplierDataService.Update(goodsData);
SuccessNotification($"{_localizationService.GetResource("UpdateSuccess") + model.SupplierName}");
return(RedirectToAction("Index"));
}
model.SupplierTypeList = _commonController.GetSupplierList();
return(View(model));
}
public ActionResult Add(SupplierDataModel model)
{
if (ModelState.IsValid)
{
SupplierData Goods = model.MapTo <SupplierDataModel, SupplierData>();
_supplierDataService.Insert(Goods);
return(RedirectToAction("Index"));
}
model.SupplierTypeList = _commonController.GetSupplierTypeList();
return(View(model));
}
public AddSuppliers(SupplierDataModel supplier)
{
InitializeComponent();
nametextBox.Text = supplier.name;
phoneMaskedTextBox.Text = supplier.phone;
addresstextBox.Text = supplier.address;
companytextBox.Text = supplier.company;
emailTextBox.Text = supplier.email;
othertextBox.Text = supplier.other;
editButton.Visible = true;
deleteButton.Visible = true;
addButton.Enabled = false;
supplierModel = supplier;
}
public ActionResult EditDetails(SupplierDataModel dt)
{
CASDatabaseEntities db = new CASDatabaseEntities();
Supplier objSupplier = new Supplier();
var id = Convert.ToInt32(Session["UserID"]);
var getData = db.Suppliers.Where(a => a.UserID == id).FirstOrDefault();
if (ModelState.IsValid)
{
if (getData != null)
{
getData.FirstName = dt.FirstName;
getData.LastName = dt.LastName;
getData.CompanyName = dt.CompanyName;
getData.CompanyAddress = dt.CompanyAddress;
getData.CurrentStatus = dt.CurrentStatus;
}
else
{
objSupplier.FirstName = dt.FirstName;
objSupplier.LastName = dt.LastName;
objSupplier.CompanyName = dt.CompanyName;
objSupplier.CompanyAddress = dt.CompanyAddress;
objSupplier.CurrentStatus = dt.CurrentStatus;
db.Suppliers.Add(objSupplier);
}
db.SaveChanges();
}
var checkName = db.Suppliers.Where(a => a.UserID == id).FirstOrDefault();
if (checkName.FirstName != null)
{
Session["Name"] = checkName.FirstName;
}
else
{
Session["Name"] = null;
}
Session["ID"] = checkName.SupplierID;
return(View(dt));
}
public ActionResult EditDetails()
{
CASDatabaseEntities db = new CASDatabaseEntities();
SupplierDataModel dt = new SupplierDataModel();
var id = Convert.ToInt32(Session["UserID"]);
var getData = db.Suppliers.Where(a => a.UserID == id).FirstOrDefault();
if (getData != null)
{
dt.FirstName = getData.FirstName;
dt.LastName = getData.LastName;
dt.CompanyName = getData.CompanyName;
dt.CompanyAddress = getData.CompanyAddress;
dt.CurrentStatus = getData.CurrentStatus;
}
else
{
dt.FirstName = null;
}
return(View(dt));
}
public ActionResult ViewSupplier()
{
CASDatabaseEntities db = new CASDatabaseEntities();
List <SupplierDataModel> list = new List <SupplierDataModel>();
SupplierDataModel dt = new SupplierDataModel();
var getData = from s in db.Suppliers
join u in db.Users
on s.UserID equals u.UserID
where s.FirstName != null
select new
{
s.SupplierID,
s.FirstName,
s.LastName,
s.CompanyName,
s.CompanyAddress,
s.CurrentStatus,
u.EmailID
};
foreach (var item in getData)
{
list.Add(new SupplierDataModel
{
SupplierID = item.SupplierID,
FirstName = item.FirstName,
LastName = item.LastName,
CompanyName = item.CompanyName,
CompanyAddress = item.CompanyAddress,
CurrentStatus = item.CurrentStatus,
EmailID = item.EmailID,
});
}
dt.ListSupplier = list;
return(View(dt));
}
public Reports(PurchaseOrderDataModel purchases, List <StockDataModel> stocks, SupplierDataModel suppliers, ClientDataModel clients)
{
InitializeComponent();
ClientDataModelBindingSource.DataSource = clients;
SupplierDataModelBindingSource.DataSource = suppliers;
PurchaseOrderDataModelBindingSource.DataSource = purchases;
StockDataModelBindingSource.DataSource = stocks;
}
