protected void ddlPreservFreq_SelectedIndexChanged(object sender, Telerik.Web.UI.DropDownListEventArgs e)
{
string[] str = txtCodes.Text.Split('-');
string company = str[2].Substring(0, 1);
txtCodes.Text = str[0] + "-" + str[1] + "-" + company + ddlPreservFreq.SelectedValue;
}
protected void ddlPOList_SelectedIndexChanged(object sender, Telerik.Web.UI.DropDownListEventArgs e)
{
string discipline_id = WebTools.GetExpr("DISCIPLINE_ID", "PIP_PO", " WHERE PO_ID='" + ddlPOList.SelectedValue + "'");
ddlDisciplineList.SelectedValue = discipline_id;
SerialNumber();
}
protected void cboNdeType_SelectedIndexChanged(object sender, Telerik.Web.UI.DropDownListEventArgs e)
{
if (cboSubcon.SelectedValue != "-1")
{
set_req_no();
}
}
protected void ddlReportType_SelectedIndexChanged(object sender, Telerik.Web.UI.DropDownListEventArgs e)
{
if (is_selected())
{
switch (ddlReportType.SelectedValue.ToString())
{
case "1":
Response.Redirect("ReportViewer.aspx?ReportID=17&Arg1=" + mivGridView.SelectedValue.ToString());
break;
case "2":
Response.Redirect("ReportViewer.aspx?ReportID=18&Arg1=" + mivGridView.SelectedValue.ToString());
break;
case "3":
Response.Redirect("ReportViewer.aspx?ReportID=16&Arg1=" + mivGridView.SelectedValue.ToString());
break;
case "4":
Response.Redirect("ReportViewer.aspx?ReportID=21&Arg1=" + mivGridView.SelectedValue.ToString());
break;
case "5":
Response.Redirect("ReportViewer.aspx?ReportID=22&Arg1=" + mivGridView.SelectedValue.ToString());
break;
}
}
}
protected void ddlMRVList_SelectedIndexChanged(object sender, Telerik.Web.UI.DropDownListEventArgs e)
{
try
{
string po_id = WebTools.GetExpr("PO_ID", "PIP_MAT_RECEIVE", " WHERE MAT_RCV_ID='" + ddlMRVList.SelectedValue + "'");
string srn_no = WebTools.GetExpr("SRN_NO", "VIEW_ADAPTER_MAT_RCV", " WHERE MAT_RCV_ID='" + ddlMRVList.SelectedValue + "'");
string store_id = WebTools.GetExpr("STORE_ID", "VIEW_ADAPTER_MAT_RCV", " WHERE MAT_RCV_ID='" + ddlMRVList.SelectedValue + "'");
string ship_no = WebTools.GetExpr("SHIP_NO", "VIEW_ADAPTER_MAT_RCV", " WHERE MAT_RCV_ID='" + ddlMRVList.SelectedValue + "'");
string supplier = WebTools.GetExpr("MANUFACTURE", "PIP_PO", " WHERE PO_ID='" + po_id + "'");
//cboSRNNo.Text = srn_no;
txtShipNumber.Text = ship_no;
txtSupplier.Text = supplier;
ddlStoreList.SelectedValue = store_id;
ddlPOList.SelectedValue = po_id;
SetSRN();
//Set MIR Number
string job_code = WebTools.GetExpr("JOB_CODE", "PROJECT_INFORMATION", " PROJECT_ID ='" + Session["PROJECT_ID"].ToString() + "'");
string prefix = job_code + "-MRIR-" + WebTools.GetExpr("SHORT_NAME", "SUB_CONTRACTOR", " SUB_CON_ID='" + ddlSubcon.SelectedValue + "'");
prefix = prefix + "-";
txtMIRNo.Text = WebTools.NextSerialNo("PRC_MAT_INSP", "MIR_NO", prefix, 4, " WHERE MRIR_SC_ID='" + ddlSubcon.SelectedValue + "'");
}
catch (Exception ex)
{
Master.show_error(ex.Message);
}
}
protected void ddlBrandName_SelectedIndexChanged(object sender, Telerik.Web.UI.DropDownListEventArgs e)
{
if (ddlBrandName.SelectedIndex >= 1)
{
string cmdStr = "Select MarketID, MarketName, AmounProductID From View_Survey_AmounProducts_Market Where AmounProductID = " + ddlBrandName.SelectedValue.ToString();
con = new SqlConnection(ConfigurationManager.ConnectionStrings["AmounCrmConnectionString"].ConnectionString);
cmd = new SqlCommand(cmdStr, con);
da = new SqlDataAdapter(cmd);
dt = new DataTable();
con.Open();
da.Fill(dt);
ddlMarketName.Items.Clear();
ddlMarketName.AppendDataBoundItems = true;
ddlMarketName.Items.Add("Select");
ddlMarketName.DataSource = dt;
ddlMarketName.DataTextField = "MarketName";
ddlMarketName.DataValueField = "MarketID";
ddlMarketName.DataBind();
ddlMarketName.SelectedIndex = 0;
chklCompetitors.Items.Clear();
tableContent2.Visible = false;
}
}
protected void ddlTransType_SelectedIndexChanged(object sender, Telerik.Web.UI.DropDownListEventArgs e)
{
string sql = string.Empty;
switch (ddlTransType.SelectedValue)
{
case "1":
lblTransDoc.Text = "Material Request No";
lblTransDoc.Visible = true;
ddlTransDocName.Visible = true;
//sql = "SELECT MAT_REQ_ID, MAT_REQ_NO as DOC_NAME FROM VIEW_MATERIAL_REQUEST WHERE REQ_TO = '" + ddFrom.SelectedValue + "' AND REQ_FROM = '" + ddTo.SelectedValue +"' ORDER BY MAT_REQ_NO DESC";
break;
case "3":
lblTransDoc.Text = "Painting MIV No";
lblTransDoc.Visible = true;
ddlTransDocName.Visible = true;
//sql = "";
break;
default:
lblTransDoc.Visible = false;
ddlTransDocName.Visible = false;
break;
}
BindDocumentNo();
//sqlDocumentSource.SelectCommand = sql;
}
protected void ddlCompanyVendor_SelectedIndexChanged(object sender, Telerik.Web.UI.DropDownListEventArgs e)
{
string[] str = txtCodes.Text.Split('-');
string freq = str[2].Substring(1, 2);
txtCodes.Text = str[0] + "-" + str[1] + "-" + ddlCompanyVendor.SelectedValue + freq;
}
protected void ddlStorageClass_SelectedIndexChanged(object sender, Telerik.Web.UI.DropDownListEventArgs e)
{
string val = ddlStorageClass.SelectedValue;
string str = txtCodes.Text.Substring(1, 6);
txtCodes.Text = val + str;
}
protected void BindBuckets(object sender, Telerik.Web.UI.DropDownListEventArgs e)
{
LeadsUtil.BindBuckets(dd_move_projects, dd_move_buckets, hf_project_id.Value, true);
LeadsUtil.BindBuckets(dd_del_projects, dd_del_buckets, hf_project_id.Value, false, true);
dd_del_buckets.Items.Insert(0, new Telerik.Web.UI.DropDownListItem("Delete all remaining Leads", "-1"));
}
protected void ddlIRN_SelectedIndexChanged(object sender, Telerik.Web.UI.DropDownListEventArgs e)
{
int irn_id = int.Parse(ddlIRN.SelectedValue);
string po_item = txtPoItem.Text;
lblbalqty.Text = "Bal IRN Qty to Receive: " + WebTools.GetExpr("BAL_TO_RECV", "VIEW_IRN_BAL_TO_RECV", " WHERE IRN_ID=" + irn_id + " AND PO_ITEM='" + po_item + "'");
txtPieces.Text = WebTools.GetExpr("BAL_TO_RECV_PIECES", "VIEW_IRN_BAL_TO_RECV", " WHERE IRN_ID=" + irn_id + " AND PO_ITEM='" + po_item + "'");
}
protected void ddlMarketName_SelectedIndexChanged(object sender, Telerik.Web.UI.DropDownListEventArgs e)
{
grdProducts.DataSourceID = "dsProducts";
grdProducts.Visible = true;
grdIndications.DataSourceID = "dsMarketIndications";
grdIndications.Visible = true;
}
protected void ddlReceiveStore_SelectedIndexChanged(object sender, Telerik.Web.UI.DropDownListEventArgs e)
{
string prefix = WebTools.GetExpr("JOB_CODE", "PROJECT_INFORMATION", " WHERE PROJECT_ID='" + Session["PROJECT_ID"].ToString() + "'");
prefix += "-";
prefix += WebTools.GetExpr("SHORT_NAME", "SUB_CONTRACTOR", " WHERE SUB_CON_ID IN (SELECT SC_ID FROM STORES_DEF WHERE STORE_ID = '" + ddlReceiveStore.SelectedValue + "')");
prefix += "-MTN-RCV-";
txtReceiveNo.Text = WebTools.NextSerialNo("RCV_NUMBER", "PIP_MAT_TRANSFER_RCV", prefix, 4, " WHERE STORE_ID = '" + ddlReceiveStore.SelectedValue + "'");
}
protected void ddlStoreList_SelectedIndexChanged(object sender, Telerik.Web.UI.DropDownListEventArgs e)
{
string prefix = WebTools.GetExpr("JOB_CODE", "PROJECT_INFORMATION", " WHERE PROJECT_ID = '" + Session["PROJECT_ID"].ToString() + "'");
prefix += "-";
prefix += WebTools.GetExpr("SHORT_NAME", "SUB_CONTRACTOR", " WHERE SUB_CON_ID = '" + ddlSubconList.SelectedValue + "'");
prefix += "-SPL-RCV-";
txtRCVNo.Text = WebTools.NextSerialNo("PIP_SPL_RECEIVE", "RCV_NO", prefix, 4, " WHERE SC_ID = '" + ddlSubconList.SelectedValue + "'");
}
protected void ddlReportType_SelectedIndexChanged(object sender, Telerik.Web.UI.DropDownListEventArgs e)
{
if (MIVRevGrid.SelectedIndexes.Count == 0)
{
Master.ShowMessage("Selected the MIV Rev number!");
return;
}
Response.Redirect("ReportViewer.aspx?ReportID=16.1&Arg1=" + Request.QueryString["ISSUE_ID"] + "&Arg2=" + MIVRevGrid.SelectedValue.ToString());
}
protected void ddlPOItems_SelectedIndexChanged(object sender, Telerik.Web.UI.DropDownListEventArgs e)
{
if (ddlPOItems.SelectedItem.Text.Contains('-'))
{
txtMatCode.Text = (ddlPOItems.SelectedItem.Text.Split('-'))[1].Trim();
}
txtPOItemNO.Text = WebTools.GetExpr("PO_ITEM", "VIEW_ADAPTER_PO_DETAIL", " PO_ITEM_ID='" + ddlPOItems.SelectedValue + "'");
}
protected void ddlSubconList_SelectedIndexChanged(object sender, Telerik.Web.UI.DropDownListEventArgs e)
{
ddlStoreList.Items.Clear();
ddlStoreList.Items.Add(new Telerik.Web.UI.DropDownListItem("Select Store", "-1"));
storeDataSource.DataBind();
cboTransfer.Text = "";
transferDataSource.DataBind();
cboTransfer.Items.Add(new Telerik.Web.UI.RadComboBoxItem("(Select Transfer)", "-1"));
txtTransReason.Text = "";
}
protected void ddlSubcon_SelectedIndexChanged(object sender, Telerik.Web.UI.DropDownListEventArgs e)
{
string prefix = WebTools.GetExpr("JOB_CODE", "PROJECT_INFORMATION", " WHERE PROJECT_ID='" + Session["PROJECT_ID"] + "'");
string sc_id = ddlSubcon.SelectedValue;
prefix += "-";
prefix += WebTools.GetExpr("SHORT_NAME", "SUB_CONTRACTOR", " WHERE SUB_CON_ID = '" + sc_id + "'");
prefix += "-QRNT-";
txtQuarantineNo.Text = WebTools.NextSerialNo("PIP_QUARANTINE", "QRNTINE_NO", prefix, 4, " PROJECT_ID=" + Session["PROJECT_ID"].ToString() + " AND SC_ID='" + ddlSubcon.SelectedValue + "'");
}
protected void ddlSubcon_SelectedIndexChanged(object sender, Telerik.Web.UI.DropDownListEventArgs e)
{
string job_code = WebTools.GetExpr("JOB_CODE", "PROJECT_INFORMATION", " PROJECT_ID ='" + Session["PROJECT_ID"].ToString() + "'");
string prefix = job_code + "-MRIR-" + WebTools.GetExpr("SHORT_NAME", "SUB_CONTRACTOR", " SUB_CON_ID='" + ddlSubcon.SelectedValue + "'");
prefix = prefix + "-";
txtMIRNo.Text = WebTools.NextSerialNo("PRC_MAT_INSP", "MIR_NO", prefix, 4, " WHERE MRIR_SC_ID='" + ddlSubcon.SelectedValue + "'");
ddlMRVList.DataBind();
}
protected void ddlSubContractor_SelectedIndexChanged(object sender, Telerik.Web.UI.DropDownListEventArgs e)
{
string prefix = WebTools.GetExpr("JOB_CODE", "PROJECT_INFORMATION", " WHERE PROJECT_ID='" + Session["PROJECT_ID"].ToString() + "'");
prefix += "-";
prefix += WebTools.GetExpr("SHORT_NAME", "SUB_CONTRACTOR", " WHERE SUB_CON_ID='" + ddlSubContractor.SelectedValue + "'");
prefix += "-";
prefix += "PAINT-MIV-";
txtIssueNo.Text = WebTools.NextSerialNo("PIP_MAT_ISSUE_BULK", "ISSUE_NO", prefix, 4, " WHERE SC_ID = '" + ddlSubContractor.SelectedValue + "'");
}
protected void ddlFromSubcon_SelectedIndexChanged(object sender, Telerik.Web.UI.DropDownListEventArgs e)
{
if (ddlFromSubcon.SelectedIndex > 0 && ddlCoatingVendor.SelectedIndex > 0)
{
SerialNo();
}
else
{
txtJCNo.Text = "";
}
}
protected void ddlTo_SelectedIndexChanged(object sender, Telerik.Web.UI.DropDownListEventArgs e)
{
lot_to = ddlTo.SelectedValue.ToString();
string short_name = WebTools.GetExpr("SHORT_NAME", "DCS_TRANS_VENDOR", "VENDOR_ID=" + decimal.Parse(ddlVendorList.SelectedValue));
string proj_code = WebTools.GetExpr("SHORT_CODE", "PROJECT_INFORMATION", "PROJECT_ID=" + Session["PROJECT_ID"].ToString());
lot_no = proj_code + "-" + short_name + "-" + lot_to + "-ST-";
string new_no = WebTools.NextSerialNo("DCS_TRANS_MASTER", "TRANS_NO", lot_no, 4, " WHERE TRANS_NO LIKE '%" + lot_no + "%'");
txtTransNo.Text = new_no;
}
protected void ddFrom_SelectedIndexChanged(object sender, Telerik.Web.UI.DropDownListEventArgs e)
{
string prefix = WebTools.GetExpr("JOB_CODE", "PROJECT_INFORMATION", " WHERE PROJECT_ID='" + Session["PROJECT_ID"] + "'");
string sc_id = WebTools.GetExpr("SC_ID", "STORES_DEF", " WHERE STORE_ID='" + ddFrom.SelectedValue + "'");
prefix += "-";
prefix += WebTools.GetExpr("SHORT_NAME", "SUB_CONTRACTOR", " WHERE SUB_CON_ID = '" + sc_id + "'");
prefix += "-MAT-TRANS-";
txtTransfNo.Text = WebTools.NextSerialNo("PIP_MAT_TRANSF", "TRANSF_NO", prefix, 4, " WHERE A_STORE_ID IN (SELECT STORE_ID FROM STORES_DEF WHERE SC_ID = '" + sc_id + "')");
//BindDocumentNo();
}
protected void subconDDL_SelectedIndexChanged(object sender, Telerik.Web.UI.DropDownListEventArgs e)
{
if (int.Parse(subconDDL.SelectedValue.ToString()) != -1)
{
set_jc_no();
}
else
{
txtJcNumber.Text = string.Empty;
}
}
protected void BindBuckets(object sender, Telerik.Web.UI.DropDownListEventArgs e)
{
if (hf_from_search.Value == "1")
{
LeadsUtil.BindBuckets(dd_projects, dd_buckets, null, false);
}
else
{
LeadsUtil.BindBuckets(dd_projects, dd_buckets, hf_bucket_id.Value, true);
}
}
protected void txtType_SelectedIndexChanged(object sender, Telerik.Web.UI.DropDownListEventArgs e)
{
if (ddlJCType.SelectedValue == "1")
{
cboJCNo.DataSource = sqlJCNoSource;
}
else if (ddlJCType.SelectedValue == "2")
{
cboJCNo.DataSource = sqlFlangeJCSource;
}
cboJCNo.DataBind();
}
protected void ddlJCSubcon_SelectedIndexChanged(object sender, Telerik.Web.UI.DropDownListEventArgs e)
{
try
{
string prefix = WebTools.GetExpr("JOB_CODE", "PROJECT_INFORMATION", " WHERE PROJECT_ID='" + Session["PROJECT_ID"] + "'");
prefix += "-SITE-MIV-";
prefix += WebTools.GetExpr("SHORT_NAME", "SUB_CONTRACTOR", " WHERE SUB_CON_ID='" + ddlJCSubcon.SelectedValue + "'") + "-";
txtSiteMIVNo.Text = WebTools.NextSerialNo("PIP_SITE_MIV", "ISSUE_NO", prefix, 4, " WHERE JC_SC_ID='" + ddlJCSubcon.SelectedValue + "'");
}
catch (Exception ex)
{
Master.show_error(ex.Message);
}
}
protected void dlType_ItemSelected(object sender, Telerik.Web.UI.DropDownListEventArgs e)
{
if (rdAll.Checked == true)
{
lblType.InnerText = "";
dlGender.Visible = false;
dlOccupation.Visible = false;
dlDepartment.Visible = false;
dlProfession.Visible = false;
dlBaptism.Visible = false;
}
else if (rdSpecific.Checked == true)
{
reportOption();
}
}
protected void ddJobcardType_SelectedIndexChanged(object sender, Telerik.Web.UI.DropDownListEventArgs e)
{
if (int.Parse(ddJobcardType.SelectedValue.ToString()) != -1)
{
if (int.Parse(subconDDL.SelectedValue.ToString()) != -1)
{
set_jc_no();
}
subconDDL.Enabled = true;
}
else
{
subconDDL.Enabled = false;
txtJcNumber.Text = string.Empty;
}
}
protected void ChangingRestoreChoice(object sender, Telerik.Web.UI.DropDownListEventArgs e)
{
bool IsClientList = dd_restore_choice.SelectedItem.Value == "CL";
tr_client_list.Visible = IsClientList;
BindProjects(IsClientList);
if (IsClientList)
{
lbl_project.Text = "From Project:";
LeadsUtil.BindBuckets(dd_project, dd_client_list, String.Empty, false, true);
}
else
lbl_project.Text = "Project:";
Util.ResizeRadWindow(this);
}
