protected void txtOptionPartNo_TextChanged(object sender, EventArgs e)
{
DataTable dt = new DataTable();
DataTable dtTemp = new DataTable();
fillOptionCategorygrid();
bool b = true;
if (txtOptionPartNo.Text != "")
{
for (int i = 0; i < txtOptionPartNo.Text.Length; i++)
{
char c = txtOptionPartNo.Text[i];
dtTemp = ObjInvBOM.BOM_ById(StrCompId.ToString(), c.ToString());
if (dtTemp.Rows.Count != 0)
{
dt.Merge(dtTemp);
for (int j = 0; j < dt.Rows.Count; j++)
{
dtTemp = null;
dtTemp = new DataView(dt, "OptionCategoryId='" + dt.Rows[j]["OptionCategoryId"].ToString() + "'", "", DataViewRowState.CurrentRows).ToTable();
if (dtTemp.Rows.Count == 2)
{
b = false;
}
}
}
else
{
b = false;
}
}
if (!b)
{
DisplayMessage("Invalid Part No");
txtOptionPartNo.Text = "";
txtOptionPartNo.Focus();
fillOptionCategorygrid();
}
else
{
for (int i = 0; i < dt.Rows.Count; i++)
{
foreach (GridViewRow Row in gvOptionCategory.Rows)
{
RadioButtonList RdoList = (RadioButtonList)Row.FindControl("rdoOption");
for (int j = 0; j < RdoList.Items.Count; j++)
{
if (RdoList.Items[j].Value == dt.Rows[i]["TransId"].ToString())
{
RdoList.Items[j].Selected = true;
}
}
}
}
}
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
DateTime dt = DateTime.ParseExact(txtDate.Text, "dd/MM/yyyy", null);
string SubProductId = "0";
string ProductId = new DataView(ObjInvProductMaster.GetProductMasterTrueAll(StrCompId.ToString()), "EProductName like '" + txtProductId.Text.Trim() + "%'", "", DataViewRowState.CurrentRows).ToTable().Rows[0]["ProductId"].ToString();
if (txtSubProduct.Text != "")
{
if (txtSubProduct.Text != "0")
{
SubProductId = new DataView(ObjInvProductMaster.GetProductMasterTrueAll(StrCompId.ToString()), "EProductName like '" + txtSubProduct.Text.Trim() + "%'", "", DataViewRowState.CurrentRows).ToTable().Rows[0]["ProductId"].ToString();
}
}
if (ProductId == "")
{
ProductId = "0";
}
if (SubProductId == "")
{
ProductId = "0";
}
if (txtOption.Text == "")
{
DisplayMessage("Enter Option");
txtOption.Text = "";
txtOption.Focus();
return;
}
if (txtOptCatId.Text == "")
{
DisplayMessage("Enter Option Category");
txtOptCatId.Text = "";
txtOptCatId.Focus();
return;
}
if (txtShortDesc.Text == "")
{
DisplayMessage("Enter Option Short Description");
txtShortDesc.Text = "";
txtShortDesc.Focus();
return;
}
if (txtUnitPrice.Text == "")
{
DisplayMessage("Enter Unit Price");
txtUnitPrice.Text = "";
txtUnitPrice.Focus();
return;
}
if (txtQty.Text == "")
{
DisplayMessage("Enter Quantity");
txtQty.Text = "";
txtQty.Focus();
return;
}
string OptionCateId = string.Empty;
if (txtOptCatId.Text != "")
{
OptionCateId = new DataView(ObjOpCate.GetOptionCategoryTrueAll(StrCompId.ToString()), "EName='" + txtOptCatId.Text.Trim() + "'", "", DataViewRowState.CurrentRows).ToTable().Rows[0]["OptionCategoryId"].ToString();
}
if (hdnDetailEdit.Value == "")
{
DataTable dtPS = new DataView(ObjInvBOM.BOM_All(StrCompId.ToString()), "OptionId='" + txtOption.Text.Trim() + "' and OptionCategoryId='" + OptionCateId.Trim() + "'", "", DataViewRowState.CurrentRows).ToTable();
if (dtPS.Rows.Count != 0)
{
DisplayMessage("Option Id & Option Category Already Exists");
txtOptCatId.Text = "";
txtOption.Text = "";
txtOption.Focus();
return;
}
ObjInvBOM.Insert_BOM(StrCompId.ToString(), "1", ProductId.Trim(), dt.ToString().Trim(), ddlTransType.SelectedValue.ToString().Trim(), SubProductId.ToString().Trim(), txtModelNo.Text.ToString().Trim(), txtOption.Text.ToString().Trim(), txtOptionDesc.Text.ToString().Trim(), txtShortDesc.Text.ToString().Trim(), OptionCateId.ToString().Trim(), txtUnitPrice.Text.ToString().Trim(), txtQty.Text.ToString().Trim(), "", "", "", "", "", "", true.ToString(), DateTime.Now.ToString(), true.ToString(), StrUserId.ToString(), DateTime.Now.ToString(), StrUserId.ToString(), DateTime.Now.ToString());
}
else
{
DataTable dtPSID = new DataView(ObjInvBOM.BOM_ById(StrCompId.ToString(), hdnDetailEdit.Value.ToString()), "OptionId='" + txtOption.Text.Trim() + "' and OptionCategoryId='" + OptionCateId.Trim() + "'", "", DataViewRowState.CurrentRows).ToTable();
if (dtPSID.Rows.Count == 0)
{
DataTable dtPS = new DataView(ObjInvBOM.BOM_All(StrCompId), "OptionId='" + txtOption.Text.Trim() + "' and OptionCategoryId='" + OptionCateId.Trim() + "'", "", DataViewRowState.CurrentRows).ToTable();
if (dtPS.Rows.Count != 0)
{
DisplayMessage("Option Id & Option Category Already Exists");
txtOptCatId.Text = "";
txtOption.Text = "";
txtOption.Focus();
return;
}
}
ObjInvBOM.Update_BOM(hdnDetailEdit.Value.ToString(), StrCompId.ToString().Trim(), "1", ProductId.ToString().Trim(), dt.ToString().Trim(), ddlTransType.SelectedValue.ToString().Trim(), SubProductId.ToString().Trim(), txtModelNo.Text.ToString().Trim(), txtOption.Text.ToString().Trim(), txtOptionDesc.Text.ToString().Trim(), txtShortDesc.Text.ToString().Trim(), OptionCateId.ToString().Trim(), txtUnitPrice.Text.ToString().Trim(), txtQty.Text.ToString().Trim(), "", "", "", "", "", "", true.ToString(), DateTime.Now.ToString(), true.ToString(), StrUserId.ToString(), DateTime.Now.ToString());
}
ddlTransType.Enabled = false;
txtDate.Enabled = false;
txtModelNo.Enabled = false;
txtProductId.Enabled = false;
Reset_Child();
fillGrid();
pnlChlidGrid.Visible = true;
rdoOption.Focus();
}