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 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 GetRegisterCusServiceList()
{
try
{
XpoTypesInfoHelper.GetXpoTypeInfoSource();
XafTypesInfo.Instance.RegisterEntity(typeof(RegisterCusService));
XPObjectSpaceProvider directProvider = new XPObjectSpaceProvider(scc, null);
IObjectSpace ObjectSpace = directProvider.CreateObjectSpace();
List <RegicusService_Model> list = new List <RegicusService_Model>();
IList <RegisterCusService> collection = ObjectSpace.GetObjects <RegisterCusService>(CriteriaOperator.Parse("GCRecord is null and IsActive = 1 ", null));
string TempSubDistrict = " ", TempDistrict = " ";
if (collection.Count > 0)
{
foreach (RegisterCusService row in collection)
{
RegicusService_Model item = new RegicusService_Model();
if (row.OrganizationOid != null)
{
item.OrganizationOid = row.OrganizationOid.Oid.ToString();
}
item.RegicusServiceOid = row.Oid.ToString();
item.RegisterDate = row.RegisterDate.ToString();
item.CitizenID = row.CitizenID;
item.TitleOid = row.TitleOid.Oid.ToString();
item.TitleName = row.TitleOid.TitleName;
item.FirstNameTH = row.FirstNameTH;
item.LastNameTH = row.LastNameTH;
if (row.GenderOid != null)
{
item.GenderOid = row.GenderOid.Oid.ToString();
item.Gender = row.GenderOid.GenderName;
}
if (row.BirthDate != null)
{
item.BirthDate = row.BirthDate.ToString("dd/MM/yyyy");
}
if (row.Tel != null)
{
item.Tel = row.Tel;
}
if (row.Email != null)
{
item.Email = row.Email;
}
if (row.Address != "")
{
item.Address = row.Address;
}
if (row.Moo != "")
{
item.Moo = row.Moo;
}
if (row.Soi != "")
{
item.Soi = row.Soi;
}
if (row.Road != "")
{
item.Road = row.Road;
}
if (row.ProvinceOid != null)
{
item.ProvinceName = row.ProvinceOid.ProvinceNameTH;
if (row.ProvinceOid.ProvinceNameTH.Contains("กรุงเทพ"))
{
TempSubDistrict = "แขวง";
}
else
{
TempSubDistrict = "ตำบล";
};
if (row.ProvinceOid.ProvinceNameTH.Contains("กรุงเทพ"))
{
TempDistrict = "เขต";
}
else
{
TempDistrict = "อำเภอ";
};
}
if (row.DistrictOid != null)
{
item.DistrictName = row.DistrictOid.DistrictNameTH;
}
if (row.SubDistrictOid != null)
{
item.SubDistrictName = row.SubDistrictOid.SubDistrictNameTH;
}
if (row.ZipCode != null)
{
item.ZipCode = row.ZipCode;
}
item.FullName = item.TitleName + item.FirstNameTH + " " + item.LastNameTH;
item.FullAddress = "เลขที่" + " " + item.Address + " หมู่ที่" + " " + checknull(item.Moo) + " ถนน" + " " + checknull(item.Road) + " " + TempSubDistrict
+ " " + item.SubDistrictName + " " + TempDistrict + " " + item.DistrictName + " " +
"จังหวัด" + " " + item.ProvinceName + " รหัสไปรษณีย์ " + item.ZipCode;
if (row.Remark != null)
{
item.Remark = row.Remark;
}
item.IsActive = row.IsActive;
item.ServicesNumber = row.ServicesNumber.ToString();
//List<RegisterCusServiceDetail_Model> item2 = new List<RegisterCusServiceDetail_Model>();
//foreach (RegisterCusServiceDetail row2 in row.RegisterCusServiceDetails)
//{
// RegisterCusServiceDetail_Model d2 = new RegisterCusServiceDetail_Model();
// d2.RegisterCusServiceOid = row2.RegisterCusServiceOid.Oid.ToString();
// d2.RefOid = row2.RefOid;
// d2.ReceiveDate = row2.ReceiveDate.ToString();
// d2.ServiceTypeOid = d2.ServiceTypeOid;
// d2.ServiceTypeName = d2.ServiceTypeName;
// d2.SubServiceTypeOid = d2.SubServiceTypeOid;
// d2.ServiceTypeName = d2.SubServiceTypeName;
// item2.Add(d2);
//}
//item.Detail = item2;
list.Add(item);
}
return(Request.CreateResponse(HttpStatusCode.OK, list));
}
else
{
UserError err = new UserError();
err.status = "false";
err.code = "0";
err.message = "ไม่มีชื่อผู้ขอรับบริการ โปรดทำการลงทะเบียน";
return(Request.CreateResponse(HttpStatusCode.BadRequest, 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));
}
}
