public void AddProductsFromExcel(byte[] formData, long storeOrderId) { using (IDAL dal = this.DAL) { dal.BeginTransaction(); try { OrderOperations Oop = new OrderOperations(dal); Oop.AddProductsFromExcel(formData, storeOrderId); dal.CommitTransaction(); } catch (Exception ex) { dal.RollbackTransaction(); throw ex; } } }