public Tuple <bool, string, string> Post(GatePassCommonEntity gatePassCommon)
        {
            DataSet             ds = new DataSet();
            ManageSQLConnection manageSQLConnection             = new ManageSQLConnection();
            List <KeyValuePair <string, string> > sqlParameters = new List <KeyValuePair <string, string> >();

            sqlParameters.Add(new KeyValuePair <string, string>("@DocumentId", gatePassCommon.DocNumber));
            ds = manageSQLConnection.GetDataSetValues("GetStockIssuesForAbstractPrint", sqlParameters);
            ManageIssuesAbstractPrint issuesAbstractPrint = new ManageIssuesAbstractPrint();
            bool result = issuesAbstractPrint.GenerateAbstractPrint(ds, gatePassCommon);

            return(new Tuple <bool, string, string>(result, result == true ? "Gate Pass Generated Successfully" :"Please contact Administrator", JsonConvert.SerializeObject(ds.Tables[0])));
        }
        public bool Put(GatePassCommonEntity entity)
        {
            ManageSQLConnection manageSQLConnection = new ManageSQLConnection();

            if (entity.Type == 1)
            {
                DataSet ds = new DataSet();
                List <KeyValuePair <string, string> > sqlParameters1 = new List <KeyValuePair <string, string> >();
                sqlParameters1.Add(new KeyValuePair <string, string>("@DocumentId", entity.DocNumber));
                ds = manageSQLConnection.GetDataSetValues("GetStockIssuesForAbstractPrint", sqlParameters1);
                ManageIssuesAbstractPrint issuesAbstractPrint = new ManageIssuesAbstractPrint();
                Task.Run(() => issuesAbstractPrint.ProcessDataToGPS(ds, entity));
            }
            List <KeyValuePair <string, string> > sqlParameters = new List <KeyValuePair <string, string> >();

            sqlParameters.Add(new KeyValuePair <string, string>("@GatePassId", entity.GatePassNo));
            sqlParameters.Add(new KeyValuePair <string, string>("@GCode", entity.GCode));
            return(manageSQLConnection.UpdateValues("UpdateGatePass", sqlParameters));
        }