public UserControlUpdateMetalPrice(ClassBIZ CB)
{
InitializeComponent();
ClassCustomer CC = new ClassCustomer();
MainMetalGrid.DataContext = CB;
}
/// <summary>
/// Denne metode henter alt dataen fra Databasens table "Customer" plus lidt fra tablet
/// "ArtTrade" og laver det om til en liste af ClassCustomer's
/// </summary>
/// <param name="inCurrency"></param>
/// <returns></returns>
public List <ClassCustomer> GetAllCustomerFromDB(ClassCurrency inCurrency)
{
List <ClassCustomer> listCCres = new List <ClassCustomer>();
SqlCommand cmd = new SqlCommand();
cmd.Connection = con;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "spGetAllCustomerFromDB";
DataTable dataTable = MakeCallToStoredProcedure(cmd);
foreach (DataRow row in dataTable.Rows)
{
ClassCustomer customer = new ClassCustomer();
customer.customerID = Convert.ToInt32(row["id"]);
customer.name = row["name"].ToString();
customer.address = row["address"].ToString();
customer.zipCity = row["zipCity"].ToString();
customer.country = row["country"].ToString();
customer.email = row["email"].ToString();
customer.phoneNo = row["phone"].ToString();
customer.classSalesValue.bidUSD = row["maximumBid"].ToString();
customer.customerCurrencyID = row["preferredCurrency"].ToString();
customer.isActive = Convert.ToBoolean(row["isActive"]);
listCCres.Add(customer);
}
return(listCCres);
}
private void LoadData()
{
CustomerEN[] CustomerENs = null;
//DataTable dt = ClassJopPosition.LoadDept();
ClassCustomer.LoadData(out CustomerENs);
if (CustomerENs != null && CustomerENs.Any())
{
divCustormerDetail.Visible = false;
dgSearch.Visible = true;
ss_CustomerEN = CustomerENs;
dgSearch.DataSource = CustomerENs;
dgSearch.DataBind();
mode = Enum_Mode.Edit.GetHashCode();
btnAdd.Attributes.Add("style", "display;");
btnCencel.Attributes.Add("style", "display:none;");
btnSave.Attributes.Add("style", "display:none;");
btnDelete.Attributes.Add("style", "display:none;");
}
else
{
btnAdd.Attributes.Add("style", "display:none;");
btnCencel.Attributes.Add("style", "display:none;");
btnSave.Attributes.Add("style", "display;");
btnDelete.Attributes.Add("style", "display:none;");
mode = Enum_Mode.Add.GetHashCode();
divCustormerDetail.Visible = true;
dgSearch.Visible = false;
}
}
private void ComboBox_SelectionChanged_1(object sender, SelectionChangedEventArgs e)
{
ComboBox comb = (ComboBox)sender;
ClassCustomer classCustomer = (ClassCustomer)comb.SelectedItem;
classCustomer.classCurrency = CB.classCurrency;
CB.classCustomer = classCustomer;
}
private void ComboBox_SelectionChanged_1(object sender, SelectionChangedEventArgs e)
{
ComboBox comb = (ComboBox)sender;
ClassCustomer classCustomer = (ClassCustomer)comb.SelectedItem;
ClassSalesValues csv = new ClassSalesValues();
csv.classCurrency = CB.classCurrency;
CB.classCustomer = classCustomer;
}
public ClassBiz()
{
classCurrency = new ClassCurrency();
GetAllCurrencyIdAndNames();
classCustomer = new ClassCustomer();
classCustomer.classCurrency = classCurrency;
listCustomer = classWorldArtSaleDB.GetAllCustomerFromDB(classCurrency);
listClassArt = classWorldArtSaleDB.GetAllArtFromDB();
}
public void SaveCustomerToDB()
{
using (ClassContext ccx = new ClassContext())
{
classCustomer.customerCurrencyID = "DKK";
ccx.classCustomer.AddOrUpdate(classCustomer);
ccx.SaveChanges();
}
classCustomer = new ClassCustomer();
listCustomer.Clear();
//getallcustomers();
}
public ClassBIZ()
{
selectedCurrency = new ClassCurrency();
selectedCustomer = new ClassCustomer();
selectedArt = new ClassArt();
listClassArt = new List <ClassArt>();
listCustomer = new List <ClassCustomer>();
Task.Run(async() => await StartCurrencyApiCall());
classFile.ReadDataFromCurrencyFile();
listCustomer = classDB.GetAllCustomerFromDB(selectedCurrency);
listClassArt = classDB.GetAllArtFromDB();
}
protected void btnDelete_Click(object sender, EventArgs e)
{
string C_ID = this.txtC_ID.Text;
ResultEN ResultENs = ClassCustomer.Delete(C_ID);
if (ResultENs != null && ResultENs.result)
{
LoadData();
set();
}
else
{
}
}
protected void Page_Load(object sender, EventArgs e)
{
ClassCustomer generateCusId = new ClassCustomer();
txCustomerId.Text = generateCusId.GenerateCustomerId();
ClassAddresses generateAddId = new ClassAddresses();
txNewAddressId.Text = generateAddId.GenerateAddressId();
btnUpdate.CssClass = "btn btn-warning disabled";
btnDelete.CssClass = "btn btn-danger disabled";
btnAddress.CssClass = "btn btn-primary disabled";
}
protected void GridViewCustomers_SelectedIndexChanged(object sender, EventArgs e)
{
ClassCustomer loadData = new ClassCustomer();
loadData.LoadCustomerUpdateData(this);
ClassAddresses loadAddress = new ClassAddresses();
loadAddress.ViewAddress(this);
btnUpdate.CssClass = "btn btn-warning";
btnDelete.CssClass = "btn btn-danger";
btnAddress.CssClass = "btn btn-primary";
lblDeleteCustomerId.Text = GridViewCustomers.SelectedRow.Cells[1].Text;
lblDeleteCustomerName.Text = GridViewCustomers.SelectedRow.Cells[3].Text;
}
public ClassBiz()
{
classCurrency = new ClassCurrency();
GetAllCurrencyIdAndNames();
ClassSalesValues csv = new ClassSalesValues();
csv.classCurrency = classCurrency;
classCustomer = new ClassCustomer();
listClassArt = new List <ClassArt>(getdata.classArt.ToList() as List <ClassArt>);
classArt = new ClassArt();
listCustomer = new List <ClassCustomer>(getdata.classCustomer.ToList() as List <ClassCustomer>);
ClassSalesValues = new ClassSalesValues();
listclassSalesValues = new List <ClassSalesValues>(getdata.classSalesValues.ToList() as List <ClassSalesValues>);
}
public ClassBIZ()
{
textLock = "true";
comboLock = "false";
classCallWebAPI = new ClassCallWebAPI();
classLuxYachtDieselDB = new ClassLuxYachtDieselDB();
currency = new ClassCurrency();
selectedCustomer = new ClassCustomer();
selectedSupplier = new ClassSupplier();
fallbackCustomer = new ClassCustomer();
fallbackSupplier = new ClassSupplier();
listCountry = GetAllCountries();
listDieselPrice = GetAllDieselPricesForListFromDB();
//country = new List<ClassCountry>();
listCustomers = GetAllCustomersForListFromDB();
listSupplier = GetAllSuplliersForListFromDB();
dieselPrice = GetDieselPriceFromDB();
order = new ClassOrder();
}
/// <summary>
/// This method saves(inserts) new customers in the DB.
/// </summary>
/// <param name="inCustomer">ClassCustomer inCustomer</param>
public void SaveCustomerInDB(ClassCustomer inCustomer)
{
SqlCommand command = new SqlCommand(); //
command.Connection = con; // Tell which db to connect to, con is declared in ClassDbCon
command.CommandType = CommandType.StoredProcedure; // Declare which type of command we want to run
command.CommandText = "spCustomers_Insert"; // Name of our stored procedure
// Our parameters for
command.Parameters.Add("@name", SqlDbType.NVarChar).Value = inCustomer.name;
command.Parameters.Add("@address", SqlDbType.NVarChar).Value = inCustomer.address;
command.Parameters.Add("@city", SqlDbType.NVarChar).Value = inCustomer.city;
command.Parameters.Add("@postalCode", SqlDbType.NVarChar).Value = inCustomer.postalCode;
command.Parameters.Add("@country", SqlDbType.Int).Value = inCustomer.country.Id;
command.Parameters.Add("@phone", SqlDbType.NVarChar).Value = inCustomer.phone;
command.Parameters.Add("@mail", SqlDbType.NVarChar).Value = inCustomer.mailAdr;
MakeCallToStoredProcedure(command); // Call method with our command as paramter. Is returned as a datatable
}
/// <summary>
/// This method updates a current customer in the DB
/// </summary>
/// <param name="inCustomer">ClassCustomer inCustomer</param>
public void UpdateCustomerInDB(ClassCustomer inCustomer)
{
SqlCommand command = new SqlCommand();
command.Connection = con;
command.CommandType = CommandType.StoredProcedure;
command.CommandText = "spCustomers_Update";
command.Parameters.Add("@customerId", SqlDbType.Int).Value = inCustomer.Id;
command.Parameters.Add("@name", SqlDbType.NVarChar).Value = inCustomer.name;
command.Parameters.Add("@address", SqlDbType.NVarChar).Value = inCustomer.address;
command.Parameters.Add("@city", SqlDbType.NVarChar).Value = inCustomer.city;
command.Parameters.Add("@postalCode", SqlDbType.NVarChar).Value = inCustomer.postalCode;
command.Parameters.Add("@country", SqlDbType.Int).Value = inCustomer.country.Id;
command.Parameters.Add("@phone", SqlDbType.NVarChar).Value = inCustomer.phone;
command.Parameters.Add("@mail", SqlDbType.NVarChar).Value = inCustomer.mailAdr;
MakeCallToStoredProcedure(command);
}
protected void Page_Load(object sender, EventArgs e)
{
System.Web.UI.HtmlControls.HtmlGenericControl li = (System.Web.UI.HtmlControls.HtmlGenericControl) this.Page.Master.FindControl("liCustomer");
System.Web.UI.HtmlControls.HtmlGenericControl span1 = (System.Web.UI.HtmlControls.HtmlGenericControl) this.Page.Master.FindControl("spanCustomer1");
System.Web.UI.HtmlControls.HtmlGenericControl span2 = (System.Web.UI.HtmlControls.HtmlGenericControl) this.Page.Master.FindControl("spanCustomer2");
li.Attributes.Add("class", "item-menu active-menu");
span1.Attributes.Add("class", "fa fa-user fa-2x active-span");
span2.Attributes.Add("class", "menu active-span");
ClassCustomer generateCusId = new ClassCustomer();
txCustomerId.Text = generateCusId.GenerateCustomerId();
ClassAddresses generateAddId = new ClassAddresses();
txNewAddressId.Text = generateAddId.GenerateAddressId();
btnUpdate.CssClass = "btn btn-warning disabled";
btnDelete.CssClass = "btn btn-danger disabled";
btnAddress.CssClass = "btn btn-primary disabled";
}
public Boolean Update(ClassCustomer customer)
{
try
{
micomm.Conectar(db);
SqlCommand comando = new SqlCommand
{
Connection = micomm.cnn,
CommandType = CommandType.Text,
CommandText = sql3
};
SqlParameter p1 = new SqlParameter("@p1", customer.CustomerID);
SqlParameter p2 = new SqlParameter("@p2", customer.CustomerName);
SqlParameter p3 = new SqlParameter("@p3", customer.Category);
SqlParameter p4 = new SqlParameter("@p4", customer.direcc);
SqlParameter p5 = new SqlParameter("@p5", customer.email);
SqlParameter p6 = new SqlParameter("@p6", customer.Anulado);
SqlParameter p7 = new SqlParameter("@p7", customer.phone);
comando.Parameters.Add(p1);
comando.Parameters.Add(p2);
comando.Parameters.Add(p3);
comando.Parameters.Add(p4);
comando.Parameters.Add(p5);
comando.Parameters.Add(p6);
comando.Parameters.Add(p7);
comando.ExecuteNonQuery();
comando.Dispose();
micomm.Desconectar();
MessageBox.Show("Se actualizaron los datos con exito...");
return(true);
}
catch (SqlException ex)
{
MessageBox.Show("Error al modificar cliente...Error Code:" + ex);
return(false);
}
}
/// <summary>
/// This method gets data from the DB by calling a stored procedure.
/// It calls the method MakeCallToStoredProcedure and sends command as a parametre.
/// Command contains con(our connection string), the command type and the name of the stored procedure.
/// As this method needs to get everthing from the table in the DB, we get several sets of data,
/// hence we put the result of the call in a List.
/// </summary>
/// <returns>List<ClassCustomer>List<ClassCustomer></returns>
public List <ClassCustomer> GetAllCustomersFromDB()
{
List <ClassCustomer> listCustomerRes = new List <ClassCustomer>();
SqlCommand command = new SqlCommand();
command.Connection = con;
command.CommandType = CommandType.StoredProcedure;
command.CommandText = "spCustomers_GetAll";
DataTable dataTable = MakeCallToStoredProcedure(command);
foreach (DataRow row in dataTable.Rows)
{
ClassCustomer customer = new ClassCustomer(); // Initialize a new empty instance of ClassPerson
ClassCountry country = new ClassCountry();
country.Id = Convert.ToInt32(row["Id"]);
country.country = row["country"].ToString();
country.countryCode = row["countryCode"].ToString();
country.currency = row["currency"].ToString();
country.currencyCode = row["currencyCode"].ToString();
// Insert the values from the current row into each ones respective instance of ClassPerson
customer.Id = Convert.ToInt32(row["customerId"]);
customer.name = row["name"].ToString();
customer.address = row["address"].ToString();
customer.city = row["city"].ToString();
customer.postalCode = row["postalCode"].ToString();
customer.country = country;
customer.phone = row["phone"].ToString();
customer.mailAdr = row["mailAdr"].ToString();
listCustomerRes.Add(customer); // Instance of ClassPerson is inserted into listPersonRes which is of the datatype List<ClassPerson>
}
return(listCustomerRes);
}
protected void btnSave_Click(object sender, EventArgs e)
{
ResultEN ResultENs = new ResultEN();
CustomerEN CustomerENs = new CustomerEN();
CustomerENs.C_ID = this.txtC_ID.Text;
CustomerENs.Name = this.txtName.Text;
CustomerENs.Tel = this.txtTel.Text;
CustomerENs.Email = this.txtEmail.Text;
CustomerENs.Fax = this.txtFax.Text;
CustomerENs.Name_Company = this.txtCompany.Text;
CustomerENs.Tel_Company = this.txtTel_Company.Text;
CustomerENs.Address = this.txtAddress.Text;
CustomerENs.Tax_Number = this.txtTax_Number.Text;
if (Enum_Mode.Add.GetHashCode() == mode)
{
CustomerENs.CreatedBy = "";
CustomerENs.CreatedDate = DateTime.Now;
ResultENs = ClassCustomer.Insert(CustomerENs);
}
else if (Enum_Mode.Edit.GetHashCode() == mode)
{
CustomerENs.UpdatedBy = "";
CustomerENs.UpdatedDate = DateTime.Now;
ResultENs = ClassCustomer.Update(CustomerENs);
}
if (ResultENs != null && ResultENs.result)
{
LoadData();
}
else
{
}
}
/// <summary>
/// This method prompts the update of a customer to the DB
/// </summary>
public void UpdateCustomerInDB()
{
classLuxYachtDieselDB.UpdateCustomerInDB(selectedCustomer);
selectedCustomer = new ClassCustomer();
GetAllCustomersForListFromDB();
}
protected void btnCustomerSearch_Click(object sender, EventArgs e)
{
ClassCustomer searchCustomer = new ClassCustomer();
searchCustomer.SearchCustomer(txCustomerSearch, ddCustomerSearch, GridViewCustomers);
}
protected void btnDeleteCustomer_Click(object sender, EventArgs e)
{
ClassCustomer deleteCustomer = new ClassCustomer();
deleteCustomer.DeleteCustomer(this);
}
protected void btnUpdateCustomerSubmit_Click(object sender, EventArgs e)
{
ClassCustomer updateCustomer = new ClassCustomer();
updateCustomer.UpdateCustomer(this);
}
protected void btnAddCustomerSubmit_Click(object sender, EventArgs e)
{
ClassCustomer addCustomer = new ClassCustomer();
addCustomer.addNewCustomer(this);
}