private void BtnSave_Click(object sender, EventArgs e)
{
SizeGridView.CloseEditor();
SizeGridView.UpdateCurrentRow();
GroupGridView.CloseEditor();
GroupGridView.UpdateCurrentRow();
foreach (DataRow drGroup in (GroupGrid.DataSource as DataTable).Rows)
{
if (drGroup["Select"].ToString().ToUpper() == "TRUE")
{
foreach (DataRow drSize in (SizeGrid.DataSource as DataTable).Rows)
{
if (drSize["Select"].ToString().ToUpper() == "TRUE")
{
//DataSet dsCheck=ProjectFunctions.GetDataSet("Select * from SizeMapping where ")
ProjectFunctions.GetDataSet("Insert into SizeMapping (GrpCode,GrpSubCode,SizeId,SizeDesc)values('" + drGroup["GrpCode"].ToString() + "','" + drGroup["GrpSubCode"].ToString() + "','" + drSize["SZSYSID"].ToString() + "','" + drSize["SizeDesc"].ToString() + "')");
}
}
}
}
Close();
}
private void FrmSizeMapping_Load(object sender, EventArgs e)
{
ProjectFunctions.ToolStripVisualize(Menu_ToolStrip);
ProjectFunctions.TextBoxVisualize(this);
DataSet dsGroup = ProjectFunctions.GetDataSet("Select * from GrpMst");
if (dsGroup.Tables[0].Rows.Count > 0)
{
dsGroup.Tables[0].Columns.Add("Select", typeof(bool));
foreach (DataRow dr in dsGroup.Tables[0].Rows)
{
dr["Select"] = false;
}
GroupGrid.DataSource = dsGroup.Tables[0];
GroupGridView.BestFitColumns();
}
else
{
GroupGrid.DataSource = null;
GroupGridView.BestFitColumns();
}
DataSet dsSize = ProjectFunctions.GetDataSet("Select SZSYSID,SZNAME,SZDESC,'' AS SizeDesc from SIZEMAST");
if (dsSize.Tables[0].Rows.Count > 0)
{
dsSize.Tables[0].Columns.Add("Select", typeof(bool));
foreach (DataRow dr in dsSize.Tables[0].Rows)
{
dr["Select"] = false;
}
SizeGrid.DataSource = dsSize.Tables[0];
SizeGridView.BestFitColumns();
}
else
{
SizeGrid.DataSource = null;
SizeGridView.BestFitColumns();
}
}
