public HttpResponseMessage RigisteOrgeService()
{
democlass democlass = new democlass();
RigisteOrgeService OrgeService = new RigisteOrgeService();
try
{
string requestString = Request.Content.ReadAsStringAsync().Result;
JObject jObject = (JObject)JsonConvert.DeserializeObject(requestString);
if (jObject.Count > 0)
{
if (jObject.SelectToken("OrganizationOid") == null)
{
OrgeService.OrganizationOid = null;
}
else
{
OrgeService.OrganizationOid = jObject.SelectToken("OrganizationOid").Value <string>();
}
OrgeService.OrgeServiceID = jObject.SelectToken("orgeServiceID").Value <string>();
OrgeService.OrgeServiceName = jObject.SelectToken("orgeServiceName").Value <string>();
OrgeService.Email = jObject.SelectToken("email").Value <string>();
OrgeService.Tel = jObject.SelectToken("tel").Value <string>();
OrgeService.Address = jObject.SelectToken("address").Value <string>();
if (jObject.SelectToken("moo") != null)
{
OrgeService.Moo = jObject.SelectToken("moo").Value <string>();
}
if (jObject.SelectToken("soi") != null)
{
OrgeService.Soi = jObject.SelectToken("soi").Value <string>();
}
if (jObject.SelectToken("road") != null)
{
OrgeService.Road = jObject.SelectToken("road").Value <string>();
}
OrgeService.Province = jObject.SelectToken("provinceOid").Value <string>();
OrgeService.District = jObject.SelectToken("districtOid").Value <string>();
OrgeService.SubDistrict = jObject.SelectToken("subDistrictOid ").Value <string>();
OrgeService.Zipcode = jObject.SelectToken("zipCode").Value <string>();
DataSet ds = new DataSet();
SqlParameter[] prm = new SqlParameter[13]; /// parameter นับได้เท่าไร ใส่เท่านั้น c#
prm[0] = new SqlParameter("@OrganizationOid", OrgeService.OrganizationOid); ///แต่ array ต้องนับจาก 0
prm[1] = new SqlParameter("@OrgeServiceID", OrgeService.OrgeServiceID);
prm[2] = new SqlParameter("@OrgeServiceName", OrgeService.OrgeServiceName);
prm[3] = new SqlParameter("@Tel", OrgeService.Tel);
prm[4] = new SqlParameter("@Email", OrgeService.Email);
prm[5] = new SqlParameter("@Address_No", OrgeService.Address);
prm[6] = new SqlParameter("@Address_moo", OrgeService.Moo);
prm[7] = new SqlParameter("@Address_Soi", OrgeService.Soi);
prm[8] = new SqlParameter("@Address_Road", OrgeService.Road);
prm[9] = new SqlParameter("@Address_provinces", OrgeService.Province);
prm[10] = new SqlParameter("@Address_districts", OrgeService.District);
prm[11] = new SqlParameter("@Address_subdistricts", OrgeService.SubDistrict);
prm[12] = new SqlParameter("@ZipCode", OrgeService.Zipcode);
ds = SqlHelper.ExecuteDataset(scc, CommandType.StoredProcedure, "spt_MoblieRigisteOrgeService", 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.Created, ds.Tables[0]));
}
else
{
UserError err = new UserError();
err.code = "5";
err.message = "ไม่สามารถลงทะเบียนได้โปรดตรวจสอบ";
return(Request.CreateResponse(HttpStatusCode.NotFound, err));
// return new HttpStatusCodeResult(HttpStatusCode.BadRequest, "naughty");
}
}
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.status = "ผิดพลาด";
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 Edit_Subscriber()
{
RegisterSubscriber_User Update_subscriber = new RegisterSubscriber_User();
try
{
string requestString = Request.Content.ReadAsStringAsync().Result;
JObject jObject = (JObject)JsonConvert.DeserializeObject(requestString);
if (jObject != null)
{
Update_subscriber.OrganizationOid = jObject.SelectToken("Organization").Value <string>();
Update_subscriber.RegisterDate = jObject.SelectToken("RegisterDate").Value <string>();
Update_subscriber.CitizenID = jObject.SelectToken("CitizenID").Value <string>();
Update_subscriber.TitleOid = jObject.SelectToken("TitleOid").Value <string>();
Update_subscriber.FirstNameTH = jObject.SelectToken("FirstNameTH").Value <string>();
Update_subscriber.LastNameTH = jObject.SelectToken("LastNameTH").Value <string>();
Update_subscriber.Gender = jObject.SelectToken("Gender").Value <string>();
Update_subscriber.BirthDate = jObject.SelectToken("BirthDate").Value <string>();
Update_subscriber.Tel = jObject.SelectToken("Tel").Value <string>();
Update_subscriber.Email = jObject.SelectToken("Email").Value <string>();
Update_subscriber.Address = jObject.SelectToken("Address_No").Value <string>();
Update_subscriber.Moo = jObject.SelectToken("Moo").Value <string>();
Update_subscriber.Soi = jObject.SelectToken("Soi").Value <string>();
Update_subscriber.Road = jObject.SelectToken("Road").Value <string>();
Update_subscriber.ProvinceOid = jObject.SelectToken("ProvinceOid").Value <string>();
Update_subscriber.DistrictOid = jObject.SelectToken("DistrictOid").Value <string>();
Update_subscriber.SubDistrictOid = jObject.SelectToken("SubDistrictOid").Value <string>();
Update_subscriber.ZipCode = jObject.SelectToken("ZipCode").Value <string>();
}
XPObjectSpaceProvider osProvider = new XPObjectSpaceProvider(scc, null);
IObjectSpace objectSpace = osProvider.CreateObjectSpace();
DataSet ds = new DataSet();
SqlParameter[] prm = new SqlParameter[19]; /// parameter นับได้เท่าไร ใส่เท่านั้น c#
prm[0] = new SqlParameter("@OrganizationOid", Update_subscriber.OrganizationOid); ///แต่ array ต้องนับจาก 0
prm[1] = new SqlParameter("@RegisterDate", Update_subscriber.RegisterDate);
prm[2] = new SqlParameter("@Citizen_ID", Update_subscriber.CitizenID);
prm[3] = new SqlParameter("@TitleOid", Update_subscriber.TitleOid);
prm[4] = new SqlParameter("@FirstName_TH", Update_subscriber.FirstNameTH);
prm[5] = new SqlParameter("@LastName_TH", Update_subscriber.LastNameTH);
prm[6] = new SqlParameter("@Gender", Update_subscriber.Gender);
prm[7] = new SqlParameter("@Birthdate", Update_subscriber.BirthDate);
prm[8] = new SqlParameter("@Tel", Update_subscriber.Tel);
prm[9] = new SqlParameter("@Email", Update_subscriber.Email);
prm[10] = new SqlParameter("@Remark", Update_subscriber.Remark);
prm[11] = new SqlParameter("@Address_No", Update_subscriber.Address);
prm[12] = new SqlParameter("@Address_moo", Update_subscriber.Moo);
prm[13] = new SqlParameter("@Address_Soi", Update_subscriber.Soi);
prm[14] = new SqlParameter("@Address_Road", Update_subscriber.Road);
prm[15] = new SqlParameter("@Address_provinces", Update_subscriber.ProvinceOid);
prm[16] = new SqlParameter("@Address_districts", Update_subscriber.DistrictOid);
prm[17] = new SqlParameter("@Address_subdistricts", Update_subscriber.SubDistrictOid);
prm[18] = new SqlParameter("@ZipCode", Update_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));
}
}
