public bool RealEstateOwnersInfo_Update(RealEstateOwnersInfo data)
{
using (DbCommand cmd = db.GetStoredProcCommand("RealEstateOwners_Update"))
{
cmd.Parameters.Add(new SqlParameter("@RealEstateOwnersID", data.RealEstateOwnersID));
cmd.Parameters.Add(new SqlParameter("@RealEstateOwnersType", data.RealEstateOwnersType));
cmd.Parameters.Add(new SqlParameter("@RealEstateOwnersName", data.RealEstateOwnersName));
cmd.Parameters.Add(new SqlParameter("@CLUR", data.CLUR));
cmd.Parameters.Add(new SqlParameter("@Address", data.Address));
cmd.Parameters.Add(new SqlParameter("@MobilePhone", data.MobilePhone));
cmd.Parameters.Add(new SqlParameter("@Email", data.Email));
cmd.Parameters.Add(new SqlParameter("@Gender", data.Gender));
cmd.Parameters.Add(new SqlParameter("@IdentityCard", data.IdentityCard));
try
{
db.ExecuteNonQuery(cmd);
return(true);
}
catch (Exception ex)
{
return(false);
//throw ex;
}
finally
{
if (cmd != null)
{
cmd.Dispose();
}
}
}
}
public RealEstateOwnersInfo RealEstateOwnersInfoIDataReader(IDataReader dr)
{
RealEstateOwnersInfo obj = new RealEstateOwnersInfo();
obj.RealEstateOwnersID = (dr["RealEstateOwnersID"] is DBNull) ? string.Empty : dr["RealEstateOwnersID"].ToString();
obj.RealEstateOwnersType = (dr["RealEstateOwnersType"] is DBNull) ? string.Empty : dr["RealEstateOwnersType"].ToString();
obj.RealEstateOwnersName = (dr["RealEstateOwnersName"] is DBNull) ? string.Empty : dr["RealEstateOwnersName"].ToString();
obj.CLUR = (dr["CLUR"] is DBNull) ? string.Empty : dr["CLUR"].ToString();
obj.Address = (dr["Address"] is DBNull) ? string.Empty : dr["Address"].ToString();
obj.MobilePhone = (dr["MobilePhone"] is DBNull) ? string.Empty : dr["MobilePhone"].ToString();
obj.Email = (dr["Email"] is DBNull) ? string.Empty : dr["Email"].ToString();
obj.Gender = (dr["Gender"] is DBNull) ? string.Empty : dr["Gender"].ToString();
obj.IdentityCard = (dr["IdentityCard"] is DBNull) ? string.Empty : dr["IdentityCard"].ToString();
return(obj);
}
public int RealEstateOwnersInfo_Insert(RealEstateOwnersInfo data, int ID)
{
using (SqlCommand cmd = new SqlCommand("RealEstateOwners_Insert", GetConnection()))
{
cmd.CommandType = CommandType.StoredProcedure;
//cmd.Parameters.Add(new SqlParameter("@RealEstateOwnersID", data.RealEstateOwnersID));
cmd.Parameters.Add(new SqlParameter("@RealEstateOwnersType", data.RealEstateOwnersType));
cmd.Parameters.Add(new SqlParameter("@RealEstateOwnersName", data.RealEstateOwnersName));
cmd.Parameters.Add(new SqlParameter("@CLUR", data.CLUR));
cmd.Parameters.Add(new SqlParameter("@Address", data.Address));
cmd.Parameters.Add(new SqlParameter("@MobilePhone", data.MobilePhone));
cmd.Parameters.Add(new SqlParameter("@Email", data.Email));
cmd.Parameters.Add(new SqlParameter("@Gender", data.Gender));
cmd.Parameters.Add(new SqlParameter("@IdentityCard", data.IdentityCard));
//cmd.Parameters.Add(new SqlParameter("@Lang", data.Lang));
try
{
SqlDataReader reader = cmd.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
ID = int.Parse(reader[0].ToString());
}
}
reader.Close();
}
catch (Exception ex)
{
//throw ex;
return(-1);
}
finally
{
if (cmd != null)
{
cmd.Dispose();
}
}
return(ID);
}
}