private void Button_Click(object sender, RoutedEventArgs e) { if (cbx_itemname.SelectedItem != null && cbx_itemcode.SelectedItem != null && txt_quantity.Text != "" && quantityEntered != 0 && cbx_units.SelectedItem != null) { GridIndent gridIndent = new GridIndent(); gridIndent.SlNo = gridIndents.Count + 1; gridIndent.ItemCode = cbx_itemcode.SelectedItem.ToString(); gridIndent.ItemName = cbx_itemname.SelectedItem.ToString(); gridIndent.Quantity = quantityEntered; gridIndent.Technical_Specifications = txt_technical_description.Text.Trim(); gridIndent.Units = cbx_units.SelectedItem.ToString(); gridIndent.Remarks = Txt_remarks.Text.Trim(); gridIndents.Add(gridIndent); grid_indentdata.ItemsSource = null; grid_indentdata.ItemsSource = gridIndents; } else if (cbx_itemname.SelectedItem == null) { MessageBox.Show("Please Select ItemName"); } else if (cbx_itemcode.SelectedItem == null) { MessageBox.Show("Please Select ItemCode"); } else if (txt_quantity.Text == "") { MessageBox.Show("Please Enter Quantity"); } else if (quantityEntered == 0) { MessageBox.Show("Please Enter Valid Quantity"); } else if (cbx_units.SelectedItem == null) { MessageBox.Show("Please Select Units"); } }
private SaveIndent GetIndent(long Id) { SaveIndent saveIndent = new SaveIndent(); long ApprovalId = Convert.ToInt64(HttpContext.Session.GetString(SessionUserID)); try { List <GridIndent> gridIndents = new List <GridIndent>(); using (SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings["SqlConnection"].ToString())) { connection.Open(); SqlCommand testCMD = new SqlCommand("GetIndent", connection); testCMD.CommandType = CommandType.StoredProcedure; testCMD.Parameters.Add(new SqlParameter("@IndentID", System.Data.SqlDbType.BigInt, 50) { Value = Id }); testCMD.Parameters.Add(new SqlParameter("@UserID", System.Data.SqlDbType.VarChar, 300) { Value = ApprovalId }); SqlDataAdapter sqlDataAdapter = new SqlDataAdapter(testCMD); DataSet dataSet = new DataSet(); sqlDataAdapter.Fill(dataSet); int counter = 0; while (counter < dataSet.Tables[0].Rows.Count) { saveIndent.Date = Convert.ToDateTime(dataSet.Tables[0].Rows[counter]["Date"]); saveIndent.LocationCode = Convert.ToInt64(dataSet.Tables[0].Rows[counter]["LocationCode"]); saveIndent.IndentRemarks = Convert.ToString(dataSet.Tables[0].Rows[counter]["Remarks"]); saveIndent.ApproverName = Convert.ToString(dataSet.Tables[0].Rows[counter]["Approver"]); saveIndent.ApprovalID = Convert.ToInt64(dataSet.Tables[0].Rows[counter]["Approver ID"]); saveIndent.ApprovalStatus = Convert.ToString(dataSet.Tables[0].Rows[counter]["ApprovalStatus"]); GridIndent gridIndent = new GridIndent(); gridIndent.SlNo = counter + 1; gridIndent.ItemCategoryName = Convert.ToString(dataSet.Tables[0].Rows[counter]["ItemCategoryName"]); gridIndent.ItemName = Convert.ToString(dataSet.Tables[0].Rows[counter]["ItemName"]); gridIndent.ItemCode = Convert.ToString(dataSet.Tables[0].Rows[counter]["ItemCode"]); gridIndent.Units = Convert.ToString(dataSet.Tables[0].Rows[counter]["Unit"]); gridIndent.Description = Convert.ToString(dataSet.Tables[0].Rows[counter]["Description"]); gridIndent.Technical_Specifications = Convert.ToString(dataSet.Tables[0].Rows[counter]["TechnicalSpecification"]); gridIndent.Quantity = Convert.ToInt32(dataSet.Tables[0].Rows[counter]["Quantity"]); gridIndent.Remarks = Convert.ToString(dataSet.Tables[0].Rows[counter]["Item Remarks"]); gridIndents.Add(gridIndent); saveIndent.Email = Convert.ToString(dataSet.Tables[0].Rows[counter]["Email"]); counter++; } dataSet.Dispose(); } saveIndent.GridIndents = gridIndents; return(saveIndent); } catch (Exception ex) { ////log.Error("Error while fetching Indent information: " + ex.StackTrace); return(saveIndent); } }