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