private void initializeProdGridViewEvent()
{
removeDoubleClickEvent(mgrid);
mgrid.DoubleClick += (o, a) =>
{
if (mgrid.SelectedRows[0].Index != -1)
{
if (actServiceForSubEvents == FormMainServiceMode.PRODUCTSMANStripAct ||
actServiceForSubEvents == FormMainServiceMode.PRODUCTSMANStripHis)
{
int index = mgrid.SelectedRows[0].Index;
List <ProductFullRow> allList = productService.getFullListOfProductions();
ProductFullRow row = allList[index];
productsManageWindow = new FormServiceProductsWindow(row, ProductWindowPurpose.DETAILS, productService, mainWindow);
}
else if (actServiceForSubEvents == FormMainServiceMode.PRODUCTSMANQualiAct ||
actServiceForSubEvents == FormMainServiceMode.PRODUCTSMANQualiHis)
{
int index = mgrid.SelectedRows[0].Index;
List <ProductQualityPart> partList = productService.getPartListOfProductions();
ProductQualityPart row = partList[index];
productsManageWindow = new FormServiceProductsWindow(row, ProductWindowPurpose.DETAILS, productService, mainWindow);
}
}
};
}
/// <summary>
/// fills up the details from record-container to show in fields in case Quality managing
/// </summary>
/// <param name="prod">data-carrier QualityPart</param>
private void fillUpQualityFieldsToModifyDeletUndelet(ProductQualityPart prod)
{
txtbName.Text = prod.productName;
txtbSaftySh.Text = prod.productSheet;
txtbQuantUn.Text = prod.productQantUnit;
txtbDanger.Text = Convert.ToString(prod.productDanger);
txtbDescr.Text = prod.productDescr;
fillAndAdjustSubcontr(prod.productSubcontr);
indexProd = prod.productQualId;
dataActOrHis = prod.productValidity;
sheetNameTemp = prod.productSheet;
if (!dataActOrHis)
{
lblInfos.Text += "Töröve!\n";
}
if (prod.productModifiedThen != "0")
{
lblInfos.Text += "Utolsó módosítás: " + prod.productModifiedThen + "\n";
}
if (prod.productModifiedBy != 0)
{
lblInfos.Text += "Végrehajtotta: " + serviceProducts.getWhoModifiedTheRecord(prod.productModifiedBy);
}
}
private void setTheNewBtn1ProdEvents()
{
removeClickEvent((Button)btn1);
btn1.Click += (e, a) => {
if (mgrid.SelectedRows[0].Index != -1)
{
try
{
if (actServiceForSubEvents == FormMainServiceMode.PRODUCTSMANQualiAct)
{
int indexFromGrid = mgrid.SelectedRows[0].Index;
int recId = (int)mgrid.Rows[indexFromGrid].Cells[0].Value;
ProductQualityPart row = productService.getPartContainerOfChosenProductions(recId);
row.productValidity = true;
productsManageWindow = new FormServiceProductsWindow(row,
ProductWindowPurpose.BRANDNEWSTRIPPING, productService, mainWindow);
}
if (actServiceForSubEvents == FormMainServiceMode.PRODUCTSMANStripAct) //normal show details of quantity
{
//create new ordering record is needed - case of ProdMode StripAct
}
}
catch (ErrorServiceProd k)
{
errorHandle(k.Message);
}
catch (Exception k)
{
errorHandle("Ismeretlen hiba történt (ContrMainProdBtn1) " + k.Message);
}
}
};
}
private void setTheNewBtn5ProdEvents()
{
removeClickEvent((Button)btn5);
btn5.Click += (e, a) => {
if (mgrid.SelectedRows[0].Index != -1)
{
try
{
int indexFromGrid = mgrid.SelectedRows[0].Index;
int recIdentif = (int)mgrid.Rows[indexFromGrid].Cells[0].Value;
if (actServiceForSubEvents == FormMainServiceMode.PRODUCTSMANStripAct ||
actServiceForSubEvents == FormMainServiceMode.PRODUCTSMANStripHis)
{
ProductFullRow row = productService.getFullistContainerOfProduction(recIdentif);
productsManageWindow = new FormServiceProductsWindow(row, ProductWindowPurpose.DETAILS, productService, mainWindow);
}
else if (actServiceForSubEvents == FormMainServiceMode.PRODUCTSMANQualiAct ||
actServiceForSubEvents == FormMainServiceMode.PRODUCTSMANQualiHis)
{
ProductQualityPart row = productService.getPartContainerOfChosenProductions(recIdentif);
productsManageWindow = new FormServiceProductsWindow(row, ProductWindowPurpose.DETAILS, productService, mainWindow);
}
}
catch (ErrorServiceProd w)
{
errorHandle(w.Message);
}
catch (Exception w)
{
errorHandle("Ismeretlen hiba történt (ContrMainGrid) " + w.Message);
}
}
};
}
private void setTheNewBtn2ProdEvents()
{
removeClickEvent((Button)btn2);
btn2.Click += (e, a) => {
if (mgrid.SelectedRows[0].Index != -1)
{
try
{
if (actServiceForSubEvents == FormMainServiceMode.PRODUCTSMANStripAct) //creates new (act) strippingRecord
{
int indexFromGrid = mgrid.SelectedRows[0].Index;
int stripId = (int)mgrid.Rows[indexFromGrid].Cells[0].Value;
ProductFullRow row = productService.getFullistContainerOfProduction(stripId);
row.productValidity = true;
productsManageWindow = new FormServiceProductsWindow(row, ProductWindowPurpose.NEW, productService, mainWindow);
}
if (actServiceForSubEvents == FormMainServiceMode.PRODUCTSMANQualiAct) //creates new (act) qualRecord
{
ProductQualityPart row = new ProductQualityPart();
row.productValidity = true;
productsManageWindow = new FormServiceProductsWindow(row, ProductWindowPurpose.NEW, productService, mainWindow);
}
}
catch (ErrorServiceProd k)
{
errorHandle(k.Message);
}
catch (Exception k)
{
errorHandle("Ismeretlen hiba történt (ContrMainProdBtn2) " + k.Message);
}
}
};
}
private void setTheNewBtn3ProdEvents()
{
removeClickEvent((Button)btn3);
btn3.Click += (e, a) => {
if (mgrid.SelectedRows[0].Index != -1)
{
try
{
int indexFromGrid = mgrid.SelectedRows[0].Index;
int recIdentif = (int)mgrid.Rows[indexFromGrid].Cells[0].Value;
if (actServiceForSubEvents == FormMainServiceMode.PRODUCTSMANQualiAct) //modify the active qualRec
{
ProductQualityPart row = productService.getPartContainerOfChosenProductions(recIdentif);
productsManageWindow = new FormServiceProductsWindow(row, ProductWindowPurpose.MODIFY, productService, mainWindow);
}
if (actServiceForSubEvents == FormMainServiceMode.PRODUCTSMANStripAct) //modify the active quantRec
{
ProductFullRow row = productService.getFullistContainerOfProduction(recIdentif);
productsManageWindow = new FormServiceProductsWindow(row, ProductWindowPurpose.MODIFY, productService, mainWindow);
}
}
catch (ErrorServiceProd k)
{
errorHandle(k.Message);
}
catch (Exception k)
{
errorHandle("Ismeretlen hiba történt (ContrMainProdBtn3) " + k.Message);
}
}
};
}
/// <summary>
/// modify a record in 'raktminoseg' table with ProductPartRow - index the definiton which
/// </summary>
/// <param name="modif">set of ProductPartElement with the new paramteres, index is remains!</param>
public void modifyProdQualityRecord(ProductQualityPart modif, string userId)
{
try
{
parameters = new List <KeyValuePair <string, string> >();
KeyValuePair <string, string> id = new KeyValuePair <string, string>("@termekId", modif.productIndex.ToString());
KeyValuePair <string, string> name = new KeyValuePair <string, string>("@nev", modif.productName);
KeyValuePair <string, string> subcon = new KeyValuePair <string, string>("@beszallito", modif.productSubcontr);
KeyValuePair <string, string> descr = new KeyValuePair <string, string>("@leiras", modif.productDescr);
KeyValuePair <string, string> unit = new KeyValuePair <string, string>("@menyegyseg", modif.productQantUnit);
KeyValuePair <string, string> sheet = new KeyValuePair <string, string>("@adatlap", modif.productSheet);
KeyValuePair <string, string> dange = new KeyValuePair <string, string>("@veszely", modif.productDanger.ToString());
KeyValuePair <string, string> who = new KeyValuePair <string, string>("@userId", userId);
parameters.Add(id);
parameters.Add(name);
parameters.Add(subcon);
parameters.Add(descr);
parameters.Add(unit);
parameters.Add(sheet);
parameters.Add(dange);
parameters.Add(who);
}
catch (Exception e)
{
throw new ErrorServiceUpdateRecord("Adatbátzis felé a kérés megalkotása sikertelen (ModProdQualModRec): " + e.Message);
}
mdi.openConnection();
mdi.execPrepDMQueryWithKVPList(queryProductsModifyRowQuality, parameters, 8);
mdi.closeConnection();
}
public FormServiceProductsWindow(ProductQualityPart prod, ProductWindowPurpose mode,
ServiceProducts serviceOfProd, Form parentMain)
{
InitializeComponent();
this.modeTheWindow = mode;
this.parentMainWindow = parentMain;
controllerProductsWindow = new ServiceProductsWinController(serviceOfProd, mode, this);
controllerProductsWindow.sendTheQualityData(prod);
parentMain.Hide();
this.Show();
}
/// <summary>
/// make change in raktminoseg - modify the spec. record
/// ProdPartRow - the productIndex musn't change!
/// </summary>
/// <param name="row">record content, that is needed to change</param>
public void setModifyRecProdQuality(ProductQualityPart row)
{
try
{
modelQualities = new ProductsModelQualityTable(dbci, parent);
modelQualities.modifyProdQualityRecord(row, userId);
}
catch (ErrorServiceUpdateRecord e)
{
errorHandle(e.Message);
}
}
/// <summary>
/// make change in raktminoseg - create new record - some value is emty! productIndex as well
/// name; subcontr; descr; unit;
/// </summary>
/// <param name="row">the spec datas to sotre in DB</param>
public void setNewRecProdQuality(ProductQualityPart row)
{
try
{
modelQualities = new ProductsModelQualityTable(dbci, parentMain);
modelQualities.createNewProdQualityRecord(row, userId);
}
catch (ErrorServiceNewRecord e)
{
throw new ErrorServiceProd(e.Message);
}
}
/// <summary>
/// adjust the elements of this form - depending of the purpose mode of this in case Quality managing
/// </summary>
/// <param name="prod">product in treat - QualityPart type</param>
public void buildTheStarterQuality(ProductQualityPart prod)
{
if (typeOfDataManaging == ProductWindowPurpose.NEW)
{
fillUpNewProdQuality();
btnOk.Text = "Bejegyzés";
btnOk.Style = MetroFramework.MetroColorStyle.Purple;
lblMain.Text += " - Új termék";
fieldsToQualityNewModify();
}
else if (typeOfDataManaging == ProductWindowPurpose.MODIFY)
{
fillUpQualityFieldsToModifyDeletUndelet(prod);
btnOk.Text = "Módosítás";
btnOk.Style = MetroFramework.MetroColorStyle.Purple;
lblMain.Text += " - Termék módosítása";
fieldsToQualityNewModify();
}
else if (typeOfDataManaging == ProductWindowPurpose.DELETE)
{
fillUpQualityFieldsToModifyDeletUndelet(prod);
btnOk.Text = "Tőrlés";
btnOk.Style = MetroFramework.MetroColorStyle.Red;
lblMain.Text += " - Termék törlése";
fieldsToQualityDeletUndeletDetails();
}
else if (typeOfDataManaging == ProductWindowPurpose.UNDELETE)
{
fillUpQualityFieldsToModifyDeletUndelet(prod);
btnOk.Text = "Visszaállítás";
btnOk.Style = MetroFramework.MetroColorStyle.Purple;
lblMain.Text += " - Termék visszaállítása";
fieldsToQualityDeletUndeletDetails();
}
else if (typeOfDataManaging == ProductWindowPurpose.DETAILS)
{
fillUpQualityFieldsToModifyDeletUndelet(prod);
btnOk.Visible = false;
lblMain.Text += " - Termék részletei";
fieldsToQualityDeletUndeletDetails();
}
else if (typeOfDataManaging == ProductWindowPurpose.BRANDNEWSTRIPPING)
{
fillUpQualityFieldsToModifyDeletUndelet(prod);
btnOk.Text = "Új kiszerelés";
btnOk.Style = MetroFramework.MetroColorStyle.Brown;
lblMain.Text += " - Új kiszerelés létrehozása";
fieldsToBrandNewStripping();
}
}
/// <summary>
/// collects the datas from fields of case quality managing
/// </summary>
public void collectAllDatasQuality()
{
tempOfCangesQuality = new ProductQualityPart();
tempOfCangesQuality.productName = txtbName.Text;
tempOfCangesQuality.productSubcontr = cmbbSubcontr.SelectedItem.ToString();
tempOfCangesQuality.productDescr = txtbDescr.Text;
tempOfCangesQuality.productDanger = Convert.ToInt32(txtbDanger.Text);
tempOfCangesQuality.productSheet = txtbSaftySh.Text;
tempOfCangesQuality.productQantUnit = txtbQuantUn.Text;
if (typeOfDataManaging == ProductWindowPurpose.NEW)
{
tempOfCangesQuality.productIndex = 0; //validity automaticly created true
}
else
{
tempOfCangesQuality.productIndex = indexProd;
tempOfCangesQuality.productValidity = true; //in case reactivate
}
}
/// <summary>
/// part of the product list collector - saves each row
/// </summary>
/// <param name="record">string[] of a record</param>
/// <returns>datas in a single product-element</returns>
private ProductQualityPart recordToListProdPartElem(string[] record)
{
ProductQualityPart row = new ProductQualityPart();
row.productName = record[0]; //name
row.productSubcontr = record[1]; //subcontr
row.productDescr = record[2]; //description
row.productQantUnit = record[3]; //quantity unit
row.productSheet = record[4]; //datasheet
row.productDanger = Convert.ToInt32(record[5]); //danger number
row.productQualId = Convert.ToInt32(record[6]); //index of table (prim.key)
row.productModifiedBy = Convert.ToInt32(record[7]); //user_id of profile
row.productModifiedThen = record[8]; //when changed the record
row.productValidity = record[9] == "1"? true : false; //is it activ or passive
/*if (record[9] == "1")
* row.productValidity = true;
* else
* row.productValidity = false;*/
return(row);
}
private void setTheNewBtn1ProdEvents()
{
removeClickEvent((Button)btn1);
btn1.Click += (e, a) => {
if (mgrid.SelectedRows[0].Index != -1)
{
if (actServiceForSubEvents == FormMainServiceMode.PRODUCTSMANQualiAct)
{
int index = mgrid.SelectedRows[0].Index;
List <ProductQualityPart> productsPartList = productService.getPartListOfProductions();
ProductQualityPart row = productsPartList[index];
row.productValidity = true;
productsManageWindow = new FormServiceProductsWindow(row, ProductWindowPurpose.BRANDNEWSTRIPPING, productService, mainWindow);
}
if (actServiceForSubEvents == FormMainServiceMode.PRODUCTSMANStripAct) //normal show details of quantity
{
//create new ordering record is needed - case of ProdMode StripAct
}
}
};
}
private void setTheNewBtn2ProdEvents()
{
removeClickEvent((Button)btn2);
btn2.Click += (e, a) => {
if (actServiceForSubEvents == FormMainServiceMode.PRODUCTSMANStripAct) //creates new (act) strippingRecord
{
if (mgrid.SelectedRows[0].Index != -1)
{
int index = mgrid.SelectedRows[0].Index;
List <ProductFullRow> productsFullList = productService.getFullListOfProductions();
ProductFullRow row = productsFullList[index];
row.productValidity = true;
productsManageWindow = new FormServiceProductsWindow(row, ProductWindowPurpose.NEW, productService, mainWindow);
}
}
if (actServiceForSubEvents == FormMainServiceMode.PRODUCTSMANQualiAct) //creates new (act) qualRecord
{
ProductQualityPart row = new ProductQualityPart();
row.productValidity = true;
productsManageWindow = new FormServiceProductsWindow(row, ProductWindowPurpose.NEW, productService, mainWindow);
}
};
}
private void setTheNewBtn3ProdEvents()
{
removeClickEvent((Button)btn3);
btn3.Click += (e, a) => {
if (mgrid.SelectedRows[0].Index != -1)
{
if (actServiceForSubEvents == FormMainServiceMode.PRODUCTSMANQualiAct) //modify the active qualRec
{
int index = mgrid.SelectedRows[0].Index;
List <ProductQualityPart> productsFullList = productService.getPartListOfProductions();
ProductQualityPart row = productsFullList[index];
productsManageWindow = new FormServiceProductsWindow(row, ProductWindowPurpose.MODIFY, productService, mainWindow);
}
if (actServiceForSubEvents == FormMainServiceMode.PRODUCTSMANStripAct) //modify the active quantRec
{
int index = mgrid.SelectedRows[0].Index;
List <ProductFullRow> productsFullList = productService.getFullListOfProductions();
ProductFullRow row = productsFullList[index];
productsManageWindow = new FormServiceProductsWindow(row, ProductWindowPurpose.MODIFY, productService, mainWindow);
}
}
};
}
private void setTheNewBtn4ProdEvents()
{
removeClickEvent((Button)btn4);
btn4.Click += (e, a) => {
if (mgrid.SelectedRows[0].Index != -1)
{
if (actServiceForSubEvents == FormMainServiceMode.PRODUCTSMANQualiAct) //delete activeQualRec
{
int index = mgrid.SelectedRows[0].Index;
List <ProductQualityPart> productsFullList = productService.getPartListOfProductions();
ProductQualityPart row = productsFullList[index];
productsManageWindow = new FormServiceProductsWindow(row, ProductWindowPurpose.DELETE, productService, mainWindow);
}
else if (actServiceForSubEvents == FormMainServiceMode.PRODUCTSMANQualiHis) //react passtiveQualRec
{
int index = mgrid.SelectedRows[0].Index;
List <ProductQualityPart> productsFullList = productService.getPartListOfProductions();
ProductQualityPart row = productsFullList[index];
productsManageWindow = new FormServiceProductsWindow(row, ProductWindowPurpose.UNDELETE, productService, mainWindow);
}
else if (actServiceForSubEvents == FormMainServiceMode.PRODUCTSMANStripAct) //delete activeQuantRec
{
int index = mgrid.SelectedRows[0].Index;
List <ProductFullRow> productsFullList = productService.getFullListOfProductions();
ProductFullRow row = productsFullList[index];
productsManageWindow = new FormServiceProductsWindow(row, ProductWindowPurpose.DELETE, productService, mainWindow);
}
else if (actServiceForSubEvents == FormMainServiceMode.PRODUCTSMANStripHis) //react passiveQuantRec
{
int index = mgrid.SelectedRows[0].Index;
List <ProductFullRow> productsFullList = productService.getFullListOfProductions();
ProductFullRow row = productsFullList[index];
productsManageWindow = new FormServiceProductsWindow(row, ProductWindowPurpose.UNDELETE, productService, mainWindow);
}
}
};
}
public void sendTheQualityData(ProductQualityPart prod)
{
typeOfInformationIsThreathing = false;
buildTheStarterQuality(prod);
}