/// <summary> /// ÜYE ID, OLUSMA_ZAMANI,GUID GÜNCELLENMEZ /// </summary> /// <param name="ptSiparis"></param> /// <returns></returns> public short DuzenleSiparis(TBLSIPARIS ptSiparis) { try { DbCommand dbCommand = db.GetSqlStringCommand("UPDATE TBLSIPARIS SET FATURA_ADI=@FATURA_ADI, FATURA_VERGINO=@FATURA_VERGINO, ADRES=@ADRES, BANKAID=@BANKAID, SPOSSONUC=@SPOSSONUC,ODEMETIPI=@ODEMETIPI,KARGOID=@KARGOID,KARGOKODU=@KARGOKODU,SIPARISDURUMU=@SIPARISDURUMU, DEGISTIREN=@DEGISTIREN, DEGISME_ZAMANI=@DEGISME_ZAMANI WHERE ID=@ID"); db.AddInParameter(dbCommand, "ID", DbType.Int64, ptSiparis.ID); db.AddInParameter(dbCommand, "FATURA_ADI", DbType.String, ptSiparis.FATURA_ADI); db.AddInParameter(dbCommand, "FATURA_VERGINO", DbType.String, ptSiparis.FATURA_VERGINO); //db.AddInParameter(dbCommand, "TUTAR", DbType.Decimal, ptSiparis.TUTAR); db.AddInParameter(dbCommand, "ADRES", DbType.String, ptSiparis.ADRES); db.AddInParameter(dbCommand, "BANKAID", DbType.Int16, ptSiparis.BANKAID); db.AddInParameter(dbCommand, "KARGOID", DbType.Int16, ptSiparis.KARGOID); db.AddInParameter(dbCommand, "KARGOKODU", DbType.String, ptSiparis.KARGOKODU); db.AddInParameter(dbCommand, "SPOSSONUC", DbType.String, ptSiparis.SPOSSONUC); db.AddInParameter(dbCommand, "ODEMETIPI", DbType.Int16, (short)ptSiparis.ODEMETIPI); db.AddInParameter(dbCommand, "SIPARISDURUMU", DbType.Int16, (short)ptSiparis.SIPARISDURUMU); db.AddInParameter(dbCommand, "DEGISTIREN", DbType.Int32, ptSiparis.DEGISTIREN); db.AddInParameter(dbCommand, "DEGISME_ZAMANI", DbType.DateTime, DateTime.Now); db.ExecuteNonQuery(dbCommand); return(1); } catch (Exception ex) { cLog.Write(ex, _iKullaniciID); return(0); } }
/// <summary> /// ilk başta kargo bilgisi ve değişme bilgisieklenmez /// </summary> /// <param name="ptSiparis"></param> /// <returns></returns> public long EkleSparis(TBLSIPARIS ptSiparis) { try { DbCommand dbCommand = db.GetSqlStringCommand("INSERT INTO TBLSIPARIS(UYEID,FATURA_ADI, FATURA_VERGINO,TUTAR,ADRES,BANKAID,SPOSSONUC,ODEMETIPI,SIPARISDURUMU,OLUSMA_ZAMANI,GUID) VALUES(@UYEID,@FATURA_ADI,@FATURA_VERGINO,@TUTAR,@ADRES,@BANKAID,@SPOSSONUC, @ODEMETIPI, @SIPARISDURUMU, @OLUSMA_ZAMANI,@GUID) SELECT @@IDENTITY"); db.AddInParameter(dbCommand, "UYEID", DbType.Int32, ptSiparis.UYEID); db.AddInParameter(dbCommand, "FATURA_ADI", DbType.String, ptSiparis.FATURA_ADI); db.AddInParameter(dbCommand, "FATURA_VERGINO", DbType.String, ptSiparis.FATURA_VERGINO); db.AddInParameter(dbCommand, "TUTAR", DbType.Decimal, ptSiparis.TUTAR); db.AddInParameter(dbCommand, "ADRES", DbType.String, ptSiparis.ADRES); db.AddInParameter(dbCommand, "BANKAID", DbType.Int16, ptSiparis.BANKAID); db.AddInParameter(dbCommand, "SPOSSONUC", DbType.String, ptSiparis.SPOSSONUC); db.AddInParameter(dbCommand, "ODEMETIPI", DbType.Int16, (short)ptSiparis.ODEMETIPI); db.AddInParameter(dbCommand, "SIPARISDURUMU", DbType.Int16, (short)ptSiparis.SIPARISDURUMU); db.AddInParameter(dbCommand, "OLUSMA_ZAMANI", DbType.DateTime, DateTime.Now); db.AddInParameter(dbCommand, "GUID", DbType.String, Guid.NewGuid().ToString()); return(db.ExecuteScalar(dbCommand).ToLong(0)); } catch (Exception ex) { cLog.Write(ex, _iKullaniciID); return(0); } }