/// <summary>
 /// create new reocord in 'raktmennyiseg' table
 /// </summary>
 /// <param name="modif">set of ProductionPartRow is needed to create</param>
 public void createNewProdQuantityRecord(ProductStrippingPart newRow, string userId)
 {
     try
     {
         parameters = new List <KeyValuePair <string, string> >();
         KeyValuePair <string, string> recordId  = new KeyValuePair <string, string>("@termekId", newRow.productIndex.ToString());
         KeyValuePair <string, string> barcode   = new KeyValuePair <string, string>("@kod", newRow.productBarcode);
         KeyValuePair <string, string> stripping = new KeyValuePair <string, string>("@kiszerel", newRow.productStripping.ToString());
         KeyValuePair <string, string> quantity  = new KeyValuePair <string, string>("@mennyi", newRow.productQuantity.ToString());
         KeyValuePair <string, string> placeing  = new KeyValuePair <string, string>("@hely", newRow.productPlace);
         KeyValuePair <string, string> who       = new KeyValuePair <string, string>("@userId", userId);
         parameters.Add(recordId);
         parameters.Add(barcode);
         parameters.Add(stripping);
         parameters.Add(quantity);
         parameters.Add(placeing);
         parameters.Add(who);
     }
     catch (Exception e)
     {
         throw new ErrorServiceNewRecord("Adatbátzis felé a kérés megalkotása sikertelen (ModProdQualNewRec): " + e.Message);
     }
     mdi.openConnection();
     mdi.execPrepDMQueryWithKVPList(queryProductsNewRowQuantity, parameters, 6);
     mdi.closeConnection();
 }
        /// <summary>
        /// modify a record in 'raktmennyiseg' table with ProductPartRow - index the definiton which
        /// </summary>
        /// <param name="modifRow">set of ProductPartElement with the new paramteres, index is remains!</param>
        public void modifyProdQuantityRecord(ProductStrippingPart modifRow, string oldStr, string userId)
        {
            try
            {
                parameters = new List <KeyValuePair <string, string> >();

                KeyValuePair <string, string> barcode        = new KeyValuePair <string, string>("@kod", modifRow.productBarcode);
                KeyValuePair <string, string> newStrip       = new KeyValuePair <string, string>("@ujKiszerel", modifRow.productStripping.ToString());
                KeyValuePair <string, string> quantity       = new KeyValuePair <string, string>("@mennyiseg", modifRow.productQuantity.ToString());
                KeyValuePair <string, string> recordId       = new KeyValuePair <string, string>("@termekId", modifRow.productIndex.ToString());
                KeyValuePair <string, string> recordOldStrip = new KeyValuePair <string, string>("@regiKiszerel", oldStr);
                KeyValuePair <string, string> placeing       = new KeyValuePair <string, string>("@hely", modifRow.productPlace);
                KeyValuePair <string, string> who            = new KeyValuePair <string, string>("@userId", userId);
                parameters.Add(barcode);
                parameters.Add(newStrip);
                parameters.Add(quantity);
                parameters.Add(recordId);
                parameters.Add(placeing);
                parameters.Add(recordOldStrip);
                parameters.Add(who);
            }
            catch (Exception e)
            {
                throw new ErrorServiceUpdateRecord("Adatbátzis felé a kérés megalkotása sikertelen (ModProdModRec): " + e.Message);
            }
            mdi.openConnection();
            mdi.execPrepDMQueryWithKVPList(queryProductsModifyRowQuantity, parameters, 7);
            mdi.closeConnection();
        }
Beispiel #3
0
 /// <summary>
 /// collects the datas from fields of case quantity managing
 /// </summary>
 public void collectAllDatasOfStripping()
 {
     tempOfChangesStripping = new ProductStrippingPart();
     tempOfChangesStripping.productBarcode   = txtbBarcode.Text;
     tempOfChangesStripping.productPlace     = txtbPlace.Text;
     tempOfChangesStripping.productQuantity  = Convert.ToInt32(txtbQuan.Text);
     tempOfChangesStripping.productStripping = Convert.ToInt32(txtbStripping.Text);
     tempOfChangesStripping.productIndex     = indexProd;
     tempOfChangesStripping.productValidity  = true;    //in case reactivate
 }
 /// <summary>
 /// makes a change in 'raktmennyiseg' table, modify a record
 /// by the original indexer and original stripping
 /// the indexer mustn't changes!
 /// </summary>
 /// <param name="row">the content of record with new parameters</param>
 /// <param name="oldStripping">the old stripping of the record</param>
 public void setModifyRecProdQuantity(ProductStrippingPart row, string oldStripping)
 {
     try
     {
         modelQuantities = new ProductsModelStrippingTable(dbci, parent);
         modelQuantities.modifyProdQuantityRecord(row, oldStripping, userId);
     }
     catch (Exception e)
     {
         errorHandle(e.Message);
     }
 }
 /// <summary>
 /// makes a change in 'raktmennyiseg' table, creates a new record
 /// </summary>
 /// <param name="row">the recors is needed to create</param>
 public void setNewRecProdQuantity(ProductStrippingPart row)
 {
     try
     {
         modelQuantities = new ProductsModelStrippingTable(dbci, parent);
         modelQuantities.createNewProdQuantityRecord(row, userId);
     }
     catch (Exception e)
     {
         errorHandle(e.Message);
     }
 }
Beispiel #6
0
 /// <summary>
 /// makes a change in 'raktmennyiseg' table, modify a record
 /// by the original indexer and original stripping
 /// the indexer mustn't changes!
 /// </summary>
 /// <param name="row">the content of record with new parameters</param>
 /// <param name="oldStripping">the old stripping of the record</param>
 public void setModifyRecProdQuantity(ProductStrippingPart row, string oldStripping)
 {
     try
     {
         modelQuantities = new ProductsModelStrippingTable(dbci, parentMain);
         modelQuantities.modifyProdQuantityRecord(row, oldStripping, userId);
     }
     catch (ErrorServiceUpdateRecord e)
     {
         throw new ErrorServiceProd(e.Message);
     }
 }
Beispiel #7
0
 /// <summary>
 /// makes a change in 'raktmennyiseg' table, creates a new record
 /// </summary>
 /// <param name="row">the recors is needed to create</param>
 public void setNewRecProdQuantity(ProductStrippingPart row)
 {
     try
     {
         modelQuantities = new ProductsModelStrippingTable(dbci, parentMain);
         modelQuantities.createNewProdQuantityRecord(row, userId);
     }
     catch (ErrorServiceNewRecord e)
     {
         throw new ErrorServiceProd(e.Message);
     }
 }