public void UpdateSupplierAndSalesAssistantInDB(ClassSupplier cs, ClassSalesAssistant csa)
{
try
{
FunctionExecuteStoredProcedures("UpdateSupplierAndSalesAssistant", "@supplierid", cs.id.ToString(), "@businessName", cs.businessName, "@address", cs.address, "@zip", cs.zipAndCity.Substring(0, cs.zipAndCity.LastIndexOf(" - ")), "@country", cs.country, "@supplierPhone", cs.phone, "@supplierMail", cs.mail, "@status", cs.status.ToString(), "@saID", cs.salesAssistantId.ToString(), "@name", csa.saName, "@phone", csa.saPhone, "@directPhone", csa.saDirectPhone, "@directMail", csa.saDirectMail);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Fejl i DB kommunikationen", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public ClassSalesAssistant GetSalesAssistant(string saID)
{
ClassSalesAssistant csa = new ClassSalesAssistant();
DataTable dt = FunctionExecuteStoredProcedures("GetSalesAssistant", "@saID", saID);
foreach (DataRow row in dt.Rows)
{
csa = new ClassSalesAssistant(Convert.ToInt32(row["id"]),
row["name"].ToString(),
row["directMail"].ToString(),
row["directPhone"].ToString(),
row["phone"].ToString());
}
return(csa);
}
/// <summary>
/// Resetter ClassSupplier og ClassSalesAssistant, så de er klar til at få ny data ind
/// </summary>
public void ClearGrainSupplierData()
{
CS = new ClassSupplier();
CSA = new ClassSalesAssistant();
}
