public override void InputFormFields() { //if (string.IsNullOrWhiteSpace(Data.Title)) //{ // Title_textbox.SendKeys(Data.Title); // //Data.Title = string.Format("Web Test Passage: {0}", DateTime.Now.ToString("yyMMddMMssfff")); //} if (Data.Title != null) { Title_textbox.Wait(5).Clear(); Title_textbox.SendKeys(Data.Title); } if (Data.Subject != null) { SubjectSelect.Wait(5).SelectByText(Data.Subject); } if (Data.GradeLow != null) { GradeFromSelect.Wait(5).SelectByText(Data.GradeLow); this.DriverCommands.WaitAndMeasurePageLoadTime(); InitElements(); } if (Data.GradeHigh != null) { GradeToSelect.Wait(5).SelectByText(Data.GradeHigh); this.DriverCommands.WaitAndMeasurePageLoadTime(); InitElements(); } //HideOptionalProperties_link.Wait(5).Click(); SelectShowOptionalProperties(); if (Data.AdditionalPassageID != null) { AdditionalPassageID_textbox.Wait(5).Clear(); AdditionalPassageID_textbox.SendKeys(Data.AdditionalPassageID); } if (Data.AssetType != null) { AssetType_textbox.Wait(5).Clear(); AssetType_textbox.SendKeys(Data.AssetType); } if (Data.Author != null) { Author_textbox.Wait(5).Clear(); Author_textbox.SendKeys(Data.Author); } if (Data.CourseID != null) { CourseID_textbox.Wait(5).Clear(); CourseID_textbox.SendKeys(Data.CourseID); } if (Data.FleschKincaid != null) { FleschKincaid_textbox.SendKeys(Data.FleschKincaid); } if (Data.Genre != null) { Genre_textbox.Wait(5).Clear(); Genre_textbox.SendKeys(Data.Genre); } if (Data.QuestionLanguage != null) { QuestionLanguage_dropdown.Wait(5).SelectByText(Data.QuestionLanguage); this.DriverCommands.WaitAndMeasurePageLoadTime(); InitElements(); //when selecting a different language, the page reloads and hides the optional properties SelectShowOptionalProperties(); } if (Data.LexileCode != null) // new, implemented in 160 { LexileCode_dropdown.Wait(5).SelectByText(Data.LexileCode); } if (Data.Lexile != null) { Lexile_textbox.Wait(5).Clear(); Lexile_textbox.SendKeys(Data.Lexile); } // commented for 160 since checkbox is removed //if (Data.BeginningReader != null) //{ // if (Data.BeginningReader.Equals("1")) // { // SelectCourseName(BeginningReader_chkbox, true); // } //} if (Data.Publisher != null) { Publisher_textbox.Wait(5).Clear(); Publisher_textbox.SendKeys(Data.Publisher); } if (Data.ReadingMaturityMetric != null) { ReadingMaturityMetric_textbox.Wait(5).SendKeys(Data.ReadingMaturityMetric); } if (Data.Topic != null) { Topic_textbox.Wait(5).Clear(); Topic_textbox.SendKeys(Data.Topic); } if (Data.Type != null) { Type_dropdown.Wait(5).SelectByText(Data.Type); } if (Data.Year != null) { Year_textbox.Wait(5).Clear(); Year_textbox.SendKeys(Data.Year); } if (Data.Batch != null) { Batch_textbox.Wait(5).Clear(); Batch_textbox.Wait(5).SendKeys(Data.Batch); } if (Data.PassageText != null) { this.Utilities.DoFileUpload(Editor, Data.AutoItData, Data.FileUploadTree, Data.PassageText); Editor.ContentData = Data.PassageText; Editor.InputFormFields(); } }
private void AddItem_btn_Click(object sender, EventArgs e) { string itemno = ""; string conStr = ConfigurationManager.ConnectionStrings["coonstring"].ToString(); SqlConnection connection = new SqlConnection(conStr); connection.Open(); SqlDataReader read; SqlCommand command = new SqlCommand("FetchItemNo", connection); command.CommandType = CommandType.StoredProcedure; command.Parameters.AddWithValue("@productname", itemname_txtboxauto.Text); read = command.ExecuteReader(); while (read.Read()) { itemno = read["PrdId"].ToString(); } connection.Close(); // SqlCommand cmm = new SqlCommand(@"INSERT INTO tbl_Stock_dummy (PurchaseID,ItemName,Company,Batch,ExpDate,PQty,Rate,Amount)VALUES('" + PURCHASEid_auto_label.Text + "','" + itemname_txtboxauto.Text + "','" + company_textbox.Text + "','" + Batch_textbox.Text + "','" + Exp_textbox.Text + "','" + Pqty_textbox.Text + "','" + Rate_txtbox.Text + "','" + amt_textbox.Text + "')", conn); SqlConnection conn = new SqlConnection(conStr); SqlCommand cmm = new SqlCommand("insert_into_Tablestockdummy", conn); cmm.CommandType = CommandType.StoredProcedure; cmm.Parameters.AddWithValue("@purchaseid", PURCHASEid_auto_label.Text); cmm.Parameters.AddWithValue("@itemno", itemno); cmm.Parameters.AddWithValue("@itemname", itemname_txtboxauto.Text); cmm.Parameters.AddWithValue("@company", company_textbox.Text); cmm.Parameters.AddWithValue("@batch", Batch_textbox.Text); cmm.Parameters.AddWithValue("@expdate", ExpdateTimePicker.Text); cmm.Parameters.AddWithValue("@pqty", Pqty_textbox.Text); cmm.Parameters.AddWithValue("@rate", Rate_txtbox.Text); cmm.Parameters.AddWithValue("@amount", amt_textbox.Text); ///NEWLY ADDED as per requirements cmm.Parameters.AddWithValue("@MRP", MRP_TXTBOX.Text); cmm.Parameters.AddWithValue("@Rack", Rack_txtbox.Text); cmm.Parameters.AddWithValue("@SGST", sgst_textBox.Text); cmm.Parameters.AddWithValue("@HSNcode", Hsn_textbox.Text); cmm.Parameters.AddWithValue("@Discount", discount_txetbox.Text); cmm.Parameters.AddWithValue("@NetRate", Net_Rate_txtbox.Text); cmm.Parameters.AddWithValue("@Srate", Srate_txtbox.Text); cmm.Parameters.AddWithValue("@Free", Freetxtbox.Text); conn.Open(); cmm.ExecuteNonQuery(); conn.Close(); DisplayData(); itemname_txtboxauto.Clear(); Batch_textbox.Clear(); Rate_txtbox.Clear(); MRP_TXTBOX.Clear(); Rack_txtbox.Clear(); sgst_textBox.Clear(); discount_txetbox.Clear(); Net_Rate_txtbox.Clear(); Hsn_textbox.Clear(); Srate_txtbox.Clear(); Freetxtbox.Clear(); Pqty_textbox.Clear(); company_textbox.Clear(); amt_textbox.Clear(); conn.Open(); SqlDataReader myReader = null; SqlConnection myConnection = new SqlConnection(conStr); //SqlCommand myCommand = new SqlCommand("select SUM(Amount)from tbl_Stock_dummy ", myConnection); SqlCommand myCommand = new SqlCommand("sumfromdummyStock ", myConnection); myConnection.Open(); myReader = myCommand.ExecuteReader(); if (myReader.Read()) { Grandtotal_txtbox.Text = myReader.GetValue(0).ToString(); } conn.Close(); DisplayData(); itemname_txtboxauto.Focus(); }