//--------------------------- //Insert CtaCtePrecioServicio //--------------------------- public BE_ResGenerico Ins_CtaCtePrecioServicio(BE_ReqCtaCtePrecioServicio Request) { BE_ResGenerico Item = new BE_ResGenerico(); DA_CtaCtePrecioServicio Obj = new DA_CtaCtePrecioServicio(); Item = Obj.Ins_CtaCtePrecioServicio(Request); return Item; }
//------------------------ //Select Lista Servicios //------------------------ public DataTable Get_List_CtaCteServicio(BE_ReqCtaCtePrecioServicio Request) { //Recuperando registros DataTable dt = new DataTable(); DA_CtaCtePrecioServicio Obj = new DA_CtaCtePrecioServicio(); return Obj.Get_List_CtaCteServicio(Request); }
//------------------------------------------------------- //Get Lista Precio por nCtaCteSerCodigo y cPerJurCodigo //------------------------------------------------------- public DataTable Get_CtaCtePrecioServicio(BE_ReqCtaCtePrecioServicio Request) { DataTable dt = new DataTable(); try { clsConection Obj = new clsConection(); string Cadena = Obj.GetConexionString("Naylamp"); using (SqlConnection cn = new SqlConnection(Cadena)) { cn.Open(); using (SqlCommand cm = new SqlCommand()) { cm.CommandText = "[usp_Get_CtaCtePrecioServicio]"; cm.CommandType = CommandType.StoredProcedure; cm.Parameters.AddWithValue("nCtaCteSerCodigo", Request.nCtaCteSerCodigo); cm.Parameters.AddWithValue("cPerJurCodigo", Request.cPerJurCodigo); cm.Connection = cn; using (SqlDataReader dr = cm.ExecuteReader()) dt.Load(dr); } } } catch (Exception) { throw; } return dt; }
//---------------------------- // INSERT CtaCtePrecioServicio //---------------------------- public BE_ResGenerico Ins_CtaCtePrecioServicio(BE_ReqCtaCtePrecioServicio Request) { BE_ResGenerico Item = new BE_ResGenerico(); long Resultado = 0; try { clsConection Obj = new clsConection(); string Cadena = Obj.GetConexionString("Naylamp"); using (SqlConnection cn = new SqlConnection(Cadena)) { cn.Open(); using (SqlCommand cm = new SqlCommand()) { cm.CommandText = "[usp_Ins_CtaCtePrecioServicio]"; cm.CommandType = CommandType.StoredProcedure; cm.Parameters.AddWithValue("nCtaCteSerCodigo", Request.nCtaCteSerCodigo); cm.Parameters.AddWithValue("cPerJurCodigo", Request.cPerJurCodigo); cm.Parameters.AddWithValue("nIntCodigo", Request.nIntCodigo ); cm.Parameters.AddWithValue("nCtaCteSerCosto", Request.nCtaCteSerCosto); cm.Parameters.AddWithValue("cPerUseCodigo", Request.cPerUseCodigo); cm.Connection = cn; Resultado = cm.ExecuteNonQuery(); Item.Resultado = Resultado; } } } catch (Exception) { throw; } return Item; }