private void btnSave_Click(object sender, EventArgs e) { CResult oValidResult = ValidateForm(); if (oValidResult.IsSuccess) { String sTempStr = txtParentCategoryName.Text.Trim(); if (sTempStr.Equals(String.Empty)) { lblSaveStatus.Text = " Write the name of the category."; lblSaveStatus.Visible = true; } else { CParentCategory oTempParent = new CParentCategory(); oTempParent.ParentCatName = sTempStr; CCategoryManager oManager = new CCategoryManager(); CResult oResult = oManager.AddParentCat(oTempParent); if (oResult.IsSuccess) { lblSaveStatus.Text = " Parent category has been added successfully."; lblSaveStatus.Visible = true; } else { lblSaveStatus.Text = oResult.Message; lblSaveStatus.Visible = true; } } } else { lblSaveStatus.Text = oValidResult.Message; lblSaveStatus.Visible = true; } }
private void btnSave_Click(object sender, EventArgs e) { //To Get parent catagory Order Number String queryStr = SqlQueries.GetQuery(Query.GetMaxParentCategoryNumber); CDalConfig oTempDal = ConfigManager.GetConfig<CDalConfig>(); String tempConnStr = oTempDal.ConnectionString; // Create a new data adapter based on the specified query. SqlDataAdapter dataAdapter = new SqlDataAdapter(queryStr, tempConnStr); // Populate a new data table and bind it to the BindingSource. DataTable table = new DataTable(); //table.Locale = System.Globalization.CultureInfo.InvariantCulture; dataAdapter.Fill(table); int lastMaxParentValue = Convert.ToInt32(table.Rows[0]["Column1"].ToString()); CResult oValidResult = ValidateForm(); if (oValidResult.IsSuccess) { String sTempStr = txtParentCategoryName.Text.Trim(); if (sTempStr.Equals(String.Empty)) { lblSaveStatus.Text = " Write the name of the category."; lblSaveStatus.Visible = true; } else { CParentCategory oTempParent = new CParentCategory(); oTempParent.ParentCatName = sTempStr; oTempParent.ParentCatID = lastMaxParentValue+1; CCategoryManager oManager = new CCategoryManager(); CResult oResult = oManager.AddParentCat(oTempParent); if (oResult.IsSuccess) { lblSaveStatus.Text = " Parent category has been added successfully."; lblSaveStatus.Visible = true; } else { lblSaveStatus.Text = oResult.Message; lblSaveStatus.Visible = true; } } } else { lblSaveStatus.Text = oValidResult.Message; lblSaveStatus.Visible = true; } }