Пример #1
0
    public void SaveProduction(ProductionUI objUI)
    {
        bool flagTransation = true;

        ProductionDB objDB = new ProductionDB();
        objDB.S = objUI.S;
        objDB.Material = objUI.Material;
        objDB.SerialNo = objUI.SerialNo;
        objDB.Plnt = objUI.Plnt;
        objDB.SLoc = objUI.SLoc;
        objDB.Description = objUI.Description;
        objDB.Production_Month = objUI.Production_Month;
        objDB.Production_Month_Year = objUI.Production_Month_Year;
        //objDB.Model_Code = objUI.Model_Code;
        objDB.FromDate = objUI.FromDate;
        objDB.ToDate = objUI.ToDate;
        objDB.MonthID = objUI.MonthID;
        objDB.YearID = objUI.YearID;
        objDB.Quarter = objUI.Quarter;
        objDB.ModelMappingID = objUI.ModelMappingID;
        DataAccessLayer objDataAccess = new DataAccessLayer();
        SqlTransaction objTrans = null;
        try
        {

            if (objTrans == null)
            {
                flagTransation = false;
                objDataAccess.GetConnection.Open();
                SqlTransaction objTransaction = objDataAccess.GetConnection.BeginTransaction();
                objTrans = objTransaction;
            }
            ProductionManager objManager = new ProductionManager();
            objManager.SaveProduction(objDB, objTrans);
            if (!flagTransation)
                objTrans.Commit();

        }
        catch (Exception ex)
        {
            if (!flagTransation)
                objTrans.Rollback();
            throw ex;
        }
        finally
        {
            objDataAccess.GetConnection.Close();
        }
    }