/// <summary> /// Deleta um Custo. /// </summary> /// <param name="Obj">Objeto Custo</param> public void DeleteCusto(ENCusto Obj) { SqlConnection _con = new SqlConnection(ConfigurationManager.ConnectionStrings["PipiConnection"].ConnectionString); SqlCommand _cmd = new SqlCommand("sprCustoCRUD", _con); _cmd.CommandType = CommandType.StoredProcedure; _cmd.Parameters.AddWithValue("@sprstrOperacao", "D"); _cmd.Parameters.AddWithValue("@sprintEspecificoR", 0); _cmd.Parameters.AddWithValue("@sprintIdCusto", Obj.IdCusto); _cmd.Parameters.AddWithValue("@sprintIdTipoCusto", Obj.IdTipoCusto); _cmd.Parameters.AddWithValue("@sprstrDescricao", Obj.StrDescricao); _cmd.Parameters.AddWithValue("@sprdteDataCusto", Obj.DteDataCusto); _cmd.Parameters.AddWithValue("@sprfltValorCusto", Obj.FltValorCusto); try { _con.Open(); _cmd.ExecuteNonQuery(); } catch (Exception ex) { throw ex; } finally { _con.Close(); } }
/// <summary> /// Apaga um Custo /// </summary> /// <param name="Obj">ENCusto Obj</param> public void DeleteCusto(ENCusto Obj) { if (Obj.StrDescricao == null) { Obj.StrDescricao = string.Empty; } if (Obj.DteDataCusto == DateTime.MinValue) { Obj.DteDataCusto = DateTime.Now; } (new DACustos()).DeleteCusto(Obj); }
/// <summary> /// Seleciona todos os custos do banco. /// </summary> /// <param name="EspecificoR">int EspecificoR</param> /// <returns>Lista de Custos</returns> public List<ENCusto> Read(int EspecificoR, int idCusto, int idTipoCusto, DateTime dteCusto, float fltValor) { List<ENCusto> _objs = new List<ENCusto>(); SqlConnection _con = new SqlConnection(ConfigurationManager.ConnectionStrings["PipiConnection"].ConnectionString); SqlCommand _cmd = new SqlCommand("sprCustoCRUD", _con); _cmd.CommandType = CommandType.StoredProcedure; _cmd.Parameters.AddWithValue("@sprstrOperacao", "R"); _cmd.Parameters.AddWithValue("@sprintEspecificoR", EspecificoR); _cmd.Parameters.AddWithValue("@sprintIdCusto", idCusto); _cmd.Parameters.AddWithValue("@sprintIdTipoCusto", idTipoCusto); _cmd.Parameters.AddWithValue("@sprstrDescricao", string.Empty); _cmd.Parameters.AddWithValue("@sprdteDataCusto", dteCusto); _cmd.Parameters.AddWithValue("@sprfltValorCusto", fltValor); _con.Open(); SqlDataReader rd = _cmd.ExecuteReader(CommandBehavior.CloseConnection); try { while (rd.Read()) { ENCusto NewObj = new ENCusto(); NewObj.IdCusto = Convert.ToInt32(rd[0].ToString()); NewObj.IdTipoCusto = Convert.ToInt32(rd[1].ToString()); NewObj.StrDescricao = rd[2].ToString(); NewObj.DteDataCusto = Convert.ToDateTime(rd[3].ToString()); NewObj.FltValorCusto = float.Parse(rd[4].ToString()); _objs.Add(NewObj); } } catch (Exception ex) { throw ex; } finally { rd.Close(); } return _objs; }
/// <summary> /// Atualiza um Custo /// </summary> /// <param name="Obj">ENCusto Obj</param> public void UpdateCusto(ENCusto Obj) { (new DACustos()).UpdateCusto(Obj); }
/// <summary> /// Cria um novo Custo /// </summary> /// <param name="Obj">ENCusto Obj</param> public void CreateCusto(ENCusto Obj) { (new DACustos()).CreateCusto(Obj); }