public async Task <IActionResult> uploadFileAndSendEmail(TroskoviSearchRequest file)
{
byte[] data = System.Convert.FromBase64String(file.file);
file.file = System.Text.ASCIIEncoding.ASCII.GetString(data);
string subject = "Registracija";
string body = file.file;
//string FromMail = "*****@*****.**";
string FromMail = "*****@*****.**";
string temp = "*****@*****.**";
string emailTo = temp;
MailMessage mail = new MailMessage();
SmtpClient SmtpServer = new SmtpClient("smtp.gmail.com");
mail.From = new MailAddress(FromMail);
mail.To.Add(emailTo);
mail.Subject = subject;
mail.Body = body;
SmtpServer.Port = 587;
SmtpServer.UseDefaultCredentials = false;
SmtpServer.Credentials = new System.Net.NetworkCredential("*****@*****.**", "Rstest123456");
SmtpServer.EnableSsl = true;
SmtpServer.Send(mail);
return(Ok());
}
public List <Troskovi> GetAllTroskoviByDatum(TroskoviSearchRequest request)
{
//var query = new List<Database.Troskovi>();
var query = _context.Troskovi.AsQueryable().Include(c => c.Predmeti);
var datum = DateTime.MinValue;
if (datum != request.DatumUplate)
{
query = query.Where(x => x.DatumUplate.Value.ToString("dd-MMM-yyyy").StartsWith(request.DatumUplate.ToString("dd-MMM-yyyy"))).Include(p => p.Predmeti);
}
if (request.PredmetID != 0)
{
query = query.Where(x => x.PredmetID.Equals(request.PredmetID)).Include(c => c.Predmeti);
}
query = query.Where(p => p.IsDeleted == false).Include(c => c.Predmeti);
var result = query.ToList();
return(_mapper.Map <List <Model.Troskovi> >(result));
}
private async void TxtPretraga_TextChanged(object sender, EventArgs e)
{
var search = new TroskoviSearchRequest
{
Sifra = txtPretraga.Text
};
var result = await _aPIService.Get <List <Model.Troskovi> >(search);
dgvTroskovi.DataSource = result;
}
public List <Troskovi> Get(TroskoviSearchRequest request)
{
var query = _context.Troskovi.AsQueryable().Include(c => c.Predmeti);
if (!string.IsNullOrWhiteSpace(request?.Sifra))
{
query = query.Where(x => x.Sifra.StartsWith(request.Sifra)).Include(c => c.Predmeti);
}
query = query.Where(p => p.IsDeleted == false).Include(c => c.Predmeti);
var result = query.ToList();
return(_mapper.Map <List <Model.Troskovi> >(result));
}
private void tmrExecutor_Elapsed(object sender, System.Timers.ElapsedEventArgs e)
{
ServiceLog.WriteErrorLog("sadsfasfasf");
//Do your Sending email work here
try
{
ServiceLog.WriteErrorLog("doslo");
var predmeti = new List <Advokati.Model.Predmeti>();
var troskovi = new List <Advokati.Model.Troskovi>();
PredmetiSearchRequest request = new PredmetiSearchRequest();
TroskoviSearchRequest request2 = new TroskoviSearchRequest();
ServiceLog.WriteErrorLog("doslo 11");
HttpClient client = new HttpClient();
client.BaseAddress = new Uri(URL);
// Add an Accept header for JSON format.
client.DefaultRequestHeaders.Accept.Add(
new MediaTypeWithQualityHeaderValue("application/json"));
// List data response.
HttpResponseMessage response = client.GetAsync("predmeti").Result; // Blocking call! Program will wait here until a response is received or a timeout occurs.
if (response.IsSuccessStatusCode)
{
// Parse the response body.
// var responseAsString = response.Content.ReadAsAsync();
// ServiceLog.WriteErrorLog(responseAsString.ToString());
//Advokati.Model.Predmeti responseAsConcreteType = JsonConvert.DeserializeObject<Advokati.Model.Predmeti>(responseAsString);
predmeti = response.Content.ReadAsAsync <List <Advokati.Model.Predmeti> >().Result; //Make sure to add a reference to System.Net.Http.Formatting.dll
//ServiceLog.WriteErrorLog("response");
//ServiceLog.WriteErrorLog(predmeti.Count.ToString());
//foreach (var d in predmeti)
//{
// ServiceLog.WriteErrorLog("d");
// ServiceLog.WriteErrorLog(d.ToString());
//}
}
else
{
Console.WriteLine("{0} ({1})", (int)response.StatusCode, response.ReasonPhrase);
}
HttpResponseMessage response1 = client.GetAsync("troskovi").Result; // Blocking call! Program will wait here until a response is received or a timeout occurs.
if (response1.IsSuccessStatusCode)
{
// Parse the response body.
// var responseAsString = response.Content.ReadAsAsync();
// ServiceLog.WriteErrorLog(responseAsString.ToString());
//Advokati.Model.Predmeti responseAsConcreteType = JsonConvert.DeserializeObject<Advokati.Model.Predmeti>(responseAsString);
troskovi = response1.Content.ReadAsAsync <List <Advokati.Model.Troskovi> >().Result; //Make sure to add a reference to System.Net.Http.Formatting.dll
//ServiceLog.WriteErrorLog("Troskovi");
//ServiceLog.WriteErrorLog(troskovi.Count.ToString());
//foreach (var d in troskovi)
//{
// ServiceLog.WriteErrorLog("tr");
// ServiceLog.WriteErrorLog(d.ToString());
//}
}
else
{
Console.WriteLine("{0} ({1})", (int)response.StatusCode, response.ReasonPhrase);
}
//Advokati.WebAPI.Services.PredmetiService.
//var predmeti = _predmetiService.Get(request);
//ServiceLog.WriteErrorLog("doslo1");
//ar troskovi = _troskoviService.Get(request2);
List <Advokati.Model.Predmeti> listPredmetaSaNulaTransakcija = new List <Advokati.Model.Predmeti>();
ServiceLog.WriteErrorLog("doslo2");
decimal countTransakcije = 0;
bool transakcijeVeceODNula = false;
foreach (var p in predmeti)
{
countTransakcije = 0;
transakcijeVeceODNula = false;
foreach (var t in troskovi)
{
if (p.PredmetId == t.PredmetID && t.Iznos == 0 && p.RokUplate < DateTime.Now)
{
ServiceLog.WriteErrorLog("prvi if");
listPredmetaSaNulaTransakcija.Add(p);
ServiceLog.SendEmail(p);
}
if (p.PredmetId == t.PredmetID)
{
countTransakcije += t.Iznos;
}
if (p.PredmetId == t.PredmetID && t.Iznos > 0 && p.RokUplate < DateTime.Now)
{
transakcijeVeceODNula = true;
}
}
if (countTransakcije < p.UkupniTrosak && transakcijeVeceODNula)
{
ServiceLog.WriteErrorLog("drugi if");
ServiceLog.SendEmail(p);
}
}
}
catch (Exception exc)
{
ServiceLog.WriteErrorLog(exc);
// Block of code to handle errors
}
// SastanciSearchRequest request = new SastanciSearchRequest();
//List<Advokati.Model.Sastanci> sastanci = _sastanciService.Get(request);
//ovdje sad treba izvrtiti sastanke ili bilo sta i zavisnosti od datuma slati mailove
}
public List <Model.Troskovi> GetAllTroskoviByDatum(TroskoviSearchRequest request)
{
return(_troskoviService.GetAllTroskoviByDatum(request));
}
public List <Model.Troskovi> Get([FromQuery] TroskoviSearchRequest request)
{
return(_troskoviService.Get(request));
}
