Int32 DisplayStocks(string CarModelFilter)
{
Int32 ModelNo; //var to store the primary key
string CarModel; //var to store the phone type
string BHP; //var to store the phone number
DateTime DateAdded;
//; //create an onstance of the phone book class
//create an instance of the phone collection class
clsStockCollection StockBook = new clsStockCollection();
StockBook.ReportByCarModel(CarModelFilter);
Int32 RecordCount; // var to store the count of records
Int32 Index = 0; // var to store the index for the loop
RecordCount = StockBook.Count; // get the count of records
lstStock.Items.Clear();
while (Index < RecordCount) // while there are records to process
{
ModelNo = StockBook.StockList[Index].ModelNo; // get the primary key
CarModel = StockBook.StockList[Index].CarModel; // get the phone type
BHP = StockBook.StockList[Index].BHP; // get the phone name
DateAdded = StockBook.StockList[Index].DateAdded; // get the phone name
//create a new entry for the list box
ListItem NewEntry = new ListItem(CarModel + " " + BHP + " " + DateAdded, ModelNo.ToString());
lstStock.Items.Add(NewEntry); // ADD THE PHONE TO THE LIST
Index++;
}
return(RecordCount); //return the count of records found
}
public ActionResult DeleteConfirmed(long id)
{
ModelNo modelno = db.ModelNos.Find(id);
db.ModelNos.Remove(modelno);
db.SaveChanges();
return(RedirectToAction("Index"));
}
//
// GET: /ModelNo/Delete/5
public ActionResult Delete(long id = 0)
{
ModelNo modelno = db.ModelNos.Find(id);
if (modelno == null)
{
return(HttpNotFound());
}
return(View(modelno));
}
public ActionResult Edit(ModelNo modelno)
{
if (ModelState.IsValid)
{
db.Entry(modelno).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(modelno));
}
public int CompareTo(MailingLabelRow other)
{
int result = Manufacturer.CompareTo(other.Manufacturer);
if (result == 0)
{
result = ModelNo.CompareTo(other.ModelNo);
}
return(result);
}
public ActionResult Create(ModelNo modelno)
{
if (ModelState.IsValid)
{
db.ModelNos.Add(modelno);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(modelno));
}
private async Task <BPFCEstablishDto> AddBPFC(BPFCEstablishDtoForImportExcel bPFCEstablishDto)
{
var result = new BPFCEstablishDto();
// make model name, model no, article no, process
using (var scope = new TransactionScope(TransactionScopeOption.Required,
new TransactionOptions {
IsolationLevel = IsolationLevel.ReadCommitted
}, TransactionScopeAsyncFlowOption.Enabled))
{
// make model name
var modelName = await _repoModelName.FindAll().FirstOrDefaultAsync(x => x.Name.ToUpper().Equals(bPFCEstablishDto.ModelName.ToUpper()));
if (modelName != null)
{
result.ModelNameID = modelName.ID;
}
else
{
var modelNameModel = new ModelName {
Name = bPFCEstablishDto.ModelName
};
_repoModelName.Add(modelNameModel);
await _repoModelNo.SaveAll();
result.ModelNameID = modelNameModel.ID;
}
// end make model no
// Make model no
var modelNo = await _repoModelNo.FindAll().FirstOrDefaultAsync(x => x.Name.ToUpper().Equals(bPFCEstablishDto.ModelNo.ToUpper()) && x.ModelNameID == result.ModelNameID);
if (modelNo != null)
{
result.ModelNoID = modelNo.ID;
}
else
{
var modelNoModel = new ModelNo {
Name = bPFCEstablishDto.ModelNo, ModelNameID = result.ModelNameID
};
_repoModelNo.Add(modelNoModel);
await _repoModelNo.SaveAll();
result.ModelNoID = modelNoModel.ID;
}
// end make model NO
// end make articleNO
var artNo = await _repoArticleNo.FindAll().FirstOrDefaultAsync(x => x.Name.ToUpper().Equals(bPFCEstablishDto.ArticleNo.ToUpper()) && x.ModelNoID == result.ModelNoID);
if (artNo != null)
{
result.ArticleNoID = artNo.ID;
}
else
{
// make art no
var articleNoModel = new ArticleNo {
Name = bPFCEstablishDto.ArticleNo, ModelNoID = result.ModelNoID
};
_repoArticleNo.Add(articleNoModel);
await _repoArticleNo.SaveAll();
result.ArticleNoID = articleNoModel.ID;
}
// end articleNO
// make Art Process
var artProcess = await _repoArtProcess.FindAll().FirstOrDefaultAsync(x => x.ProcessID.Equals(bPFCEstablishDto.Process.ToUpper() == "STF" ? 2 : 1) && x.ArticleNoID == result.ArticleNoID);
if (artProcess != null)
{
result.ArtProcessID = artProcess.ID;
}
else
{
// make art process
var artProcessModel = new ArtProcess {
ArticleNoID = result.ArticleNoID, ProcessID = bPFCEstablishDto.Process.ToUpper() == "STF" ? 2 : 1
};
_repoArtProcess.Add(artProcessModel);
await _repoArtProcess.SaveAll();
result.ArtProcessID = artProcessModel.ID;
}
//End make Art Process
result.CreatedBy = bPFCEstablishDto.CreatedBy;
scope.Complete();
return(result);
}
}
