protected void PopulateState()
{
BusinessLayer.Common.State objState = new BusinessLayer.Common.State();
state = objState.GetStateById(StateId);
if (state != null)
{
StateId = state.StateId;
txtStateName.Text = state.StateName.ToString();
Message.Show = false;
btnSave.Text = "Update";
}
}
public static void Save(Entity.Common.State state)
{
using (DataManager oDm = new DataManager())
{
oDm.Add("@pStateId", SqlDbType.Int, ParameterDirection.InputOutput, state.StateId);
oDm.Add("@pStateName", SqlDbType.VarChar, 30, state.StateName);
oDm.CommandType = CommandType.StoredProcedure;
oDm.ExecuteNonQuery("State_Save");
state.StateId = (int)oDm["@pStateId"].Value;
}
}
public static Entity.Common.State GetStateById(int stateId)
{
using (DataManager oDm = new DataManager())
{
oDm.CommandType = CommandType.StoredProcedure;
oDm.Add("@pStateId", SqlDbType.Int, ParameterDirection.Input, stateId);
SqlDataReader dr = oDm.ExecuteReader("State_GetById");
Entity.Common.State state = new Entity.Common.State();
if (dr.HasRows)
{
while (dr.Read())
{
state.StateId = stateId;
state.StateName = (dr[1] == DBNull.Value) ? "" : dr[1].ToString();
}
}
return(state);
}
}
public void Save(Entity.Common.State state)
{
DataAccess.Common.State.Save(state);
}
