Example #1
0
        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);
            }
        }
Example #2
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);
        }