public int Add(TblPecasDAO entity) { try { parameters = new List <SqlParameter> { new SqlParameter("@P0", entity.price), new SqlParameter("@P1", entity.descPiece), new SqlParameter("@P2", entity.dtBuy), new SqlParameter("@P3", entity.dtStart) }; return(ExecuteNonQuery(insert)); } catch (Exception ex) { throw ex; } }
public string saveChange() { string message = ""; try { TblPecasDAO tblPecasDataRepository = new TblPecasDAO { idPiece = idPiece, dtBuy = dtBuy, dtFinish = dtFinish, dtStart = dtStart, price = price, descPiece = descPiece }; switch (State) { //Execulta reglas comerciais / calculos case EntityState.Add: pecasRepository.Add(tblPecasDataRepository); message = "Usuário Cadastrado com sucesso!"; break; case EntityState.Modified: pecasRepository.Edit(tblPecasDataRepository); message = "Usuário alterado com sucesso!"; break; case EntityState.Delete: pecasRepository.Remove((int)idPiece); message = "Usuário removido com sucesso!"; break; } return(message); } catch (Exception ex) { return(ex.Message); } }
public int Edit(TblPecasDAO entity) { try { parameters = new List <SqlParameter> { new SqlParameter("@P0", entity.idPiece), new SqlParameter("@P1", entity.price), new SqlParameter("@P2", entity.descPiece), new SqlParameter("@P3", entity.dtBuy), new SqlParameter("@P4", entity.dtStart), new SqlParameter("@P5", entity.dtFinish) }; return(ExecuteNonQuery(update)); } catch (Exception ex) { throw ex; } }
public int Edit(TblPecasDAO entity) { throw new NotImplementedException(); }