public short EkleKargo(TBLKARGOLAR ptKargolar) { try { DbCommand dbCommand = db.GetSqlStringCommand("INSERT INTO TBLKARGOLAR(ADI,TELEFON,EMAIL,AKTIF) VALUES(@ADI,@TELEFON,@EMAIL,@AKTIF) SELECT @@IDENTITY"); db.AddInParameter(dbCommand, "ADI", DbType.String, ptKargolar.ADI); db.AddInParameter(dbCommand, "TELEFON", DbType.String, ptKargolar.TELEFON); db.AddInParameter(dbCommand, "EMAIL", DbType.String, ptKargolar.EMAIL); db.AddInParameter(dbCommand, "AKTIF", DbType.Int16, (short)ptKargolar.AKTIF); return(db.ExecuteScalar(dbCommand).ToShort(0)); } catch (Exception ex) { cLog.Write(ex, _iKullaniciID); return(0); } }
public short DuzenleKargo(TBLKARGOLAR ptKargolar) { try { DbCommand dbCommand = db.GetSqlStringCommand("UPDATE TBLKARGOLAR SET ADI=@ADI, TELEFON=@TELEFON,EMAIL=@EMAIL,AKTIF=@AKTIF WHERE ID=@ID"); db.AddInParameter(dbCommand, "ID", DbType.Int16, ptKargolar.ID); db.AddInParameter(dbCommand, "ADI", DbType.String, ptKargolar.ADI); db.AddInParameter(dbCommand, "TELEFON", DbType.String, ptKargolar.TELEFON); db.AddInParameter(dbCommand, "EMAIL", DbType.String, ptKargolar.EMAIL); db.AddInParameter(dbCommand, "AKTIF", DbType.Int16, (short)ptKargolar.AKTIF); db.ExecuteNonQuery(dbCommand); return(1); } catch (Exception ex) { cLog.Write(ex, _iKullaniciID); return(0); } }