public AdsDbObjects(string p1, string p2, string p3, SharedValidators.DataBase dataBase)
{
// TODO: Complete member initialization
this.inputFolder = p1;
this.OutputFolder = p2;
this.FileName = p3;
this.adsdb = dataBase;
}
public void DoRandomizeSubmission(string mdbfile, DateTime dateTime, int startIndex=0)
{
if (String.IsNullOrEmpty(mdbfile))
{
SharedValidators.Log.LogMessages("Information : DoRandomizeSubmission : File name is blank ");
MessageBox.Show("File name is blank");
return;
}
if (String.IsNullOrEmpty(dateTime.ToString()) || dateTime.Year <2015)
{
SharedValidators.Log.LogMessages("Information : DoRandomizeSubmission : In correct Start Date time ");
MessageBox.Show("In correct Start Date time");
return;
}
try
{
SharedValidators.DataBase Dbmdb;
Dbmdb = new SharedValidators.DataBase(mdbfile);
int rowcount = Convert.ToInt32(Dbmdb.getRowCount());
if (Dbmdb.dataTable.Columns.Count < 70)
{
MessageBox.Show("Invalid database.mdb file. Please check..");
Dbmdb.dataTable.Rows.Clear();
Dbmdb.dataTable.Columns.Clear();
return;
}
this.form1.InitializeProgress(rowcount + 10);
DateTime StartDatetime = dateTime;
Random rnd = new Random();
for (int i = startIndex; i < Dbmdb.dataTable.Rows.Count; i++)
{
string skey = Dbmdb.dataTable.Rows[i]["imagePath"].ToString();
string updatedatetime = Dbmdb.dataTable.Rows[i]["lastEdited"].ToString();
int valuetoAdd = rnd.Next(1, 600) + 180;
StartDatetime = StartDatetime.AddSeconds(valuetoAdd);
DateTime updatetime = new DateTime(1900, 1, 1);
if (updatedatetime != "")
{
updatetime = StartDatetime.AddDays(1).AddSeconds(valuetoAdd);
}
Dbmdb.UpdateDateTime(skey, StartDatetime, updatetime);
this.form1.setProgress();
}
Dbmdb.CommitChanges();
this.form1.DoneProgress();
SharedValidators.Log.LogMessages("Information : DoRandomizeSubmission : Done");
}
catch(Exception ex1 )
{
SharedValidators.Log.LogMessages("Error : DoRandomizeSubmission :" + ex1.Message.ToString());
}
}
private void btnSaveAndAutomate_Click(object sender, EventArgs e)
{
if (((DataTable)dgDatabase.DataSource).Rows.Count < 1)
{
MessageBox.Show("Nothing to Save and Automate.");
SharedValidators.Log.LogMessages(" Error : next_Click: Nothing to Save and Automate. ");
return;
}
saveprogress_Click(btnsaveprogress, new EventArgs());
// panel3.Visible = false;
foreach (var process in Process.GetProcesses())
{
if (process.ProcessName == "DEApp")
{
process.Kill();
}
}
DataRow[] dr = ((DataTable)dgDatabase.DataSource).Select("Verified=true");
if (dr.Length > 0)
{
int fField = Convert.ToInt32(ConfigurationManager.AppSettings["FormFields"].ToString());
int loginRequired = Convert.ToInt32(ConfigurationManager.AppSettings["loginRequired"].ToString());
string appPath = ConfigurationManager.AppSettings["appPath"].ToString();
string loginWinName = ConfigurationManager.AppSettings["loginWindowName"].ToString();
string MainWinName = ConfigurationManager.AppSettings["MainWindowName"].ToString();
string DriveName = ConfigurationManager.AppSettings["DriveName"].ToString();
//lblStatus.Text = dr.Length.ToString() + " Records to fill";
ExtraFeatures feature = new ExtraFeatures(this);
Dbmdb = new SharedValidators.DataBase("database.mdb");
Dbmdb.getRowCount();
DateTime DT = Convert.ToDateTime(Dbmdb.dataTable.Rows[Dbmdb.dataTable.Rows.Count - 1]["submittedOn"].ToString());
ADS.Form.Filler.Scenarios.Win32Tests x = new ADS.Form.Filler.Scenarios.Win32Tests();
// x.NotepadTests();
string eMessage = x.USdeap(appPath, dr, fField, loginRequired, loginWinName, MainWinName, lblInputdirectory.Text, DriveName);
if (!String.IsNullOrEmpty(eMessage))
{
SharedValidators.Log.LogMessages("Error : During Automation " + eMessage);
return;
}
feature.DoRandomizeSubmission("database.mdb", DT, Dbmdb.dataTable.Rows.Count);
}
}
private void OFileDialog_FileOk(object sender, CancelEventArgs e)
{
if (OFileDialog.Tag.ToString() == "1")
{
lblDatabasemdb.Text = OFileDialog.FileName;
Dbmdb = new SharedValidators.DataBase(lblDatabasemdb.Text);
int rowcount = Convert.ToInt32(Dbmdb.getRowCount());
if (Dbmdb.dataTable.Columns.Count < 70)
{
MessageBox.Show("Invalid database.mdb file. Please check..");
Dbmdb.dataTable.Rows.Clear();
Dbmdb.dataTable.Columns.Clear();
return;
}
lblDBcount.Text = rowcount.ToString() + " Rows ";
btnViewMdb.Enabled = (rowcount > 0);
}
if (OFileDialog.Tag.ToString() == "2")
{
lblWorkloadmdb.Text = OFileDialog.FileName;
wkmdb = new SharedValidators.DataBase(lblWorkloadmdb.Text);
int rowcount = Convert.ToInt32(wkmdb.getRowCount());
if (wkmdb.dataTable.Columns.Count > 1)
{
MessageBox.Show("Invalid workload.mdb file. Please check..");
wkmdb.dataTable.Rows.Clear();
wkmdb.dataTable.Columns.Clear();
return;
}
lblworkLoadcount.Text = rowcount.ToString() + " Rows ";
btnAddRowstoDb.Enabled = (rowcount > 0);
}
if (OFileDialog.Tag.ToString() == "3")
{
lblAds.Text = OFileDialog.FileName;
}
if (OFileDialog.Tag.ToString() == "21")
{
btnfirstfile.Text = OFileDialog.FileName;
}
if (OFileDialog.Tag.ToString() == "22")
{
btnsecondfile.Text = OFileDialog.FileName;
}
}
