private void UpdateDatabase()
        {
            DB.Open();
            DB.BeginTransaction();
            try
            {
                MaterialsAdd materialsAdd = new MaterialsAdd(materialsAddTDS);
                materialsAdd.Save();

                DB.CommitTransaction();

                // Store datasets
                materialsAddTDS.AcceptChanges();
                Session["materialsAddTDS"] = materialsAddTDS;

            }
            catch (Exception ex)
            {
                DB.RollbackTransaction();

                string url = string.Format("./../../error_page.aspx?error={0}", ex.Message.Replace('\n', ' '));
                Response.Redirect(url);
            }
        }
        private void PostPageChanges()
        {
            // Load user data
            string description = hdfDescription.Value;
            string size = hdfSize.Value;
            string length = hdfLength.Value;
            string thickness = hdfThickness.Value;
            string type = hdfType.Value;
            string state = hdfState.Value;
            bool deleted = false;
            int companyId = Int32.Parse(hdfCompanyId.Value);
            bool inDataBase = false;

            LiquiForce.LFSLive.BL.Resources.Materials.MaterialsAdd model = new LiquiForce.LFSLive.BL.Resources.Materials.MaterialsAdd(materialsAddTDS);
            hdfMaterialId.Value =  model.Insert( description, size, length, thickness, type, state, deleted, companyId, inDataBase).ToString();

            // Store session
            Session["materialsAddTDS"] = materialsAddTDS;
        }