private int Update(DBConnection Connection, ST_STATE_LDC objST_STATE_L) { int updateCount = 0; StringBuilder sql = new StringBuilder(); sql.Append("proc_ST_STATE_LUUpdate"); DBCommandWarpper dbCommandWrapper = new DBCommandWarpper(Connection.dataBase.GetStoredProcCommand(sql.ToString()), Connection); dbCommandWrapper.AddInParameter("p_ST_STATE", DbType.String, objST_STATE_L.ST_STATE); dbCommandWrapper.AddInParameter("p_ST_STATENAME", DbType.String, objST_STATE_L.ST_STATENAME); if (Connection.Transaction != null) { updateCount = Connection.dataBase.ExecuteNonQuery(dbCommandWrapper.DBCommand, Connection.Transaction); } else { updateCount = Connection.dataBase.ExecuteNonQuery(dbCommandWrapper.DBCommand); } if (updateCount == 0) { objST_STATE_L.IsDirty = IsDirty = true; } return(updateCount); }
public ST_STATE_LDC LoadByPrimaryKey(DBConnection Connection, string ST_STATE) { ST_STATE_LDC objST_STATE_L = new ST_STATE_LDC(); StringBuilder sql = new StringBuilder(); sql.Append("proc_ST_STATE_LULoadByPrimaryKey"); DBCommandWarpper dbCommandWrapper = new DBCommandWarpper(Connection.dataBase.GetStoredProcCommand(sql.ToString()), Connection); dbCommandWrapper.AddInParameter("p_ST_STATE", DbType.String, ST_STATE); IDataReader reader = null; if (Connection.Transaction != null) { reader = Connection.dataBase.ExecuteReader(dbCommandWrapper.DBCommand, Connection.Transaction); } else { reader = Connection.dataBase.ExecuteReader(dbCommandWrapper.DBCommand); } objST_STATE_L = FillObject(reader); return(objST_STATE_L); }
private ST_STATE_LDC FillObject(DataRow row) { ST_STATE_LDC objST_STATE_L = null; objST_STATE_L = new ST_STATE_LDC(); objST_STATE_L.ST_STATE = (String)row["ST_STATE"]; objST_STATE_L.ST_STATENAME = row["ST_STATENAME"] == DBNull.Value ? null : (String)row["ST_STATENAME"]; return(objST_STATE_L); }
private ST_STATE_LDC FillObject(IDataReader reader) { ST_STATE_LDC objST_STATE_L = null; if (reader != null && reader.Read()) { objST_STATE_L = new ST_STATE_LDC(); objST_STATE_L.ST_STATE = (String)reader["ST_STATE"]; objST_STATE_L.ST_STATENAME = reader["ST_STATENAME"] == DBNull.Value ? null : (String)reader["ST_STATENAME"]; reader.Close(); reader.Dispose(); } return(objST_STATE_L); }
public IHttpActionResult GetAll() { ST_STATE_LBL objStates = new ST_STATE_LBL(); List <ST_STATE_LDC> objResultList = new List <ST_STATE_LDC>(); try { ST_STATE_LDC objState = new ST_STATE_LDC(); //objState.ST_STATE = ""; //objState.ST_STATENAME = ""; objResultList = objStates.LoadAll(); //objResultList.Insert (0,objState); return(Ok(new { objResultList })); } catch (Exception ex) { return(new TextResult(ex.Message, Request, ex.StackTrace)); } }
public ST_STATE_LDC LoadByPrimaryKey(string ST_STATE) { DBConnection objConnection = new DBConnection(); ST_STATE_LDA objST_STATE_LDA = new ST_STATE_LDA(); ST_STATE_LDC objST_STATE_LDC = null; try { objConnection.Open(false); objST_STATE_LDC = objST_STATE_LDA.LoadByPrimaryKey(objConnection, ST_STATE); } catch (Exception ex) { throw ex; } finally { objConnection.Close(); } return(objST_STATE_LDC); }