public DataSet ArrestgetByCon(ArrestgetByConmodel model) { var cc = new cf(); try { var db = new Configs(); JObject jsonobj = (JObject)JToken.FromObject(model); var client = new RestClient("http://" + cc.GetIP + "/ArrestgetByCon"); var request = new RestRequest(Method.POST); request.AddHeader("Postman-Token", "0d7a7694-f469-49b6-b944-8bbfe790bbec"); request.AddHeader("Cache-Control", "no-cache"); request.AddHeader("Content-Type", "application/json"); request.AddParameter("undefined", jsonobj.ToString(), RestSharp.ParameterType.RequestBody); IRestResponse response = client.Execute(request); //var content = response.Content; IRestResponse <List <ArrestgetByCon> > response2 = client.Execute <List <ArrestgetByCon> >(request); //Console.WriteLine(response.Content); DataSet dtsr = new DataSet(); DATASETREPORT.ArrestgetByConDataTable dts1 = new DATASETREPORT.ArrestgetByConDataTable(); DATASETREPORT.ArrestgetByConRow dr1; DATASETREPORT.ArrestgetByCon2DataTable dts2 = new DATASETREPORT.ArrestgetByCon2DataTable(); DATASETREPORT.ArrestgetByCon2Row dr2; if (response2.Data == null) { return(null); } else { foreach (var x in response2.Data) { dr1 = dts1.NewArrestgetByConRow(); dr1.ArrestCode = x.ArrestCode; dr1.ArrestStation = x.ArrestStation; dr1.ArrestDay = DateTime.Parse(x.ArrestDate).ToString("dd"); string[] mounth = { "", "มกราคม", "กุมภาพันธ์", "มีนาคม", "เมษายน", "พฤษภาคม", "มิถุนายน", "กรกฎาคม", "สิงหาคม", "กันยายน", "ตุลาคม", "พฤศจิกายน", "ธันวาคม" }; string dayint = DateTime.Parse(x.ArrestDate).ToString("MM"); dr1.ArrestMonth = mounth[int.Parse(dayint)]; string sdadasd = DateTime.Parse(x.ArrestDate).ToString("yyyy"); int fff = int.Parse(sdadasd) + 543; dr1.ArrestYear = fff.ToString(); dr1.ArrestTime = x.ArrestTime; dr1.Behaviour = x.Behaviour; if (x.ArrestStaff != null) { dr1._AS_Nameup6 = ""; foreach (var y in x.ArrestStaff) { if (y.ContributorCode == 6) { dr1._AS_Name6 = y.TitleName + " " + y.FirstName + " " + y.LastName; dr1._AS_PositionName = y.PositionName; dr1._AS_OfficeName = y.OfficeName; } else if (y.ContributorCode != 6) { dr1._AS_Nameup6 += y.TitleName + " " + y.FirstName + " " + y.LastName + " "; } } } if (x.ArrestIndictment != null) { foreach (var y in x.ArrestIndictment) { if (y.ArrestIndictmentDetail != null) { foreach (var z in y.ArrestIndictmentDetail) { if (z.ArrestLawbreaker != null) { dr1._AL_Name = ""; foreach (var o in z.ArrestLawbreaker) { if (o.EntityType == 1) { dr1._AL_Name += o.LawbreakerTitleName + " " + o.LawbreakerFirstName + " " + o.LawbreakerLastName + " "; } else if (o.EntityType == 2) { dr1._AL_Name += o.CompanyTitle + " " + o.CompanyName + " " + o.CompanyOtherName + " "; } } } } } if (y.ArrestLawGuitbase != null) { dr1.GuiltBaseName = ""; foreach (var z in y.ArrestLawGuitbase) { dr1.GuiltBaseName += z.GuiltBaseName + " "; } } } } if (x.ArrestProduct != null) { dr1._AP_ProductDesc = ""; dr1._AL_count = x.ArrestProduct.Count.ToString(); foreach (var y in x.ArrestProduct) { dr1._AP_ProductDesc += y.ProductDesc + " "; dr2 = dts2.NewArrestgetByCon2Row(); dr2.ArrestCode = x.ArrestCode; dr2._ap_ProductDesc = y.ProductDesc; dr2.Qty = y.Qty + " " + y.QtyUnit; dts2.Rows.Add(dr2); } } if (x.ArrestLocale != null) { foreach (var z in x.ArrestLocale) { dr1._ai_Location = z.Location + " " + z.Address + " " + z.Village + " " + z.Building + " " + z.Floor + " " + z.Room + " " + z.SubDistrict + " " + z.District + " " + z.Province; dr1._ai_Address = z.Address; dr1._ai_Village = z.Village; dr1._ai_SubDistrict = z.SubDistrict; dr1._ai_District = z.District; dr1._ai_Province = z.Province; dr1._ai_Road = z.Road; } } dr1.OccurrenceDay = DateTime.Parse(x.OccurrenceDate).ToString("dd"); string odayint = DateTime.Parse(x.ArrestDate).ToString("MM"); dr1.OccurrenceMonth = mounth[int.Parse(odayint)]; string sadsasas = DateTime.Parse(x.OccurrenceDate).ToString("yyyy"); int offf = int.Parse(sadsasas) + 543; dr1.OccurrenceYear = offf.ToString(); dr1.OccurrenceTime = x.OccurrenceTime; dr1.Prompt = x.Prompt; dts1.Rows.Add(dr1); } dtsr.Tables.Add(dts1); dtsr.Tables.Add(dts2); return(dtsr); } } catch { return(null); } }
public DataTable Lawsuitgetbycon(LawsuitArrestgetByConModels model) { var cc = new cf(); try { var db = new Configs(); JObject jsonobj = (JObject)JToken.FromObject(model); //var client = new RestClient("http://150.95.81.223:8083/XCS60/LawsuitArrestgetByCon"); var client = new RestClient("http://103.233.193.62:8083/XCS60/LawsuitArrestgetByCon"); var request = new RestRequest(Method.POST); request.AddHeader("Postman-Token", "0d7a7694-f469-49b6-b944-8bbfe790bbec"); request.AddHeader("Cache-Control", "no-cache"); request.AddHeader("Content-Type", "application/json"); request.AddParameter("undefined", jsonobj.ToString(), RestSharp.ParameterType.RequestBody); IRestResponse response = client.Execute(request); //var content = response.Content; IRestResponse <List <LawsuitArrestgetByConJson> > response2 = client.Execute <List <LawsuitArrestgetByConJson> >(request); //Console.WriteLine(response.Content); DATASETREPORT.LawsuitArrestgetByConDataTable dts = new DATASETREPORT.LawsuitArrestgetByConDataTable(); DATASETREPORT.LawsuitArrestgetByConRow dr2; if (response2.Data == null) { return(null); } else { if (response2.Data != null) { foreach (var x in response2.Data) { if (x.ArrestCode != null) { dr2 = dts.NewLawsuitArrestgetByConRow(); dr2.ArrestCode = x.ArrestCode; //Console.WriteLine(x.ArrestCode); foreach (var x1 in x.LawsuitArrestIndicment) { foreach (var x2 in x1.Lawsuit) { if (x2.LawsuiteStaff != null) { foreach (var x3 in x2.LawsuiteStaff) { dr2._ls_OfficeName = x3.OfficeName; } } dr2.LawsuitStation = x2.LawsuitStation; dr2.LawsuitNo = x2.LawsuitNo; dr2.LawsuitDate = DateTime.Parse(x2.LawsuitDate); dr2.Lawsuitday = DateTime.Parse(x2.LawsuitDate).ToString("dd"); string[] mounth = { "", "มกราคม", "กุมภาพันธ์", "มีนาคม", "เมษายน", "พฤษภาคม", "มิถุนายน", "กรกฎาคม", "สิงหาคม", "กันยายน", "ตุลาคม", "พฤศจิกายน", "ธันวาคม" }; string dayint = DateTime.Parse(x2.LawsuitDate).ToString("MM"); dr2.Lawsuitmonth = mounth[int.Parse(dayint)]; string sdadasd = DateTime.Parse(x2.LawsuitDate).ToString("yyyy"); int fff = int.Parse(sdadasd) + 543; dr2.Lawsuityear = fff.ToString(); dr2.IsLawsuit = x2.IsLawsuit; dr2.ReasonDontLawsuit = x2.ReasonDontLawsuit; } foreach (var x4 in x1.LawsuitArrestIndicmentDetail) { if (x4.LawsuitArrestLawbreaker != null) { dr2.LawbreakerName = ""; foreach (var x5 in x4.LawsuitArrestLawbreaker) { dr2.LawbreakerName += x5.LawbreakerTitleName + " " + x5.LawbreakerFirstName + " " + x5.LawbreakerMiddleName + " " + x5.LawbreakerLastName + " " + x5.LawbreakerOtherName; } } if (x4.LawsuitArrestProductDetail != null) { dr2.ProductDesc = ""; foreach (var x6 in x4.LawsuitArrestProductDetail) { dr2.ProductDesc += x6.ProductDesc + " " + x6.ProductSize + " " + x6.ProductSizeUnitName + " " + x6.ProductQty + " " + x6.ProductNetVolume + " " + x6.ProductNetVolumeUnit; } } } if (x1.LawsuitLawGuiltbase != null) { dr2.GuiltBaseName = ""; foreach (var x7 in x1.LawsuitLawGuiltbase) { dr2.GuiltBaseName += x7.GuiltBaseName; } } } foreach (var x1 in x.LawsuitArrestStaff) { if (x1.ContributorID == 6) { dr2._las_Name = x1.TitleName + " " + x1.FirstName + " " + x1.LastName; dr2._las_PositionName = x1.PositionName; dr2._las_OfficeShortName = x1.OfficeShortName; } } dts.Rows.Add(dr2); } } } } return(dts); } catch (Exception ex) { Console.WriteLine(ex); return(null); } }