public static BOStateProvince GetByName(string Name) { SqlConnection con = new SqlConnection(GetConnectionString()); con.Open(); try { SqlCommand cmd = new SqlCommand("P_StateProvince_GetByName", con); cmd.CommandType = CommandType.StoredProcedure; SetVarCharParameter(cmd.Parameters, "@Name", 100, Name, false); SqlDataReader rdr = cmd.ExecuteReader(CommandBehavior.SingleResult); try { if (rdr.Read()) { BOStateProvince businessObject = new BOStateProvince(rdr); return businessObject; } } finally { rdr.Close(); } } finally { con.Close(); } return null; }
public BOStateProvinceComparer(BOStateProvince.Columns column, BOStateProvince.SortDirections direction) { _column = column; _direction = direction; }
protected override void BeforeSave(SQLTransaction trans) { if (StateProvince == null) StateProvince = new BOStateProvince(1); base.BeforeSave(trans); }