private void FillDataLoanToControl(string query, Dictionary <string, string> param = null)
{
try
{
using (SqlConnection con = new SqlConnection(Properties.Settings.Default.vPretConnectionString))
{
con.Open();
using (SqlCommand cmd = new SqlCommand(query, con))
{
cmd.CommandType = CommandType.Text;
if (param != null)
{
foreach (KeyValuePair <string, string> sqlparam in param)
{
cmd.Parameters.Add(new SqlParameter(sqlparam.Key, sqlparam.Value));
}
}
using (SqlDataAdapter sda = new SqlDataAdapter(cmd))
{
using (DataSet ds = new DataSet())
{
cmd.ExecuteNonQuery();
sda.Fill(ds);
radGridViewControlTech.DataSource = ds.Tables[0];
GridViewCheckBoxColumn checkbox = new GridViewCheckBoxColumn();
checkbox.Name = "ValiderControle";
checkbox.FieldName = "ValiderControle";
checkbox.HeaderText = "Valider Contrôle";
checkbox.DataType = typeof(int);
checkbox.EditMode = EditMode.OnValueChange;
radGridViewControlTech.MasterTemplate.Columns.Add(checkbox);
radGridViewControlTech.MasterTemplate.Columns["LOAID"].IsVisible = false;
radGridViewControlTech.MasterTemplate.BestFitColumns();
radGridViewControlTech.AllowAddNewRow = false;
radGridViewControlTech.AllowColumnResize = true;
radGridViewControlTech.MasterTemplate.AutoSizeColumnsMode = GridViewAutoSizeColumnsMode.Fill;
/*
* Here the relation between Loan & product
* */
GridViewTemplate template1 = new GridViewTemplate();
template1.AllowAddNewRow = false;
template1.DataSource = ds.Tables[1];
radGridViewControlTech.MasterTemplate.Templates.Add(template1);
GridViewRelation relation1 = new GridViewRelation(radGridViewControlTech.MasterTemplate);
relation1.ChildTemplate = template1;
relation1.RelationName = "Produit / Pret";
relation1.ParentColumnNames.Add("LOAID");
relation1.ChildColumnNames.Add("PROLOAIDFK");
radGridViewControlTech.Templates[0].Columns["PROLOAIDFK"].IsVisible = false;
radGridViewControlTech.Templates[0].Columns["PROID"].IsVisible = false;
radGridViewControlTech.Templates[0].AllowAutoSizeColumns = true;
radGridViewControlTech.Templates[0].AutoSizeColumnsMode = GridViewAutoSizeColumnsMode.Fill;
radGridViewControlTech.Templates[0].BestFitColumns();
radGridViewControlTech.Relations.Add(relation1);
/**
* Here the relation between Product & accessories
**/
// Can't use radgridview.MasterTemplates.template for some reasons
GridViewTemplate template2 = new GridViewTemplate();
template2.AllowAddNewRow = false;
template2.DataSource = ds.Tables[2];
template1.Templates.Add(template2);
GridViewRelation relation2 = new GridViewRelation(template1);
relation2.ChildTemplate = template2;
relation2.RelationName = "Produit / Accessoire";
relation2.ParentColumnNames.Add("PROID");
relation2.ChildColumnNames.Add("ACCPROIDFK");
template2.Columns["ACCPROIDFK"].IsVisible = false;
template2.AllowAutoSizeColumns = true;
template2.AutoSizeColumnsMode = GridViewAutoSizeColumnsMode.Fill;
template2.BestFitColumns();
radGridViewControlTech.Relations.Add(relation2);
template2.Columns["Nom Accessoire"].ReadOnly = true;
template2.Columns["PN Accessoire"].ReadOnly = true;
template2.Columns["Commentaire Accessoire"].ReadOnly = true;
template1.Columns["Nom Produit"].ReadOnly = true;
template1.Columns["N°Série Produit"].ReadOnly = true;
template1.Columns["Commentaire Produit"].ReadOnly = true;
template1.AllowDeleteRow = false;
template2.AllowDeleteRow = false;
radGridViewControlTech.MasterTemplate.AllowDeleteRow = false;
foreach (GridViewColumn row in radGridViewControlTech.Columns)
{
if (row.FieldName.Equals("ValiderControle") == false)
{
row.ReadOnly = true;
}
}
foreach (GridViewRowInfo rowInfo in radGridViewControlTech.Rows)
{
IQueryable <LOAN> loans = (from LOAN in VpretContext.Instance.vPretContext.LOAN
where LOAN.LOA_ID.Equals(rowInfo.Cells["LOAID"].Value.ToString())
select LOAN);
if (loans != null)
{
foreach (LOAN loan in loans)
{
GridViewDataRowInfo row = rowInfo as GridViewDataRowInfo;
GridViewHierarchyRowInfo hierarchyRow = row as GridViewHierarchyRowInfo;
if (hierarchyRow != null)
{
IterateChildRowsAndAddProduct(hierarchyRow);
}
if (loan.LOA_STATE == 1)
{
rowInfo.Cells["ValiderControle"].Value = CheckState.Checked;
}
}
}
}
}
}
}
}
radGridViewControlTech.MasterTemplate.AutoSizeColumnsMode = GridViewAutoSizeColumnsMode.Fill;
radGridViewControlTech.Templates[0].AutoSizeColumnsMode = GridViewAutoSizeColumnsMode.Fill;
this.Dock = DockStyle.Fill;
}
catch (Exception ex)
{
Log.UCTechControle.Error("FillDataLoanToControl - Exception: " + ex.ToString());
}
finally
{
Log.UCTechControle.Debug("FillDataLoanToControl : STATUT : PASSED");
}
}
