public async Task <CheckedData> CheckCloths()
{
await Task.Delay(3000);
MySqlCommand command = new MySqlCommand();
MySqlConnection connection = getConnection();
command.Connection = connection;
command.CommandText = "CheckLejarat";
command.CommandType = System.Data.CommandType.StoredProcedure;
CheckedData data = new CheckedData(0, 0);
try
{
OpenConnection(connection);
MySqlDataReader reader = (MySqlDataReader)await command.ExecuteReaderAsync();
while (reader.Read())
{
if (reader.HasRows)
{
data = new CheckedData(int.Parse(reader["ember"].ToString()), int.Parse(reader["cikk"].ToString()));
}
}
}
catch (Exception e)
{
return(data);
}
finally
{
CloseConnection(connection);
}
return(data);
}
private async void CheckAndExecuteEndings()
{
DolgozoDatabaseHelper helper = new DolgozoDatabaseHelper();
CheckedData data = await helper.CheckCloths();
MessageBoxResult result = MessageBoxResult.Cancel;
if (data.DolgozoCount > 0)
{
result = MessageBox.Show($"Összesen: {data.DolgozoCount} dolgozónál találtam lejárt ruhát. A ruhák száma: {data.ClothesCount}{Environment.NewLine}Szeretné, hogy töröljem őket?", "Lejárt ruhák", MessageBoxButton.OKCancel, MessageBoxImage.Asterisk);
}
if (MessageBoxResult.OK == result)
{
await helper.DeleteEndings();
MessageBox.Show("A lejárt ruhákat kivezettem!");
}
}
/// <summary>
/// حفظ بيانات الاعانة التأسيسية
/// </summary>
/// <param name="chda"></param>
/// <param name="ChairmanBoardMobileNumber"></param>
/// <param name="ChairmanBoardName"></param>
/// <returns></returns>
public RequestResult InsertFoundationSubsidyDAL(
CheckedData chda,
string ChairmanBoardMobileNumber,
string ChairmanBoardName
)
{
List <SpInPuts> inputs = new List <SpInPuts>
{
new SpInPuts()
{
KEY = "P_REG_TYPE_CODE", VALUE = chda.AgencyType
},
new SpInPuts()
{
KEY = "P_SOC_REG_NO", VALUE = chda.AgencyLicenseNumber
},
new SpInPuts()
{
KEY = "P_BOARD_CHAIRMAN_NAME", VALUE = ChairmanBoardName
},
new SpInPuts()
{
KEY = "P_BOARD_CHAIRMAN_MOBILE", VALUE = ChairmanBoardMobileNumber
},
new SpInPuts()
{
KEY = "P_LOGIN_ID", VALUE = chda.CommissionerNumber
}
};
List <SpOutPuts> Outouts = new List <SpOutPuts>()
{
new SpOutPuts()
{
ParameterName = "P_RESULT_CODE", OracleDbType = OracleDbType.Varchar2, Size = 300
},
new SpOutPuts()
{
ParameterName = "P_RESULT_TEXT", OracleDbType = OracleDbType.Varchar2, Size = 2000
},
new SpOutPuts()
{
ParameterName = "P_REQUEST_ID", OracleDbType = OracleDbType.Varchar2, Size = 300
}
};
//Populate Parameters
List <OracleParameter> OpParms = ado.PopulateSpInPuts(
in inputs
);
ado.PopulateSpOutPuts(
ref OpParms,
in Outouts
);
ado.ExecuteStoredProcedure(
"CH_P_SUBSIDY_ESTBLSH",
OpParms,
out OracleParameterCollection OPCs
);
RequestResult RequestResult = new RequestResult
{
RequestId = OPCs[":P_REQUEST_ID"].Value != null?Convert.ToInt64(OPCs[":P_REQUEST_ID"].Value.ToString()) : 0,
RequestCode = OPCs[":P_RESULT_CODE"].Value.ToString(),
RequestName = OPCs[":P_RESULT_TEXT"].Value.ToString(),
};
return(RequestResult);
}
public RequestResult UpdateFoundationSubsidy(
long RequestId,
CheckedData CheckedData,
string ChairmanBoardMobileNumber,
string ChairmanBoardName
)
{
try
{
/// Data Validations
DataValidation.IsEmptyOrDefault2(CheckedData);
if (String.IsNullOrEmpty(ChairmanBoardMobileNumber) ||
String.IsNullOrEmpty(ChairmanBoardName) ||
ChairmanBoardMobileNumber.Length > 150 ||
ChairmanBoardName.Length > 150
)
{
string MS = "Invalid Parameters ChairmanBoardMobileNumber or ChairmanBoardName is Required but have null or empty or 0 value or length > 150";
throw new FaultException <ValidationFault>(
new ValidationFault()
{
Result = false,
Message = MS,
Description = MS
}, new FaultReason(MS));
}
/// Call Database
using (CharityDAL dal = new CharityDAL(new ADO()))
{
return(dal.UpdateFoundationSubsidyDAL(
RequestId,
CheckedData,
ChairmanBoardMobileNumber,
ChairmanBoardName));
}
}
catch (FaultException <ValidationFault> flex)
{
//ValidationFault fault = new ValidationFault
//{
// Result = true,
// Message = "Parameter not correct",
// Description = "Invalid Parameters is Required but have null or empty or 0 value"
//};
//var flex = new FaultException<ValidationFault>(fault, new FaultReason("Invalid Parameters is Required but have null or empty or 0 value"));
_log.Error(flex);
throw flex;
}
catch (Exception ex)
{
ValidationFault fault = new ValidationFault
{
Result = false,
Message = ex.Message,
Description = "Service have an internal error please contact service administartor [email protected]"
};
_log.Error(ex);
throw new FaultException <ValidationFault>(fault, new FaultReason("General Fault"));
}
}
