public CampaignDTO GetCampaignById(string id)
{
SqlConnection sqlconn = new SqlConnection(ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString);
// get campaign id from the model
CampaignDTO campaignDTO = new CampaignDTO();
using (sqlconn)
{
using (SqlCommand cmd = new SqlCommand("SelecOneCampaign", sqlconn))
{
cmd.CommandType = System.Data.CommandType.StoredProcedure;
sqlconn.Open();
cmd.Parameters.AddWithValue("@CampaignID", id);
using (SqlDataReader reader = cmd.ExecuteReader())
{
reader.Read();
campaignDTO.StartDate = (DateTime)reader["StartDate"];
campaignDTO.EndDate = (DateTime)reader["EndDate"];
campaignDTO.Description = reader["Description"].ToString();
campaignDTO.Country = reader["Country"].ToString();
}
}
}
return(campaignDTO);
}
public void RemoveCampaignService()
{
var uow = new UnitOfWork(new DigitalSignageDbContext("Test"));
CampaignService cS = new CampaignService();
Campaign campaign = new Campaign();
campaign.Name = "nueva campaña";
campaign.Description = "qsy";
campaign.InitDate = new DateTime().AddYears(2018);
campaign.EndDate = new DateTime().AddYears(2018);
campaign.InitTime = new TimeSpan();
campaign.EndTime = new TimeSpan();
uow.CampaignRepository.Add(campaign);
uow.Complete();
var campaignDTO = new CampaignDTO();
AutoMapper.Mapper.Map(campaign, campaignDTO);
try
{
cS.Remove(campaignDTO);
}
catch (Exception e)
{
Assert.Fail(e.Message);
}
}
public ActionResult Edit(CampaignDTO objeCampaign)
{
if (ModelState.IsValid)
{
using (sqlconn)
{
using (SqlCommand cmd = new SqlCommand("UpdateCampaignDescription", sqlconn))
{
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@CampaignID", objeCampaign.CampaignID);
cmd.Parameters.AddWithValue("@StartDate", objeCampaign.StartDate);
cmd.Parameters.AddWithValue("@EndDate", objeCampaign.EndDate);
cmd.Parameters.AddWithValue("@Description", objeCampaign.Description);
cmd.Parameters.AddWithValue("@Country", objeCampaign.Country);
sqlconn.Open();
cmd.ExecuteNonQuery();
sqlconn.Close();
}
}
}
return(View());
}
public ActionResult Details(string id)
{
CampaignViewModel campaignVM = new CampaignViewModel();
CampaignDTO campaign = campaignVM.GetCampaignById(id);
return(View(campaign));
}
/// <summary>
/// Crea una campaña
/// </summary>
/// <param name="pCampignDTO">camapaña que se quiere crear</param>
public void Create(CampaignDTO pCampignDTO)
{
///Mapea el DTO a un objecto Campaign
var campaign = new Campaign();
AutoMapper.Mapper.Map(pCampignDTO, campaign);
///Si hay una lista de Image entonces las mapea a sus DTO
if (pCampignDTO.Images != null)
{
for (int i = 0; i < pCampignDTO.Images.Count; i++)
{
AutoMapper.Mapper.Map(pCampignDTO.Images[i], campaign.Images[i]);
}
}
try
{
log.Info("Guardando campaña");
this.iUnitOfWork.CampaignRepository.Add(campaign);
this.iUnitOfWork.Complete();
log.Info("Campaña creada con exito");
}
catch (ArgumentException e)
{
log.Error("Error al crear campaña: " + e.Message);
throw new ArgumentException();
}
}
public void Put(CampaignDTO campaign, string id) //Update, all fields in one
{
UpdateLocalDB();
foreach (Campaign c in allCampaign)
{
if (c.Id == id)
{
Campaign input = ConvDTOtoDB(campaign);
if (input.Name != null)
{
c.Name = input.Name;
}
if (input.Type != null)
{
SelectType(input);
c.Type = input.Type;
}
if (input.Description != null)
{
c.Description = input.Description;
}
if (input.Active) //removes active campaign if any
{
Activate(id); //activate campaign
}
else
{
Deactivate(id); //deactivate campaign
}
_campaignDB.Update(input); //Updates Campaign in DataBase
break;
} //if none found does nothing
}
}
public CampaignDTO Post(CampaignDTO campaign) //Creates a new Campaign
{
if (VerifyFields(campaign))
{
UpdateLocalDB();
Campaign input = ConvDTOtoDB(campaign);
if (allCampaign.Count == 0) //verifies if allCampaigns is empty
{
input.Id = "CAMPAIGN-1"; //if it is, its first member has id = 1
}
else
{
Campaign c = allCampaign.Last();
string[] fracment = c.Id.Split("-");
int lastId = Int32.Parse(fracment[1]) + 1;
input.Id = "CAMPAIGN-" + lastId; //if not, it is the last id + 1
}
SelectType(input);
if (input.Active)
{
if (_campaignDB.OneCampaignActive()) //if a campaign is already active
{
input.Active = false; //input campaign can´t be activate
}
}
_campaignDB.Create(input); //Creates Campaign in DataBase
return(campaign);
}
return(null);
}
void IAddModifyViewForm.Add(IDTO pNewCampaign)
{
this.txtTitle.Text = String.Empty;
this.txtDescription.Text = String.Empty;
this.Text = "Agregar nueva Campaña";
this.iOriginalCampaign = (CampaignDTO)pNewCampaign;
}
public List <CampaignDTO> GetAllCampaigns()
{
SqlConnection sqlconn = new SqlConnection(ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString);
List <CampaignDTO> list = new List <CampaignDTO>();
using (sqlconn)
{
using (SqlCommand cmd = new SqlCommand("SelectAllCampaigns", sqlconn))
{
cmd.CommandType = System.Data.CommandType.StoredProcedure;
sqlconn.Open();
using (SqlDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
CampaignDTO campaignDTO = new CampaignDTO
{
CampaignID = reader["CampaignID"].ToString(),
StartDate = (DateTime)reader["StartDate"],
EndDate = (DateTime)reader["EndDate"],
Description = reader["Description"].ToString(),
Country = reader["Country"].ToString()
};
list.Add(campaignDTO);
}
}
}
}
return(list);
}
/// <summary>
/// Actualiza una campaña
/// </summary>
/// <param name="pCampaignDTO">Campaña a actualizar</param>
public void Update(CampaignDTO pCampaignDTO)
{
IUnitOfWork iUnitOfWork = new UnitOfWork(new DigitalSignageDbContext());
CampaignMapper campaignMapper = new CampaignMapper();
Campaign campaign = new Campaign();
Campaign oldCampaign = new Campaign();
campaignMapper.MapToModel(pCampaignDTO, campaign);
oldCampaign = iUnitOfWork.campaignRepository.Get(pCampaignDTO.id);
//actualiza los datos
oldCampaign.name = campaign.name;
oldCampaign.initTime = campaign.initTime;
oldCampaign.endTime = campaign.endTime;
oldCampaign.initDate = campaign.initDate;
oldCampaign.endDate = campaign.endDate;
oldCampaign.imagesList.Clear();
oldCampaign.imagesList = campaign.imagesList;
oldCampaign.interval = campaign.interval;
iUnitOfWork.Complete();
cLogger.Info("Campaña actualizada");
}
public ActionResult Edit(string id)
{
CampaignViewModel campaignVM = new CampaignViewModel();
CampaignDTO status = campaignVM.GetCampaignById(id);
status.CampaignID = id;
return(View(status));
}
public CampaignDTO Post([FromBody] CampaignDTO campaign)
{
Console.WriteLine("from post => " + campaign.Id + " - " + campaign.Name + " - " + campaign.Type + " - " + campaign.Description);
_campaignLogic.Post(campaign); //Create, Makes a new Campaign
var dbServer = _configuration.GetSection("Database").GetSection("ServerName");
campaign.Name = $"{campaign.Name} data from {dbServer.Value}";
return(campaign);
}
public static void ReadCampaign()
{
List <CampaignDTO> CampaignDTOList = new List <CampaignDTO>();
CampaignDTOList = CampaignService.GetCampaignNotSentList();
if (CampaignDTOList != null)
{
foreach (var item in CampaignDTOList)
{
try
{
CampaignDTO CampaignDTO = new CampaignDTO();
CampaignDTO = item;
DateTime ScheduledDate = CampaignDTO.ScheduledDate.Date;
DateTime Time;
if (CampaignDTO.ScheduledTime != "")
{
Time = Convert.ToDateTime(CampaignDTO.ScheduledTime);
}
else
{
Time = Convert.ToDateTime("12:00 AM");
}
ScheduledDate = Convert.ToDateTime(ScheduledDate.Date.ToString("MM/dd/yyyy") + " " + Time.TimeOfDay);
Console.WriteLine("Scheduled Time = " + ScheduledDate);
if (ScheduledDate <= System.DateTime.Now)
{
SplitMobile(item.RecipientsNumber, CampaignDTO);
}
else
{
}
}
catch (Exception ex)
{
using (FileStream file = new FileStream(Directory.GetCurrentDirectory() + "\\msgBlasterBackendService_Log.txt", FileMode.Append, FileAccess.Write))
{
StreamWriter streamWriter = new StreamWriter(file);
streamWriter.WriteLine(System.DateTime.Now + " - " + " ReadCampaign()" + " - " + ex.Message);
streamWriter.Close();
}
continue;
}
}
}
//Check Client Balance
//Modify Client Balance
}
private Campaign MapCampaignDtoToModel(CampaignDTO campaignDto)
{
return(new Campaign
{
Id = campaignDto.Id,
Description = campaignDto.Description,
From = campaignDto.From,
To = campaignDto.To,
Url = campaignDto.Url
});
}
public static CampaignDTO CampaignToDTO(Campaign Campaign)
{
if (Campaign == null)
{
return(null);
}
Mapper.CreateMap <Campaign, CampaignDTO>();
CampaignDTO CampaignDTO = Mapper.Map <CampaignDTO>(Campaign);
return(CampaignDTO);
}
public ActionResult Create(CampaignDTO campaign)
{
var newId = _campaigns.Create(campaign);
if (newId == -1)
{
return(BadRequest());
}
return(CreatedAtAction(nameof(Get), new { id = newId }));
}
public CampaignDTO ConvDBtoDTO(Campaign old) //Converts a DB Campaign to a DTOCampaign
{
CampaignDTO valid = new CampaignDTO();
valid.Id = old.Id;
valid.Name = old.Name;
valid.Description = old.Description;
valid.Type = old.Type;
valid.Active = old.Active;
return(valid);
}
public async Task <IActionResult> GetCampaignByIdAsync([FromRoute] int campaignId)
{
var campaign = await _campaignRepository.GetCampaignByIdAsync(campaignId);
if (campaign == null)
{
throw new NotFound404Exception("campaign");
}
return(Ok(CampaignDTO.GetFrom(campaign)));
}
public static Campaign CampaignToDomain(CampaignDTO CampaignDTO)
{
if (CampaignDTO == null)
{
return(null);
}
Mapper.CreateMap <CampaignDTO, Campaign>();
Campaign Campaign = Mapper.Map <Campaign>(CampaignDTO);
return(Campaign);
}
private async Task SaveCampaignAsync(CartDTO cart, CampaignDTO selectedCampaign, double discountAmount)
{
CartCampaignDTO cartCampaignDTO = new CartCampaignDTO
{
CartId = cart.CartId,
CampaignId = selectedCampaign.CampaignId,
DiscountAmount = discountAmount
};
CartCampaignModel cartCampaignModel = _mapper.Map <CartCampaignModel>(cartCampaignDTO);
await _cartEFService.SaveCartCampaignAsync(cartCampaignModel, cart.CartId);
}
private void dgvCampaign_CellContentDoubleClick(object sender, DataGridViewCellEventArgs e)
{
DataGridViewRow row = dgvCampaign.CurrentRow;
CampaignDTO campaign = (CampaignDTO)dgvCampaign.GetItem(row.Index);
AgregarModificarCampaña ventana = new AgregarModificarCampaña(this.iFactory);
if (this.dgvCampaign.Modify(ventana, campaign))
{
iController.ModifyCampaign(campaign);
this.CargarDataGrid();
}
}
private Campaign MapCampaignDtoToModel(CampaignDTO campaignDto)
{
return(new Campaign
{
Id = campaignDto.Id,
Name = campaignDto.Name,
Description = campaignDto.Description,
From = campaignDto.From,
To = campaignDto.To,
PictureUri = campaignDto.PictureUri
});
}
public void CreateCampaign([FromBody] CampaignDTO data)
{
_logger.LogInformation(0, "inside method");
try
{
campaignService.CreateCampaign(data);
}
catch (Exception ex)
{
_logger.LogInformation(4, ex.Message);
}
}
public async Task <ActionResult> CreateCoupon([FromBody] CampaignDTO campaign)
{
var campaignRepo = _mapper.Map <Campaign>(campaign);
_repo.Add(campaignRepo);
if (await _repo.SaveAll())
{
return(Ok(campaign));
}
return(BadRequest("Adding category error"));
}
public Campaign ConvDTOtoDB(CampaignDTO old) //Converts a DTOCampaign to a DB Campaign
{
Campaign valid = new Campaign();
if (old.Id != "CAMPAIGN-0")
{
valid.Id = old.Id;
}
valid.Name = old.Name;
valid.Description = old.Description;
valid.Type = old.Type;
valid.Active = old.Active;
return(valid);
}
public void CancelCampaign(string accessId, CampaignDTO campaignDTO)
{
try
{
CampaignService.CancelCampaign(campaignDTO);
}
catch (Exception)
{
throw new HttpResponseException(new HttpResponseMessage(HttpStatusCode.InternalServerError)
{
Content = new StringContent("An error occurred, please try again or contact the administrator."),
ReasonPhrase = "Critical Exception"
});
}
}
public ActionResult Update(int id, CampaignDTO campaign)
{
if (id != campaign.Id)
{
return(BadRequest());
}
return(_campaigns.Update(campaign) switch
{
OperationResults.Fail => BadRequest(),
OperationResults.Success => NoContent(),
OperationResults.NotFound => NotFound(),
_ => throw new NotImplementedException(),
});
void IAddModifyViewForm.Modify(IDTO pCampaign)
{
if (pCampaign == null)
{
throw new EntidadNulaException("La campaña indicada es nula");
//TODO excepcion argumentexception creo
}
else
{
this.iOriginalCampaign = (CampaignDTO)pCampaign;
this.txtTitle.Text = iOriginalCampaign.Name;
this.txtDescription.Text = iOriginalCampaign.Description;
this.Text = "Modificar Campaña";
}
}
public async Task <ActionResult> CreateCampaignAsync([FromBody] CampaignDTO campaignDto)
{
if (campaignDto is null)
{
return(BadRequest());
}
var campaign = MapCampaignDtoToModel(campaignDto);
await _context.Campaigns.AddAsync(campaign);
await _context.SaveChangesAsync();
return(CreatedAtAction(nameof(GetCampaignByIdAsync), new { id = campaign.Id }, null));
}
private CampaignDTO MapCampaignModelToDto(Campaign campaign)
{
var userId = _identityService.GetUserIdentity();
var dto = new CampaignDTO
{
Id = campaign.Id,
Name = campaign.Name,
Description = campaign.Description,
From = campaign.From,
To = campaign.To,
PictureUri = GetUriPlaceholder(campaign),
};
return(dto);
}
