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);
}
}
