public void gried() { summaryReport summarReport = new summaryReport(); List <summaryReport> lstSummary = new List <summaryReport>(); DateTime fromdate = Convert.ToDateTime(ViewState["fromdate"]); DateTime todate = Convert.ToDateTime(ViewState["todate"]); int AgentIds = Convert.ToInt32(ddlPartyName.SelectedItem.Value); int LocId = basePage.LoggedInUser.UserLocation.LocationId; int userId = basePage.LoggedInUser.UserTypeId; if (userId == Convert.ToInt32(UserType.Admin)) { LocId = 0; lstSummary = summaryBusinessAccess.readReport(fromdate, todate, AgentIds, LocId); } else { lstSummary = summaryBusinessAccess.readReport(fromdate, todate, AgentIds, LocId); } grdsummary.DataSource = lstSummary; grdsummary.DataBind(); lblPartyName.Text = ddlPartyName.SelectedItem.Text; lbldate.Text = (txt_fromDate.Text) + " To " + (txt_toDate.Text); }
public List <summaryReport> ReadSummaryReport(DateTime Fromdate, DateTime todate, int AgentIds, int?LocId) { List <summaryReport> lst = new List <summaryReport>(); DbCommand dbCommand = MyDataBase.GetStoredProcCommand(DBConstant.READ_SUMMARYREPORT); if (LocId != 0) { MyDataBase.AddInParameter(dbCommand, "@LocationId", DbType.Int32, LocId); } else { MyDataBase.AddInParameter(dbCommand, "@LocationId", DbType.Int32, DBNull.Value); } MyDataBase.AddInParameter(dbCommand, "@in_from_date", DbType.DateTime, Fromdate); MyDataBase.AddInParameter(dbCommand, "@in_to_date", DbType.DateTime, todate); MyDataBase.AddInParameter(dbCommand, "@in_agent_Id", DbType.Int32, AgentIds); using (IDataReader ireader = MyDataBase.ExecuteReader(dbCommand)) { while (ireader.Read()) { summaryReport summaryReport = new summaryReport(); summaryReport.PartyName = GetStringFromDataReader(ireader, "Agent_Name"); summaryReport.Country = GetStringFromDataReader(ireader, "Country_Name"); summaryReport.NumberOfPassport = GetIntegerFromDataReader(ireader, "No_of_Passport"); summaryReport.PaxName = GetStringFromDataReader(ireader, "Pax_Name"); summaryReport.PassportNumber = GetStringFromDataReader(ireader, "Passport_No"); summaryReport.Remarks = GetStringFromDataReader(ireader, "Remarks"); lst.Add(summaryReport); } } return(lst); }
public void ReplyDispatchReport() { SUTI rmsg = new SUTI(); orgType sender = new orgType(); sender.name = "HTD"; sender.idOrg.id = "104:HTD_001"; sender.idOrg.src = "SUTI"; orgType receiver = new orgType(); receiver.name = "HUT"; receiver.idOrg.id = "801:HUT_001"; receiver.idOrg.src = "SUTI"; rmsg.orgReceiver = receiver; rmsg.orgSender = sender; rmsg.msg = new List <SUTIMsg>(); SUTIMsg msgResponse = new SUTIMsg(); idType id = new idType(); id.src = "104:HTD_001:MSGID"; id.id = System.DateTime.Now.Ticks.ToString(); msgResponse.idMsg = id; msgResponse.msgName = "OrderReport"; msgResponse.msgType = "6001"; msgResponse.referencesTo = new msgReferencesTo(); idType idOrder = new idType(); idOrder.src = "KELA_ROUTEID"; idOrder.id = this.kela_id; List <idType> idList = new List <idType>(); idList.Add(idOrder); msgResponse.referencesTo.idOrder = idList; if (smsg != null) { msgResponse.referencesTo.idMsg = smsg.msg[0].idMsg; } else { idType idMsg = new idType(); idMsg.src = "901:HUT:MSGID"; idMsg.id = "12345"; msgResponse.referencesTo.idMsg = idMsg; } idType idVehicle = new idType(); idVehicle.id = this.veh_nbr; idVehicle.src = "104:HTD_001:VEHICLEID"; idVehicle.unique = true; msgResponse.referencesTo.idVehicle = idVehicle; msgResponse.referencesTo.idOrder = idList; orderReport or = new orderReport(); or.summaryReport = new List <summaryReport>(); summaryReport sr = new summaryReport(); sr.orderEnded = true; sr.vehicle = this.veh_nbr; or.summaryReport.Add(sr); msgResponse.Item = or; //= new List<resourceType>; rmsg.msg.Add(msgResponse); try { log.InfoFormat("HTD->HUT " + rmsg.Serialize().ToString()); //WebRequest request = WebRequest.Create("http://10.100.113.33:8202/default.aspx"); string response = "<SOAP-ENV:Envelope xmlns:SOAP-ENC='http://schemas.xmlsoap.org/soap/encoding/' xmlns:SOAP-ENV='http://schemas.xmlsoap.org/soap/envelope/' xmlns:ZSI='http://www.zolera.com/schemas/ZSI/' xmlns:xsd='http://www.w3.org/2001/XMLSchema' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance'><SOAP-ENV:Header></SOAP-ENV:Header><SOAP-ENV:Body xmlns:ns1='http://tempuri.org/'><ns1:ReceiveSutiMsg><ns1:xmlstring>" + System.Web.HttpUtility.HtmlEncode(rmsg.Serialize().ToString()) + "</ns1:xmlstring></ns1:ReceiveSutiMsg></SOAP-ENV:Body></SOAP-ENV:Envelope>"; byte[] buffer = Encoding.UTF8.GetBytes(response); WebRequest request = WebRequest.Create("http://192.168.222.11:7202/SUTI"); request.Credentials = CredentialCache.DefaultCredentials; ((HttpWebRequest)request).UserAgent = "ASP.NET from HTD KELA SVC"; ((HttpWebRequest)request).KeepAlive = false; ((HttpWebRequest)request).Timeout = System.Threading.Timeout.Infinite; ((HttpWebRequest)request).ReadWriteTimeout = System.Threading.Timeout.Infinite; ((HttpWebRequest)request).ProtocolVersion = HttpVersion.Version10; ((HttpWebRequest)request).AllowWriteStreamBuffering = false; ((HttpWebRequest)request).ContentLength = buffer.Length; request.Method = "POST"; request.ContentType = "application/xml"; Stream writer = request.GetRequestStream(); log.InfoFormat("HTD->HUT " + response); writer.Write(buffer, 0, buffer.Length); writer.Close(); // Response WebResponse resp = request.GetResponse(); writer = resp.GetResponseStream(); StreamReader rdr = new StreamReader(writer); log.InfoFormat("HUT->HTD " + rdr.ReadToEnd()); rdr.Close(); writer.Close(); resp.Close(); } catch (WebException exc) { log.InfoFormat("Error with KEEP ALIVE - {0}", exc.Message); } catch (ProtocolViolationException exc) { log.InfoFormat("Error with KEEP ALIVE - {0}" + exc.Message); } // *** Test Phase *** // ** Cancel Order and Notify *** // return; }