private void btnCreate_Click(object sender, RoutedEventArgs e) { crud_modal.Visibility = System.Windows.Visibility.Visible; cntrl.Curd.price_list objPriceList = new cntrl.Curd.price_list(); item_price_list item_price_list = new item_price_list(); entity.db.item_price_list.Add(item_price_list); item_price_listViewSource.View.MoveCurrentToLast(); objPriceList.item_price_listViewSource = item_price_listViewSource; objPriceList._entity = entity; crud_modal.Children.Add(objPriceList); }
private void sync_PriceList() { DataTable dt = exeDT("SELECT * FROM TIPOCLIENTE"); foreach (DataRow row in dt.Rows) { item_price_list price = new item_price_list(); price.name = (string)row["DESTIPOCLIENTE"]; price.id_company = id_company; price.is_active = true; dbContext.item_price_list.Add(price); } dt.Clear(); dbContext.SaveChanges(); }
private void EditPricelist_PreviewMouseUp(object sender, MouseButtonEventArgs e) { item_price item_price = item_priceDataGrid.SelectedItem as item_price; item_price_list item_price_list = item_price.item_price_list; if (item_price_list != null) { crud_modal.Visibility = Visibility.Visible; cntrl.Curd.price_list _price_list = new cntrl.Curd.price_list(); _price_list.item_price_listViewSource = item_price_listViewSource; _price_list.MainViewSource = itemViewSource; _price_list.curMainObject = itemViewSource.View.CurrentItem; // _price_list._entity = dbContext; _price_list.price_listobject = item_price_list; _price_list.operationMode = cntrl.Class.clsCommon.Mode.Edit; _price_list.isExternalCall = true; crud_modal.Children.Add(_price_list); } }
private void btnDelete_Click(object sender, RoutedEventArgs e) { try { if (!isExternalCall) { MessageBoxResult res = MessageBox.Show("Are you sure want to Delete?", "Cognitivo", MessageBoxButton.YesNo, MessageBoxImage.Question); if (res == MessageBoxResult.Yes) { item_price_list item_price_list = item_price_listViewSource.View.CurrentItem as entity.item_price_list; item_price_list.is_active = false; btnSave_Click(sender, e); } } } catch (Exception ex) { throw ex; } }
public void product() { string sql = " SELECT dbo.FAMILIA.DESFAMILIA, dbo.LINEA.DESLINEA, dbo.RUBRO.DESRUBRO, dbo.IVA.DESIVA, dbo.CODIGOS.DESCODIGO1, dbo.CODIGOS.CODIGO, dbo.CODIGOS.PESABLE, dbo.CODIGOS.VENCIMIENTO, dbo.CODIGOS.BALANZA, dbo.PRODUCTOS.DESPRODUCTO, dbo.PRODUCTOS.STOCKMINIMO, dbo.PRODUCTOS.STOCKMAXIMO, " + " dbo.PRODUCTOS.SERVICIO, dbo.PRODUCTOS.ESTADO, dbo.PRODUCTOS.ESPECIFICACIONES, dbo.PRODUCTOS.PRODUCTO, dbo.UNIDADMEDIDA.DESMEDIDA, dbo.CODIGOS.CODCODIGO" + " FROM dbo.CODIGOS LEFT OUTER JOIN" + " dbo.PRODUCTOS ON dbo.CODIGOS.CODPRODUCTO = dbo.PRODUCTOS.CODPRODUCTO LEFT OUTER JOIN" + " dbo.UNIDADMEDIDA ON dbo.PRODUCTOS.CODMEDIDA = dbo.UNIDADMEDIDA.CODMEDIDA LEFT OUTER JOIN" + " dbo.RUBRO ON dbo.PRODUCTOS.CODRUBRO = dbo.RUBRO.CODRUBRO LEFT OUTER JOIN" + " dbo.FAMILIA ON dbo.PRODUCTOS.CODFAMILIA = dbo.FAMILIA.CODFAMILIA LEFT OUTER JOIN" + " dbo.LINEA ON dbo.PRODUCTOS.CODLINEA = dbo.LINEA.CODLINEA LEFT OUTER JOIN" + " dbo.IVA ON dbo.PRODUCTOS.CODIVA = dbo.IVA.CODIVA"; SqlConnection conn = new SqlConnection(_connString); //Counts Total number of Rows we have to process SqlCommand cmd = new SqlCommand(); conn.Open(); cmd.Connection = conn; cmd.CommandText = "SELECT COUNT(*) FROM CODIGOS"; cmd.CommandType = CommandType.Text; int count = (int)cmd.ExecuteScalar(); //cmd.Dispose(); conn.Close(); int value = 0; Dispatcher.BeginInvoke((Action)(() => progItem.Maximum = count)); Dispatcher.BeginInvoke((Action)(() => progItem.Value += value)); Dispatcher.BeginInvoke((Action)(() => itemMaximum.Text = count.ToString())); Dispatcher.BeginInvoke((Action)(() => itemValue.Text = value.ToString())); string sql_price = " SELECT dbo.TIPOCLIENTE.DESTIPOCLIENTE, dbo.PRECIO.CANTIDAD, dbo.PRECIO.PRECIOVENTA, dbo.MONEDA.DESMONEDA, dbo.PRODUCTOS.DESPRODUCTO" + " FROM dbo.PRECIO LEFT OUTER JOIN" + " dbo.MONEDA ON dbo.PRECIO.CODMONEDA = dbo.MONEDA.CODMONEDA LEFT OUTER JOIN" + " dbo.PRODUCTOS ON dbo.PRECIO.CODPRODUCTO = dbo.PRODUCTOS.CODPRODUCTO LEFT OUTER JOIN" + " dbo.TIPOCLIENTE ON dbo.PRECIO.CODTIPOCLIENTE = dbo.TIPOCLIENTE.CODTIPOCLIENTE"; DataTable dt_Price = exeDT(sql_price); conn.Open(); cmd.Connection = conn; cmd.CommandText = sql; cmd.CommandType = CommandType.Text; DataTable dt_product = exeDT(sql); foreach (DataRow reader in dt_product.Rows) { using (db db = new db()) { db.Configuration.AutoDetectChangesEnabled = false; item item = new item(); item.id_company = id_company; if (!(reader[9] is DBNull)) { item.name = reader[9].ToString(); } else { continue; } item.code = (reader[5] is DBNull) ? string.Empty : reader[5].ToString(); item.variation = (reader[9] is DBNull) ? string.Empty : reader[9].ToString(); item.is_active = (reader[13] is DBNull) ? false : true; item.description = (reader[14] is DBNull) ? string.Empty : reader[14].ToString(); string name = (reader[16] is DBNull) ? string.Empty : reader[16].ToString(); if (db.app_measurement.Where(x => x.name == name && x.id_company == id_company).FirstOrDefault() != null) { item.id_measurement = db.app_measurement.Where(x => x.name == name && x.id_company == id_company).FirstOrDefault().id_measurement; } //string FAMILIA; if (!(reader[0] is DBNull)) { string tagname = reader[0].ToString(); item_tag item_tagFam = db.item_tag.Where(x => x.name == tagname && x.id_company == id_company).FirstOrDefault(); item_tag_detail tag_detailFam = new item_tag_detail(); tag_detailFam.id_tag = item_tagFam.id_tag; item.item_tag_detail.Add(tag_detailFam); } //string LINEA; if (!(reader[1] is DBNull)) { string tagLinname = reader[1].ToString(); item_tag item_tagLin = db.item_tag.Where(x => x.name == tagLinname && x.id_company == id_company).FirstOrDefault(); item_tag_detail tag_detailLin = new item_tag_detail(); tag_detailLin.id_tag = item_tagLin.id_tag; item.item_tag_detail.Add(tag_detailLin); } //string RUBRO; if (!(reader[2] is DBNull)) { string tagrubro = reader[2].ToString(); item_tag item_tagRub = db.item_tag.Where(x => x.name == tagrubro && x.id_company == id_company).FirstOrDefault(); item_tag_detail tag_detailRub = new item_tag_detail(); tag_detailRub.id_tag = item_tagRub.id_tag; item.item_tag_detail.Add(tag_detailRub); } if (!(reader[15] is DBNull)) { if (Convert.ToInt32(reader[15]) == 1) { //Product item.id_item_type = item.item_type.Product; item_product product = new item_product(); product.id_company = id_company; product.can_expire = (reader[7] is DBNull || Convert.ToInt32(reader[7]) == 0) ? false : true; product.is_weigted = (reader[6] is DBNull || Convert.ToInt32(reader[6]) == 0) ? false : true; product.stock_max = (reader[11] is DBNull) ? 0M : (decimal)reader[11]; product.stock_min = (reader[10] is DBNull) ? 0M : (decimal)reader[10]; item.item_product.Add(product); } else { item.id_item_type = item.item_type.Task; //Generic Service //item_service service } } else { item.id_item_type = item.item_type.Task; //Generic Service //item_service service } decimal _vat_coeficient = 0; if (!(reader[3] is DBNull)) { string vatname = reader[3].ToString(); app_vat_group app_vat_group = db.app_vat_group.Where(x => x.name == vatname && x.id_company == id_company).FirstOrDefault(); item.id_vat_group = app_vat_group.id_vat_group; } decimal coefficient = 0; List <app_vat_group_details> app_vat_group_details = db.app_vat_group_details.Where(x => x.id_vat_group == item.id_vat_group).ToList(); foreach (app_vat_group_details app_vat_group in app_vat_group_details) { coefficient = coefficient + app_vat_group.app_vat.coefficient; } string _DESPRODUCTO = reader["DESPRODUCTO"].ToString(); _DESPRODUCTO = _DESPRODUCTO.Replace("'", ""); try { foreach (DataRow price_row in dt_Price.Select("DESPRODUCTO = '" + _DESPRODUCTO + "'")) { string _desTipoCliente = (price_row.IsNull("DESTIPOCLIENTE")) ? string.Empty : price_row["DESTIPOCLIENTE"].ToString(); string _desMoneda = (price_row.IsNull("DESMONEDA")) ? string.Empty : price_row["DESMONEDA"].ToString(); if (_desTipoCliente != string.Empty && _desMoneda != string.Empty) { item_price_list item_price_list = db.item_price_list.Where(x => x.name == _desTipoCliente && x.id_company == id_company).FirstOrDefault(); app_currency app_currency = db.app_currency.Where(x => x.name == _desMoneda && x.id_company == id_company).FirstOrDefault(); if (item_price_list != null && app_currency != null && _vat_coeficient != -1) { item_price item_price = new item_price(); item_price.item = item; if (price_row["PRECIOVENTA"] is DBNull) { item_price.value = 0; } else { if (coefficient != -1) { item_price.value = ((decimal)price_row["PRECIOVENTA"] / (1 + coefficient)); } } item_price.min_quantity = (price_row.IsNull("CANTIDAD")) ? 0 : Convert.ToDecimal(price_row["CANTIDAD"]); item_price.id_currency = app_currency.id_currency; item_price.id_price_list = item_price_list.id_price_list; item.item_price.Add(item_price); } } } } catch (Exception ex) { throw ex; } try { if (item.Error == null) { db.items.Add(item); db.SaveChanges(); value += 1; Dispatcher.BeginInvoke((Action)(() => progItem.Value = value)); Dispatcher.BeginInvoke((Action)(() => itemValue.Text = value.ToString())); } } catch { } } } //cmd.Dispose(); conn.Close(); _product_Current = _product_Max; }
public void customer() { string sql = " SELECT " + " VENDEDOR.DESVENDEDOR," + " TIPOCLIENTE.DESTIPOCLIENTE, " + " ZONA.DESZONA, " + " CIUDAD.DESCIUDAD, " + " PAIS.DESPAIS, " + " CLIENTES.NUMCLIENTE, " //5 + " CLIENTES.NOMBRE, " + " CLIENTES.RUC," + " CLIENTES.DIRECCION, " + " CLIENTES.TELEFONO," + " CLIENTES.CELULAR, " //10 + " CLIENTES.FAX, " + " CLIENTES.EMAIL, " + " CLIENTES.WEB, " + " CLIENTES.LIMCREDITO, " + " CLIENTES.PORCENTAJE, " //15 + " CLIENTES.OBSERVACION, " + " CLIENTES.SEPSA, " + " CLIENTES.RELACION, " // 18 + " CLIENTES.TIPOVENTA, " + " CLIENTES.TELEFONO1, " //20 + " CLIENTES.EMAIL1, " + " CLIENTES.DIASVENCIMIENTO, " + " CLIENTES.CONDICIONVENTA, " + " CLIENTES.NUMEROTOL, " + " CLIENTES.PROVEEDOR_ID, " //25 + " CLIENTES.PERSONAJURIDICA, " + " CLIENTES.TIMBRADORETENCION, " + " CLIENTES.CODCATEGORIACLIENTE, " + " CATEGORIACLIENTE.DESCATEGORIACLIENTE," + " CLIENTES.NOMBREFANTASIA, " //30 + " CLIENTES.CUSTOMFIELD, " + " CLIENTES.CODCLIENTE, " + " CLIENTES.SEXO, " + " CLIENTES.FECHANACIMIENTO," + " CLIENTES.FECHAINGRESO," //35 + " PRODUCTOS.DESPRODUCTO," + " CLIENTES.EMPPRESACLIENTE" //35 + " FROM VENDEDOR " + " RIGHT OUTER JOIN CIUDAD RIGHT OUTER JOIN ZONA ON CIUDAD.CODCIUDAD = ZONA.CODCIUDAD RIGHT OUTER JOIN" + " TIPOCLIENTE RIGHT OUTER JOIN CLIENTES LEFT OUTER JOIN CATEGORIACLIENTE ON CLIENTES.CODCATEGORIACLIENTE = CATEGORIACLIENTE.CODCATEGORIACLIENTE ON " + " TIPOCLIENTE.CODTIPOCLIENTE = CLIENTES.CODTIPOCLIENTE ON ZONA.CODZONA = CLIENTES.CODZONA ON " + " VENDEDOR.CODVENDEDOR = CLIENTES.CODVENDEDOR LEFT OUTER JOIN" + " PAIS ON CIUDAD.CODPAIS = PAIS.CODPAIS LEFT OUTER JOIN" + " PRODUCTOS ON CLIENTES.PROVEEDOR_ID = PRODUCTOS.CODPRODUCTO "; SqlConnection conn = new SqlConnection(_connString); //Counts Total number of Rows we have to process SqlCommand cmd = new SqlCommand(sql, conn); conn.Open(); cmd.CommandText = "SELECT COUNT(*) FROM CLIENTES"; cmd.CommandType = CommandType.Text; int count = (int)cmd.ExecuteScalar(); conn.Close(); int value = 0; Dispatcher.BeginInvoke((Action)(() => customerMaximum.Text = count.ToString())); Dispatcher.BeginInvoke((Action)(() => customerValue.Text = value.ToString())); Dispatcher.BeginInvoke((Action)(() => progCustomer.Maximum = count)); Dispatcher.BeginInvoke((Action)(() => progCustomer.Value = value)); cmd = new SqlCommand(sql, conn); conn.Open(); cmd.CommandType = CommandType.Text; // SqlDataReader reader = cmd.ExecuteReader(); DataTable dt_customer = exeDT(sql); foreach (DataRow reader in dt_customer.Rows) { using (entity.db db = new entity.db()) { db.Configuration.AutoDetectChangesEnabled = false; contact contacts = new contact(); contacts.id_company = id_company; contacts.is_active = true; contacts.is_customer = true; contacts.is_supplier = false; contacts.is_employee = false; if (!(reader[6] is DBNull)) { contacts.name = reader[6].ToString(); } else { continue; } contacts.code = (reader[5] is DBNull) ? null : reader[5].ToString(); contacts.gov_code = (reader[7] is DBNull) ? "xxx" : reader[7].ToString(); contacts.credit_limit = (reader[14] is DBNull) ? 0 : (decimal)reader[14]; contacts.address = (reader[8] is DBNull) ? null : reader[8].ToString(); contacts.telephone = (reader[9] is DBNull) ? null : reader[9].ToString(); contacts.email = (reader[12] is DBNull) ? null : reader[12].ToString(); contacts.alias = (reader[30] is DBNull) ? null : reader[30].ToString(); int _dias = Convert.ToInt32((reader["DIASVENCIMIENTO"] is DBNull) ? 0 : reader["DIASVENCIMIENTO"]); string contrat_name = _dias + " " + "Días"; if (db.app_contract.Where(x => x.name == contrat_name).FirstOrDefault() != null) { app_contract app_contract = db.app_contract.Where(x => x.name == contrat_name).FirstOrDefault(); contacts.id_contract = app_contract.id_contract; contacts.app_contract = app_contract; } contacts.id_contact_role = db.contact_role.Where(x => x.is_principal == true && x.id_company == id_company).FirstOrDefault().id_contact_role; if (_connString.Contains("Angelius")) { if (!(reader[18] is DBNull)) { contacts.timestamp = Convert.ToDateTime(reader[35]); } contacts.is_person = true; string role_name = (reader[31] is DBNull) ? null : reader[31].ToString(); if (db.contact_role.Where(x => x.name == role_name && x.id_company == id_company).FirstOrDefault() != null) { contacts.id_contact_role = db.contact_role.Where(x => x.name == role_name && x.id_company == id_company).FirstOrDefault().id_contact_role; } else { if (db.app_field.Where(x => x.field_type == app_field.field_types.Account).FirstOrDefault() != null) { app_field app_field = db.app_field.Where(x => x.field_type == app_field.field_types.Account).FirstOrDefault(); contact_field_value contact_field_value = new entity.contact_field_value(); contact_field_value.contact = contacts; contact_field_value.value = role_name; contact_field_value.id_field = app_field.id_field; contacts.contact_field_value.Add(contact_field_value); } } int relationid = Convert.ToInt32((reader[18] is DBNull) ? null : reader[18].ToString()); int code = Convert.ToInt32((reader[32] is DBNull) ? null : reader[32].ToString()); if (relationid != code) { DataTable dt_newcustomer = exeDT("select NOMBRE from CLIENTES where CODCLIENTE=" + relationid); string name = (dt_newcustomer.Rows[0][0]).ToString(); if (db.contacts.Where(x => x.name == name).FirstOrDefault() != null) { contacts.parent = db.contacts.Where(x => x.name == name).FirstOrDefault(); } } var SEXO = Convert.ToInt32((reader[33] is DBNull) ? null : reader[33].ToString()); if (SEXO != null) { if (SEXO == 0) { contacts.gender = contact.Genders.Male; } else { contacts.gender = contact.Genders.Female; } } DateTime FECHANACIMINETO = Convert.ToDateTime((reader[34] is DBNull) ? null : reader[34].ToString()); if (FECHANACIMINETO != null) { if (FECHANACIMINETO.Year < 2014) { contacts.date_birth = FECHANACIMINETO; } } contact_subscription contact_subscription = new contact_subscription(); if (!(reader[33] is DBNull)) { if (Convert.ToInt32((reader[33])) > 0) { contact_subscription.unit_price = Convert.ToInt32((reader[33])); } } if (!(reader[25] is DBNull)) { string name = reader[36].ToString(); if (db.items.Where(x => x.name == name).FirstOrDefault() != null) { contact_subscription.id_item = db.items.Where(x => x.name == name).FirstOrDefault().id_item; if (db.items.Where(x => x.name == name).FirstOrDefault() != null) { contact_subscription.id_vat_group = db.items.Where(x => x.name == name).FirstOrDefault().id_vat_group; } else { if (db.app_vat_group.Where(x => x.is_default).FirstOrDefault() != null) { contact_subscription.id_vat_group = db.app_vat_group.Where(x => x.is_default).FirstOrDefault().id_vat_group; } } } } else { if (contacts.parent != null) { contact_subscription.id_item = contacts.parent.contact_subscription.FirstOrDefault().id_item; contact_subscription.id_vat_group = contacts.parent.contact_subscription.FirstOrDefault().id_vat_group; } } if (db.app_contract.Where(x => x.is_active).FirstOrDefault() != null) { contact_subscription.id_contract = db.app_contract.Where(x => x.is_active).FirstOrDefault().id_contract; } contacts.contact_subscription.Add(contact_subscription); if (!(reader[37] is DBNull)) { string name = reader[37].ToString(); if (db.contact_tag.Local.Where(x => x.name == name).FirstOrDefault() == null) { if (reader[37].ToString() != "") { contact_tag contact_tag = new contact_tag(); contact_tag.name = reader[37].ToString(); db.contact_tag.Add(contact_tag); contact_tag_detail contact_tag_detail = new contact_tag_detail(); contact_tag_detail.contact = contacts; contact_tag_detail.contact_tag = contact_tag; db.contact_tag_detail.Add(contact_tag_detail); } } else { contact_tag_detail contact_tag_detail = new contact_tag_detail(); contact_tag_detail.contact = contacts; contact_tag_detail.contact_tag = db.contact_tag.Local.Where(x => x.name == name).FirstOrDefault(); db.contact_tag_detail.Add(contact_tag_detail); } } } if (!(reader["DESZONA"] is DBNull)) { string name = (string)reader["DESZONA"]; app_geography _app_geography = db.app_geography.Where(x => x.name == name).FirstOrDefault(); if (_app_geography != null) { contacts.app_geography = _app_geography; contacts.id_geography = _app_geography.id_geography; } } else if (!(reader["DESCIUDAD"] is DBNull)) { string name = (string)reader["DESCIUDAD"]; app_geography _app_geography = db.app_geography.Where(x => x.name == name).FirstOrDefault(); if (_app_geography != null) { contacts.app_geography = _app_geography; contacts.id_geography = _app_geography.id_geography; } } else if (!(reader["DESPAIS"] is DBNull)) { string name = (string)reader["DESPAIS"]; app_geography _app_geography = db.app_geography.Where(x => x.name == name).FirstOrDefault(); if (_app_geography != null) { contacts.app_geography = _app_geography; contacts.id_geography = _app_geography.id_geography; } } //db Related Insertion. if (!(reader[1] is DBNull)) { string _price = reader[1].ToString(); item_price_list price_list = db.item_price_list.Where(x => x.name == _price && x.id_company == id_company).FirstOrDefault(); contacts.id_price_list = price_list.id_price_list; } if (!(reader[0] is DBNull)) { string _sales_rep = reader[0].ToString(); sales_rep sales_rep = db.sales_rep.Where(x => x.name == _sales_rep && x.id_company == id_company).FirstOrDefault(); contacts.id_sales_rep = (short)sales_rep.id_sales_rep; } if (contacts.Error == null) { db.contacts.Add(contacts); try { db.SaveChanges(); } catch (Exception ex) { throw ex; } value += 1; Dispatcher.BeginInvoke((Action)(() => progCustomer.Value = value)); Dispatcher.BeginInvoke((Action)(() => customerValue.Text = value.ToString())); } else { //Add code to include error contacts into Contact_ErrorList.Add(contacts); } } } //cmd.Dispose(); conn.Close(); _customer_Current = _customer_Max; }