public BrokerInfo BrokerInfoIDataReader(IDataReader dr) { BrokerInfo obj = new BrokerInfo(); obj.BrokerID = (dr["BrokerID"] is DBNull) ? string.Empty : dr["BrokerID"].ToString(); obj.Gender = (dr["Gender"] is DBNull) ? string.Empty : dr["Gender"].ToString(); obj.Name = (dr["Name"] is DBNull) ? string.Empty : dr["Name"].ToString(); obj.Birthday = (dr["Birthday"] is DBNull) ? string.Empty : dr["Birthday"].ToString(); obj.IdentityCard = (dr["IdentityCard"] is DBNull) ? string.Empty : dr["IdentityCard"].ToString(); obj.About = (dr["About"] is DBNull) ? string.Empty : dr["About"].ToString(); obj.Address = (dr["Address"] is DBNull) ? string.Empty : dr["Address"].ToString(); obj.HomePhone = (dr["HomePhone"] is DBNull) ? string.Empty : dr["HomePhone"].ToString(); obj.MobiPhone = (dr["MobiPhone"] is DBNull) ? string.Empty : dr["MobiPhone"].ToString(); obj.Email = (dr["Email"] is DBNull) ? string.Empty : dr["Email"].ToString(); obj.PropertyNumber = (dr["PropertyNumber"] is DBNull) ? string.Empty : dr["PropertyNumber"].ToString(); obj.RealEstateName = (dr["RealEstateName"] is DBNull) ? string.Empty : dr["RealEstateName"].ToString(); return(obj); }
public bool BrokerInfo_Update(BrokerInfo data) { using (SqlCommand dbCmd = new SqlCommand("Banner_Update", GetConnection())) { dbCmd.CommandType = CommandType.StoredProcedure; dbCmd.Parameters.Add(new SqlParameter("@BrokerID", data.BrokerID)); dbCmd.Parameters.Add(new SqlParameter("@Name", data.Name)); dbCmd.Parameters.Add(new SqlParameter("@Gender", data.Gender)); dbCmd.Parameters.Add(new SqlParameter("@Birthday", data.Birthday)); dbCmd.Parameters.Add(new SqlParameter("@About", data.About)); dbCmd.Parameters.Add(new SqlParameter("@IdentityCard", data.IdentityCard)); dbCmd.Parameters.Add(new SqlParameter("@Address", data.Address)); dbCmd.Parameters.Add(new SqlParameter("@HomePhone", data.HomePhone)); dbCmd.Parameters.Add(new SqlParameter("@MobiPhone", data.MobiPhone)); dbCmd.Parameters.Add(new SqlParameter("@Email", data.Email)); dbCmd.Parameters.Add(new SqlParameter("@PropertyNumber", data.PropertyNumber)); dbCmd.Parameters.Add(new SqlParameter("@RealEstateName", data.RealEstateName)); dbCmd.ExecuteNonQuery(); } //Clear cache System.Web.HttpContext.Current.Cache.Remove("BrokerInfo"); return(true); }