public void FHH_0002_Updated(CDM_Hang_Hoa p_objHangHoa, List <CDM_Don_Vi_Tinh_Chuyen_Doi> p_arrDVTChuyenDoi) { SqlConnection v_conn = null; SqlTransaction v_trans = null; try { v_conn = CSqlHelper.CreateConnection(CConfig.g_strVTNN_Conn_String); v_conn.Open(); v_trans = v_conn.BeginTransaction(); _objHangHoaDAO.FHH0002_Update_DM_Hang_Hoa(v_conn, v_trans, p_objHangHoa); foreach (CDM_Don_Vi_Tinh_Chuyen_Doi v_obj in p_arrDVTChuyenDoi) { if (v_obj.Auto_ID <= 0) { v_obj.Hang_Hoa_ID = p_objHangHoa.Auto_ID; _objDVTChuyenDoiDAO.FDVTCD_0001_Insert_DM_Don_Vi_Tinh_Chuyen_Doi(v_conn, v_trans, v_obj); } if (v_obj.Auto_ID > 0) { _objDVTChuyenDoiDAO.FDVTCD_0002_Update_DM_Don_Vi_Tinh_Chuyen_Doi(v_conn, v_trans, v_obj); } } v_trans.Commit(); } catch (Exception ex) { throw ex; } finally { v_trans.Dispose(); if (v_conn != null) { v_conn.Close(); } } }
public bool FHH_0001_Insert(CDM_Hang_Hoa p_objHangHoa, List <CDM_Don_Vi_Tinh_Chuyen_Doi> p_arrDVTChuyenDoi) { bool v_blResul = true; SqlConnection v_conn = null; SqlTransaction v_trans = null; try { v_conn = CSqlHelper.CreateConnection(CConfig.g_strVTNN_Conn_String); v_conn.Open(); v_trans = v_conn.BeginTransaction(); Int64 v_iHangHoaID = _objHangHoaDAO.FHH0001_Insert_DM_Hang_Hoa(v_conn, v_trans, p_objHangHoa); foreach (CDM_Don_Vi_Tinh_Chuyen_Doi v_obj in p_arrDVTChuyenDoi) { v_obj.Hang_Hoa_ID = v_iHangHoaID; _objDVTChuyenDoiDAO.FDVTCD_0001_Insert_DM_Don_Vi_Tinh_Chuyen_Doi(v_conn, v_trans, v_obj); } v_trans.Commit(); } catch (Exception ex) { v_blResul = false; throw ex; } finally { v_trans.Dispose(); if (v_conn != null) { v_conn.Close(); } } return(v_blResul); //return _objHangHoaDAO.FHH0001_Insert_DM_Hang_Hoa(p_Cons, p_Trans, p_objHangHoa); }