public int GetIdTypeCredit(Expiry_of_mode expiry) { int id = 0; using (var en = new DB_SystemFoodTrucksEntities()) { var query = en.Expiry_of_mode.FirstOrDefault(t => t.ModeName == expiry.ModeName); if (query.Id != 0) { id = query.Id; } return(id); } }
private void btnRegCredit_Click(object sender, RoutedEventArgs e) { int idTrnsT; var idTransType = new Expiry_of_mode() { ModeName = cboModeExp.SelectedValue.ToString() }; idTrnsT = CreditBL.GetInstance().GetIdTypeCredit(idTransType); string expMode = cboModeExp.SelectedValue.ToString(); if (txtCode.Text != "" && txtMonto.Text != "" && cboModeExp.SelectedIndex > -1) { if (expMode == "Cantidad") { if (txtCant.Text != "") { var newCredit = new Credits() { Code_credits = txtCode.Text, Amount = Convert.ToInt32(txtMonto.Text), Type_credit = 1, Cant = Convert.ToInt32(txtCant.Text), Expiry_mode = idTrnsT, Qty_sold = 0, Creation_date = DateTime.Now }; CreditBL.GetInstance().RegisterCreditCode(newCredit); MessageBoxRM.Show("Codigo registrado exitosamente", "Registro de codigo credito", MessageBoxButtonRM.OK, MessageBoxIconRM.Information); txtCode.Clear(); txtMonto.Clear(); txtCant.Clear(); cboModeExp.SelectedIndex = -1; txtCant.IsEnabled = false; DateT.Text = ""; } else { MessageBoxRM.Show("El campo cantidad se encuentra vacio", "Campos sin llenar", MessageBoxButtonRM.OK, MessageBoxIconRM.Warning); } } else if (expMode == "Fecha") { if (DateT.Text != "") { var newCredit = new Credits() { Code_credits = txtCode.Text, Amount = Convert.ToInt32(txtMonto.Text), Type_credit = 1, Expire_date = DateT.SelectedDate, Cant = 0, Expiry_mode = idTrnsT, Qty_sold = 0, Creation_date = DateTime.Now }; CreditBL.GetInstance().RegisterCreditCode(newCredit); MessageBoxRM.Show("Codigo registrado exitosamente", "Registro de codigo credito", MessageBoxButtonRM.OK, MessageBoxIconRM.Information); txtCode.Clear(); txtMonto.Clear(); txtCant.Clear(); cboModeExp.SelectedIndex = -1; DateT.IsEnabled = false; DateT.Text = ""; } else { MessageBoxRM.Show("No se ha seleccionado una fecha", "Campos sin llenar", MessageBoxButtonRM.OK, MessageBoxIconRM.Warning); } } } else { MessageBoxRM.Show("Algun campo se encuentra vacio", "Campos sin llenar", MessageBoxButtonRM.OK, MessageBoxIconRM.Warning); } }