Esempio n. 1
0
    public void SaveInformation()
    {
        int MonthID = Convert.ToInt32(drpMonth.SelectedValue);
        int YearID = Convert.ToInt32(drpYear.SelectedValue);
        int ModelGroupID = Convert.ToInt32(drpModel.SelectedValue);
        double ReworkCost_I_Year = Convert.ToDouble(txtReworkCostIYear.Text.Trim());
        double ReworkCost_II_Year = Convert.ToDouble(txtReworkCostIIYear.Text.Trim());

        ReworkCostController objController = new ReworkCostController();
        ReworkCostUI objUI = new ReworkCostUI();

        objUI.MonthID = MonthID;
        objUI.YearID = YearID;
        objUI.GroupID = ModelGroupID;
        objUI.ReworkCost_I_Year = ReworkCost_I_Year;
        objUI.ReworkCost_II_Year = ReworkCost_II_Year;
        objUI.ModelCategoryID = Convert.ToInt32(rdoModelCategory.SelectedValue);
        objUI.HMR_Range = rdoHMR.SelectedItem.Text;
        int ID = 0;
        try
        {
            ID = objController.SaveReworkCost(objUI, null);
            if (ID >0)
            {
                string str = "<script language = 'javascript'>";
                str += "setMessageText('ctl00_ContentPlaceHolder1_lblMessage','Records Saved Successfully');";
                str += "</script>";
                Literal1.Text = str;
            }
            else
            {
                string str = "<script language = 'javascript'>";
                str += "setMessageText('ctl00_ContentPlaceHolder1_lblMessage','Records could not be Saved Successfully');";
                str += "</script>";
                Literal1.Text = str;
            }
        }
        catch
        {
            string str = "<script language = 'javascript'>";
            str += "setMessageText('ctl00_ContentPlaceHolder1_lblMessage','Records could not be Saved Successfully');";
            str += "</script>";
            Literal1.Text = str;
        }
    }
Esempio n. 2
0
    public int SaveReworkCost(ReworkCostUI objUI, System.Data.SqlClient.SqlTransaction objTrans)
    {
        int ID = 0;
        bool flagTransation = true;

        ReworkCostDB objDB = new ReworkCostDB();
        objDB.GroupID = objUI.GroupID;
        objDB.MonthID = objUI.MonthID;
        objDB.YearID = objUI.YearID;
        objDB.ReworkCost_I_Year = objUI.ReworkCost_I_Year;
        objDB.ReworkCost_II_Year = objUI.ReworkCost_II_Year;
        objDB.ModelCategoryID = objUI.ModelCategoryID;
        objDB.HMR_Range = objUI.HMR_Range;
        DataAccessLayer objDataAccess = new DataAccessLayer();

        try
        {

            if (objTrans == null)
            {
                flagTransation = false;
                objDataAccess.GetConnection.Open();
                SqlTransaction objTransaction = objDataAccess.GetConnection.BeginTransaction();
                objTrans = objTransaction;
            }
            ReworkCostManager objManager = new ReworkCostManager();
            ID=objManager.SaveReworkCost(objDB, objTrans);
            if (!flagTransation)
                objTrans.Commit();
            return ID;
        }
        catch (Exception ex)
        {
            if (!flagTransation)
                objTrans.Rollback();
            throw ex;
        }
        finally
        {
            objDataAccess.GetConnection.Close();
        }
    }