public HttpResponseMessage GetCusService() { List <FarmerCitizen> farmerCitizenList = new List <FarmerCitizen>(); FarmerCitizen farmer_info = new FarmerCitizen(); try { string CitizenID = string.Empty; if (HttpContext.Current.Request.Form["CitizenID"].ToString() != null) { CitizenID = HttpContext.Current.Request.Form["CitizenID"].ToString(); } RegisterFarmerController best = new RegisterFarmerController(); if (best.CheckCitizenID(CitizenID) == false) { return(Request.CreateResponse(HttpStatusCode.BadRequest, "หมายเลขบัตรประชาชนไม่ถูกต้อง กรุณาตรวจสอบ")); } DataSet ds = new DataSet(); ds = SqlHelper.ExecuteDataset(scc, CommandType.StoredProcedure, "spt_MobileGetCusService", new SqlParameter("@CitizenID", CitizenID)); if (ds.Tables[0].Rows.Count > 0) { DataTable dt = new DataTable(); dt = ds.Tables[0]; System.Web.Script.Serialization.JavaScriptSerializer serializer = new System.Web.Script.Serialization.JavaScriptSerializer(); List <Dictionary <string, object> > rows = new List <Dictionary <string, object> >(); Dictionary <string, object> row; foreach (DataRow dr in dt.Rows) { row = new Dictionary <string, object>(); foreach (DataColumn col in dt.Columns) { row.Add(col.ColumnName, dr[col]); } rows.Add(row); } return(Request.CreateResponse(HttpStatusCode.OK, rows)); } else if (ds.Tables[0].Rows.Count == 0) { return(Request.CreateResponse(HttpStatusCode.NotFound, "ไม่พบบัตรประจำตัวประชาชน")); } else { return(Request.CreateResponse(HttpStatusCode.NotFound, "NoData")); } } catch (Exception ex) { //Error case เกิดข้อผิดพลาด UserError err = new UserError(); err.code = "6"; // error จากสาเหตุอื่นๆ จะมีรายละเอียดจาก system แจ้งกลับ err.message = ex.Message; // Return resual return(Request.CreateResponse(HttpStatusCode.BadRequest, err)); } }
public HttpResponseMessage Register_Subscriber() { RegicusService_Model Regi_subscriber = new RegicusService_Model(); try { string requestString = Request.Content.ReadAsStringAsync().Result; JObject jObject = (JObject)JsonConvert.DeserializeObject(requestString); if (jObject != null) { if (jObject.SelectToken("OrganizationOid") != null) { Regi_subscriber.OrganizationOid = jObject.SelectToken("OrganizationOid").Value <string>(); } Regi_subscriber.CitizenID = jObject.SelectToken("citizenId").Value <string>(); RegisterFarmerController best = new RegisterFarmerController(); if (best.CheckCitizenID(jObject.SelectToken("citizenId").ToString()) == false) { return(Request.CreateResponse(HttpStatusCode.BadRequest, "หมายเลขบัตรประชาชนไม่ถูกต้อง กรุณาตรวจสอบ")); } Regi_subscriber.TitleOid = jObject.SelectToken("titleOid").Value <string>(); Regi_subscriber.FirstNameTH = jObject.SelectToken("firstNameTh").Value <string>(); Regi_subscriber.LastNameTH = jObject.SelectToken("lastNameTh").Value <string>(); Regi_subscriber.GenderOid = jObject.SelectToken("genderOid").Value <string>(); Regi_subscriber.BirthDate = jObject.SelectToken("birthDate").Value <string>(); Regi_subscriber.Tel = jObject.SelectToken("tel").Value <string>(); Regi_subscriber.Email = jObject.SelectToken("email").Value <string>(); Regi_subscriber.Address = jObject.SelectToken("address").Value <string>(); if (jObject.SelectToken("moo") != null) { Regi_subscriber.Moo = jObject.SelectToken("moo").Value <string>(); } if (jObject.SelectToken("soi") != null) { Regi_subscriber.Soi = jObject.SelectToken("soi").Value <string>(); } if (jObject.SelectToken("road") != null) { Regi_subscriber.Road = jObject.SelectToken("road").Value <string>(); } if (jObject.SelectToken("remark") != null) { Regi_subscriber.Remark = jObject.SelectToken("remark").Value <string>(); } Regi_subscriber.ProvinceOid = jObject.SelectToken("provinceOid").Value <string>(); Regi_subscriber.DistrictOid = jObject.SelectToken("districtOid").Value <string>(); Regi_subscriber.SubDistrictOid = jObject.SelectToken("subDistrictOid").Value <string>(); Regi_subscriber.ZipCode = jObject.SelectToken("zipCode").Value <string>(); } DataSet ds = new DataSet(); SqlParameter[] prm = new SqlParameter[18]; /// parameter นับได้เท่าไร ใส่เท่านั้น c# prm[0] = new SqlParameter("@OrganizationOid", Regi_subscriber.OrganizationOid); ///แต่ array ต้องนับจาก 0 prm[1] = new SqlParameter("@Citizen_ID", Regi_subscriber.CitizenID); prm[2] = new SqlParameter("@TitleOid", Regi_subscriber.TitleOid); prm[3] = new SqlParameter("@FirstName_TH", Regi_subscriber.FirstNameTH); prm[4] = new SqlParameter("@LastName_TH", Regi_subscriber.LastNameTH); prm[5] = new SqlParameter("@Gender", Regi_subscriber.GenderOid); prm[6] = new SqlParameter("@Birthdate", Regi_subscriber.BirthDate); prm[7] = new SqlParameter("@Tel", Regi_subscriber.Tel); prm[8] = new SqlParameter("@Email", Regi_subscriber.Email); prm[9] = new SqlParameter("@Remark", Regi_subscriber.Remark); prm[10] = new SqlParameter("@Address_No", Regi_subscriber.Address); prm[11] = new SqlParameter("@Address_moo", Regi_subscriber.Moo); prm[12] = new SqlParameter("@Address_Soi", Regi_subscriber.Soi); prm[13] = new SqlParameter("@Address_Road", Regi_subscriber.Road); prm[14] = new SqlParameter("@Address_provinces", Regi_subscriber.ProvinceOid); prm[15] = new SqlParameter("@Address_districts", Regi_subscriber.DistrictOid); prm[16] = new SqlParameter("@Address_subdistricts", Regi_subscriber.SubDistrictOid); prm[17] = new SqlParameter("@ZipCode", Regi_subscriber.ZipCode); ds = SqlHelper.ExecuteDataset(scc, CommandType.StoredProcedure, "spt_MoblieRigisterUser_Service", prm); if (ds.Tables[0].Rows[0]["pStatus"].ToString() != "0" || ds.Tables[0].Rows[0]["pStatus"].ToString() == "2") { var subscriber_User = new Farmer_Status(); subscriber_User.Status = "1"; subscriber_User.Message = "บันทึกข้อมูลผู้ขอรับบริการ เรียบร้อยแล้ว"; return(Request.CreateResponse(HttpStatusCode.OK, ds.Tables[0])); } else { UserError err = new UserError(); err.code = "2"; err.message = "ผิดพลาด กรอกข้อมูลไม่ครบ"; return(Request.CreateResponse(HttpStatusCode.BadRequest, err)); // return new HttpStatusCodeResult(HttpStatusCode.BadRequest, "naughty"); } } catch (Exception ex) { //Error case เกิดข้อผิดพลาด UserError err = new UserError(); err.code = "6"; // error จากสาเหตุอื่นๆ จะมีรายละเอียดจาก system แจ้งกลับ err.message = ex.Message; // Return resual return(Request.CreateResponse(HttpStatusCode.BadRequest, err)); } }
public HttpResponseMessage RegisterCusService_ByCitizenID() { string CitizenID = string.Empty; try { if (HttpContext.Current.Request.Form["CitizenID"].ToString() != null) { CitizenID = HttpContext.Current.Request.Form["CitizenID"].ToString(); } RegisterFarmerController best = new RegisterFarmerController(); if (best.CheckCitizenID(CitizenID) == false) { return(Request.CreateResponse(HttpStatusCode.BadRequest, "หมายเลขบัตรประชาชนไม่ถูกต้อง กรุณาตรวจสอบ")); } if (CitizenID != "") { XpoTypesInfoHelper.GetXpoTypeInfoSource(); XafTypesInfo.Instance.RegisterEntity(typeof(RegisterCusService)); XPObjectSpaceProvider directProvider = new XPObjectSpaceProvider(scc, null); IObjectSpace ObjectSpace = directProvider.CreateObjectSpace(); RegicusService_Model RegisterCusServicer_Info = new RegicusService_Model(); RegisterCusService RegisterCusService_; RegisterCusService_ = ObjectSpace.FindObject <RegisterCusService>(CriteriaOperator.Parse("GCRecord is null and CitizenID = ? ", CitizenID)); string TempSubDistrict = "", TempDistrict = ""; if (RegisterCusService_ != null) { RegicusService_Model item = new RegicusService_Model(); item.RegicusServiceOid = RegisterCusService_.Oid.ToString(); item.OrganizationOid = RegisterCusService_.OrganizationOid.Oid.ToString(); item.RegisterDate = RegisterCusService_.RegisterDate.ToString("dd/MM/yyyy"); item.CitizenID = RegisterCusService_.CitizenID; item.TitleOid = RegisterCusService_.TitleOid.Oid.ToString(); item.TitleName = RegisterCusService_.TitleOid.TitleName; item.FirstNameTH = RegisterCusService_.FirstNameTH; item.LastNameTH = RegisterCusService_.LastNameTH; if (RegisterCusService_.GenderOid != null) { item.GenderOid = RegisterCusService_.GenderOid.Oid.ToString(); item.Gender = RegisterCusService_.GenderOid.GenderName; } if (RegisterCusService_.BirthDate != null) { item.BirthDate = RegisterCusService_.BirthDate.ToString("dd/MM/yyyy"); } if (RegisterCusService_.Tel != null) { item.Tel = RegisterCusService_.Tel; } if (RegisterCusService_.Email != null) { item.Email = RegisterCusService_.Email; } item.FullName = item.TitleName + item.FirstNameTH + " " + item.LastNameTH; if (RegisterCusService_.Address != "") { item.Address = RegisterCusService_.Address; } if (RegisterCusService_.Moo != "") { item.Moo = RegisterCusService_.Moo; } if (RegisterCusService_.Soi != " ") { item.Soi = RegisterCusService_.Soi; } if (RegisterCusService_.Road != "") { item.Road = RegisterCusService_.Road; } if (RegisterCusService_.ProvinceOid != null) { item.ProvinceOid = RegisterCusService_.ProvinceOid.Oid.ToString(); item.ProvinceName = RegisterCusService_.ProvinceOid.ProvinceNameTH; if (RegisterCusService_.ProvinceOid.ProvinceNameTH.Contains("กรุงเทพ")) { TempSubDistrict = "แขวง"; } else { TempSubDistrict = "ตำบล"; }; if (RegisterCusService_.ProvinceOid.ProvinceNameTH.Contains("กรุงเทพ")) { TempDistrict = "เขต"; } else { TempDistrict = "อำเภอ"; }; } if (RegisterCusService_.DistrictOid != null) { item.DistrictOid = RegisterCusService_.DistrictOid.Oid.ToString(); item.DistrictName = RegisterCusService_.DistrictOid.DistrictNameTH; } if (RegisterCusService_.SubDistrictOid != null) { item.SubDistrictOid = RegisterCusService_.SubDistrictOid.Oid.ToString(); item.SubDistrictName = RegisterCusService_.SubDistrictOid.SubDistrictNameTH; } if (RegisterCusService_.ZipCode != null) { item.ZipCode = RegisterCusService_.ZipCode; } item.FullAddress = RegisterCusService_.FullAddress; if (RegisterCusService_.Remark != null) { item.Remark = RegisterCusService_.Remark; } item.IsActive = RegisterCusService_.IsActive; directProvider.Dispose(); return(Request.CreateResponse(HttpStatusCode.OK, item)); } else { return(Request.CreateResponse(HttpStatusCode.NotFound, "NoData")); } } else { UserError err = new UserError(); err.code = "6"; // error จากสาเหตุอื่นๆ จะมีรายละเอียดจาก system แจ้งกลับ err.message = "กรุณาระบุเลขบัตรประชาชน"; // Return resual return(Request.CreateResponse(HttpStatusCode.NotFound, err)); } } catch (Exception ex) { UserError err = new UserError(); err.code = "6"; // error จากสาเหตุอื่นๆ จะมีรายละเอียดจาก system แจ้งกลับ err.message = ex.Message; // Return resual return(Request.CreateResponse(HttpStatusCode.BadRequest, err)); } }
public HttpResponseMessage get_CitizenID() { List <FarmerCitizen> farmerCitizenList = new List <FarmerCitizen>(); FarmerCitizen farmer_info = new FarmerCitizen(); try { string CitizenID = string.Empty; if (HttpContext.Current.Request.Form["CitizenID"].ToString() != null) { CitizenID = HttpContext.Current.Request.Form["CitizenID"].ToString(); } RegisterFarmerController best = new RegisterFarmerController(); if (best.CheckCitizenID(CitizenID) == false) { return(Request.CreateResponse(HttpStatusCode.BadRequest, $"หมายเลขบัตรประชาชนไม่ถูกต้อง กรุณาตรวจสอบ")); } DataSet ds = new DataSet(); ds = SqlHelper.ExecuteDataset(scc, CommandType.StoredProcedure, "spt_MobileGetCitizenID", new SqlParameter("@CitizenID", CitizenID)); if (ds.Tables.Count > 0) { List <Farmer_Modelinfo> Farmer_Model = new List <Farmer_Modelinfo>(); Farmer_Modelinfo Farmer_info = new Farmer_Modelinfo(); Farmer_info.Oid = ds.Tables[0].Rows[0]["Oid"].ToString(); Farmer_info.OrganizationOid = ds.Tables[0].Rows[0]["OrganizationOid"].ToString(); Farmer_info.OrganizeNameTH = ds.Tables[0].Rows[0]["OrganizeNameTH"].ToString(); Farmer_info.CitizenID = ds.Tables[0].Rows[0]["CitizenID"].ToString(); Farmer_info.TitleOid = ds.Tables[0].Rows[0]["TitleOid"].ToString(); Farmer_info.TitleName = ds.Tables[0].Rows[0]["TitleName"].ToString(); Farmer_info.GenderName = ds.Tables[0].Rows[0]["GenderName"].ToString(); Farmer_info.FirstNameTH = ds.Tables[0].Rows[0]["FirstNameTH"].ToString(); Farmer_info.LastNameTH = ds.Tables[0].Rows[0]["LastNameTH"].ToString(); Farmer_info.GenderOid = ds.Tables[0].Rows[0]["GenderOid"].ToString(); if (ds.Tables[0].Rows[0]["BirthDate"].ToString() != "") { Farmer_info.BirthDate = Convert.ToDateTime(ds.Tables[0].Rows[0]["BirthDate"]).ToString("dd/MM/yyyy"); } Farmer_info.Tel = ds.Tables[0].Rows[0]["Tel"].ToString(); Farmer_info.Email = ds.Tables[0].Rows[0]["Email"].ToString(); Farmer_info.IsActive = ds.Tables[0].Rows[0]["IsActive"].ToString(); Farmer_info.DisPlayName = ds.Tables[0].Rows[0]["DisPlayName"].ToString(); Farmer_info.Address = ds.Tables[0].Rows[0]["Address"].ToString(); Farmer_info.Moo = ds.Tables[0].Rows[0]["Moo"].ToString(); Farmer_info.Soi = ds.Tables[0].Rows[0]["Soi"].ToString(); Farmer_info.Road = ds.Tables[0].Rows[0]["Road"].ToString(); Farmer_info.ProvinceOid = ds.Tables[0].Rows[0]["ProvinceOid"].ToString(); Farmer_info.ProvinceNameTH = ds.Tables[0].Rows[0]["ProvinceNameTH"].ToString(); Farmer_info.DistrictOid = ds.Tables[0].Rows[0]["DistrictOid"].ToString(); Farmer_info.DistrictNameTH = ds.Tables[0].Rows[0]["DistrictNameTH"].ToString(); Farmer_info.SubDistrictOid = ds.Tables[0].Rows[0]["SubDistrictOid"].ToString(); Farmer_info.SubDistrictNameTH = ds.Tables[0].Rows[0]["SubDistrictNameTH"].ToString(); Farmer_info.ZipCode = ds.Tables[0].Rows[0]["ZipCode"].ToString(); Farmer_info.FullAddress = ds.Tables[0].Rows[0]["FullAddress"].ToString(); Farmer_info.Latitude = ds.Tables[0].Rows[0]["Latitude"].ToString(); Farmer_info.Longitude = ds.Tables[0].Rows[0]["Longitude"].ToString(); Farmer_info.Rigister_Type = ds.Tables[0].Rows[0]["RegisterType"].ToString(); Farmer_info.FarmerGroupsOid = ds.Tables[0].Rows[0]["FarmerGroupsOid"].ToString(); Farmer_info.Status = ds.Tables[0].Rows[0]["Status"].ToString(); Farmer_info.ForageTypeName1 = null; Farmer_info.ForageTypeName2 = null; Farmer_info.ForageTypeName3 = null; Farmer_info.ForageTypeName4 = null; if (ds.Tables[0].Rows[0]["ForageTypeName"].ToString().Contains("เมล็ด")) { Farmer_info.ForageTypeName1 = "เมล็ดพันธุ์"; } if (ds.Tables[0].Rows[0]["ForageTypeName"].ToString().Contains("เสบียง")) { Farmer_info.ForageTypeName2 = "เสบียงสัตว์"; } if (ds.Tables[0].Rows[0]["ForageTypeName"].ToString().Contains("ท่อน")) { Farmer_info.ForageTypeName3 = "ท่อนพันธุ์"; } Farmer_Model.Add(Farmer_info); return(Request.CreateResponse(HttpStatusCode.OK, Farmer_Model)); // return Request.CreateResponse(HttpStatusCode.OK, Farmer_Modelinfo); } else { string param = "username=regislive01&password=password&grant_type=password";//เพื่อทำการขอ access_token byte[] dataStream = Encoding.UTF8.GetBytes(param); string AuthParam = "regislive:password"; string authInfo = Convert.ToBase64String(Encoding.Default.GetBytes(AuthParam)); var request = (HttpWebRequest)WebRequest.Create("http://regislives.dld.go.th:9080/regislive_authen/oauth/token"); request.Method = "POST"; request.ContentType = "application/x-www-form-urlencoded"; request.ContentLength = dataStream.Length; request.Headers.Add("Authorization", "Basic " + authInfo); using (var stream = request.GetRequestStream()) { stream.Write(dataStream, 0, dataStream.Length); } var response = (HttpWebResponse)request.GetResponse(); string responseString = new StreamReader(response.GetResponseStream()).ReadToEnd().ToString(); var jsonResulttodict = JsonConvert.DeserializeObject <Dictionary <string, object> >(responseString); var access_token = jsonResulttodict["access_token"]; // 'Get Data By Token request = (HttpWebRequest)WebRequest.Create("http://regislives.dld.go.th:9080/regislive_webservice/farmer/findbyPid?pid=" + CitizenID); request.Method = "GET"; request.ContentType = "application/x-www-form-urlencoded"; request.Headers.Add("Authorization", "Bearer " + access_token); response = (HttpWebResponse)request.GetResponse(); var xreader = new StreamReader(response.GetResponseStream()).ReadToEnd(); if (response.StatusCode.ToString() != "OK") { var farmerResul = JsonConvert.DeserializeObject <Dictionary <string, object> >(xreader); if (xreader != string.Empty) { farmer_info.CitizenID = farmerResul["pid"]; farmer_info.titleName = farmerResul["prefixNameTh"]; farmer_info.FirstNameTH = farmerResul["firstName"]; farmer_info.LastNameTH = farmerResul["lastName"]; if (farmerResul["genderName"] == null) { farmer_info.genderName = ""; } else { farmer_info.genderName = farmerResul["genderName"]; } farmer_info.birthDate = farmerResul["birthDay"]; farmer_info.tel = farmerResul["phone"]; farmer_info.email = farmerResul["email"]; farmer_info.address = farmerResul["homeNo"]; farmer_info.moo = farmerResul["moo"]; farmer_info.soi = farmerResul["soi"]; farmer_info.road = farmerResul["road"]; farmer_info.provinceNameTH = farmerResul["provinceName"]; farmer_info.districtNameTH = farmerResul["amphurName"]; farmer_info.subDistrictNameTH = farmerResul["tambolName"]; farmer_info.PostCode = farmerResul["postCode"]; farmer_info.latitude = farmerResul["latitude"]; farmer_info.longitude = farmerResul["longitude"]; } else { return(Request.CreateResponse(HttpStatusCode.NoContent, "ไม่ข้อมูลเลขบัตรนี้ โปรดลงทะเบียน")); } } else { return(Request.CreateResponse(HttpStatusCode.GatewayTimeout, "ไม่สามารถติดต่อเซิฟเวอร์ได้")); } farmerCitizenList.Add(farmer_info); return(Request.CreateResponse(HttpStatusCode.OK, farmerCitizenList)); //} // else // { // UserError err3 = new UserError(); // err3.status = "ไม่พบเลขบัตรประชาชน กรุณาลงทะเบียน"; // err3.code = "6"; // error จากสาเหตุอื่นๆ จะมีรายละเอียดจาก system แจ้งกลับ // // Return resual // return Request.CreateResponse(HttpStatusCode.NotFound, err3); // } //Farmer_Model.Add(Farmer_info); //return Request.CreateResponse(HttpStatusCode.OK, Farmer_Model); //else //{ // UserError err = new UserError(); // err.status = "ไม่พบเลขบัตรประชาชนในระบบ กรุณาลงทะเบียน"; // err.code = "6"; // error จากสาเหตุอื่นๆ จะมีรายละเอียดจาก system แจ้งกลับ // // Return resual // //return Request.CreateResponse(HttpStatusCode.NotFound, err); } } catch (Exception ex) { //Error case เกิดข้อผิดพลาด UserError err = new UserError(); err.code = "6"; // error จากสาเหตุอื่นๆ จะมีรายละเอียดจาก system แจ้งกลับ err.message = ex.Message; // Return resual return(Request.CreateResponse(HttpStatusCode.BadRequest, err)); } finally { SqlConnection.ClearAllPools(); } }