protected void btnGuardar_Click(object sender, EventArgs e) { var minutes = Math.Round(Convert.ToDecimal(Request.Form["slMinutes"].ToString()) / 60, 2); var hours = Convert.ToInt32(Request.Form["slHours"].ToString()) + minutes; Ent_tticol075 data075 = new Ent_tticol075() { orden = txtWorkOrder.Text.Trim().ToUpper(), numOperacion = _opno, tarifaHoraria = Request.Form["slHoursLaborType"].ToString(), horas = hours, comentario = Request.Form["slComments"].ToString(), usuario = HttpContext.Current.Session["user"].ToString(), procesado = 2, chequeado = 2, fecha = DateTime.Now, mensaje = " ", refcntd = 0, refcntu = 0 }; List <Ent_tticol075> lista = new List <Ent_tticol075>(); lista.Add(data075); var validInsert = _idaltticol075.insertarRegistro(ref lista, ref strError); if (validInsert > 0) { divTable.InnerHtml = String.Empty; divBtnGuardar.Visible = false; txtWorkOrder.Text = String.Empty; lblConfirm.Text = mensajes("msjsave"); lblConfirm.Visible = true; lblError.Visible = false; return; } else { lblError.Text = mensajes("errorsave"); lblError.Visible = true; lblConfirm.Visible = false; return; } }
private List <Ent_ParametrosDAL> AdicionaParametrosComunes(Ent_tticol075 parametros, bool blnUsarPRetorno = false) { method = MethodBase.GetCurrentMethod(); string strError = string.Empty; List <Ent_ParametrosDAL> parameterCollection = new List <Ent_ParametrosDAL>(); try { Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$REFCNTD", DbType.Int32, parametros.refcntd); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$REFCNTU", DbType.Int32, parametros.refcntu); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$CHEC", DbType.Int32, parametros.chequeado); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$COMM", DbType.String, parametros.comentario); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$CWTT", DbType.String, parametros.tarifaHoraria); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$DATE", DbType.String, parametros.fecha.ToString("dd/MM/yyyy HH:mm:ss")); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$HREA", DbType.Decimal, parametros.horas); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$LOGN", DbType.String, parametros.usuario); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$MESS", DbType.String, parametros.mensaje); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$OPNO", DbType.Int32, parametros.numOperacion); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$PDNO", DbType.String, parametros.orden); Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$PROC", DbType.Int32, parametros.procesado); if (blnUsarPRetorno) { Ent_ParametrosDAL pDal = new Ent_ParametrosDAL(); pDal.Name = "@p_Int_Resultado"; pDal.Type = DbType.Int32; pDal.ParDirection = ParameterDirection.Output; parameterCollection.Add(pDal); } } catch (Exception ex) { strError = "Error when creating parameters [075]. Try again or contact your administrator \n"; log.escribirError(strError + Console.Out.NewLine + ex.Message, stackTrace.GetFrame(1).GetMethod().Name, method.Name, method.ReflectedType.Name); } return(parameterCollection); }