public Task <ReturnPriceType> ReturnPriceType(int pkPriceType) { try { ReturnPriceType priceType = new ReturnPriceType(); using (var conn = _settings.GetConnection()) { if (conn.State == ConnectionState.Closed) { conn.Open(); } string query = $"SELECT * FROM RETORNA_TIPO_PRECIO({pkPriceType});"; using (var cmd = new SqlCommand(query, conn)) { cmd.CommandType = CommandType.Text; var dr = cmd.ExecuteReader(); while (dr.Read()) { priceType.PkCode = dr.GetInt32(0); priceType.Code = (dr.IsDBNull(1) ? null: dr.GetString(1)); priceType.Type = dr.GetString(2); } } } return(Task.FromResult(priceType)); } catch (Exception e) { Console.WriteLine(e); return(null); } }
public object Convert(object value, Type targetType, object parameter, System.Globalization.CultureInfo culture) { ReturnPriceType returnPriceType = (ReturnPriceType)value; string para = parameter.ToString(); if (returnPriceType == ReturnPriceType.InputPrice) { return(para == "Input" ? Visibility.Visible : Visibility.Collapsed); } else { return(para == "Input" ? Visibility.Collapsed : Visibility.Visible); } }
public async Task <ActionResult> PriceTypeEdit(ReturnPriceType priceType) { var result = await _updateMethods.UpdatePriceType(priceType.PkCode, priceType.Type); var returnPriceType = await _returnMethods.ReturnPriceType(priceType.PkCode); if (result) { return(await Task.FromResult <ActionResult>(RedirectToAction("PriceTypeList"))); } ModelState.AddModelError(key: "", errorMessage: "Ha ocurrido un error.\n"); return(View(returnPriceType)); }