Пример #1
0
    public int SaveAcr(AcrDB objDB,SqlTransaction objTrans)
    {
        int ID = 0;
        DataAccessLayer objDataLayer = new DataAccessLayer();
        SqlCommand objCmd = new SqlCommand();
        try
        {
            objCmd.CommandText = "usp_AcrInsert";
            objCmd.CommandType = CommandType.StoredProcedure;
            objCmd.Parameters.AddWithValue("@WCDOCNO", objDB.WCDOCNO);
            objCmd.Parameters.AddWithValue("@DLR_REF", objDB.DLR_REF);
            objCmd.Parameters.AddWithValue("@TRACTOR_NO", objDB.TRACTOR_NO);
            objCmd.Parameters.AddWithValue("@ENGINE_NO", objDB.ENGINE_NO);
            objCmd.Parameters.AddWithValue("@INS_DATE", objDB.INS_DATE);
            objCmd.Parameters.AddWithValue("@DEF_DATE", objDB.DEF_DATE);
            objCmd.Parameters.AddWithValue("@REP_DATE", objDB.REP_DATE);
            objCmd.Parameters.AddWithValue("@HMR", objDB.HMR);
            objCmd.Parameters.AddWithValue("@DLR_CO", objDB.DLR_CO);
            objCmd.Parameters.AddWithValue("@DEALER_NAME", objDB.DEALER_NAME);
            objCmd.Parameters.AddWithValue("@REG", objDB.REG);
            objCmd.Parameters.AddWithValue("@CR_DATE", objDB.CR_DATE);
            objCmd.Parameters.AddWithValue("@ITEM_CODE", objDB.ITEM_CODE);
            objCmd.Parameters.AddWithValue("@DESCRIPTION", objDB.DESCRIPTION);
            objCmd.Parameters.AddWithValue("@QUANTITY", objDB.QUANTITY);
            objCmd.Parameters.AddWithValue("@COST", objDB.COST);
            objCmd.Parameters.AddWithValue("@DEF", objDB.DEF);
            objCmd.Parameters.AddWithValue("@NDP", objDB.NDP);
            objCmd.Parameters.AddWithValue("@VALUE", objDB.VALUE);
            objCmd.Parameters.AddWithValue("@CVOICE", objDB.CVOICE);
            objCmd.Parameters.AddWithValue("@OUTLV", objDB.OUTLV);
            objCmd.Parameters.AddWithValue("@DT", objDB.DT);
            objCmd.Parameters.AddWithValue("@CUL_CODE", objDB.CUL_CODE);
            objCmd.Parameters.AddWithValue("@BLANK", objDB.BLANK);
            objCmd.Parameters.AddWithValue("@CR_AMOUNT", objDB.CR_AMOUNT);
            objCmd.Parameters.AddWithValue("@AUTH_AMT", objDB.AUTH_AMOUNT);
            objCmd.Parameters.AddWithValue("@DIFF", objDB.DIFF);
            objCmd.Parameters.AddWithValue("@Production_Month", objDB.Production_Month);
            objCmd.Parameters.AddWithValue("@Production_Month_Year", objDB.Production_Month_Year);
            objCmd.Parameters.AddWithValue("@ModelMappingID", objDB.ModelMappingID);
            objCmd.Parameters.AddWithValue("@HMR_Range", objDB.HMR_Range);
            objCmd.Parameters.AddWithValue("@FromDate", objDB.FromDate);
            objCmd.Parameters.AddWithValue("@ToDate", objDB.ToDate);
            objCmd.Parameters.AddWithValue("@MonthID", objDB.MonthID);
            objCmd.Parameters.AddWithValue("@YearID", objDB.YearID);
            objCmd.Parameters.AddWithValue("@Quarter", objDB.Quarter);
            objCmd.Parameters.AddWithValue("@Engine", objDB.Engine);
            objCmd.Parameters.AddWithValue("@IsEngine", objDB.IsEngine);
            objCmd.Parameters.AddWithValue("@ID", SqlDbType.Int);
            objCmd.Parameters["@ID"].Direction = ParameterDirection.Output;
            objCmd.Transaction = objTrans;
            objCmd.Connection = objTrans.Connection;
            objDataLayer.Command = objCmd;
            objDataLayer.ExecQuery();
            ID = Convert.ToInt32(objCmd.Parameters["@ID"].Value);
        }
        catch (Exception ex)
        {

            throw ex;
        }

        return ID;
    }
Пример #2
0
    public int SaveAcr(AcrUI objUI)
    {
        int ID = 0;
        bool flagTransation = true;

        AcrDB objDB = new AcrDB();
        objDB.WCDOCNO = objUI.WCDOCNO;
        objDB.DLR_REF = objUI.DLR_REF;
        objDB.TRACTOR_NO = objUI.TRACTOR_NO;
        objDB.ENGINE_NO = objUI.ENGINE_NO;
        objDB.INS_DATE = objUI.INS_DATE;
        objDB.REP_DATE = objUI.REP_DATE;
        objDB.DEF_DATE = objUI.DEF_DATE;
        objDB.HMR = objUI.HMR;
        objDB.DLR_CO = objUI.DLR_CO;
        objDB.DEALER_NAME = objUI.DEALER_NAME;
        objDB.REG = objUI.REG;
        objDB.CR_DATE = objUI.CR_DATE;
        objDB.ITEM_CODE = objUI.ITEM_CODE;
        objDB.DESCRIPTION = objUI.DESCRIPTION;
        objDB.COST = objUI.COST;
        objDB.QUANTITY = objUI.QUANTITY;
        objDB.DEF = objUI.DEF;
        objDB.NDP = objUI.NDP;
        objDB.VALUE = objUI.VALUE;
        objDB.CVOICE = objUI.CVOICE;
        objDB.OUTLV = objUI.OUTLV;
        objDB.DT = objUI.DT;
        objDB.CUL_CODE = objUI.CUL_CODE;
        objDB.BLANK = objUI.BLANK;
        objDB.CR_AMOUNT = objUI.CR_AMOUNT;
        objDB.AUTH_AMOUNT = objUI.AUTH_AMOUNT;
        objDB.DIFF = objUI.DIFF;
        objDB.Production_Month = objUI.Production_Month;
        objDB.Production_Month_Year = objUI.Production_Month_Year;
        objDB.ModelMappingID = objUI.ModelMappingID;
        objDB.HMR_Range = objUI.HMR_Range;
        objDB.FromDate = objUI.FromDate;
        objDB.ToDate = objUI.ToDate;
        objDB.MonthID = objUI.MonthID;
        objDB.YearID = objUI.YearID;
        objDB.Quarter = objUI.Quarter;
        objDB.Engine = objUI.Engine;
        objDB.IsEngine = objUI.IsEngine;

        DataAccessLayer objDataAccess = new DataAccessLayer();
        SqlTransaction objTrans = null;
        try
        {

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

        }
        catch (Exception ex)
        {
            if (!flagTransation)
                objTrans.Rollback();
            throw ex;
        }
        return ID;
    }