public static bool tbRecipient_Update(tbRecipient data)
{
return db.tbRecipient_Update(data);
}
public bool tbRecipient_Update(tbRecipient data)
{
using (SqlCommand dbCmd = new SqlCommand("sp_tbRecipient_Update", GetConnection()))
{
dbCmd.CommandType = CommandType.StoredProcedure;
dbCmd.Parameters.Add(new SqlParameter("@ireid", data.ireid));
dbCmd.Parameters.Add(new SqlParameter("@iusid", data.iusid));
dbCmd.Parameters.Add(new SqlParameter("@vcusname", data.vcusname));
dbCmd.Parameters.Add(new SqlParameter("@dbirthday", data.dbirthday));
dbCmd.Parameters.Add(new SqlParameter("@vprovince", data.vprovince));
dbCmd.Parameters.Add(new SqlParameter("@vaddress", data.vaddress));
dbCmd.Parameters.Add(new SqlParameter("@vphone", data.vphone));
dbCmd.Parameters.Add(new SqlParameter("@vmobile", data.vmobile));
dbCmd.Parameters.Add(new SqlParameter("@vemail", data.vemail));
dbCmd.Parameters.Add(new SqlParameter("@dcreatedate", data.dcreatedate));
dbCmd.Parameters.Add(new SqlParameter("@istatus", data.istatus));
dbCmd.ExecuteNonQuery();
}
//Clear cache
System.Web.HttpContext.Current.Cache.Remove("tbRecipient");
return true;
}
public static bool tbRecipient_Insert(tbRecipient data)
{
return db.tbRecipient_Insert(data);
}