public int Insert(BANKS entity) { OracleCommand command = (OracleCommand)Session.Connection.CreateCommand(); command.AppendText(string.Format("insert into {0}({1}) values ({2})", TableName, "URID,CODE,NAME,SYBANKID,DIRECTBANKCODE,DIRECTFLAG,DESCRIPTION,ISACTIVE,DISPLAYORDER,CREATEDON,CREATEDBY,LASTMODIFIEDON,LASTMODIFIEDBY,ROWVERSION")); command.AppendParameter(Session.DBParameterGenerator.GetParameter(entity.URID, BANKS.URIDProperty)); command.AppendText(", "); command.AppendParameter(Session.DBParameterGenerator.GetParameter(entity.CODE, BANKS.CODEProperty)); command.AppendText(", "); command.AppendParameter(Session.DBParameterGenerator.GetParameter(entity.NAME, BANKS.NAMEProperty)); command.AppendText(", "); command.AppendParameter(Session.DBParameterGenerator.GetParameter(entity.SYBANKID, BANKS.SYBANKIDProperty)); command.AppendText(", "); command.AppendParameter(Session.DBParameterGenerator.GetParameter(entity.DIRECTBANKCODE, BANKS.DIRECTBANKCODEProperty)); command.AppendText(", "); command.AppendParameter(Session.DBParameterGenerator.GetParameter(entity.DIRECTFLAG, BANKS.DIRECTFLAGProperty)); command.AppendText(", "); command.AppendParameter(Session.DBParameterGenerator.GetParameter(entity.DESCRIPTION, BANKS.DESCRIPTIONProperty)); command.AppendText(", "); command.AppendParameter(Session.DBParameterGenerator.GetParameter(entity.ISACTIVE, BANKS.ISACTIVEProperty)); command.AppendText(", "); command.AppendParameter(Session.DBParameterGenerator.GetParameter(entity.DISPLAYORDER, BANKS.DISPLAYORDERProperty)); command.AppendText(", "); command.AppendParameter(Session.DBParameterGenerator.GetParameter(entity.CREATEDON, BANKS.CREATEDONProperty)); command.AppendText(", "); command.AppendParameter(Session.DBParameterGenerator.GetParameter(entity.CREATEDBY, BANKS.CREATEDBYProperty)); command.AppendText(", "); command.AppendParameter(Session.DBParameterGenerator.GetParameter(entity.LASTMODIFIEDON, BANKS.LASTMODIFIEDONProperty)); command.AppendText(", "); command.AppendParameter(Session.DBParameterGenerator.GetParameter(entity.LASTMODIFIEDBY, BANKS.LASTMODIFIEDBYProperty)); command.AppendText(", "); command.AppendParameter(Session.DBParameterGenerator.GetParameter(entity.ROWVERSION, BANKS.ROWVERSIONProperty)); return(Session.ExecuteNonQuery(command)); }
public IHttpActionResult PostBANKS(BANKS bANKS) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } db.BANKS.Add(bANKS); try { db.SaveChanges(); } catch (DbUpdateException) { if (BANKSExists(bANKS.BANK_ID)) { return(Conflict()); } else { throw; } } return(CreatedAtRoute("DefaultApi", new { id = bANKS.BANK_ID }, bANKS)); }
public IHttpActionResult PutBANKS(int id, BANKS bANKS) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != bANKS.BANK_ID) { return(BadRequest()); } db.Entry(bANKS).State = EntityState.Modified; try { db.SaveChanges(); } catch (DbUpdateConcurrencyException) { if (!BANKSExists(id)) { return(NotFound()); } else { throw; } } return(StatusCode(HttpStatusCode.NoContent)); }
public IHttpActionResult GetBANKS(int id) { BANKS bANKS = db.BANKS.Find(id); if (bANKS == null) { return(NotFound()); } return(Ok(bANKS)); }
private void btnThem_Click(object sender, RoutedEventArgs e) { using (var db = new MoneyEntity()) { BANKS banks = new BANKS() { Name = txtName.Text }; db.bANKs.Add(banks); db.SaveChanges(); MessageBox.Show("Thêm thành công", "Thông báo", MessageBoxButton.OK); Close(); } }
public IHttpActionResult DeleteBANKS(int id) { BANKS bANKS = db.BANKS.Find(id); if (bANKS == null) { return(NotFound()); } db.BANKS.Remove(bANKS); db.SaveChanges(); return(Ok(bANKS)); }
public BANKS SelectOne(string code, string name) { OracleCommand command = (OracleCommand)Session.Connection.CreateCommand(); command.CommandText = string.Format("select * from {0} where {1}", TableName, "CODE = :CODE,NAME = :NAME"); command.Parameters.Add(Session.DBParameterGenerator.GetParameter(code, BANKS.CODEProperty)); command.Parameters.Add(Session.DBParameterGenerator.GetParameter(name, BANKS.NAMEProperty)); var reader = Session.ExecuteDataReader(command); BANKS result = null; if (reader.Read()) { result = new BANKS(reader); } return(result); }
//public int InsertBANKSList(IEnumerable<BANKS> entityList) public int Insert(BANKS entity) { OracleCommand command = (OracleCommand)Session.Connection.CreateCommand(); command.CommandText = string.Format("insert into {0}({1}) values ({2})", TableName, "URID,CODE,NAME,SYBANKID,DIRECTBANKCODE,DIRECTFLAG,DESCRIPTION,ISACTIVE,DISPLAYORDER,CREATEDON,CREATEDBY,LASTMODIFIEDON,LASTMODIFIEDBY,ROWVERSION", ":URID,:CODE,:NAME,:SYBANKID,:DIRECTBANKCODE,:DIRECTFLAG,:DESCRIPTION,:ISACTIVE,:DISPLAYORDER,:CREATEDON,:CREATEDBY,:LASTMODIFIEDON,:LASTMODIFIEDBY,:ROWVERSION"); command.Parameters.Add(new OracleParameter("URID", OracleDbType.Decimal, 10) { Value = entity.URID }); command.Parameters.Add(new OracleParameter("CODE", OracleDbType.Varchar2, 20) { Value = entity.CODE }); command.Parameters.Add(new OracleParameter("NAME", OracleDbType.Varchar2, 64) { Value = entity.NAME }); command.Parameters.Add(new OracleParameter("SYBANKID", OracleDbType.Decimal, 10) { Value = entity.SYBANKID }); command.Parameters.Add(new OracleParameter("DIRECTBANKCODE", OracleDbType.Varchar2, 20) { Value = entity.DIRECTBANKCODE }); command.Parameters.Add(new OracleParameter("DIRECTFLAG", OracleDbType.Decimal, 2) { Value = entity.DIRECTFLAG }); command.Parameters.Add(new OracleParameter("DESCRIPTION", OracleDbType.Varchar2, 512) { Value = entity.DESCRIPTION }); command.Parameters.Add(new OracleParameter("ISACTIVE", OracleDbType.Decimal, 2) { Value = entity.ISACTIVE }); command.Parameters.Add(new OracleParameter("DISPLAYORDER", OracleDbType.Decimal, 10) { Value = entity.DISPLAYORDER }); command.Parameters.Add(new OracleParameter("CREATEDON", OracleDbType.Date) { Value = entity.CREATEDON }); command.Parameters.Add(new OracleParameter("CREATEDBY", OracleDbType.Decimal, 10) { Value = entity.CREATEDBY }); command.Parameters.Add(new OracleParameter("LASTMODIFIEDON", OracleDbType.Date) { Value = entity.LASTMODIFIEDON }); command.Parameters.Add(new OracleParameter("LASTMODIFIEDBY", OracleDbType.Decimal, 10) { Value = entity.LASTMODIFIEDBY }); command.Parameters.Add(new OracleParameter("ROWVERSION", OracleDbType.Decimal, 19) { Value = entity.ROWVERSION }); return(Session.ExecuteNonQuery(command)); }
//public int UpdateBANKSList(IEnumerable<BANKS> entityList) public int UpdateBANKS(BANKS entity) { string sql = string.Format("update {0} set {2} where urid = {1};", TableName, "", ""); return(Session.ExecuteNonQuery(sql)); }