Exemplo n.º 1
0
        //Get GetPOCode
        #region [Max POCode Code]
        public DataSet GetPOCode_DL(EWA_QualityControl objEWA)
        {
            DataSet ds = new DataSet();

            try
            {
                prmList    = new string[6];
                prmList[0] = "@Action";
                prmList[1] = "GetPOCode";
                prmList[2] = "@POCode";
                prmList[3] = objEWA.PreText;
                prmList[4] = "@OrgId";
                prmList[5] = Convert.ToString(objEWA.OrgId);

                ds = ObjHelper.FillControl(prmList, "SP_QualityControl");
                if (ds.Tables[0].Rows.Count > 0)
                {
                    return(ds);
                }
                return(ds);
            }
            catch (Exception exp)
            {
                throw exp;
            }
        }
Exemplo n.º 2
0
        //Bind Supplier category
        #region [Bind Supplier]

        public DataSet BindSupplier_DL(EWA_QualityControl objEWA)
        {
            DataSet ds = new DataSet();

            try
            {
                prmList    = new string[4];
                prmList[0] = "@Action";
                prmList[1] = "FetchSupplier";

                prmList[2] = "@OrgId";
                prmList[3] = Convert.ToString(objEWA.OrgId);

                ds = ObjHelper.FillControl(prmList, "SP_QualityControl");
                if (ds.Tables[0].Rows.Count > 0)
                {
                    return(ds);
                }

                return(ds);
            }
            catch (Exception exp)
            {
                throw exp;
            }
        }
Exemplo n.º 3
0
        //Bind Item Category
        #region [Bind Item Grid]

        public DataSet BindItemGrid_DL(EWA_QualityControl objEWA)
        {
            DataSet ds = new DataSet();

            try
            {
                prmList    = new string[4];
                prmList[0] = "@Action";
                prmList[1] = "FetchItemData";

                prmList[2] = "@SupplierId";
                prmList[3] = objEWA.SupplierId;

                ds = ObjHelper.FillControl(prmList, "SP_QualityControl");
                if (ds.Tables[0].Rows.Count > 0)
                {
                    return(ds);
                }
                else
                {
                    DataTable dt = new DataTable();
                    dt.Columns.Add("ItemName");

                    dt.Rows.Add();
                    dt.Rows.Add();
                    dt.Rows.Add();
                    //return dsCode;
                }
                return(ds);
            }
            catch (Exception exp)
            {
                throw exp;
            }
        }
Exemplo n.º 4
0
        //Get Data
        #region [Get Data]

        public DataSet BindPODetails_DL(EWA_QualityControl objEWA)
        {
            try
            {
                prmList    = new string[6];
                prmList[0] = "@Action";
                prmList[1] = "GetDataByPOCode";
                prmList[2] = "@POCode";
                prmList[3] = objEWA.POCode;
                prmList[4] = "@OrgId";
                prmList[5] = Convert.ToString(objEWA.OrgId);

                DataSet ds = ObjHelper.FillControl(prmList, "SP_QualityControl");
                if (ds.Tables[0].Rows.Count > 0)
                {
                    return(ds);
                }
                else
                {
                    DataTable dt = new DataTable();
                    dt.Columns.Add("SupplierName");

                    dt.Rows.Add();
                    dt.Rows.Add();
                    dt.Rows.Add();
                    //return dsCode;
                }
                return(ds);
            }
            catch (Exception exp)
            {
                throw exp;
            }
        }
Exemplo n.º 5
0
        //Item Grid Bind
        #region [Item Grid Bind]

        public DataSet BindItemGrid_BL(EWA_QualityControl objEWA)
        {
            try
            {
                DL_QualityControl objDL = new DL_QualityControl();
                DataSet           ds    = objDL.BindItemGrid_DL(objEWA);
                return(ds);
            }
            catch (Exception exp)
            {
                throw exp;
            }
        }
Exemplo n.º 6
0
        //Bind Supplier Category
        #region [Bind PO Details]

        public DataSet BindPODetails_BL(EWA_QualityControl objEWA)
        {
            try
            {
                DL_QualityControl objDL = new DL_QualityControl();
                DataSet           ds    = objDL.BindPODetails_DL(objEWA);
                return(ds);
            }
            catch (Exception)
            {
                throw;
            }
        }
Exemplo n.º 7
0
        //To Fetch POCode

        #region [Fetch POCode]

        public DataSet GetPOCode_BL(EWA_QualityControl objEWA)
        {
            try
            {
                DL_QualityControl objDL = new DL_QualityControl();
                DataSet           ds    = objDL.GetPOCode_DL(objEWA);
                return(ds);
            }
            catch (Exception exp)
            {
                throw exp;
            }
        }
Exemplo n.º 8
0
        //Action Performed
        #region [ActionPerformed For Supplier ]

        public int QCAction_BL(EWA_QualityControl objEWA, DataTable dt)
        {
            try
            {
                DL_QualityControl objDL = new DL_QualityControl();
                int flag = objDL.QCAction_DL(objEWA, dt);
                return(flag);
            }
            catch (Exception)
            {
                throw;
            }
        }
Exemplo n.º 9
0
        //Perform Action on Supplier Table

        #region [Perform Actions On Supplier]

        public int QCAction_DL(EWA_QualityControl objEWA, DataTable dt)
        {
            try
            {
                cmd             = new SqlCommand("SP_QualityControl", con);
                cmd.CommandType = CommandType.StoredProcedure;

                cmd.Parameters.AddWithValue("@Action", objEWA.Action);
                cmd.Parameters.AddWithValue("@POId", objEWA.POId);
                cmd.Parameters.AddWithValue("@QCId", objEWA.QCId);
                cmd.Parameters.AddWithValue("@QCDate", objEWA.QCDate);
                cmd.Parameters.AddWithValue("@POCode", objEWA.POCode);
                cmd.Parameters.AddWithValue("@SupplierId", objEWA.SupplierId);

                cmd.Parameters.AddWithValue("@Remark", objEWA.Remark);
                cmd.Parameters.AddWithValue("@OrgId", objEWA.OrgId);
                cmd.Parameters.AddWithValue("@UserId", objEWA.UserId);
                cmd.Parameters.AddWithValue("@IsActive", objEWA.IsActive);

                SqlParameter tblvaluetype = cmd.Parameters.AddWithValue("@QCDetails", dt);  //Passing table value parameter
                tblvaluetype.SqlDbType = SqlDbType.Structured;

                con.Open();
                sqlTransaction  = con.BeginTransaction();
                cmd.Transaction = sqlTransaction;
                int flag = cmd.ExecuteNonQuery();
                sqlTransaction.Commit();
                return(flag);
            }
            catch (Exception ex)
            {
                int err = ((System.Data.SqlClient.SqlException)(ex)).Number;
                if (err == 547 && objEWA.Action == "Delete")
                {
                    throw new SystemException("Record is in use !!!");
                }
                else
                {
                    throw ex;
                }
            }
            finally
            {
                con.Close();
                cmd.Dispose();
            }
        }