public HttpResponseMessage UpdateSprout() { // object objStockAnimalInfo = null; HistoryWork ObjHistory = null; IList <StockSeedInfo> objStockSeedInfo = null; object objDetailService = null; string Username = "******"; try { string RefNo = HttpContext.Current.Request.Form["RefNo"].ToString(); //ข้อมูลเลขที่อ้างอิง // string Status = HttpContext.Current.Request.Form["Status"].ToString(); //สถานะ string CancelMsg = HttpContext.Current.Request.Form["Remark"].ToString(); //หมายเหตุ Username = HttpContext.Current.Request.Form["Username"].ToString(); if (RefNo != "") { XpoTypesInfoHelper.GetXpoTypeInfoSource(); XafTypesInfo.Instance.RegisterEntity(typeof(nutrition.Module.SupplierSproutUseProduct)); XafTypesInfo.Instance.RegisterEntity(typeof(nutrition.Module.StockSproutInfo)); XafTypesInfo.Instance.RegisterEntity(typeof(nutrition.Module.StockSproutInfo_Report)); XafTypesInfo.Instance.RegisterEntity(typeof(nutrition.Module.HistoryWork)); XafTypesInfo.Instance.RegisterEntity(typeof(nutrition.Module.SupplierProductModifyDetail)); XafTypesInfo.Instance.RegisterEntity(typeof(nutrition.Module.SupplierProductModify)); XafTypesInfo.Instance.RegisterEntity(typeof(UserInfo)); XafTypesInfo.Instance.RegisterEntity(typeof(ReceiveLotNumber)); XafTypesInfo.Instance.RegisterEntity(typeof(ReceiveLotNumber)); XafTypesInfo.Instance.RegisterEntity(typeof(RegisterCusServiceDetail)); XafTypesInfo.Instance.RegisterEntity(typeof(OrgeServiceDetail)); XafTypesInfo.Instance.RegisterEntity(typeof(ServiceType)); List <SupplierSproutUseProduct> list = new List <SupplierSproutUseProduct>(); XPObjectSpaceProvider directProvider = new XPObjectSpaceProvider(scc, null); IObjectSpace ObjectSpace = directProvider.CreateObjectSpace(); UserInfo objUserInfo = ObjectSpace.FindObject <UserInfo>(CriteriaOperator.Parse("[UserName]=?", Username)); SupplierSproutUseProduct ObjMaster = ObjectSpace.FindObject <SupplierSproutUseProduct>(CriteriaOperator.Parse("UseNo=?", RefNo)); foreach (SupplierSproutUseProductDetail row in ObjMaster.SupplierSproutUseProductDetails) { string TempDescription = ""; if (ObjMaster.Status == EnumRodBreedProductSeedStatus.Accepet) { // 'Update สถานะ IsApprove ให้เป็น True var objStockGetBudgetSource = ObjectSpace.FindObject <StockSproutInfo>(CriteriaOperator.Parse("[FinanceYearOid]=? and [AnimalSeedOid]=? and [OrganizationOid]=? and [SeedTypeOid]=?", row.SupplierSproutUseProduct.FinanceYearOid, row.AnimalSeedOid, row.SupplierSproutUseProduct.OrganizationOid, row.SeedTypeOid)); if (objStockGetBudgetSource != null) { var objStockSproutInfoEdit = ObjectSpace.FindObject <StockSproutInfo>(CriteriaOperator.Parse("[SupplierSproutNumber]=? and [FinanceYearOid]=? and [BudgetSourceOid]=? and [OrganizationOid]=? and [AnimalSeedOid]=? and [SeedTypeOid]=?", row.SupplierSproutUseProduct.UseNo, row.SupplierSproutUseProduct.FinanceYearOid, objStockGetBudgetSource.BudgetSourceOid, row.SupplierSproutUseProduct.OrganizationOid, row.AnimalSeedOid, row.SeedTypeOid)); if (objStockSproutInfoEdit != null) { objStockSproutInfoEdit.IsApprove = true; } } // 'Stock สำหรับ กปศ4ว // 'Update สถานะ IsApprove ให้เป็น True var objStockGetBudgetSourceReport = ObjectSpace.FindObject <StockSproutInfo_Report>(CriteriaOperator.Parse("[FinanceYearOid]=? and [AnimalSeedOid]=? and [OrganizationOid]=? and [SeedTypeOid]=?", row.SupplierSproutUseProduct.FinanceYearOid, row.AnimalSeedOid, row.SupplierSproutUseProduct.OrganizationOid, row.SeedTypeOid)); var objStockRodBreedInfoReportEdit = ObjectSpace.FindObject <StockSproutInfo_Report>(CriteriaOperator.Parse("[SproutProductNumber]=? and [FinanceYearOid]=? and [BudgetSourceOid]=? and [OrganizationOid]=? and [AnimalSeedOid]=? and [SeedTypeOid]=?", row.SupplierSproutUseProduct.UseNo, row.SupplierSproutUseProduct.FinanceYearOid, objStockGetBudgetSource.BudgetSourceOid, row.SupplierSproutUseProduct.OrganizationOid, row.AnimalSeedOid, row.SeedTypeOid)); var objStockSproutInfo_DetailNew = ObjectSpace.CreateObject <StockSproutInfo_Report>(); // ========================================== if (objStockRodBreedInfoReportEdit != null) { objStockRodBreedInfoReportEdit.IsApprove = true; } } } if (ObjMaster.ActivityOid.ActivityName.Contains("จำหน่าย") == true) { if (ObjMaster.ChkOneService == true) { objDetailService = ObjectSpace.FindObject <RegisterCusServiceDetail>(CriteriaOperator.Parse("[RegisterCusServiceOid]=? and [ServiceTypeOid.ServiceTypeName] like '%จำหน่าย%' and [SubServiceTypeOid.ServiceTypeName]='กล้าพันธุ์' and [ReceiveDate]=?", ObjMaster.RegisCusServiceOid, ObjMaster.UseDate)); if (objDetailService == null) { RegisterCusServiceDetail objDetailService_new = ObjectSpace.CreateObject <RegisterCusServiceDetail>(); objDetailService_new.RegisterCusServiceOid = ObjMaster.RegisCusServiceOid; ServiceType objServiceType = ObjectSpace.FindObject <ServiceType>(CriteriaOperator.Parse("[ServiceTypeName] like '%จำหน่าย%'")); objDetailService_new.ServiceTypeOid = objServiceType; ServiceType objSubServiceType = ObjectSpace.FindObject <ServiceType>(CriteriaOperator.Parse("[MasterServiceType]=? and [ServiceTypeName]='กล้าพันธุ์'", objServiceType.Oid)); objDetailService_new.SubServiceTypeOid = objSubServiceType; objDetailService_new.ReceiveDate = ObjMaster.UseDate; objDetailService_new.RefOid = ObjMaster.Oid.ToString(); } } else if (ObjMaster.ChkGroupService == true) { objDetailService = ObjectSpace.FindObject <OrgeServiceDetail>(CriteriaOperator.Parse("[OrgeServiceOid]=? and [ServiceTypeOid.ServiceTypeName] like '%จำหน่าย%' and [SubServiceTypeOid.ServiceTypeName]='กล้าพันธุ์' and [ReceiveDate]=?", ObjMaster.OrgeServiceOid, ObjMaster.UseDate)); if (objDetailService == null) //'ถ้ายังไม่มีข้อมูลการขอรับบบริการให้ Insert ลงในส่วนของรายละเอียดการขอรับบริการด้วย { OrgeServiceDetail objDetailService_new = ObjectSpace.CreateObject <OrgeServiceDetail>(); objDetailService_new.OrgeServiceOid = ObjMaster.OrgeServiceOid; ServiceType objServiceType = ObjectSpace.FindObject <ServiceType>(CriteriaOperator.Parse("[ServiceTypeName] like '%จำหน่าย%'")); objDetailService_new.ServiceTypeOid = objServiceType; ServiceType objSubServiceType = ObjectSpace.FindObject <ServiceType>(CriteriaOperator.Parse("[MasterServiceType]=? and [ServiceTypeName]='กล้าพันธุ์'", objServiceType.Oid)); objDetailService_new.SubServiceTypeOid = objSubServiceType; objDetailService_new.ReceiveDate = ObjMaster.UseDate; objDetailService_new.RefOid = ObjMaster.Oid.ToString(); } } } else if (ObjMaster.ActivityOid.ActivityName.Contains("แจกจ่าย") == true) { if (ObjMaster.ChkOneService == true) //'รายเดี่ยว { objDetailService = ObjectSpace.FindObject <RegisterCusServiceDetail>(CriteriaOperator.Parse("[RegisterCusServiceOid]=? and [ServiceTypeOid.ServiceTypeName] like '%แจกจ่าย%' and [SubServiceTypeOid.ServiceTypeName]='กล้าพันธุ์' and [ReceiveDate]=?", ObjMaster.RegisCusServiceOid, ObjMaster.UseDate)); if (objDetailService == null)// 'ถ้ายังไม่มีข้อมูลการขอรับบบริการให้ Insert ลงในส่วนของรายละเอียดการขอรับบริการด้วย { RegisterCusServiceDetail objDetailService_new = ObjectSpace.CreateObject <RegisterCusServiceDetail>(); objDetailService_new.RegisterCusServiceOid = ObjMaster.RegisCusServiceOid; ServiceType objServiceType = ObjectSpace.FindObject <ServiceType>(CriteriaOperator.Parse("[ServiceTypeName] like '%แจกจ่าย%'")); objDetailService_new.ServiceTypeOid = objServiceType; ServiceType objSubServiceType = ObjectSpace.FindObject <ServiceType>(CriteriaOperator.Parse("[MasterServiceType]=? and [ServiceTypeName]='กล้าพันธุ์'", objServiceType.Oid)); objDetailService_new.SubServiceTypeOid = objSubServiceType; objDetailService_new.ReceiveDate = ObjMaster.UseDate; objDetailService_new.RefOid = ObjMaster.Oid.ToString(); } } else if (ObjMaster.ChkGroupService == true) { objDetailService = ObjectSpace.FindObject <OrgeServiceDetail>(CriteriaOperator.Parse("[OrgeServiceOid]=? and [ServiceTypeOid.ServiceTypeName] like '%แจกจ่าย%' and [SubServiceTypeOid.ServiceTypeName]='กล้าพันธุ์' and [ReceiveDate]=?", ObjMaster.OrgeServiceOid, ObjMaster.UseDate)); if (objDetailService == null) //'ถ้ายังไม่มีข้อมูลการขอรับบบริการให้ Insert ลงในส่วนของรายละเอียดการขอรับบริการด้วย { OrgeServiceDetail objDetailService_new = ObjectSpace.CreateObject <OrgeServiceDetail>(); objDetailService_new.OrgeServiceOid = ObjMaster.OrgeServiceOid; ServiceType objServiceType = ObjectSpace.FindObject <ServiceType>(CriteriaOperator.Parse("[ServiceTypeName] like '%แจกจ่าย%'")); objDetailService_new.ServiceTypeOid = objServiceType; ServiceType objSubServiceType = ObjectSpace.FindObject <ServiceType>(CriteriaOperator.Parse("[MasterServiceType]=? and [ServiceTypeName]='กล้าพันธุ์'", objServiceType.Oid)); objDetailService_new.SubServiceTypeOid = objSubServiceType; objDetailService_new.ReceiveDate = ObjMaster.UseDate; objDetailService_new.RefOid = ObjMaster.Oid.ToString(); } } } ObjMaster.Status = EnumRodBreedProductSeedStatus.Approve; ObjMaster.ApproveDate = DateTime.Now; ObjHistory = ObjectSpace.CreateObject <HistoryWork>(); // ประวัติ ObjHistory.RefOid = ObjMaster.Oid.ToString(); ObjHistory.FormName = "กล้าพันธุ์"; ObjHistory.Message = "อนุมัติ (ขอใช้กล้าพันธุ์ (Mobile Application) ) ลำดับที่ : " + ObjMaster.UseNo; ObjHistory.CreateBy = objUserInfo.UserName; ObjHistory.CreateDate = DateTime.Now; ObjectSpace.CommitChanges(); UpdateResult ret = new UpdateResult(); ret.status = "true"; ret.message = "บันทึกข้อมูลอนุมัติเรียบร้อยแล้ว"; return(Request.CreateResponse(HttpStatusCode.OK, ret)); } else { UpdateResult ret = new UpdateResult(); ret.status = "False"; ret.message = "กรุณากรอก RefNo"; return(Request.CreateResponse(HttpStatusCode.NoContent, ret)); } } catch (Exception ex) { UserError err = new UserError(); err.code = "6"; // error จากสาเหตุอื่นๆ จะมีรายละเอียดจาก system แจ้งกลับ err.message = ex.Message; return(Request.CreateResponse(HttpStatusCode.BadRequest, err)); } }
public HttpResponseMessage UpdateSproutUseEject() { // object objStockAnimalInfo = null; HistoryWork ObjHistory = null; IList <StockSeedInfo> objStockSeedInfo = null; string Username = "******"; try { //string RefNo = HttpContext.Current.Request.Form["RefNo"].ToString(); //ข้อมูลเลขที่อ้างอิง //string Status = HttpContext.Current.Request.Form["Status"].ToString(); //สถานะ //string CancelMsg = HttpContext.Current.Request.Form["Remark"].ToString(); //หมายเหตุ //Username = HttpContext.Current.Request.Form["Username"].ToString(); string RefNo = HttpContext.Current.Request.Form["RefNo"].ToString(); //ข้อมูลเลขที่อ้างอิง // string Status = HttpContext.Current.Request.Form["Status"].ToString(); //สถานะ string CancelMsg = HttpContext.Current.Request.Form["Remark"].ToString(); //หมายเหตุ Username = HttpContext.Current.Request.Form["Username"].ToString(); if (RefNo != "") { XpoTypesInfoHelper.GetXpoTypeInfoSource(); XafTypesInfo.Instance.RegisterEntity(typeof(nutrition.Module.SupplierSproutUseProduct)); XafTypesInfo.Instance.RegisterEntity(typeof(nutrition.Module.StockSproutInfo)); XafTypesInfo.Instance.RegisterEntity(typeof(nutrition.Module.StockSproutInfo_Report)); XafTypesInfo.Instance.RegisterEntity(typeof(nutrition.Module.HistoryWork)); XafTypesInfo.Instance.RegisterEntity(typeof(nutrition.Module.SupplierProductModifyDetail)); XafTypesInfo.Instance.RegisterEntity(typeof(nutrition.Module.SupplierProductModify)); XafTypesInfo.Instance.RegisterEntity(typeof(UserInfo)); XafTypesInfo.Instance.RegisterEntity(typeof(ReceiveLotNumber)); XafTypesInfo.Instance.RegisterEntity(typeof(RegisterCusServiceDetail)); XafTypesInfo.Instance.RegisterEntity(typeof(OrgeServiceDetail)); XafTypesInfo.Instance.RegisterEntity(typeof(ServiceType)); List <SupplierSproutUseProduct> list = new List <SupplierSproutUseProduct>(); XPObjectSpaceProvider directProvider = new XPObjectSpaceProvider(scc, null); IObjectSpace ObjectSpace = directProvider.CreateObjectSpace(); UserInfo objUserInfo = ObjectSpace.FindObject <UserInfo>(CriteriaOperator.Parse("[UserName]=?", Username)); SupplierSproutUseProduct ObjMaster = ObjectSpace.FindObject <SupplierSproutUseProduct>(CriteriaOperator.Parse("UseNo=?", RefNo)); if (ObjMaster.SupplierSproutUseProductDetails != null) { foreach (SupplierSproutUseProductDetail row in ObjMaster.SupplierSproutUseProductDetails) { if (ObjMaster.Status == EnumRodBreedProductSeedStatus.Accepet || ObjMaster.Status == EnumRodBreedProductSeedStatus.Approve) { var objCheckStockSproutInfo = ObjectSpace.GetObjects <StockSproutInfo>(CriteriaOperator.Parse("SupplierSproutNumber=? and FinanceYearOid=? and AnimalSeedOid=? and OrganizationOid=? and SeedTypeOid=?", row.SupplierSproutUseProduct.UseNo, row.SupplierSproutUseProduct.FinanceYearOid, row.AnimalSeedOid, row.SupplierSproutUseProduct.OrganizationOid, row.SeedTypeOid)); if (objCheckStockSproutInfo.Count > 0) { objCheckStockSproutInfo = ObjectSpace.GetObjects <StockSproutInfo>(CriteriaOperator.Parse("FinanceYearOid=? and AnimalSeedOid=? and OrganizationOid=? and SeedTypeOid=?", row.SupplierSproutUseProduct.FinanceYearOid.Oid, row.AnimalSeedOid.Oid, row.SupplierSproutUseProduct.OrganizationOid.Oid, row.SeedTypeOid)); // 'Update สถานะ IsApprove ให้เป็น True var objStockSproutInfoEdit = ObjectSpace.FindObject <StockSproutInfo>(CriteriaOperator.Parse("[SupplierSproutNumber]=? and [FinanceYearOid]=? and [BudgetSourceOid]=? and [OrganizationOid]=? and [AnimalSeedOid]=? and [SeedTypeOid]=?", row.SupplierSproutUseProduct.UseNo, row.SupplierSproutUseProduct.FinanceYearOid, objCheckStockSproutInfo[0].BudgetSourceOid, row.SupplierSproutUseProduct.OrganizationOid, row.AnimalSeedOid, row.SeedTypeOid)); //-------------------------------------------------------- IList <StockSproutInfo> collection = ObjectSpace.GetObjects <StockSproutInfo>(CriteriaOperator.Parse("GCRecord is null and [SupplierSproutNumber] = ?", row.SupplierSproutUseProduct.UseNo)); if (objStockSproutInfoEdit != null) { objStockSproutInfoEdit.IsApprove = true; } //var q = (from Item in collection // orderby Item.SupplierSproutNumber descending // select Item).First(); //SqlParameter[] prm = new SqlParameter[10]; //prm[0] = new SqlParameter("@SupplierSproutNumber", row.SupplierSproutUseProduct.UseNo.ToString()); //prm[1] = new SqlParameter("@FinanceYearOid", row.SupplierSproutUseProduct.FinanceYearOid.Oid); //prm[2] = new SqlParameter("@BudgetSourceOid", objCheckStockSproutInfo.First().BudgetSourceOid.Oid); //prm[3] = new SqlParameter("@AnimalSeedOid", row.AnimalSeedOid.Oid); //prm[4] = new SqlParameter("@OrganizationOid", row.SupplierSproutUseProduct.OrganizationOid.Oid); //prm[5] = new SqlParameter("@Weight", row.Weight); //prm[6] = new SqlParameter("@Remark", "คืนสต๊อกเนื่องจากไม่อนุมัติการใช้กล้าพันธุ์ (Mobile Application)"); //prm[7] = new SqlParameter("@SeedTypeOid", row.SeedTypeOid.Oid); //prm[8] = new SqlParameter("@IsApprove", true); //prm[9] = new SqlParameter("@Description", null); //SqlHelper.ExecuteNonQuery(scc, CommandType.StoredProcedure, "SP_inserts_StockSproutInfo", prm); var objStockSproutInfo = ObjectSpace.CreateObject <StockSproutInfo>(); objStockSproutInfo.TransactionDate = DateTime.Now; objStockSproutInfo.SupplierSproutNumber = row.SupplierSproutUseProduct.UseNo; objStockSproutInfo.FinanceYearOid = row.SupplierSproutUseProduct.FinanceYearOid; objStockSproutInfo.BudgetSourceOid = objCheckStockSproutInfo.First().BudgetSourceOid; objStockSproutInfo.AnimalSeedOid = row.AnimalSeedOid; objStockSproutInfo.OrganizationOid = row.SupplierSproutUseProduct.OrganizationOid; objStockSproutInfo.Weight = row.Weight; objStockSproutInfo.Remark = "คืนสต๊อกเนื่องจากไม่อนุมัติการใช้กล้าพันธุ์ (Mobile Application)"; objStockSproutInfo.SeedTypeOid = row.SeedTypeOid; objStockSproutInfo.Description = "คืนสต๊อกเนื่องจากไม่อนุมัติการใช้กล้าพันธุ์ : " + ObjMaster.OrganizationOid.SubOrganizeName + " (Mobile Application)"; objStockSproutInfo.IsApprove = true; // ''Stock สำหรับ กปศ4ว //'======================================================================= //if (ObjMaster.Status == EnumRodBreedProductSeedStatus.Accepet || ObjMaster.Status == EnumRodBreedProductSeedStatus.Approve) //{ var objStockSproutInfo_Detail = ObjectSpace.GetObjects <StockSproutInfo_Report>(CriteriaOperator.Parse("[FinanceYearOid]=? and [OrganizationOid]=? and [AnimalSeedOid]=? and [SeedTypeOid]=?", ObjMaster.FinanceYearOid, ObjMaster.OrganizationOid, row.AnimalSeedOid, row.SeedTypeOid)); if (objStockSproutInfo_Detail.Count > 0) { var ObjStockSproutInfo_DetailSource = (from Item in objStockSproutInfo_Detail orderby Item.TransactionDate descending select Item).First(); var objStockRodBreedInfoReportEdit = ObjectSpace.FindObject <StockSproutInfo_Report>(CriteriaOperator.Parse("[SproutProductNumber]=? and [FinanceYearOid]=? and [BudgetSourceOid]=? and [OrganizationOid]=? and [AnimalSeedOid]=? and [SeedTypeOid]=?", row.SupplierSproutUseProduct.UseNo, row.SupplierSproutUseProduct.FinanceYearOid, ObjStockSproutInfo_DetailSource.BudgetSourceOid, row.SupplierSproutUseProduct.OrganizationOid, row.AnimalSeedOid, row.SeedTypeOid)); if (objStockRodBreedInfoReportEdit != null) { objStockRodBreedInfoReportEdit.IsApprove = true; } var objStockSproutInfo_DetailNew = ObjectSpace.CreateObject <StockSproutInfo_Report>(); objStockSproutInfo_DetailNew.TransactionDate = DateTime.Now; objStockSproutInfo_DetailNew.SproutProductNumber = ObjMaster.UseNo; objStockSproutInfo_DetailNew.FinanceYearOid = ObjMaster.FinanceYearOid; objStockSproutInfo_DetailNew.BudgetSourceOid = ObjStockSproutInfo_DetailSource.BudgetSourceOid; objStockSproutInfo_DetailNew.OrganizationOid = ObjMaster.OrganizationOid; objStockSproutInfo_DetailNew.AnimalSeedOid = row.AnimalSeedOid; objStockSproutInfo_DetailNew.TotalForward = ObjStockSproutInfo_DetailSource.TotalWeight; objStockSproutInfo_DetailNew.TotalChange = row.Weight; objStockSproutInfo_DetailNew.SeedTypeOid = row.SeedTypeOid; objStockSproutInfo_DetailNew.Description = "คืนสต๊อกเนื่องจากไม่อนุมัติการใช้กล้าพันธุ์ : " + ObjMaster.OrganizationOid.SubOrganizeName + " (Mobile Application)"; objStockSproutInfo_DetailNew.IsApprove = true; } } } // } } SupplierSproutUseProduct TmpObjMaster; ObjMaster.CancelMsg = CancelMsg; ObjMaster.Status = EnumRodBreedProductSeedStatus.Eject; ObjMaster.CancelBy = objUserInfo.UserName; ObjMaster.ActionType = EnumAction.Eject; ObjMaster.CancelDate = DateTime.Now; ObjHistory = ObjectSpace.CreateObject <HistoryWork>(); // ประวัติ ObjHistory.RefOid = ObjMaster.Oid.ToString(); ObjHistory.FormName = "กล้าพันธุ์"; ObjHistory.Message = "ไม่อนุมัติ (ขอใช้กล้าพันธุ์ (Mobile Application)) ลำดับที่ : " + ObjMaster.UseNo; ObjHistory.CreateBy = objUserInfo.UserName; ObjHistory.CreateDate = DateTime.Now; ObjectSpace.CommitChanges(); UpdateResult ret = new UpdateResult(); ret.status = "true"; ret.message = "บันทึกข้อมูลไม่อนุมัติเรียบร้อยแล้ว"; // ret.message = "บันทึกข้อมูลไม่อนุมัติเรียบร้อยแล้ว"+ "(Mobile Application)"; return(Request.CreateResponse(HttpStatusCode.OK, ret)); } else { UpdateResult ret = new UpdateResult(); ret.status = "-99"; ret.message = "ไม่สามารถบันทึกข้อมูลได้ ไม่มีข้อมูลกล้าพันธุ์"; // ret.message = "บันทึกข้อมูลไม่อนุมัติเรียบร้อยแล้ว"+ "(Mobile Application)"; return(Request.CreateResponse(HttpStatusCode.NotFound, ret)); } } else { UpdateResult ret = new UpdateResult(); ret.status = "False"; ret.message = "กรุณากรอก RefNo"; return(Request.CreateResponse(HttpStatusCode.NotFound, ret)); } } catch (Exception ex) { UserError err = new UserError(); err.code = "6"; // error จากสาเหตุอื่นๆ จะมีรายละเอียดจาก system แจ้งกลับ err.message = ex.Message; return(Request.CreateResponse(HttpStatusCode.BadRequest, err)); } finally { SqlConnection.ClearAllPools(); } }