private void button4_Click(object sender, EventArgs e)
{
tableLayoutPanel1.Controls.Clear();
ArrayList param = new ArrayList();
param.Add(textBox1.Text);
DataSet ds = new DBHandler().GetMetaData(1, param);
if (ds != null && ds.Tables.Count > 0)
{
tableLayoutPanel1.RowCount = ds.Tables[0].Rows.Count;
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
Label lbl = new Label();
lbl.Text = ds.Tables[0].Rows[i]["Parameter_name"].ToString().Substring(1) + " (" + ds.Tables[0].Rows[i]["Type"].ToString() + ")";
lbl.Size = new System.Drawing.Size(300, 30);
tableLayoutPanel1.Controls.Add(lbl, 0, i);
TextBox txt = new TextBox();
if (ds.Tables[0].Rows[i]["Type"].ToString().ToLower() == "bigint" || ds.Tables[0].Rows[i]["Type"].ToString().ToLower() == "int" || ds.Tables[0].Rows[i]["Type"].ToString().ToLower() == "float")
txt.Text = "0";
if (ds.Tables[0].Rows[i]["Type"].ToString().ToLower() == "bit")
txt.Text = "false";
tableLayoutPanel1.Controls.Add(txt, 1, i);
}
}
}
private void button1_Click(object sender, EventArgs e)
{
DataSet ds = new DBHandler().Getter(1, GetParams(), textBox1.Text);
if (ds != null && ds.Tables.Count > 0)
{
dataGridView1.Visible = true;
dataGridView1.DataSource = ds.Tables[0];
}
}
private void button1_Click(object sender, EventArgs e)
{
ArrayList param = new ArrayList();
param.Add(19);
DataSet ds = new DBHandler().GetAccountDetails(1, param);
if (ds != null && ds.Tables.Count > 0)
{
MessageBox.Show(ds.Tables[0].Rows.Count.ToString());
}
}
private void button2_Click(object sender, EventArgs e)
{
dataGridView1.Visible = false;
long ID;
try
{
string Message = new DBHandler().settter(1, GetParams(), textBox1.Text, out ID);
MessageBox.Show(Message);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void button3_Click(object sender, EventArgs e)
{
try
{
ArrayList param = new ArrayList();
param.Add(19);
DBHandler db = new DBHandler();
long accountId;
string Message = db.DeleteAccount(1, param, out accountId);
MessageBox.Show(Message);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
int getPrevRow()
{
int i = 0;
ArrayList Param = new ArrayList();
Param.Add(ListViewID);
Param.Add(strColumns);
Param.Add(StrFilterColumn);
Param.Add(Text);
Param.Add(2);
Param.Add(true);
Param.Add("");
Param.Add("");
Param.Add(LanguageID);
DataTable Dt = new PACT.DBHandler.DBHandler().GetCostCenterListViewData(CompanyDBIndex, Param).Tables[0];
if (Dt.Rows.Count > 0)
{
//if (!((DataView)this.ItemsSource).Table.Rows.Contains(Dt.Rows[0][0]))
//{
DataRow dr = ((DataView)this.ItemsSource).Table.NewRow();
for (int j = 0; j < ((DataView)this.ItemsSource).Table.Columns.Count; j++)
{
dr[j] = Dt.Rows[0][j];
}
((DataView)this.ItemsSource).Table.Rows.InsertAt(dr, 0);
((DataView)this.ItemsSource).Table.Rows.RemoveAt(((DataView)this.ItemsSource).Table.Rows.Count - 1);
// }
}
return(i);
}
private void button2_Click(object sender, EventArgs e)
{
ArrayList param = new ArrayList();
param.Add(0);
param.Add("001");
param.Add("Ikram");
param.Add("Hussain");
param.Add("1");
param.Add("2");
param.Add(19);
param.Add(0);
param.Add(0);
param.Add(0);
param.Add(0);
param.Add(0);
param.Add(0);
param.Add(0);
param.Add("Sample");
param.Add("ikmra");
param.Add(1);
param.Add("UserCol1='asdfasdf'");
try
{
DBHandler db = new DBHandler();
long accountId;
string Message = db.SetAccountDetails(1, param, out accountId);
MessageBox.Show(Message);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
int getPrevRow()
{
int i = 0;
ArrayList Param = new ArrayList();
Param.Add(ListViewID);
Param.Add(strColumns);
Param.Add(StrFilterColumn);
Param.Add(Text);
Param.Add(2);
Param.Add(true);
Param.Add("");
Param.Add("");
Param.Add(LanguageID);
DataTable Dt = new PACT.DBHandler.DBHandler().GetCostCenterListViewData(CompanyDBIndex, Param).Tables[0];
if (Dt.Rows.Count > 0)
{
//if (!((DataView)this.ItemsSource).Table.Rows.Contains(Dt.Rows[0][0]))
//{
DataRow dr = ((DataView)this.ItemsSource).Table.NewRow();
for (int j = 0; j < ((DataView)this.ItemsSource).Table.Columns.Count; j++)
{
dr[j] = Dt.Rows[0][j];
}
((DataView)this.ItemsSource).Table.Rows.InsertAt(dr, 0);
((DataView)this.ItemsSource).Table.Rows.RemoveAt(((DataView)this.ItemsSource).Table.Rows.Count - 1);
// }
}
return i;
}
void FillListBox()
{
ArrayList Param = new ArrayList();
Param.Add(ListViewID);
Param.Add(strColumns);
Param.Add(StrFilterColumn);
Param.Add(Text);
if (IsPartiralData)
Param.Add(PageSize);
else
Param.Add(0);
Param.Add(false);
Param.Add("");
if (valueSelected)
Param.Add(this.SelectedValue.ToString());
else
Param.Add("");
Param.Add(LanguageID);
DataTable Dt = new PACT.DBHandler.DBHandler().GetCostCenterListViewData(CompanyDBIndex, Param).Tables[0];
IstextChanged = true;
if (Dt != null && Dt.Rows.Count > 0)
{
if (this.ItemsSource == null)
{
this.ItemsSource = Dt.AsDataView();
// ((DataView)this.ItemsSource).Table.PrimaryKey = new DataColumn[] { ((DataView)this.ItemsSource).Table.Columns[0] };
}
else
{
((DataView)this.ItemsSource).Table.Rows.Clear();
//Dt.PrimaryKey = new DataColumn[] { Dt.Columns[0] };
//for (int i = 0; i < ((DataView)this.ItemsSource).Table.Rows.Count; i++)
//{
// if (!Dt.Rows.Contains(((DataView)this.ItemsSource).Table.Rows[i][0]))
// {
// ((DataView)this.ItemsSource).Table.Rows.RemoveAt(i);
// i--;
// }
//}
for (int i = 0; i < Dt.Rows.Count; i++)
{
//if (((DataView)this.ItemsSource).Table.Rows.Contains(Dt.Rows[i][0]))
// continue;
DataRow dr = ((DataView)this.ItemsSource).Table.NewRow();
for (int j = 0; j < ((DataView)this.ItemsSource).Table.Columns.Count; j++)
{
dr[j] = Dt.Rows[i][j];
}
// if (((DataView)this.ItemsSource).Table.Rows.Count == i)
((DataView)this.ItemsSource).Table.Rows.Add(dr);
//else
// ((DataView)this.ItemsSource).Table.Rows.InsertAt(dr, i);
}
//if (popupDataGrid.Items.Count > 0)
// popupDataGrid.SelectedItem = popupDataGrid.Items[0];
}
//if (txt != this.Text)
//{
// IstextChanged = true;
// this.Text = txt;
// for (int i = 0; i < popupDataGrid.Items.Count; i++)
// {
// if (this.Text == ((DataRowView)popupDataGrid.Items[i]).Row.ItemArray[SearchColumn].ToString())
// {
// popupDataGrid.SelectedItem = popupDataGrid.Items[i];
// return;
// }
// }
//}
}
IstextChanged = false;
}
protected override void OnInitialized(EventArgs e)
{
base.OnInitialized(e);
if (CostCenterID == 0)
return;
ArrayList Param = new ArrayList();
Param.Add(CostCenterID);
Param.Add(TypeID);
Param.Add(UserID);
Param.Add(LanguageID);
DataSet ds = new PACT.DBHandler.DBHandler().GetCostCenterListView(CompanyDBIndex, Param);
ListViewID = Convert.ToInt32(ds.Tables[0].Rows[0]["ListViewID"].ToString());
this.IsEditable = true;
Microsoft.Windows.Controls.DataGridTextColumn dgCol;
dgCol = new Microsoft.Windows.Controls.DataGridTextColumn();
dgCol.Header = strPrimaryKey;
dgCol.Binding = new Binding(strPrimaryKey);
dgCol.Visibility = System.Windows.Visibility.Hidden;
this.Columns.Add(dgCol);
ColumnsList = new ArrayList();
for (int i = 0; i < ds.Tables[1].Rows.Count; i++)
{
if (i == 0)
strColumns = ds.Tables[1].Rows[i]["SysColumnName"].ToString();
else
strColumns += "," + ds.Tables[1].Rows[i]["SysColumnName"].ToString();
ColumnsList.Add(ds.Tables[1].Rows[i]["SysColumnName"].ToString());
dgCol = new Microsoft.Windows.Controls.DataGridTextColumn();
dgCol.Header = ds.Tables[1].Rows[i]["UserColumnName"].ToString();
if (ds.Tables[1].Rows.Count == 1)
dgCol.Width = this.Width;
else
dgCol.Width = Convert.ToInt32(ds.Tables[1].Rows[i]["ColumnWidth"].ToString());
dgCol.CanUserResize = false;
dgCol.CanUserSort = false;
dgCol.Binding = new Binding(ds.Tables[1].Rows[i]["SysColumnName"].ToString());
iWidth += Convert.ToInt32(ds.Tables[1].Rows[i]["ColumnWidth"].ToString());
this.Columns.Add(dgCol);
}
if (this.SelectedValue != null)
valueSelected = true;
//this.SelectedValue = new Binding(strPrimaryKey);
this.SelectedValuePath = strPrimaryKey;
}
private void TestSP_Load(object sender, EventArgs e)
{
ArrayList param = new ArrayList();
DataSet ds = new DBHandler().Getter(1, param, "GetProcedures");
if (ds != null && ds.Tables.Count > 0)
{
cmbProcedures.DataSource = ds.Tables[0];
cmbProcedures.DisplayMember = "name";
cmbProcedures.ValueMember = "name";
}
}
void FillListBox()
{
ArrayList Param = new ArrayList();
Param.Add(ListViewID);
Param.Add(strColumns);
Param.Add(StrFilterColumn);
Param.Add(Text);
if (IsPartiralData)
{
Param.Add(PageSize);
}
else
{
Param.Add(0);
}
Param.Add(false);
Param.Add("");
if (valueSelected)
{
Param.Add(this.SelectedValue.ToString());
}
else
{
Param.Add("");
}
Param.Add(LanguageID);
DataTable Dt = new PACT.DBHandler.DBHandler().GetCostCenterListViewData(CompanyDBIndex, Param).Tables[0];
IstextChanged = true;
if (Dt != null && Dt.Rows.Count > 0)
{
if (this.ItemsSource == null)
{
this.ItemsSource = Dt.AsDataView();
// ((DataView)this.ItemsSource).Table.PrimaryKey = new DataColumn[] { ((DataView)this.ItemsSource).Table.Columns[0] };
}
else
{
((DataView)this.ItemsSource).Table.Rows.Clear();
//Dt.PrimaryKey = new DataColumn[] { Dt.Columns[0] };
//for (int i = 0; i < ((DataView)this.ItemsSource).Table.Rows.Count; i++)
//{
// if (!Dt.Rows.Contains(((DataView)this.ItemsSource).Table.Rows[i][0]))
// {
// ((DataView)this.ItemsSource).Table.Rows.RemoveAt(i);
// i--;
// }
//}
for (int i = 0; i < Dt.Rows.Count; i++)
{
//if (((DataView)this.ItemsSource).Table.Rows.Contains(Dt.Rows[i][0]))
// continue;
DataRow dr = ((DataView)this.ItemsSource).Table.NewRow();
for (int j = 0; j < ((DataView)this.ItemsSource).Table.Columns.Count; j++)
{
dr[j] = Dt.Rows[i][j];
}
// if (((DataView)this.ItemsSource).Table.Rows.Count == i)
((DataView)this.ItemsSource).Table.Rows.Add(dr);
//else
// ((DataView)this.ItemsSource).Table.Rows.InsertAt(dr, i);
}
//if (popupDataGrid.Items.Count > 0)
// popupDataGrid.SelectedItem = popupDataGrid.Items[0];
}
//if (txt != this.Text)
//{
// IstextChanged = true;
// this.Text = txt;
// for (int i = 0; i < popupDataGrid.Items.Count; i++)
// {
// if (this.Text == ((DataRowView)popupDataGrid.Items[i]).Row.ItemArray[SearchColumn].ToString())
// {
// popupDataGrid.SelectedItem = popupDataGrid.Items[i];
// return;
// }
// }
//}
}
IstextChanged = false;
}
protected override void OnInitialized(EventArgs e)
{
base.OnInitialized(e);
if (CostCenterID == 0)
{
return;
}
ArrayList Param = new ArrayList();
Param.Add(CostCenterID);
Param.Add(TypeID);
Param.Add(UserID);
Param.Add(LanguageID);
DataSet ds = new PACT.DBHandler.DBHandler().GetCostCenterListView(CompanyDBIndex, Param);
ListViewID = Convert.ToInt32(ds.Tables[0].Rows[0]["ListViewID"].ToString());
this.IsEditable = true;
Microsoft.Windows.Controls.DataGridTextColumn dgCol;
dgCol = new Microsoft.Windows.Controls.DataGridTextColumn();
dgCol.Header = strPrimaryKey;
dgCol.Binding = new Binding(strPrimaryKey);
dgCol.Visibility = System.Windows.Visibility.Hidden;
this.Columns.Add(dgCol);
ColumnsList = new ArrayList();
for (int i = 0; i < ds.Tables[1].Rows.Count; i++)
{
if (i == 0)
{
strColumns = ds.Tables[1].Rows[i]["SysColumnName"].ToString();
}
else
{
strColumns += "," + ds.Tables[1].Rows[i]["SysColumnName"].ToString();
}
ColumnsList.Add(ds.Tables[1].Rows[i]["SysColumnName"].ToString());
dgCol = new Microsoft.Windows.Controls.DataGridTextColumn();
dgCol.Header = ds.Tables[1].Rows[i]["UserColumnName"].ToString();
if (ds.Tables[1].Rows.Count == 1)
{
dgCol.Width = this.Width;
}
else
{
dgCol.Width = Convert.ToInt32(ds.Tables[1].Rows[i]["ColumnWidth"].ToString());
}
dgCol.CanUserResize = false;
dgCol.CanUserSort = false;
dgCol.Binding = new Binding(ds.Tables[1].Rows[i]["SysColumnName"].ToString());
iWidth += Convert.ToInt32(ds.Tables[1].Rows[i]["ColumnWidth"].ToString());
this.Columns.Add(dgCol);
}
if (this.SelectedValue != null)
{
valueSelected = true;
}
//this.SelectedValue = new Binding(strPrimaryKey);
this.SelectedValuePath = strPrimaryKey;
}
