private void btnAdd_Click(object sender, System.EventArgs e)
{
string strErrorMessage = "";
int iDatagridRowCount = 0;
iDatagridRowCount = grdCompany.Items.Count;
if (CheckBlankCompanyCodeForCheckedRows(iDatagridRowCount, out strErrorMessage) == false)
{
lblMessage.Text = strErrorMessage;
return;
}
DataAccess da = new DataAccess(CBSAppUtils.PrimaryConnectionString);
RecordSet rs = da.CreateInsertBuffer("TradingRelation");
TextBox tbV_Code = null;
TextBox tbV_Class = null;
DropDownList ddlCurrency = null;
for (int i = 0, j = grdCompany.Items.Count; i < j; i++)
{
if (this.grdCompany.Items[i].FindControl("chkRelation").ID == "chkRelation")
{
CheckBox chk = (CheckBox)this.grdCompany.Items[i].FindControl("chkRelation");
if (chk.Checked)
{
tbV_Code = (TextBox)grdCompany.Items[i].FindControl("tbCompanyCode");
tbV_Class = (TextBox)grdCompany.Items[i].FindControl("tbVendorClass");
ddlCurrency = (DropDownList)grdCompany.Items[i].FindControl("ddlCurrencyType");
rs.AddNew();
int dtIndex = grdCompany.Items[i].DataSetIndex;
int supplierID = System.Convert.ToInt32(rsGrid.ParentTable.Rows[dtIndex]["CompanyID"]);
rs["BuyerCompanyID"] = System.Convert.ToInt32(Session["SelectedBuyerID"]);
rs["SupplierCompanyID"] = supplierID;
rs["SupplierCodeAgainstBuyer"] = tbV_Code.Text.Trim();
rs["New_CurrencyTypeID"] = ddlCurrency.SelectedValue.Trim();
rs["New_VendorClass"] = tbV_Class.Text.Trim();
int pkID = 0;
da.InsertRow(rs, ref pkID);
}
}
}
rs = null;
Response.Redirect("TradingRelation.aspx");
}
