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)); }