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