public int Insert(TravelCard.DomainModel.Entities.TravelCard travelcard_) { try { var travelcardtoinsert = new TravelCard.DomainModel.Entities.TravelCard { PartSetUpID = travelcard_.PartSetUpID, IsContinuationCard = travelcard_.IsContinuationCard, IsDraft = travelcard_.IsDraft, OperationCode = travelcard_.OperationCode, LanguageID = travelcard_.LanguageID, PrintDate = travelcard_.PrintDate, PrintLocation = travelcard_.PrintLocation, PrintedBy = travelcard_.PrintedBy, Notes = travelcard_.Notes }; _qualityEntities.AddToTravelCards(travelcardtoinsert); _qualityEntities.SaveChanges(SaveOptions.AcceptAllChangesAfterSave); return(travelcardtoinsert.TCID); } catch (Exception ex) { string errormessage = ex.ToString(); return(0); } }
public void Update(TravelCard.DomainModel.Entities.TravelCard TravelCard_) { var travelcardtoupdate = _qualityEntities.TravelCards .FirstOrDefault(x => x.TCID == TravelCard_.TCID); travelcardtoupdate.PartSetUpID = TravelCard_.PartSetUpID; travelcardtoupdate.TCBarCodeText = TravelCard_.TCBarCodeText; travelcardtoupdate.IsContinuationCard = TravelCard_.IsContinuationCard; travelcardtoupdate.IsDraft = TravelCard_.IsDraft; travelcardtoupdate.OperationCode = TravelCard_.OperationCode; travelcardtoupdate.PrintDate = TravelCard_.PrintDate; travelcardtoupdate.PrintDate = TravelCard_.PrintDate; travelcardtoupdate.PrintLocation = TravelCard_.PrintLocation; travelcardtoupdate.LanguageID = TravelCard_.LanguageID; travelcardtoupdate.PrintedBy = TravelCard_.PrintedBy; travelcardtoupdate.Notes = TravelCard_.Notes; _qualityEntities.SaveChanges(SaveOptions.AcceptAllChangesAfterSave); }
public int SaveTravelCards(TravelCardPrintViewModel viewModel, bool isdraft, int?operationcode, int partsetupid, bool iscontinuationcard) { GetUserInfo(); string user = username; string language = ResolveCulture().Name; viewModel.TCLanguage = _languageRepository.Language.FirstOrDefault(a => a.LanguageCode == language.Trim()); viewModel.UserSetting = _usersettingsRepository.UserSetting.FirstOrDefault(a => a.UserName == username); viewModel.PartSetUp = _partsetupRepository.PartSetUp.FirstOrDefault(a => a.PartSetUpID == partsetupid); //TODO: Find out why I had to declare a new TravelCard since it was included in the view model. TravelCard.DomainModel.Entities.TravelCard travelcard_ = new TravelCard.DomainModel.Entities.TravelCard(); //save the travel card record int travelcardID = 0; travelcard_.PartSetUpID = viewModel.PartSetUp.PartSetUpID; travelcard_.IsContinuationCard = iscontinuationcard; travelcard_.LanguageID = Convert.ToInt16(viewModel.TCLanguage.LanguageID); travelcard_.IsDraft = isdraft; travelcard_.OperationCode = Convert.ToInt16(operationcode); travelcard_.PrintDate = DateTime.Now; travelcard_.PrintedBy = username; travelcard_.PrintLocation = viewModel.UserSetting.Plant.PlantName; travelcard_.Notes = ""; travelcardID = _travelcardRepository.Insert(travelcard_); //save the bar code text; string plantnum = viewModel.UserSetting.Plant.PlantCode; string partsetup = viewModel.PartSetUp.PartSetUpID.ToString(); string tcid = travelcardID.ToString(); string barcodeid = plantnum + "-" + partsetup + "-" + tcid; viewModel.TravelCard = _travelcardRepository.TravelCard.FirstOrDefault(a => a.TCID == travelcardID); viewModel.TravelCard.TCBarCodeText = barcodeid; _travelcardRepository.Update(viewModel.TravelCard); return(travelcardID); }