protected override void Dispose(bool disposing)
{
base.Dispose(disposing);
if (disposing)
{
if (objectSpaceProvider != null)
{
objectSpaceProvider.Dispose();
objectSpaceProvider = null;
}
}
}
public HttpResponseMessage Count_NumberAccepet()
{
try
{
string OrganizationOid = HttpContext.Current.Request.Form["OrganizationOid"].ToString();
SqlConnection objConn = new SqlConnection(scc);
if (objConn.State != ConnectionState.Open)
{
objConn.Open();
}
DataSet ds = SqlHelper.ExecuteDataset(scc, CommandType.StoredProcedure, "SP_CountNumber_Approve", new SqlParameter("@OrganizationOid", OrganizationOid));
if (ds.Tables[0].Rows.Count > 0)
{
XpoTypesInfoHelper.GetXpoTypeInfoSource();
XafTypesInfo.Instance.RegisterEntity(typeof(Organization));
XPObjectSpaceProvider directProvider = new XPObjectSpaceProvider(scc, null);
IObjectSpace ObjectSpace = directProvider.CreateObjectSpace();
Organization Organization = ObjectSpace.FindObject <Organization>(CriteriaOperator.Parse("GCRecord is null and Oid =?", OrganizationOid));
Count_Number number = new Count_Number();
number.OrganizationName = Organization.OrganizeNameTH;
number.CountNumber = (int)ds.Tables[0].Rows[0]["Count_Total"];
directProvider.Dispose();
ObjectSpace.Dispose();
return(Request.CreateResponse(HttpStatusCode.OK, number));
}
else
{
UserError err = new UserError();
err.code = "-1"; // error จากสาเหตุอื่นๆ จะมีรายละเอียดจาก system แจ้งกลับ
err.message = "ไม่พบข้อมูลรายการ";
return(Request.CreateResponse(HttpStatusCode.NotFound, err));
}
}
catch (Exception ex)
{
UserError err = new UserError();
err.code = "6"; // error จากสาเหตุอื่นๆ จะมีรายละเอียดจาก system แจ้งกลับ
err.message = ex.Message;
return(Request.CreateResponse(HttpStatusCode.BadRequest, err));
}
}
public HttpResponseMessage RodBreedList()
{
try
{
string Org = HttpContext.Current.Request.Form["organizationOid"].ToString();
// string type = HttpContext.Current.Request.Form["type"].ToString();
XpoTypesInfoHelper.GetXpoTypeInfoSource();
XafTypesInfo.Instance.RegisterEntity(typeof(SupplierRodBreedUseProduct));
XPObjectSpaceProvider directProvider = new XPObjectSpaceProvider(scc, null);
IObjectSpace ObjectSpace = directProvider.CreateObjectSpace();
List <Rodbreed_model> Detail = new List <Rodbreed_model>();
IList <SupplierRodBreedUseProduct> collection = ObjectSpace.GetObjects <SupplierRodBreedUseProduct>(CriteriaOperator.Parse(" GCRecord is null and Status = 1 and OrganizationOid = ? ", Org));
var query = from Q in collection orderby Q.UseNo select Q;
if (collection.Count > 0)
{
foreach (SupplierRodBreedUseProduct row in query)
{
Rodbreed_model item = new Rodbreed_model();
item.SupplierRodBreedUseProductOid = row.Oid.ToString();
item.FinanceYearOid = row.FinanceYearOid.Oid.ToString();
item.FinanceYear = row.FinanceYearOid.YearName;
item.ActivityNameOid = row.ActivityOid.Oid.ToString();
item.ActivityName = row.ActivityOid.ActivityName;
if (row.SubActivityLevelOid != null)
{
item.SubActivityLevelOid = row.SubActivityLevelOid.Oid.ToString();
item.SubActivityLevelName = row.SubActivityLevelOid.ActivityName;
}
item.FinanceYearOid = row.FinanceYearOid.Oid.ToString();
item.FinanceYear = row.FinanceYearOid.YearName;
item.UseNo = row.UseNo;
item.UseDate = row.UseDate.ToString("dd/MM/yy");
item.OrganizationOid = row.OrganizationOid.Oid.ToString();
item.OrganizationName = row.OrganizationOid.SubOrganizeName;
if (row.EmployeeOid != null)
{
item.EmployeeOid = row.EmployeeOid.Oid.ToString();
item.EmployeeName = row.EmployeeOid.FullName;
}
if (row.RegisCusServiceOid != null)
{
item.RegisCusServiceOid = row.RegisCusServiceOid.Oid.ToString();
item.FullName = row.RegisCusServiceOid.DisPlayName;
item.FullAddress = row.RegisCusServiceOid.FullAddress;
}
if (row.OrgeServiceOid != null)
{
item.OrgeServiceOid = row.OrgeServiceOid.Oid.ToString();
item.FullName = row.OrgeServiceOid.OrgeServiceName;
item.FullAddress = row.OrgeServiceOid.FullAddress;
}
item.ServiceCount = row.ServiceCount;
item.TotalWeight = row.SupplierRodBreedUseProductDetails.Sum((c => c.Weight)).ToString() + " กิโลกรัม";
Detail.Add(item);
}
directProvider.Dispose();
ObjectSpace.Dispose();
//lists.Receive = ReceiveItems;
return(Request.CreateResponse(HttpStatusCode.OK, Detail));
}
else
{
UserError err2 = new UserError();
err2.status = "false";
err2.code = "-9";
err2.message = "ไม่มีข้อมูลรายการ การใช้ท่อนพันธุ์";
return(Request.CreateResponse(HttpStatusCode.BadRequest, err2));
}
}
catch (Exception ex)
{
UserError err = new UserError();
err.status = "false";
err.code = "6"; // error จากสาเหตุอื่นๆ จะมีรายละเอียดจาก system แจ้งกลับ
err.message = ex.ToString();
return(Request.CreateResponse(HttpStatusCode.BadRequest, err));
}
}
/// <summary>
/// ฟังชั่นเช็ค user password ให้ถูกต้องตามรหัส xaf ที่สมัครไว้
/// </summary>
/// <param name="Username"></param>
/// <param name="Password"></param>
/// <returns></returns>
public WebApi.Jwt.Models.user.User_info CheckLogin_XAF(string Username, string Password) // value1 = Username, value2 = Password จาก class อื่น
{
user.User_info objUser_info = new user.User_info();
try
{
XpoTypesInfoHelper.GetXpoTypeInfoSource();
XafTypesInfo.Instance.RegisterEntity(typeof(UserInfo));
XafTypesInfo.Instance.RegisterEntity(typeof(RoleInfo));
WebApi.Jwt.Models.user.member_info_Shot user2 = new WebApi.Jwt.Models.user.member_info_Shot();
//XPObjectSpaceProvider directProvider = new XPObjectSpaceProvider(scc);
using (XPObjectSpaceProvider directProvider = new XPObjectSpaceProvider(scc))
{
using (IObjectSpace ObjectSpace = directProvider.CreateObjectSpace())
{
UserInfo User;
nutrition.Module.Organization DLD;
User = ObjectSpace.FindObject <UserInfo>(new BinaryOperator("UserName", Username));
// UserInfo = ObjectSpace.FindObject<RoleInfo>(new BinaryOperator("Name", Username));
PasswordCryptographer.EnableRfc2898 = true;
PasswordCryptographer.SupportLegacySha512 = false;
if (User.ComparePassword(Password) == true)
{
objUser_info.User_Name = User.UserName;
objUser_info.DisplayName = User.DisplayName;
objUser_info.OrganizationOid = User.Organization.Oid;
objUser_info.OrganizationNameTH = User.Organization.OrganizeNameTH;
objUser_info.SubOrganizeName = User.Organization.SubOrganizeName;
objUser_info.Tel = User.Organization.Tel;
objUser_info.Email = User.Organization.Email;
objUser_info.Address = User.Organization.Address;
objUser_info.Moo = User.Organization.Moo;
objUser_info.Soi = User.Organization.Soi;
objUser_info.Road = User.Organization.Road;
if (objUser_info.ProvinceNameTH == "")
{
objUser_info.ProvinceNameTH = "ไม่มีข้อมูลศูนย์";
}
else if (objUser_info.ProvinceNameTH != "")
{
objUser_info.ProvinceNameTH = User.Organization.ProvinceOid.ProvinceNameTH;
}
if (objUser_info.DistrictNameTH == "")
{
objUser_info.DistrictNameTH = "ไม่มีข้อมูลศูนย์";
}
else if (objUser_info.DistrictNameTH != "")
{
objUser_info.DistrictNameTH = User.Organization.DistrictOid.DistrictNameTH;
}
if (objUser_info.SubDistrictNameTH == "")
{
objUser_info.SubDistrictNameTH = "ไม่มีข้อมูลศูนย์";
}
else if (objUser_info.SubDistrictNameTH != "")
{
objUser_info.SubDistrictNameTH = User.Organization.SubDistrictOid.SubDistrictNameTH;
}
string TempSubDistrict, TempDistrict;
if (User.Organization.ProvinceOid.ProvinceNameTH.Contains("กรุงเทพ"))
{
TempSubDistrict = "แขวง";
}
else
{
TempSubDistrict = "ตำบล";
};
if (User.Organization.ProvinceOid.ProvinceNameTH.Contains("กรุงเทพ"))
{
TempDistrict = "เขต";
}
else
{
TempDistrict = "อำเภอ";
};
objUser_info.FullAddress = User.Organization.Address + " หมู่ที่" + " " + checknull(User.Organization.Moo) + " ถนน" + checknull(User.Organization.Road) + " " +
TempSubDistrict + User.Organization.SubDistrictOid.SubDistrictNameTH + " " + TempDistrict + User.Organization.DistrictOid.DistrictNameTH + " " +
"จังหวัด" + User.Organization.ProvinceOid.ProvinceNameTH + " " + User.Organization.DistrictOid.PostCode;
DLD = ObjectSpace.FindObject <nutrition.Module.Organization>(new BinaryOperator("Oid", User.Organization.MasterOrganization));
if (DLD == null)
{
objUser_info.DLDName = "ไม่มีเขต";
}
else if (DLD != null)
{
objUser_info.DLDName = DLD.OrganizeNameTH;
}
objUser_info.DLDZone = User.Organization.ProvinceOid.DLDZone.Oid.ToString();
objUser_info.Latitude = User.Organization.Latitude;
objUser_info.Longitude = User.Organization.Longitude;
TokenController token = new TokenController();
objUser_info.Description = "ระบบ Login";
objUser_info.Token_key = token.Get(Username, Password);
objUser_info.Status = 1;
objUser_info.Message = "เข้าสู่ระบบสำเร็จ";
string AcName = "";
foreach (RoleInfo row2 in User.UserRoles)
{
switch (row2.Name)
{
case "Approver":
if (AcName == "")
{
AcName = "Approve";
}
else
{
AcName = AcName + "," + "Approve";
}
break;
case "Operator":
if (AcName == "")
{
AcName = "Edit";
}
else if (AcName.Contains("Edit") != true)
{
AcName = AcName + "," + "Edit";
}
break;
case "Administrator":
if (AcName == "")
{
AcName = "EditAdmin";
}
else if (AcName.Contains("EditAdmin") != true)
{
AcName = AcName + "," + "EditAdmin";
}
//else
//{
// AcName = AcName + "," + "Edit";
//}
break;
case "EditAdmin":
if (AcName == "")
{
AcName = "EditAdmin";
}
else if (AcName.Contains("EditAdmin") != true)
{
AcName = AcName + "," + "EditAdmin";
}
break;
default:
if (AcName == "")
{
AcName = "ReadOnly";
}
else
{
if (AcName.Contains("ReadOnly") == false)
{
AcName = AcName + "," + "ReadOnly";
}
}
break;
}
}
objUser_info.ActionName = AcName;
//List<WebApi.Jwt.Models.user.Roles_info> objListRoles_info = new List<WebApi.Jwt.Models.user.Roles_info>();
//if (AcName.Contains("Edit") == true || AcName.Contains("Administrator") == true )
//{
// objUser_info.ActionName = "Edit"+ "Administrator";
//}
//else
//{
// objUser_info.ActionName = AcName;
//}
}
else if (User.ComparePassword(Password) == false)
{
objUser_info.User_Name = User.UserName;
objUser_info.DisplayName = User.DisplayName;
objUser_info.OrganizationNameTH = User.Organization.OrganizeNameTH;
objUser_info.Tel = User.Organization.Tel;
objUser_info.Status = 0;
objUser_info.Message = "เข้าสู่ระบบไม่สำเร็จ";
}
}
directProvider.Dispose();
}
//IObjectSpace ObjectSpace = directProvider.CreateObjectSpace();
}
catch (Exception ex)
{
objUser_info.Status = 6;
objUser_info.Message = ex.Message;
}
return(objUser_info);
}
protected void Page_Unload(object sender, EventArgs e)
{
objectSpace.Dispose();
security.Dispose();
objectSpaceProvider.Dispose();
}
public void TearDown()
{
directProvider.Dispose();
objectSpace.Dispose();
// generator.Dispose();
}
public HttpResponseMessage ManageSubAnimalSupplierList()
{
List <AnimalProductDetail> animalDatail = new List <AnimalProductDetail>();
AnimalProductDetail animal = new AnimalProductDetail();
try
{
// string QuotaName = HttpContext.Current.Request.Form["QuotaName"].ToString();
string OrganizationOid = HttpContext.Current.Request.Form["OrganizationOid"].ToString();
//string AnimalSupplieOid = HttpContext.Current.Request.Form["AnimalSupplieOid"].ToString();
//string AnimalSupplieTypeOid = HttpContext.Current.Request.Form["AnimalSupplieTypeOid"].ToString();
string QuotaTypeOid = HttpContext.Current.Request.Form["QuotaTypeOid"].ToString();
List <QuotaType_Model> listquo = new List <QuotaType_Model>();
QuotaType_Model quota = new QuotaType_Model();
XpoTypesInfoHelper.GetXpoTypeInfoSource();
XafTypesInfo.Instance.RegisterEntity(typeof(QuotaType));
XafTypesInfo.Instance.RegisterEntity(typeof(ManageAnimalSupplier));
XafTypesInfo.Instance.RegisterEntity(typeof(ManageSubAnimalSupplier));
XPObjectSpaceProvider directProvider = new XPObjectSpaceProvider(scc, null);
List <ManageAnimalSupplier_Model2> list = new List <ManageAnimalSupplier_Model2>();
IObjectSpace ObjectSpace = directProvider.CreateObjectSpace();
QuotaType quotaType;
// var ManageSubAnimalSupplierOid = null;
quotaType = ObjectSpace.FindObject <QuotaType>(CriteriaOperator.Parse("GCRecord is null and IsActive = 1 and Oid = '" + QuotaTypeOid + "' ", null));
ManageAnimalSupplier ObjManageAnimalSupplier = ObjectSpace.FindObject <ManageAnimalSupplier>(CriteriaOperator.Parse("[OrganizationOid]=? and Status=1", OrganizationOid));
if (ObjManageAnimalSupplier != null)
{
switch (quotaType.QuotaName)
{
case "โควตาสำนัก":
animal.QuotaName = "โควตาสำนัก"; //ผิด
animal.AnimalSupplieTypeOid = ObjectSpace.FindObject <AnimalSupplieType>(CriteriaOperator.Parse("[SupplietypeName]='หญ้าแห้ง'", null)).Oid.ToString();
animal.AnimalSupplieTypeName = ObjectSpace.FindObject <AnimalSupplieType>(CriteriaOperator.Parse("[SupplietypeName]='หญ้าแห้ง'", null)).SupplietypeName;
break;
case "โควตาศูนย์ฯ":
animal.QuotaName = "โควตาศูนย์ฯ";
animal.AnimalSupplieTypeOid = ObjectSpace.FindObject <AnimalSupplieType>(CriteriaOperator.Parse("[SupplietypeName]='หญ้าแห้ง'", null)).Oid.ToString();
animal.AnimalSupplieTypeName = ObjectSpace.FindObject <AnimalSupplieType>(CriteriaOperator.Parse("[SupplietypeName]='หญ้าแห้ง'", null)).SupplietypeName;
animal.QuotaQTY = ObjManageAnimalSupplier.CenterQTY;
break;
case "โควตาปศุสัตว์เขต":
animal.QuotaName = "โควตาปศุสัตว์เขต";
animal.AnimalSupplieTypeOid = ObjectSpace.FindObject <AnimalSupplieType>(CriteriaOperator.Parse("[SupplietypeName]='หญ้าแห้ง'", null)).Oid.ToString();
animal.AnimalSupplieTypeName = ObjectSpace.FindObject <AnimalSupplieType>(CriteriaOperator.Parse("[SupplietypeName]='หญ้าแห้ง'", null)).SupplietypeName;
animal.QuotaQTY = ObjManageAnimalSupplier.ZoneQTY;
break;
//case "โควตาปศุสัตว์จังหวัด":
// animal.QuotaName = "โควตาปศุสัตว์จังหวัด";
// animal.AnimalSupplieTypeOid = ObjectSpace.FindObject<AnimalSupplieType>(CriteriaOperator.Parse("[SupplietypeName]='หญ้าแห้ง'", null)).Oid.ToString();
// animal.AnimalSupplieTypeName = ObjectSpace.FindObject<AnimalSupplieType>(CriteriaOperator.Parse("[SupplietypeName]='หญ้าแห้ง'", null)).SupplietypeName;
// animal.QuotaQTY = ObjManageAnimalSupplier.ZoneQTY;
// break;
case "โควตาอื่นๆ":
animal.QuotaName = "โควตาอื่นๆ";
animal.AnimalSupplieTypeOid = ObjectSpace.FindObject <AnimalSupplieType>(CriteriaOperator.Parse("[SupplietypeName]='หญ้าแห้ง'", null)).Oid.ToString();
animal.AnimalSupplieTypeName = ObjectSpace.FindObject <AnimalSupplieType>(CriteriaOperator.Parse("[SupplietypeName]='หญ้าแห้ง'", null)).SupplietypeName;
animal.QuotaQTY = ObjManageAnimalSupplier.OtherQTY;
break;
case "โควตาปศุสัตว์จังหวัด":
if (ObjManageAnimalSupplier != null)
{
animal.AnimalSupplieTypeOid = ObjectSpace.FindObject <AnimalSupplieType>(CriteriaOperator.Parse("[SupplietypeName]='หญ้าแห้ง'", null)).Oid.ToString();
animal.AnimalSupplieTypeName = ObjectSpace.FindObject <AnimalSupplieType>(CriteriaOperator.Parse("[SupplietypeName]='หญ้าแห้ง'", null)).SupplietypeName;
animal.manageSubAnimalSupplierOid = ObjManageAnimalSupplier.Oid.ToString();
List <ManageSubAnimalSupplier_Province> Detail2 = new List <ManageSubAnimalSupplier_Province>();
IList <ManageSubAnimalSupplier> objmanageSubAnimalSupplier = ObjectSpace.GetObjects <ManageSubAnimalSupplier>(CriteriaOperator.Parse("[ManageAnimalSupplierOid]= '" + ObjManageAnimalSupplier.Oid + "' ", null));
if (objmanageSubAnimalSupplier.Count > 0)
{
foreach (ManageSubAnimalSupplier row2 in objmanageSubAnimalSupplier)
{
ManageSubAnimalSupplier_Province subanimal = new ManageSubAnimalSupplier_Province();
subanimal.ManageAnimalSupplierOid = row2.ManageAnimalSupplierOid.Oid.ToString();
subanimal.ManageSubAnimalSupplierOid = row2.Oid.ToString();
subanimal.ProvinceOid = row2.ProvinceOid.Oid.ToString();
subanimal.ProvinceName = row2.ProvinceOid.ProvinceNameTH;
Detail2.Add(subanimal);
}
animal.QuotaName = quotaType.QuotaName;
animal.ObjProvinceName = Detail2;
}
}
break;
}
directProvider.Dispose();
ObjectSpace.Dispose();
return(Request.CreateResponse(HttpStatusCode.OK, animal));
}
else
{
UserError err2 = new UserError();
err2.code = "3"; // error จากสาเหตุอื่นๆ จะมีรายละเอียดจาก system แจ้งกลับ
err2.message = "ไม่พบข้อมูล";
return(Request.CreateResponse(HttpStatusCode.BadRequest, err2));
}
}
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 GetSendOrderSeed()
{
try
{
string org_oid = HttpContext.Current.Request.Form["Org_Oid"].ToString();
string type = HttpContext.Current.Request.Form["type"].ToString(); //รับ=1/ส่ง=2
if (org_oid != "" && type != "")
{
XpoTypesInfoHelper.GetXpoTypeInfoSource();
XafTypesInfo.Instance.RegisterEntity(typeof(SendOrderSeed));
List <SendOrderSeedType> SendItems = new List <SendOrderSeedType>();
List <ReceiveOrderSeedType> ReceiveItems = new List <ReceiveOrderSeedType>();
SendOrderSeedModel lists = new SendOrderSeedModel();
lists.org_oid = org_oid;
XPObjectSpaceProvider directProvider = new XPObjectSpaceProvider(scc, null);
IObjectSpace ObjectSpace = directProvider.CreateObjectSpace();
if (type == "2")
{ //หน่วยส่ง
IList <SendOrderSeed> collection = ObjectSpace.GetObjects <SendOrderSeed>(CriteriaOperator.Parse("GCRecord is null and SendStatus=1 and [SendOrgOid.Oid]='" + org_oid + "'", null));
var query = from Q in collection orderby Q.SendNo select Q;
if (collection.Count > 0)
{
foreach (SendOrderSeed row in query)
{
SendOrderSeedType item = new SendOrderSeedType();
item.SendNo = row.SendNo;
item.SendDate = row.SendDate.ToString("dd/MM/yyyy");
item.SendOrgOid = row.SendOrgOid.Oid.ToString();
item.SendOrgName = row.SendOrgOid.SubOrganizeName;
item.SendOrgFullName = row.SendOrgOid.OrganizeNameTH;
item.Remark = row.Remark;
item.SendStatus = row.SendStatus.ToString();
item.FinanceYear = row.FinanceYearOid.YearName;
item.CancelMsg = row.CancelMsg;
item.ReceiveOrgOid = row.ReceiveOrgOid.Oid.ToString();
item.ReceiveOrgName = row.ReceiveOrgOid.SubOrganizeName;
item.ReceiveOrgFullName = row.ReceiveOrgOid.OrganizeNameTH;
item.RefNo = row.SendNo + "|" + row.SendOrgOid.Oid.ToString() + "|2";
item.TotalWeight = row.SendOrderSeedDetails.Sum((c => c.Weight)).ToString() + " กิโลกรัม";
SendItems.Add(item);
}
}
//lists.Sender = null; //SendItems;
return(Request.CreateResponse(HttpStatusCode.OK, SendItems));
}
else if (type == "1")
{ //รับ
IList <SendOrderSeed> collection2 = ObjectSpace.GetObjects <SendOrderSeed>(CriteriaOperator.Parse("GCRecord is null and SendStatus = 2 and ReceiveStatus=1 and ReceiveOrgOid.Oid='" + org_oid + "'", null));
var query = from Q in collection2 orderby Q.SendNo select Q;
if (collection2.Count > 0)
{
foreach (SendOrderSeed row in query)
{
ReceiveOrderSeedType item = new ReceiveOrderSeedType();
item.SendNo = row.SendNo;
item.SendDate = row.SendDate.ToString("dd/MM/yyyy");
item.SendOrgOid = row.SendOrgOid.Oid.ToString();
item.SendOrgName = row.SendOrgOid.SubOrganizeName;
item.SendOrgFullName = row.SendOrgOid.OrganizeNameTH;
item.Remark = row.Remark;
item.ReceiveOrderStatus = row.ReceiveStatus.ToString();
item.FinanceYear = row.FinanceYearOid.YearName;
item.CancelMsg = row.CancelMsg;
item.ReceiveOrgOid = row.ReceiveOrgOid.Oid.ToString();
item.ReceiveOrgName = row.ReceiveOrgOid.SubOrganizeName;
item.ReceiveOrgFullName = row.ReceiveOrgOid.OrganizeNameTH;
item.RefNo = row.SendNo + "|" + row.ReceiveOrgOid.Oid.ToString() + "|1";
item.TotalWeight = row.SendOrderSeedDetails.Sum((c => c.Weight)).ToString() + " กิโลกรัม";
ReceiveItems.Add(item);
}
directProvider.Dispose();
ObjectSpace.Dispose();
//lists.Receive = ReceiveItems;
return(Request.CreateResponse(HttpStatusCode.OK, ReceiveItems));
}
}
//invalid
UserError err = new UserError();
err.status = "false";
err.code = "0";
err.message = "กรุณาใส่ข้อมูล Org_Oid และ type ให้เรียบร้อยก่อน";
return(Request.CreateResponse(HttpStatusCode.BadRequest, err));
}
else
{
UserError err = new UserError();
err.status = "false";
err.code = "0";
err.message = "กรุณาใส่ข้อมูล Org_Oid ให้เรียบร้อยก่อน";
return(Request.CreateResponse(HttpStatusCode.BadRequest, err));
}
}
catch (Exception ex)
{
UserError err = new UserError();
err.status = "false";
err.code = "6"; // error จากสาเหตุอื่นๆ จะมีรายละเอียดจาก system แจ้งกลับ
err.message = "ไม่พบข้อมูล";
return(Request.CreateResponse(HttpStatusCode.BadRequest, err));
}
finally
{
SqlConnection.ClearAllPools();
}
}
