public static List <Temp> GetMetaData(this PlantCode entityObject)
        {
            XERP.Server.DAL.PlantDAL.DALUtility dalUtility = new DALUtility();
            List <Temp> tempList = new List <Temp>();
            int         id       = 0;

            using (PlantEntities ctx = new PlantEntities(dalUtility.EntityConectionString))
            {
                var c            = ctx.PlantCodes.FirstOrDefault();
                var queryResults = from meta in ctx.MetadataWorkspace.GetItems(DataSpace.CSpace)
                                   .Where(m => m.BuiltInTypeKind == BuiltInTypeKind.EntityType)
                                   from query in (meta as EntityType).Properties
                                   .Where(p => p.DeclaringType.Name == entityObject.GetType().Name)
                                   select query;

                if (queryResults.Count() > 0)
                {
                    foreach (var queryResult in queryResults.ToList())
                    {
                        Temp temp = new Temp();
                        temp.ID          = id;
                        temp.Name        = queryResult.Name.ToString();
                        temp.ShortChar_1 = queryResult.TypeUsage.EdmType.Name;
                        if (queryResult.TypeUsage.EdmType.Name == "String")
                        {
                            temp.Int_1 = Convert.ToInt32(queryResult.TypeUsage.Facets["MaxLength"].Value);
                        }
                        temp.Bool_1 = false; //we use this as a error trigger false = not an error...
                        tempList.Add(temp);
                        id++;
                    }
                }
            }
            return(tempList);
        }
예제 #2
0
 private void ChangeKeyLogic()
 {
     if (!string.IsNullOrEmpty(SelectedPlantCode.PlantCodeID))
     {//check to see if key is part of the current companylist...
         PlantCode query = PlantCodeList.Where(company => company.PlantCodeID == SelectedPlantCode.PlantCodeID &&
                                                 company.AutoID != SelectedPlantCode.AutoID).FirstOrDefault();
         if (query != null)
         {//revert it back...
             SelectedPlantCode.PlantCodeID = SelectedPlantCodeMirror.PlantCodeID;
             //change to the newly selected item...
             SelectedPlantCode = query;
             return;
         }
         //it is not part of the existing list try to fetch it from the db...
         PlantCodeList = GetPlantCodeByID(SelectedPlantCode.PlantCodeID, XERP.Client.ClientSessionSingleton.Instance.CompanyID);
         if (PlantCodeList.Count == 0)//it was not found do new record required logic...
             NotifyNewRecordNeeded("Record " + SelectedPlantCode.PlantCodeID + " Does Not Exist.  Create A New Record?");
         else
             SelectedPlantCode = PlantCodeList.FirstOrDefault();
     }
     else
     {
         string errorMessage = "ID Is Required.";
         NotifyMessage(errorMessage);
         //revert back to the value it was before it was changed...
         if (SelectedPlantCode.PlantCodeID != SelectedPlantCodeMirror.PlantCodeID)
             SelectedPlantCode.PlantCodeID = SelectedPlantCodeMirror.PlantCodeID;
     }
 }
예제 #3
0
        public IQueryable <Temp> GetMetaData(string tableName)
        {
            switch (tableName)
            {
            case "Plants":
                Plant Plant = new Plant();
                return(Plant.GetMetaData().AsQueryable());

            case "PlantTypes":
                PlantType PlantType = new PlantType();
                return(PlantType.GetMetaData().AsQueryable());

            case "PlantCodes":
                PlantCode PlantCode = new PlantCode();
                return(PlantCode.GetMetaData().AsQueryable());

            default:     //no table exists for the given tablename given...
                List <Temp> tempList = new List <Temp>();
                Temp        temp     = new Temp();
                temp.ID          = 0;
                temp.Int_1       = 0;
                temp.Bool_1      = true; //bool_1 will flag it as an error...
                temp.Name        = "Error";
                temp.ShortChar_1 = "Table " + tableName + " Is Not A Valid Table Within The Given Entity Collection, Or Meta Data Was Not Defined For The Given Table Name";
                tempList.Add(temp);
                return(tempList.AsQueryable());
            }
        }
예제 #4
0
        public IEnumerable <PlantCode> GetPlantCodes(PlantCode itemCodeQuerryObject, string companyID)
        {
            _repositoryContext             = new PlantEntities(_rootUri);
            _repositoryContext.MergeOption = MergeOption.AppendOnly;
            _repositoryContext.IgnoreResourceNotFoundException = true;
            var queryResult = from q in _repositoryContext.PlantCodes
                              where q.CompanyID == companyID
                              select q;

            if (!string.IsNullOrEmpty(itemCodeQuerryObject.Code))
            {
                queryResult = queryResult.Where(q => q.Code.StartsWith(itemCodeQuerryObject.Code.ToString()));
            }

            if (!string.IsNullOrEmpty(itemCodeQuerryObject.Description))
            {
                queryResult = queryResult.Where(q => q.Description.StartsWith(itemCodeQuerryObject.Description.ToString()));
            }

            if (!string.IsNullOrEmpty(itemCodeQuerryObject.PlantCodeID))
            {
                queryResult = queryResult.Where(q => q.Description.StartsWith(itemCodeQuerryObject.PlantCodeID.ToString()));
            }

            return(queryResult);
        }
예제 #5
0
        public void DeleteFromRepository(PlantCode itemCode)
        {
            if (_repositoryContext.GetEntityDescriptor(itemCode) != null)
            {//if it exists in the db delete it from the db
                PlantEntities context = new PlantEntities(_rootUri);
                context.MergeOption = MergeOption.AppendOnly;
                context.IgnoreResourceNotFoundException = true;
                PlantCode deletedPlantCode = (from q in context.PlantCodes
                                              where q.PlantCodeID == itemCode.PlantCodeID
                                              select q).FirstOrDefault();
                if (deletedPlantCode != null)
                {
                    context.DeleteObject(deletedPlantCode);
                    context.SaveChanges();
                }
                context = null;

                _repositoryContext.MergeOption = MergeOption.AppendOnly;
                //if it is being tracked remove it...
                if (GetPlantCodeEntityState(itemCode) != EntityStates.Detached)
                {
                    _repositoryContext.Detach(itemCode);
                }
            }
        }
예제 #6
0
 private BindingList<PlantCode> GetPlantCodes(PlantCode itemCode, string companyID)
 {
     BindingList<PlantCode> itemCodeList = new BindingList<PlantCode>(_serviceAgent.GetPlantCodes(itemCode, companyID).ToList());
     Dirty = false;
     AllowCommit = false;
     return itemCodeList;
 }
예제 #7
0
 //PlantCode Object Scope Validation check the entire object for validity...
 private byte PlantCodeIsValid(PlantCode item, out string errorMessage)
 {   //validate key
     errorMessage = "";
     if (string.IsNullOrEmpty(item.PlantCodeID))
     {
         errorMessage = "ID Is Required.";
         return 1;
     }
     EntityStates entityState = GetPlantCodeState(item);
     if (entityState == EntityStates.Added && PlantCodeExists(item.PlantCodeID, ClientSessionSingleton.Instance.CompanyID))
     {
         errorMessage = "Item AllReady Exists.";
         return 1;
     }
     //check cached list for duplicates...
     int count = PlantCodeList.Count(q => q.PlantCodeID == item.PlantCodeID);
     if (count > 1)
     {
         errorMessage = "Item AllReady Exists.";
         return 1;
     }
     //validate Description
     if (string.IsNullOrEmpty(item.Description))
     {
         errorMessage = "Description Is Required.";
         return 1;
     }
     //a value of 2 is pending changes...
     //On Commit we will give it a value of 0...
     return 2;
 }
예제 #8
0
 public static object GetPropertyValue(this PlantCode myObj, string propertyName)
 {
     var propInfo = typeof(PlantCode).GetProperty(propertyName);
     if (propInfo != null)
         return propInfo.GetValue(myObj, null);
     else
         return string.Empty;
 }
예제 #9
0
 public static string GetPropertyCode(this PlantCode myObj, string propertyName)
 {
     var propInfo = typeof(PlantCode).GetProperty(propertyName);
     if (propInfo != null)
         return propInfo.PropertyType.Name.ToString();
     else
         return null;
 }
예제 #10
0
 private void SetAsEmptySelection()
 {
     SelectedPlantCode = new PlantCode();
     AllowEdit = false;
     AllowDelete = false;
     Dirty = false;
     AllowCommit = false;
     AllowRowCopy = false;
 }
예제 #11
0
 //udpate merely updates the repository a commit is required 
 //to commit it to the db...
 private bool Update(PlantCode item)
 {
     _serviceAgent.UpdatePlantCodeRepository(item);
     Dirty = true;
     if (CommitIsAllowed())
         AllowCommit = true;
     else
         AllowCommit = false;
     return AllowCommit;
 }
예제 #12
0
 public void UpdateRepository(PlantCode itemCode)
 {
     if (_repositoryContext.GetEntityDescriptor(itemCode) != null)
     {
         itemCode.LastModifiedBy        = XERP.Client.ClientSessionSingleton.Instance.SystemUserID;
         itemCode.LastModifiedByDate    = DateTime.Now;
         _repositoryContext.MergeOption = MergeOption.AppendOnly;
         _repositoryContext.UpdateObject(itemCode);
     }
 }
예제 #13
0
 public EntityStates GetPlantCodeEntityState(PlantCode itemCode)
 {
     if (_repositoryContext.GetEntityDescriptor(itemCode) != null)
     {
         return(_repositoryContext.GetEntityDescriptor(itemCode).State);
     }
     else
     {
         return(EntityStates.Detached);
     }
 }
예제 #14
0
 private void OnSearchResult(object sender, NotificationEventArgs<BindingList<PlantCode>> e)
 {
     if (e.Data != null && e.Data.Count > 0)
     {
         PlantCodeList = e.Data;
         SelectedPlantCode = PlantCodeList.FirstOrDefault();
         Dirty = false;
         AllowCommit = false;
     }
     UnregisterToReceiveMessages<BindingList<PlantCode>>(MessageTokens.PlantCodeSearchToken.ToString(), OnSearchResult);
 }
예제 #15
0
        public override int GetHashCode()
        {
            // Get the hash code for the Name field if it is not null.
            int hashProductName = PlantName == null ? 0 : PlantName.GetHashCode();

            // Get the hash code for the Code field.
            int hashProductCode = PlantCode.GetHashCode();

            // Calculate the hash code for the product.
            return(hashProductName ^ hashProductCode);
        }
예제 #16
0
 public void OnChangePlantTypes(PlantCode PlantCode, UpdateOperations operations)
 {
     if (operations == UpdateOperations.Delete)
     {//update a null to any place the Code was used by its parent record...
         XERP.Server.DAL.PlantDAL.DALUtility dalUtility = new DALUtility();
         var context = new PlantEntities(dalUtility.EntityConectionString);
         context.Plants.MergeOption = System.Data.Objects.MergeOption.NoTracking;
         string companyID = PlantCode.CompanyID;
         string codeID    = PlantCode.PlantCodeID;
         string sqlstring = "UPDATE Plants SET PlantCodeID = null WHERE CompanyID = '" + companyID + "' and PlantCodeID = '" + codeID + "'";
         context.ExecuteStoreCommand(sqlstring);
     }
 }
예제 #17
0
            private void AddCommand(string command, string unlessFollowing = null)
            {
                // add the command unless the last thing on the list is the second parameter
                // if it is, remove that entry and don't add the command
                if (unlessFollowing != null && PlantCode.LastOrDefault() == unlessFollowing)
                {
                    PlantCode.RemoveAt(PlantCode.Count - 1);
                    return;
                }

                Debug.WriteLine("----------------------------------");
                Debug.WriteLine(currentTitle);
                Debug.WriteLine("   " + command);
                PlantCode.Add(command);
            }
예제 #18
0
        public void DeletePlantCodeCommand()
        {
            try
            {//company is fk to 100's of tables deleting it can be tricky...
                int i = 0;
                int ii = 0;
                for (int j = SelectedPlantCodeList.Count - 1; j >= 0; j--)
                {
                    PlantCode item = (PlantCode)SelectedPlantCodeList[j];
                    //get Max Index...
                    i = PlantCodeList.IndexOf(item);
                    if (i > ii)
                        ii = i;
                    Delete(item);
                    PlantCodeList.Remove(item);
                }

                if (PlantCodeList != null && PlantCodeList.Count > 0)
                {
                    //back off one index from the max index...
                    ii = ii - 1;

                    //if they delete the first row...
                    if (ii < 0)
                        ii = 0;

                    //make sure it does not exceed the list count...
                    if (ii >= PlantCodeList.Count())
                        ii = PlantCodeList.Count - 1;

                    SelectedPlantCode = PlantCodeList[ii];
                    //we will only enable committ for dirty validated records...
                    if (Dirty == true)
                        AllowCommit = CommitIsAllowed();
                    else
                        AllowCommit = false;
                }
                else//only one record, deleting will result in no records...
                    SetAsEmptySelection();
            }//we try catch company delete as it may be used in another table as a key...
            //As well we will force a refresh to sqare up the UI after the botched delete...
            catch
            {
                NotifyMessage("PlantCode/s Can Not Be Deleted.  Contact XERP Admin For More Details.");
                Refresh();
            }
        }
예제 #19
0
        public bool Equals(Plant p)
        {
            // Check whether the compared object is null.
            if (Object.ReferenceEquals(p, null))
            {
                return(false);
            }

            // Check whether the compared object references the same data.
            if (Object.ReferenceEquals(this, p))
            {
                return(true);
            }

            // Check whether the products' properties are equal.
            return(PlantCode.Equals(p.PlantCode) && PlantName.Equals(p.PlantName));
        }
예제 #20
0
        public CodeSearchViewModel(IPlantServiceAgent serviceAgent)
        {
            this._serviceAgent = serviceAgent;

            SearchObject = new PlantCode();
            ResultList   = new BindingList <PlantCode>();
            SelectedList = new BindingList <PlantCode>();
            //make sure of session authentication...
            if (XERP.Client.ClientSessionSingleton.Instance.SessionIsAuthentic)//make sure user has rights to UI...
            {
                DoFormsAuthentication();
            }
            else
            {//User is not authenticated...
                RegisterToReceiveMessages <bool>(MessageTokens.StartUpLogInToken.ToString(), OnStartUpLogIn);
                FormIsEnabled = false;
                //we will do forms authentication once the log in returns a valid System User...
            }
        }
예제 #21
0
 private void Refresh()
 {//refetch current records...
     long selectedAutoID = SelectedPlantCode.AutoID;
     string autoIDs = "";
     //bool isFirstItem = true;
     foreach (PlantCode itemCode in PlantCodeList)
     {//auto seeded starts at 1 any records at 0 or less or not valid records...
         if (itemCode.AutoID > 0)
             autoIDs = autoIDs + itemCode.AutoID.ToString() + ",";
     }
     if (autoIDs.Length > 0)
     {
         //ditch the extra comma...
         autoIDs = autoIDs.Remove(autoIDs.Length - 1, 1);
         PlantCodeList = new BindingList<PlantCode>(_serviceAgent.RefreshPlantCode(autoIDs).ToList());
         SelectedPlantCode = (from q in PlantCodeList
                            where q.AutoID == selectedAutoID
                            select q).FirstOrDefault();
         Dirty = false;
         AllowCommit = false;
     }
 }
예제 #22
0
파일: Form1.cs 프로젝트: wolf99/PlantHire
        private void DeletePlant_Click(object sender, EventArgs e)
        {
            // Prompt the user if they're sure about deleting the record
            var m       = (Machine)Machines.Current;
            var message = string.Format("Are you sure you want to delete the following record\n{0}\n{1}\n{2}\n{3}\n{4}\n{5}",
                                        m.Code, m.DetailLn1, m.DetailLn2, m.DetailLn3, m.DetailLn4, m.DetailLn5);
            var result = MessageBox.Show(message, "Delete record", MessageBoxButtons.YesNo, MessageBoxIcon.Error);

            // Check the user's response
            if (result == DialogResult.Yes)
            {
                // Temporarily unbind BindingSource from DataGridView DataSource
                MachineDataGridView.DataSource = null;
                // Remove the item from the binding source
                Machines.Remove(m);
                // Rebind BindinSgource to DataGridView DataSource
                MachineDataGridView.DataSource = Machines;
                // Save the change to file
                UpdateCsvFile <Machine>(((SortableBindingList <Machine>)Machines.DataSource).ToList(), PlantCsvPath);
                // Refocus on the Code ComboBox
                PlantCode.Select();
            }
        }
예제 #23
0
        private bool NewPlantCode(string id)
        {
            PlantCode item = new PlantCode();
            //all new records will be give a negative int autoid...
            //when they are updated then sql will generate one for them overiding this set value...
            //it will allow us to give uniqueness to the tempory new records...
            //Before they are updated to the entity and given an autoid...
            //we use a negative number and keep subtracting by 1 for each new item added...
            //This will allow it to alwasy be unique and never interfere with SQL's positive autoid...
            _newPlantCodeAutoId = _newPlantCodeAutoId - 1;
            item.AutoID = _newPlantCodeAutoId;
            item.PlantCodeID = id;
            item.CompanyID = ClientSessionSingleton.Instance.CompanyID;
            item.IsValid = 1;
            item.NotValidMessage = "New Record Key Field/s Are Required.";
            PlantCodeList.Add(item);
            _serviceAgent.AddToPlantCodeRepository(item);
            SelectedPlantCode = PlantCodeList.LastOrDefault();

            AllowEdit = true;
            Dirty = false;
            return true;
        }
예제 #24
0
 //Object.Property Scope Validation...
 private bool PlantCodeIsValid(PlantCode item, _companyValidationProperties validationProperties, out string errorMessage)
 {
     errorMessage = "";
     switch (validationProperties)
     {
         case _companyValidationProperties.PlantCodeID:
             //validate key
             if (string.IsNullOrEmpty(item.PlantCodeID))
             {
                 errorMessage = "ID Is Required.";
                 return false;
             }
             EntityStates entityState = GetPlantCodeState(item);
             if (entityState == EntityStates.Added && PlantCodeExists(item.PlantCodeID, ClientSessionSingleton.Instance.CompanyID))
             {
                 errorMessage = "Item All Ready Exists...";
                 return false;
             }
             //check cached list for duplicates...
             int count = PlantCodeList.Count(q => q.PlantCodeID == item.PlantCodeID);
             if (count > 1)
             {
                 errorMessage = "Item All Ready Exists...";
                 return false;
             }
             break;
         case _companyValidationProperties.Name:
             //validate Description
             if (string.IsNullOrEmpty(item.Description))
             {
                 errorMessage = "Description Is Required.";
                 return false;
             }
             break;
     }
     return true;
 }
예제 #25
0
 public EntityStates GetPlantCodeEntityState(PlantCode itemCode)
 {
     return(PlantCodeSingletonRepository.Instance.GetPlantCodeEntityState(itemCode));
 }
예제 #26
0
 public void DeleteFromPlantCodeRepository(PlantCode itemCode)
 {
     PlantCodeSingletonRepository.Instance.DeleteFromRepository(itemCode);
 }
예제 #27
0
 public void AddToPlantCodeRepository(PlantCode itemCode)
 {
     PlantCodeSingletonRepository.Instance.AddToRepository(itemCode);
 }
예제 #28
0
 public void UpdatePlantCodeRepository(PlantCode itemCode)
 {
     PlantCodeSingletonRepository.Instance.UpdateRepository(itemCode);
 }
예제 #29
0
 public IEnumerable <PlantCode> GetPlantCodes(PlantCode itemCodeQuerryObject, string companyID)
 {
     return(PlantCodeSingletonRepository.Instance.GetPlantCodes(itemCodeQuerryObject, companyID));
 }
예제 #30
0
 public static void SetPropertyValue(this PlantCode myObj, object propertyName, object propertyValue)
 {
     var propInfo = typeof(PlantCode).GetProperty((string)propertyName);
     if (propInfo != null)
         propInfo.SetValue(myObj, propertyValue, null);
 }