public async void getAvailableProviders()
{
var content = await CommonFunction.GetWebService(Ultis.Settings.SessionBaseURI, ControllerUtil.getAvailableProvider());
clsResponse available_response = JsonConvert.DeserializeObject <clsResponse>(content);
if (available_response.IsGood)
{
for (int check = 0; check < available_response.Result.Count; check++)
{
clsProvider provider = new clsProvider();
provider.Code = available_response.Result[check]["Code"];
provider.Name = available_response.Result[check]["Name"];
provider.Url = available_response.Result[check]["Url"];
providers.Add(provider);
}
BindingContext = new ProviderListViewModel(providers);
}
else
{
await DisplayAlert("JsonError", available_response.Message, "OK");
}
}
public async Task <clsResponse <EstudioSocioeconomicoDTO> > getAllEstudioSocioeconomico(int pagina, int rowsPerPAge)
{
var query = context.EstudioSocioeconomico.AsQueryable();
var totalRegisters = query.Count();
var estudiosSocioeconomicos = await query
.Skip(rowsPerPAge *(pagina - 1))
.Take(rowsPerPAge)
.OrderBy(x => x.Id)
.ToListAsync();
if (estudiosSocioeconomicos == null)
{
return(null);
}
var estudiosSocioeconomicosDTO = mapper.Map <List <EstudioSocioeconomicoDTO> >(estudiosSocioeconomicos);
var respuesta = new clsResponse <EstudioSocioeconomicoDTO>()
{
Error = false,
RegistrosFundabiem = estudiosSocioeconomicosDTO,
pages = ((int)Math.Ceiling((double)totalRegisters / rowsPerPAge)),
totalRows = totalRegisters
};
return(respuesta);
}
public string createDisk(string pstringRequest, int pintBandId)
{
clsRequest request = JsonConvert.DeserializeObject <clsRequest>(pstringRequest);
clsDisk Disk = DeserializeJson.DeserializeDisk(request.Data.ToString());
Disk.Id = request.Id;
clsResponse response = new clsResponse();
if (Disk.Id == pintBandId)
{
Disk.Id = FacadeDA.createdisk(ref Disk, ref response, pintBandId);
//save image here!
ArchiveManager.saveDiskImage(Disk.Id, Disk.Picture, ref response);
}
else
{
//error info
response.Success = false;
response.Message = "Invalid Operation";
response.Code = 401;
}
Disk.Picture = null;
Disk.Songs = null;
Disk.Label = null;
Disk.DateCreation = null;
Disk.Name = null;
Disk.CodGenre = -1;
response.Data = serializer.Serialize(Disk);
return(serializer.Serialize(response));
}
public string login(string pstringRequest)
{
clsRequest request = JsonConvert.DeserializeObject <clsRequest>(pstringRequest);
clsInfoUser InfoUser = DeserializeJson.DeserializeInfoUser(request.Data);
clsResponse response = new clsResponse();
FacadeDA.validateUser(InfoUser, ref response);
if (response.Success) //existing username
{
InfoUser = FacadeDA.getSaltPass(InfoUser, ref response); //get salt and password from DA
string HashedPassword = clsHasher.hashPassword(InfoUser.Password, InfoUser.Salt); // hash the incoming password with salt from DA
if (!(clsHasher.compare(HashedPassword, InfoUser.SaltHashed))) //compare hashed passwords
{
//not match
//error info
response.Success = false;
response.Message = "Incorrect Username or Password";
response.Code = 3;
}
InfoUser.Password = null;
InfoUser.Salt = null; // clear the object before sending
InfoUser.SaltHashed = null; // clear the object before sending
}
response.Data = serializer.Serialize(InfoUser);
return(serializer.Serialize(response));
}
public void changeStateEvent(String State, ref clsResponse pclsResponse, int pintEventCode)
{
try
{
SqlCommand cmd = new SqlCommand("myFan.SP_ChangeStateEvento", conn);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.Add("@strState", System.Data.SqlDbType.VarChar).Value = State;
cmd.Parameters.Add("@intCodEvent", System.Data.SqlDbType.Int).Value = pintEventCode;
SqlParameter message = cmd.Parameters.Add("@strMessageError", SqlDbType.VarChar, 256);
message.Direction = ParameterDirection.Output;
SqlParameter cod = cmd.Parameters.Add("@strCodError", SqlDbType.VarChar, 4);
cod.Direction = ParameterDirection.Output;
conn.Open();
cmd.ExecuteNonQuery();
pclsResponse.Code = 0;
pclsResponse.Message = "Done";
pclsResponse.Success = true;
}
catch (SqlException ex)
{
pclsResponse.Code = 1;
pclsResponse.Success = false;
pclsResponse.Message = ex.Message;
}
catch (Exception ex)
{
pclsResponse.Code = 2;
pclsResponse.Success = false;
pclsResponse.Message = ex.Message;
}
finally
{
conn.Close();
}
}
public static clsDisk parseDisk(string json)
{
clsResponse Response = parseResponse(json);
clsDisk disk = JsonConvert.DeserializeObject <clsDisk>(Convert.ToString(Response.Data));
return(disk);
}
public async void UpdateLocation(object sender, EventArgs e)
{
if (!(String.IsNullOrEmpty(locationName.Text)))
{
try
{
activityIndicator.IsRunning = true;
var content = await CommonFunction.CallWebService(0, null, Ultis.Settings.SessionBaseURI, ControllerUtil.getLocationURL(locationName.Text), this);
clsResponse json_response = JsonConvert.DeserializeObject <clsResponse>(content);
if (json_response.IsGood)
{
await DisplayAlert("Success", "Message sent successfully.", "OK");
}
activityIndicator.IsRunning = false;
}
catch (Exception exception)
{
await DisplayAlert("Error", exception.Message, "OK");
}
}
else
{
await DisplayAlert("Error", "Please key in location name", "OK");
}
}
public async void updateRFC(object sender, EventArgs e)
{
DateTime compareTime = DateTime.Now.AddHours(Convert.ToInt32(rfcHours));
string currentTime = datePicker.Date.ToString("yyyy-MM-dd") + " " + timePicker.SelectedItem;
if (Convert.ToDateTime(currentTime) > compareTime)
{
if (String.IsNullOrEmpty(remarks.Text))
{
remarks.Text = "";
}
var content = await CommonFunction.CallWebService(0, null, Ultis.Settings.SessionBaseURI, ControllerUtil.updateContainerRFCURL(provider_code, process_id, currentTime, remarks.Text), this);
clsResponse rfc_response = JsonConvert.DeserializeObject <clsResponse>(content);
if (rfc_response.IsGood)
{
await PopupNavigation.Instance.PopAsync(true);
MessagingCenter.Send <App>((App)Application.Current, "OnCategoryCreated");
}
else
{
await DisplayAlert("JsonError", rfc_response.Message, "OK");
}
}
else
{
await DisplayAlert("Error", "Required Date & Time must be later than " + compareTime.ToString("yyyy-MM-dd hh:mm"), "OK");
}
}
async void Url_Clicked(object sender, EventArgs e)
{
submitButton.IsEnabled = false;
this.activityIndicator.IsRunning = true;
try
{
var content = await CommonFunction.CallWebService(0, null, "https://api.asolute.com/", ControllerUtil.getBaseURL(nameEntry.Text), this);
clsResponse json_response = JsonConvert.DeserializeObject <clsResponse>(content);
if (json_response.IsGood)
{
string returnUri = json_response.Result;
if (!(returnUri.Contains("Unknown")))
{
Ultis.Settings.EnterpriseName = nameEntry.Text.ToUpper();
Ultis.Settings.SessionBaseURI = json_response.Result + "api/";
await DisplayAlert("Success", "Enterprise name updated.", "Ok");
await Navigation.PopAsync();
}
else
{
await DisplayAlert("Error", "Enterprise name unknown", "OK");
}
}
}
catch
{
}
this.activityIndicator.IsRunning = false;
submitButton.IsEnabled = true;
}
public void stopfollowBand(int pintCodFanatico, int pintCodBanda, ref clsResponse pclsResponse)
{
try
{
SqlCommand cmd = new SqlCommand("myFan.SP_NoSeguirBanda", conn);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.Add("@intCodFanatico", System.Data.SqlDbType.Int).Value = pintCodFanatico;
cmd.Parameters.Add("@intCodBanda", System.Data.SqlDbType.Int).Value = pintCodBanda;
SqlParameter message = cmd.Parameters.Add("@strMessageError", SqlDbType.VarChar, 256);
message.Direction = ParameterDirection.Output;
SqlParameter cod = cmd.Parameters.Add("@strCodError", SqlDbType.VarChar, 4);
cod.Direction = ParameterDirection.Output;
conn.Open();
cmd.ExecuteNonQuery();
pclsResponse.Code = 0;
pclsResponse.Message = "Done";
pclsResponse.Success = true;
}
catch (SqlException ex)
{
pclsResponse.Code = 1;
pclsResponse.Success = false;
pclsResponse.Message = "Error while procesing your request.";
}
catch (Exception ex)
{
pclsResponse.Code = 2;
pclsResponse.Success = false;
pclsResponse.Message = "Unexpected error.";
}
finally
{
conn.Close();
}
}
public async Task getProviderList()
{
var content = await CommonFunction.CallWebService(0, null, Ultis.Settings.SessionBaseURI, ControllerUtil.getProviderListURL(), this);
clsResponse provider_response = JsonConvert.DeserializeObject <clsResponse>(content);
if (provider_response.IsGood)
{
var providers = JObject.Parse(content)["Result"].ToObject <List <clsProvider> >();
App.Database.deleteRecords("ProviderList");
App.Database.deleteRecordSummary("ProviderList");
foreach (clsProvider provider in providers)
{
ListItems menu = new ListItems();
menu.Id = provider.Code;
menu.Name = provider.Name;
menu.Category = "ProviderList";
App.Database.SaveMenuAsync(menu);
SummaryItems summaryItem = new SummaryItems();
summaryItem.Id = provider.Code;
summaryItem.Name = provider.Name;
summaryItem.Type = "ProviderList";
summaryItem.Caption = "";
summaryItem.Value = provider.Name;
summaryItem.Display = true;
App.Database.SaveSummarysAsync(summaryItem);
}
LoadProviderList();
}
}
public CustomerRegistration(string content)
{
InitializeComponent();
NavigationPage.SetHasNavigationBar(this, false);
if (!(String.IsNullOrEmpty(Ultis.Settings.Email)))
{
emailAddressEntry.Text = Ultis.Settings.Email;
}
if (content != "")
{
clsResponse verify_response = JsonConvert.DeserializeObject <clsResponse>(content);
if (verify_response.Result != null)
{
result = JObject.Parse(content)["Result"].ToObject <clsRegister>();
userNameEntry.Text = result.UserName;
phoneEntry.Text = result.MobileNo;
businessRegEntry.Text = result.RegNo;
companyEntry.Text = result.CompanyName;
}
}
}
public string updateFan(string pstringRequest, int pintFanId)
{
clsRequest request = JsonConvert.DeserializeObject <clsRequest>(pstringRequest);
clsInfoFan InfoFan = DeserializeJson.DeserializeFanForm(request.Data);
InfoFan.Id = request.Id;
clsResponse response = new clsResponse();
if (InfoFan.Id == pintFanId)
{
InfoFan = FacadeDA.updateFan(InfoFan, ref response);
if (InfoFan.Picture.CompareTo("") != 0) // change image
{
ArchiveManager.updateUserImage(InfoFan.Id, InfoFan.Picture, ref response);
}
}
else
{
//error info
response.Success = false;
response.Message = "Invalid Operation";
response.Code = 401;
}
//Data = null
return(serializer.Serialize(response));
}
public string UnfollowBand(int pintFanId, int pintBandId)
{
clsResponse response = new clsResponse();
FacadeDA.stopfollowBand(pintFanId, pintBandId, ref response);
return(serializer.Serialize(response));
}
private clsResponse _GetTableList(string pWhere)
{
clsResponse response = new clsResponse();
string SQL = "SELECT name FROM sys.objects";
SQL += " where type = 'U'";
if (pWhere.Length > 0)
{
SQL += " and name like " + "'" + pWhere + "'";
}
SQL += " order by name";
response = _Select(SQL);
if (response.xHasError)
{ }
else
{
DataTable dt = new DataTable();
dt.Columns.Add("テーブル名", typeof(string));
for (int i = 0; i < response.xGetDataTable(0).Rows.Count; i++)
{
DataRow row = dt.NewRow();
row["テーブル名"] = response.xGetDataTable(0).Rows[i]["name"].ToString();
dt.Rows.Add(row);
}
response = new clsResponse();
response.xAddDataTable(dt);
}
return response;
}
private clsResponse _ReaderOpen(string pSQL)
{
clsResponse response = new clsResponse();
try
{
////OleDbCommand command = new OleDbCommand(pSQL, this.myConnection_, this.myTransaction_);
NpgsqlCommand command = new NpgsqlCommand(pSQL, this.myConnection_, this.myTransaction_);
////myReader_ = (OleDbDataReader)command.ExecuteReader();
myReader_ = (NpgsqlDataReader)command.ExecuteReader();
}
catch (Exception ex)
{
string msg = "DataReaderのOpenに失敗しました。";
msg += "(" + myDBInfo_.xDBName + ")" + "(" + pSQL + ")" + Environment.NewLine;
msg += ex.Message + Environment.NewLine;
response.xSetError(msg);
msg += ex.StackTrace;
////////clsTextLogger.xWriteTextLog(
//////// MethodBase.GetCurrentMethod().DeclaringType.FullName + "." +
//////// MethodBase.GetCurrentMethod().Name, msg);
}
finally
{
myTable_ = null;
}
return response;
}
public static clsEvent parseEvent(string json)
{
clsResponse Response = parseResponse(json);
clsEvent Event = JsonConvert.DeserializeObject <clsEvent>(Convert.ToString(Response.Data));
return(Event);
}
async void GetYardValue()
{
try
{
var content = await CommonFunction.CallWebService(0, null, Ultis.Settings.SessionBaseURI, ControllerUtil.getBlockList(), this);
clsResponse response = JsonConvert.DeserializeObject <clsResponse>(content);
if (response.IsGood)
{
yardBlocks = JObject.Parse(content)["Result"].ToObject <List <clsYardBlock> >();
foreach (clsYardBlock yardBlock in yardBlocks)
{
blocks.Add(yardBlock.Id);
}
blockComboBox.ComboBoxSource = blocks;
if (!(String.IsNullOrEmpty(selectedItem.Action)))
{
blockComboBox.Text = selectedItem.Action;
LoadComboBoxValue();
}
}
}
catch (Exception ex)
{
await DisplayAlert("Error", ex.Message, "OK");
}
}
async void UploadImage()
{
try
{
recordImages = App.Database.GetRecordImagesAsync(offlineLogID, false);
foreach (AppImage recordImage in recordImages)
{
clsFileObject image = new clsFileObject();
byte[] originalPhotoImageBytes = File.ReadAllBytes(recordImage.photoFileLocation);
scaledImageByte = DependencyService.Get <IThumbnailHelper>().ResizeImage(originalPhotoImageBytes, 1024, 1024, 100);
image.Content = scaledImageByte;
image.FileName = recordImage.photoFileName;
var content = await CommonFunction.CallWebService(1, image, Ultis.Settings.SessionBaseURI, ControllerUtil.UploadImageURL(imageLinkID), this);
clsResponse response = JsonConvert.DeserializeObject <clsResponse>(content);
recordImage.Uploaded = true;
App.Database.SaveRecordImageAsync(recordImage);
}
}
catch
{
}
}
async void Handle_Clicked(object sender, System.EventArgs e)
{
var button = sender as SfButton;
switch (button.StyleId)
{
case "btnVerify":
var content = await CommonFunction.CallWebService(1, null, Ultis.Settings.SessionBaseURI, ControllerUtil.getPalletVerificationURL(record.Id, palletIdEntry.Text), this);
clsResponse response = JsonConvert.DeserializeObject <clsResponse>(content);
if (response.IsGood)
{
// see whether web service got return stuff
await DisplayAlert("Success", "Pallet verified", "OK");
palletIdEntry.Text = "";
palletDesc.Children.Clear();
}
break;
case "btnDropOff":
case "btnPickUp":
PalletUpdate();
break;
}
}
//AILS Yard container inquiry combo box data
async void GetComboBoxData(string getBlockIdUri)
{
try
{
var content = await CommonFunction.CallWebService(0, null, Ultis.Settings.SessionBaseURI, getBlockIdUri, this);
clsResponse response = JsonConvert.DeserializeObject <clsResponse>(content);
if (response.IsGood)
{
blocksID.Clear();
List <clsYardBlock> yardBlocks = JObject.Parse(content)["Result"].ToObject <List <clsYardBlock> >();
blocksID.Add("All");
foreach (clsYardBlock yardBlock in yardBlocks)
{
blocksID.Add(yardBlock.Id);
}
blockComboBox.ComboBoxSource = blocksID;
dateComboBox.ComboBoxSource = dateOption;
}
}
catch (Exception ex)
{
await DisplayAlert("Error", ex.Message, "OK");
}
}
public async void UploadImage(string uploadID)
{
int uploadedImage = 0;
List <AppImage> recordImages = App.Database.GetRecordImagesAsync(uploadID, false);
foreach (AppImage recordImage in recordImages)
{
clsFileObject image = new clsFileObject();
if (recordImage.type == "signature")
{
image.Content = recordImage.imageData;
}
else
{
byte[] originalPhotoImageBytes = File.ReadAllBytes(recordImage.photoFileLocation);
scaledImageByte = DependencyService.Get <IThumbnailHelper>().ResizeImage(originalPhotoImageBytes, 1024, 1024, 100);
image.Content = scaledImageByte;
}
image.FileName = recordImage.photoFileName;
var content = await CommonFunction.CallWebService(1, image, Ultis.Settings.SessionBaseURI, ControllerUtil.UploadImageURL(eventRecordID.ToString()), this);
clsResponse image_response = JsonConvert.DeserializeObject <clsResponse>(content);
if (image_response.IsGood == true)
{
uploadedImage++;
recordImage.Uploaded = true;
App.Database.SaveRecordImageAsync(recordImage);
}
}
}
async void GeneratePallet(object sender, System.EventArgs e)
{
try
{
clsWhsHeader productList = new clsWhsHeader();
productList.Id = uploadID;
productList.Items = items;
var content = await CommonFunction.CallWebService(1, productList, Ultis.Settings.SessionBaseURI, ControllerUtil.postPackingDetailURL(), this);
clsResponse update_response = JsonConvert.DeserializeObject <clsResponse>(content);
if (update_response.IsGood)
{
await DisplayAlert("Success", "List uploaded", "OK");
await Navigation.PopAsync();
}
else
{
await DisplayAlert("Error", update_response.Message, "OK");
}
}
catch (Exception ex)
{
await DisplayAlert("Error", ex.Message, "OK");
}
}
public static clsNew parseNew(string json)
{
clsResponse Response = parseResponse(json);
clsNew New = JsonConvert.DeserializeObject <clsNew>(Convert.ToString(Response.Data));
return(New);
}
public string createFan(string pstringRequest)
{
clsRequest request = JsonConvert.DeserializeObject <clsRequest>(pstringRequest);
clsInfoFan InfoFan = DeserializeJson.DeserializeFanForm(request.Data);
clsResponse response = new clsResponse();
clsInfoUser InfoUser = new clsInfoUser();
InfoUser.Username = InfoFan.Username;
FacadeDA.validateUser(InfoUser, ref response);
if (!response.Success) //not existing username
{
response = new clsResponse(); //clear the response
InfoFan.Salt = clsHasher.genSalt();
InfoFan.SaltHashed = clsHasher.hashPassword(InfoFan.Password, InfoFan.Salt);
InfoFan = FacadeDA.createFan(InfoFan, ref response);
//save image
ArchiveManager.saveUserImage(InfoFan.Id, InfoFan.Picture, ref response);
InfoUser.Salt = null; // clear the object before sending
InfoUser.SaltHashed = null; // clear the object before sending
}
else
{
//error info
response.Success = false;
response.Message = "Existing Username";
response.Code = 3;
}
response.Data = serializer.Serialize(InfoFan);
return(serializer.Serialize(response));
}
private clsResponse _SelectToFile(string pSQL)
{
clsResponse response = new clsResponse();
string msg = "";
////////string fileName = Path.Combine(
//////// clsSystemInfo.xTempDirectory, "./file.xml");
////////try
////////{
//////// ////OleDbDataAdapter da = new OleDbDataAdapter(pSQL, this.myConnection_);
//////// SqlDataAdapter da = new SqlDataAdapter(pSQL, this.myConnection_);
//////// DataSet ds = new DataSet();
//////// da.Fill(ds);
//////// ds.WriteXml(fileName, XmlWriteMode.IgnoreSchema);
//////// response.xSetReturn("FileName", fileName);
////////}
////////catch (Exception ex)
////////{
//////// msg = "SELECTに失敗しました。";
//////// msg += "(" + myDBInfo_.xDBName + ")" + "(" + pSQL + ")" + Environment.NewLine;
//////// msg += ex.Message + Environment.NewLine;
//////// response.xSetError(msg);
//////// msg += ex.StackTrace;
//////// clsTextLogger.xWriteTextLog(
//////// MethodBase.GetCurrentMethod().DeclaringType.FullName + "." +
//////// MethodBase.GetCurrentMethod().Name, msg);
////////}
return response;
}
protected async void GetPendingList()
{
records.Clear();
string url = "";
if (Title.Equals("Cargo Receiving"))
{
url = ControllerUtil.getPendingReceivingURL();
}
else if (Title.Equals("Cargo Loading"))
{
url = ControllerUtil.getPendingLoadURL();
}
else if (Title.Equals("Cargo Measuring"))
{
url = ControllerUtil.getPendingReceivingURL();
}
var content = await CommonFunction.CallWebService(0, null, Ultis.Settings.SessionBaseURI, url, this);
clsResponse pending_response = JsonConvert.DeserializeObject <clsResponse>(content);
if (pending_response.IsGood)
{
App.Database.DeleteTruckModel();
List <clsTruckingModel> trucks = JObject.Parse(content)["Result"].ToObject <List <clsTruckingModel> >();
foreach (clsTruckingModel truck in trucks)
{
string summary = "";
TruckModel record = new TruckModel();
record.TruckId = truck.TruckId;
record.RecordId = truck.Id;
foreach (clsCaptionValue truckValue in truck.Summary)
{
summary += truckValue.Caption + " : " + truckValue.Value + "\r\n" + "\r\n";
if (truckValue.Caption.Equals("Job No."))
{
record.JobNo = truckValue.Value;
}
}
record.Summary = summary;
//App.Database.SaveTruckModelAsync(record);
records.Add(record);
}
loadPendingList();
}
else
{
await DisplayAlert("JsonError", pending_response.Message, "OK");
}
}
async void GetAction(string deviceID)
{
try
{
if (Ultis.Settings.FireID.Equals("firebase"))
{
OneSignal.Current.IdsAvailable((playerID, pushToken) => firebaseID = playerID);
Ultis.Settings.FireID = firebaseID;
}
var content = await CommonFunction.CallWebService(0, null, Ultis.Settings.SessionBaseURI, ControllerUtil.getActionURL(deviceID, firebaseID), this);
clsResponse login_response = JsonConvert.DeserializeObject <clsResponse>(content);
if (login_response.IsGood)
{
var result = JObject.Parse(content)["Result"].ToObject <clsLogin>();
Ultis.Settings.SessionSettingKey = result.SessionId;
Ultis.Settings.SessionUserId = result.UserName;
if (result.MainMenu.Count == 1)
{
loading.IsVisible = false;
loading.IsEnabled = false;
string action = result.MainMenu[0].Id;
switch (action)
{
case "Register":
emailEntryView.IsVisible = true;
submit.IsVisible = true;
break;
case "Activate":
Application.Current.MainPage = new AccountActivation();
break;
case "Home":
Application.Current.MainPage = new MainPage();
break;
case "HaulageVolume":
Application.Current.MainPage = new MainPage();
break;
}
}
}
}
catch (Exception ex)
{
await DisplayAlert("Error", ex.Message, "OK");
}
}
public static List <clsBands> parseBands(string json)
{
clsResponse Response = parseResponse(json);
dynamic data = JObject.Parse(Response.Data);
List <clsBands> bands = JsonConvert.DeserializeObject <List <clsBands> >(Convert.ToString(data.Bands));
return(bands);
}
private clsResponse _ExecuteSQL(string pSQL, bool pWithTransaction, int pCommandTimeout)
{
clsResponse response = new clsResponse();
string msg = "";
////OleDbCommand command = new OleDbCommand();
NpgsqlCommand command = new NpgsqlCommand();
int count = 0;
try
{
if (pWithTransaction)
{
myTransaction_ = myConnection_.BeginTransaction();
}
if (pCommandTimeout > 0)
{
command.CommandTimeout = pCommandTimeout;
}
else
{
// 2018/01/13
command.CommandTimeout = 300;
}
command.Connection = myConnection_;
command.Transaction = myTransaction_;
command.CommandText = pSQL;
command.CommandType = CommandType.Text;
count = command.ExecuteNonQuery();
response.xSetReturn("-- ResultCount", count.ToString());
if (pWithTransaction)
{
myTransaction_.Commit();
}
}
catch (Exception ex)
{
if (pWithTransaction) myTransaction_.Rollback();
msg = "SQLの実行に失敗しました。" + Environment.NewLine;
msg += "(" + myDBInfo_.xDBName + ")" + "(" + pSQL + ")" + Environment.NewLine;
msg += ex.Message + Environment.NewLine;
response.xSetError(msg);
msg += ex.StackTrace;
////////clsTextLogger.xWriteTextLog(
//////// MethodBase.GetCurrentMethod().DeclaringType.FullName + "." +
//////// MethodBase.GetCurrentMethod().Name, msg);
}
finally
{
if (command != null)
{
command.Dispose();
command = null;
}
}
return response;
}
