Example #1
0
    public void UpdateModel(object sender, EventArgs e)
    {
        MastersController objController = new MastersController();
        ModelUI objUI = new ModelUI();
        int Code = 0;
        string strModelCode = "";
        int GroupID = 0;
        int index = Convert.ToInt16(hdnIndex.Value);
           // string strQuery = "";
        int ID = 0;
        //int ID = Convert.ToInt32(((HiddenField)grdModelException.Rows[index].FindControl("hdnID")).Value);
        string strCode = ((Label)grdModelException.Rows[index].FindControl("lblCode")).Text;
        if (strCode == "")
        {
            Code = 0;
        }
        else
        {
            Code = Convert.ToInt16(strCode);
        }

        int selected = ((RadioButtonList)grdModelException.Rows[index].FindControl("rdoMode")).SelectedIndex;
        if (selected == 0)
        {
            strModelCode = ((DropDownList)grdModelException.Rows[index].FindControl("drpModel")).SelectedItem.Text;
            GroupID = Convert.ToInt16(((DropDownList)grdModelException.Rows[index].FindControl("drpModel")).SelectedValue);
        }
        else if (selected == 1)
        {
            strModelCode = ((TextBox)grdModelException.Rows[index].FindControl("txtModel")).Text;
        }
        objUI.Code = Code;
        objUI.ModelCode = strModelCode;
        objUI.GroupID = GroupID;
        string strMessage = "";
        //strQuery = "Insert into Model (Code,Model_Code) values (" + Code + ",'" + strModelCode + "')";
        try
        {
            objController.SaveModel(objUI, ID);
        }
        catch
        {}
        try
        {
            string strAcrQuery = "Select * from AcrTemp where IsModelEx=0 and IsItemEx=0 and IsCulpritEx=0 and IsCVoiceEx=0 and IsDefectEx=0";
            DataTable dtAcr = objQueryController.ExecuteQuery(strAcrQuery);
            if (dtAcr != null)
            {
                SaveAcr(dtAcr);
                string strDeleteAcrQuery = "Delete from AcrTemp where IsModelEx=0 and IsItemEx=0 and IsCulpritEx=0 and IsCVoiceEx=0 and IsDefectEx=0";
                objQueryController.ExecuteQuery(strDeleteAcrQuery);
            }

            string strProductionQuery = "Select * from ProductionTemp where IsModelEx=0";
            DataTable dtProd = objQueryController.ExecuteQuery(strProductionQuery);
            if (dtProd != null)
            {
                SaveProduction(dtProd);
                string strDeleteProdQuery = "Delete from ProductionTemp where IsModelEx=0";
                objQueryController.ExecuteQuery(strDeleteProdQuery);

            }

            BindGrid();
            strMessage = "Records Updated Successfully";
        }
        catch
        {
            strMessage = "Records could not be Updated Successfully";
        }
        string strjscript = "<script language='javascript'>";
        strjscript += " setMessageText('ctl00_ContentPlaceHolder1_lblMessage','" + strMessage + "' );";
        strjscript += "</script" + ">";
        Literal1.Text = strjscript;
    }