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