protected string getSch()
{
TextBox txtSchDesc = (TextBox)StockDetailsView.FindControl("txtSchDesc");
string sch_desc = "";
RadAutoCompleteBox txtSch1 = (RadAutoCompleteBox)StockDetailsView.FindControl("txtSch1");
RadAutoCompleteBox txtSch2 = (RadAutoCompleteBox)StockDetailsView.FindControl("txtSch2");
if (txtSch1.Entries.Count > 0)
{
sch_desc = string.IsNullOrEmpty(txtSch1.Entries[0].Text) ? txtSch1.Text : txtSch1.Entries[0].Text;
}
if (txtSch2.Entries.Count > 0)
{
if (txtSch1.Entries.Count < 1)
{
sch_desc = txtSch2.Entries[0].Text;
}
else
{
sch_desc = sch_desc + " X " + txtSch2.Entries[0].Text;
}
}
txtSchDesc.Text = "";
txtSchDesc.Text = sch_desc;
return(sch_desc);
}
protected string getSize()
{
TextBox txtsizeDesc = (TextBox)StockDetailsView.FindControl("txtSizeDesc");
string size_desc = "";
RadAutoCompleteBox txtSize1 = (RadAutoCompleteBox)StockDetailsView.FindControl("txtSize1");
RadAutoCompleteBox txtSize2 = (RadAutoCompleteBox)StockDetailsView.FindControl("txtSize2");
if (txtSize1.Entries.Count > 0)
{
size_desc = txtSize1.Entries[0].Text;
}
if (txtSize2.Entries.Count > 0)
{
if (txtSize1.Entries.Count < 1)
{
size_desc = txtSize2.Entries[0].Text;
}
else
{
size_desc = size_desc + " X " + txtSize2.Entries[0].Text;
}
}
txtsizeDesc.Text = "";
txtsizeDesc.Text = size_desc;
return(size_desc);
}
protected void txtlen_TextChanged(object sender, EventArgs e)
{
decimal leng = 0;
TextBox txtlength = (TextBox)StockDetailsView.FindControl("txtlength");
TextBox txtlen1 = (TextBox)StockDetailsView.FindControl("txtlen1");
TextBox txtlen2 = (TextBox)StockDetailsView.FindControl("txtlen2");
if (txtlen1.Text != "")
{
leng = leng + (decimal.Parse(txtlen1.Text));
}
if (txtlen2.Text != "")
{
leng = leng + (decimal.Parse(txtlen2.Text));
}
txtlength.Text = leng + "";
}
protected void StockDetailsView_ItemUpdating(object sender, DetailsViewUpdateEventArgs e)
{
PIP_MAT_STOCKTableAdapter stock_adapter = new PIP_MAT_STOCKTableAdapter();
//dsMainTablesATableAdapters.PIP_MAT_STOCKTableAdapter stock = new PIP_MAT_STOCKTableAdapter();
TextBox matcode1 = (TextBox)StockDetailsView.FindControl("txtMatcode1");
TextBox matcode2 = (TextBox)StockDetailsView.FindControl("txtMatcode2");
TextBox sizeDesc = (TextBox)StockDetailsView.FindControl("txtSizeDesc");
RadAutoCompleteBox txtSize1 = (RadAutoCompleteBox)StockDetailsView.FindControl("txtSize1");
RadAutoCompleteBox txtSize2 = (RadAutoCompleteBox)StockDetailsView.FindControl("txtSize2");
RadAutoCompleteBox txtSch1 = (RadAutoCompleteBox)StockDetailsView.FindControl("txtSch1");
RadAutoCompleteBox txtSch2 = (RadAutoCompleteBox)StockDetailsView.FindControl("txtSch2");
TextBox schDesc = (TextBox)StockDetailsView.FindControl("txtSchDesc");
TextBox unitwt = (TextBox)StockDetailsView.FindControl("txtUnitwt");
TextBox length = (TextBox)StockDetailsView.FindControl("txtlength");
TextBox len1 = (TextBox)StockDetailsView.FindControl("txtlen1");
TextBox len2 = (TextBox)StockDetailsView.FindControl("txtlen2");
RadDropDownList profile = (RadDropDownList)StockDetailsView.FindControl("ddlProfile");
DropDownList item = (DropDownList)StockDetailsView.FindControl("ddlitem");
DropDownList uom = (DropDownList)StockDetailsView.FindControl("ddlUOM");
TextBox mat_type = (TextBox)StockDetailsView.FindControl("txtMatType");
TextBox ptCode = (TextBox)StockDetailsView.FindControl("txtPtCode");
TextBox mClass = (TextBox)StockDetailsView.FindControl("txtClass");
TextBox shortDesc = (TextBox)StockDetailsView.FindControl("txtShortDescr");
TextBox matDescr = (TextBox)StockDetailsView.FindControl("txtMatDescr");
string sch = getSch();
string size = getSize();
stock_adapter.UpdateQuery(matcode1.Text, matcode2.Text, size, txtSize1.Entries[0].Text, txtSize2.Entries[0].Text, sch, txtSch1.Entries[0].Text,
txtSch2.Entries[0].Text, decimal.Parse(unitwt.Text), decimal.Parse(item.SelectedValue.ToString()), decimal.Parse(uom.SelectedValue.ToString()), mat_type.Text,
mClass.Text, ptCode.Text, shortDesc.Text, matDescr.Text, length.Text, decimal.Parse(len1.Text), decimal.Parse(len2.Text), profile.SelectedValue.ToString(), decimal.Parse(ListBox1.SelectedValue.ToString()));
e.Cancel = true;
StockDetailsView.ChangeMode(StockDetailsView.DefaultMode);
StockDetailsView.DataBind();
}
protected void StockDetailsView_DataBound(object sender, EventArgs e)
{
if (Request.QueryString["MAT_ID"] != null & !IsPostBack)
{
ListBox1.Visible = false;
}
if (StockDetailsView.CurrentMode == DetailsViewMode.Edit & modechanged == true)
{
string size1 = WebTools.GetExpr("size1", "PIP_MAT_STOCK", " WHERE MAT_ID=" + ListBox1.SelectedValue.ToString());
if (size1 != "")
{
RadAutoCompleteBox txtSize1 = (RadAutoCompleteBox)StockDetailsView.FindControl("txtSize1");
txtSize1.Entries.Add(new AutoCompleteBoxEntry(size1));
}
string size2 = WebTools.GetExpr("size2", "PIP_MAT_STOCK", " WHERE MAT_ID=" + ListBox1.SelectedValue.ToString());
if (size2 != "")
{
RadAutoCompleteBox txtSize2 = (RadAutoCompleteBox)StockDetailsView.FindControl("txtSize2");
txtSize2.Entries.Add(new AutoCompleteBoxEntry(size2));
}
string thk1 = WebTools.GetExpr("thk1", "PIP_MAT_STOCK", " WHERE MAT_ID=" + ListBox1.SelectedValue.ToString());
if (thk1 != "")
{
RadAutoCompleteBox txtSch1 = (RadAutoCompleteBox)StockDetailsView.FindControl("txtSch1");
txtSch1.Entries.Add(new AutoCompleteBoxEntry(thk1));
}
string thk2 = WebTools.GetExpr("thk2", "PIP_MAT_STOCK", " WHERE MAT_ID=" + ListBox1.SelectedValue.ToString());
if (thk2 != "")
{
RadAutoCompleteBox txtSch2 = (RadAutoCompleteBox)StockDetailsView.FindControl("txtSch2");
txtSch2.Entries.Add(new AutoCompleteBoxEntry(thk2));
}
}
modechanged = false;
}
