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();
}
