/// <summary>
/// reads in the pool of strippings, that a chosen product has
/// </summary>
/// <param name="termekId">the target product name</param>
/// <returns>DB id of tha targeted product</returns>
public List <StrippingToChoose> getThePoolOfStrippings(string termekId)
{
KeyValuePair <string, string> param = new KeyValuePair <string, string>("@productMinId", termekId);
mdi.openConnection();
List <string[]> result = mdi.execPrepQueryInListStringArrWithKVP
(queryReadingInTheStrippingOfTheChosenProductToRenewAcitveRequest, param);
mdi.closeConnection();
List <StrippingToChoose> rows = new List <StrippingToChoose>();
try
{
foreach (string[] arr in result)
{
StrippingToChoose strip = new StrippingToChoose();
strip.termekKiszerel = Convert.ToInt32(arr[0]);
strip.termekQuantId = Convert.ToInt32(arr[1]);
strip.termekHely = arr[2];
rows.Add(strip);
}
}
catch (Exception e)
{
throw new ErrorServiceRequOrderGetTheStripPool
("Az adott termék kiszereléseinek betöltése sikertelen (ModReqStrPool) " + e.Message);
}
return(rows);
}
/// <summary>
/// start to indentify the user - must be the first query step
/// </summary>
/// <param name="parent">LoginWindow</param>
/// <param name="userName">given name by user</param>
/// <param name="userPwd">given password by user</param>
/// <returns></returns>
public string checkDBForThisUser(string userName)
{
try
{
param = new KeyValuePair <string, string>("@userName", userName);
}
catch (Exception e)
{
throw new ErrorServiceLoginDBAccess("A lekérdezés összeállítása sikertelen (ModLoginUserSeek) " + e.Message);
}
mdi.openConnection();
List <string[]> resultIdentify = mdi.execPrepQueryInListStringArrWithKVP(queryOfUserIdentify, param);
mdi.closeConnection();
if (resultIdentify.Count == 1)
{
userId = resultIdentify[0][0];
return(hashedPwd = resultIdentify[0][1]);
}
else if (resultIdentify.Count == 0)
{
throw new ErrorServiceLoginDBAccess("Nem megfelelő felhasználónév vagy jelszó");
}
else
{
throw new ErrorServiceLoginDBAccess("Az adatbázis sérült, több találat is érkezett (ModLoginUserSeek)");
}
}
/// <summary>
/// gets the accident of the specified user
/// </summary>
/// <param name="userId">userId in DB of the user</param>
/// <returns></returns>
public List <string[]> getUserConnectedAccidents(string userId)
{
List <string[]> result;
try
{
param = new KeyValuePair <string, string>("userId", userId);
}
catch (Exception e)
{
throw new ErrorServiceProfileDetailsManage("Az adatbázis felé a kérés megalkotása sikertelen (ModPersonAccid) "
+ e.Message);
}
mdi.openConnection();
result = mdi.execPrepQueryInListStringArrWithKVP(queryToGetAccidentsOfUser, param);
mdi.closeConnection();
return(result);
}
/// <summary>
/// gets the list of OrderingCancelled to show them the user
/// </summary>
/// <returns>list of OrderingCancelled</returns>
public List <OrderingCancelled> getListOfCancelledOrderings()
{
List <OrderingCancelled> listCancelled = new List <OrderingCancelled>();
KeyValuePair <string, string> param = new KeyValuePair <string, string>("@erveny", "0");
mdi.openConnection();
List <string[]> rows = mdi.execPrepQueryInListStringArrWithKVP(
queryForReadInRecords, param);
mdi.closeConnection();
try
{
foreach (string[] rec in rows)
{
listCancelled.Add(convertCancelledOrdering(rec));
}
}
catch (Exception e)
{
throw new ErrorOrderingGetTheCancelledPool("A visszavont rendelések adatlista megalkotása sikertelen (ModOrdNorm) " + e.Message);
}
return(listCancelled);
}