public async Task <IActionResult> Edit(Guid id, [Bind("Comment,CampaignId,AppUserId,CreatedBy,CreatedAt,EditedBy,EditedAt,Id")] UserCampaign userCampaign)
{
if (id != userCampaign.Id)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(userCampaign);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!UserCampaignExists(userCampaign.Id))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
ViewData["AppUserId"] = new SelectList(_context.Users, "Id", "FirstName", userCampaign.AppUserId);
ViewData["CampaignId"] = new SelectList(_context.Campaigns, "Id", "Name", userCampaign.CampaignId);
return(View(userCampaign));
}
public List <UserCampaign> GetUserCampaign()
{
SqlConnection sqlconn = new SqlConnection(ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString);
List <UserCampaign> list = new List <UserCampaign>();
using (sqlconn)
{
using (SqlCommand cmd = new SqlCommand("getUserCampaign", sqlconn))
{
cmd.CommandType = System.Data.CommandType.StoredProcedure;
sqlconn.Open();
using (SqlDataReader rdr = cmd.ExecuteReader())
{
while (rdr.Read())
{
UserCampaign userCampaign = new UserCampaign
{
UserId = rdr["UserId"].ToString(),
CampaignID = rdr["CampaignID"].ToString()
};
list.Add(userCampaign);
}
}
}
}
return(list);
}
public async Task <IActionResult> Create([Bind("Comment,CampaignId,AppUserId,CreatedBy,CreatedAt,EditedBy,EditedAt,Id")] UserCampaign userCampaign)
{
if (ModelState.IsValid)
{
userCampaign.Id = Guid.NewGuid();
_context.Add(userCampaign);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
ViewData["AppUserId"] = new SelectList(_context.Users, "Id", "FirstName", userCampaign.AppUserId);
ViewData["CampaignId"] = new SelectList(_context.Campaigns, "Id", "Name", userCampaign.CampaignId);
return(View(userCampaign));
}
public async Task <JsonResult> Create(UserCampaignModel model)
{
try
{
if (ModelState.IsValid)
{
var overWrite = db.UserCampaigns.Where(x => x.UserId == model.UserId && x.CampaignId == model.CampaignId).ToList();
if (overWrite.Count > 0 && model.confirmOverwite != 1)
{
Response.StatusCode = 400;
return(Json("Error"));
}
var userCampaign = db.UserCampaigns.Where(x => x.CampaignId == model.CampaignId && x.UserId == model.UserId).FirstOrDefault();
if (userCampaign != null)
{
db.UserProjects.RemoveRange(db.UserProjects.Where(y => y.UserCampaignId == userCampaign.Id && y.UserId == model.UserId));
db.UserCampaigns.RemoveRange(db.UserCampaigns.Where(x => x.UserId == model.UserId && x.CampaignId == model.CampaignId));
}
var entity = new UserCampaign
{
User = model.User,
UserId = model.UserId,
Campaign = model.Campaign,
CampaignId = model.CampaignId,
BudgetedHours = model.BudgetedHours,
PayRateDialingHours = model.PayRateDialingHours,
PayRateTrainingHours = model.PayRateTrainingHours,
PayRateSuccess = model.PayRateSuccess,
LastUpdate = DateTime.Now,
CreationDate = DateTime.Now,
IsDeleted = false,
};
db.UserCampaigns.Add(entity);
var userProjects = new List <UserProject>();
foreach (var item in model.ProjectIds)
{
userProjects.Add(new UserProject
{
UserCampaignId = entity.Id,
UserId = model.UserId,
ProjectId = item,
CreationDate = DateTime.Now,
LastUpdate = DateTime.Now,
IsDeleted = false
});
}
db.UserProjects.AddRange(userProjects);
await db.SaveChangesAsync();
return(Json("Ok"));
}
}
catch (Exception e)
{
AddAlert($"Oops! something went wrong. Error code: {e.HResult}", "Create(model)", this.GetType().ToString(), AlertType.error, e);
}
var Users = db.Users.Where(x => !x.IsDeleted);
ViewBag.UserId = new SelectList(Users.Where(x => x.Roles.Any(y => y.RoleId == "2" || y.RoleId == "3")), "Id", "DisplayName");
ViewBag.CampaignId = new SelectList(db.Campaigns.Where(x => !x.IsDeleted), "Id", "Identifier");
return(Json("Error"));
}
public void CreateDomainLevel2()
{
try
{
var ctx = ApplicationDbContext.Create();
//already OK
if (ctx.Forms.Any())
{
return;
}
var reader = new ReadOnlyContext();
var db = MemoryDB.LoadDomainLevel2(reader);
var container = new MemoryDB();
foreach (var item in db.Forms)
{
var form = new Form
{
Id = item.Id,
//Campaign = campaign,
//CampaignId = campaign.Id,
CampaignId = item.CampaignId,
CreationDate = item.CreationDate,
Description = item.Description,
IsDeleted = item.IsDeleted,
LastUpdate = item.LastUpdate,
Name = item.Name,
};
container.Forms.Add(form);
}
foreach (var item in db.AgentLogs)
{
var agentLog = new AgentLog
{
Id = item.Id,
//Agent = agent,
//AgentId = agent.Id,
AgentId = item.AgentId,
//Campaign = campaign,
//CampaignId = campaign.Id,
CampaignId = item.CampaignId,
//TimeZone = timeZone,
//TimeZoneId = timeZone.Id,
TimeZoneId = item.TimeZoneId,
CreationDate = item.CreationDate,
DialingHours = item.DialingHours,
IsDeleted = item.IsDeleted,
LastUpdate = item.LastUpdate,
Project = item.Project,
ProjectId = item.ProjectId,
Successes = item.Successes,
TrainingHours = item.TrainingHours,
};
container.AgentLogs.Add(agentLog);
}
//foreach (var item in db.CampaignCallCodes)
//{
// var campaignCallCodes = new CampaignCallCode
// {
// Id = item.Id,
// //CallCode = callCode,
// //CallCodeId = callCode.Id,
// CallCodeId = item.CallCodeId,
// //Campaign = campaign,
// //CampaignId = campaign.Id,
// CampaignId = item.CampaignId,
// CreationDate = item.CreationDate,
// IsDeleted = item.IsDeleted,
// LastUpdate = item.LastUpdate,
// };
// container.CampaignCallCodes.Add(campaignCallCodes);
//}
foreach (var item in db.ExtraFields)
{
var extraField = new ExtraField
{
Id = item.Id,
//Campaign = campaign,
//CampaignId = campaign.Id,
CampaignId = item.CampaignId,
CreationDate = item.CreationDate,
// ExtraFieldOptions = item.ExtraFieldOptions,
FieldName = item.FieldName,
IsDeleted = item.IsDeleted,
TypeId = item.TypeId,
LastUpdate = item.LastUpdate,
};
container.ExtraFields.Add(extraField);
}
foreach (var item in db.UserCampaigns)
{
var userCampaign = new UserCampaign
{
Id = item.Id,
//Campaign = campaign,
//CampaignId = campaign.Id,
CampaignId = item.CampaignId,
//User = user,
//UserId = user.Id,
UserId = item.UserId,
BudgetedHours = item.BudgetedHours,
CreationDate = item.CreationDate,
IsDeleted = item.IsDeleted,
LastUpdate = item.LastUpdate,
PayRateDialingHours = item.PayRateDialingHours,
PayRateSuccess = item.PayRateSuccess,
PayRateTrainingHours = item.PayRateTrainingHours,
};
container.UserCampaigns.Add(userCampaign);
}
foreach (var item in db.UserProjects)
{
var userProject = new UserProject
{
Id = item.Id,
//UserCampaign = userCampaign,
//UserCampaignId = userCampaign.Id,
UserCampaignId = item.UserCampaignId,
//Project = project,
//ProjectId = project.Id,
ProjectId = item.ProjectId,
//User = user,
//UserId = user.Id,
UserId = item.UserId,
CreationDate = item.CreationDate,
IsDeleted = item.IsDeleted,
LastUpdate = item.LastUpdate,
};
container.UserProjects.Add(userProject);
}
foreach (var item in db.UsersHistory)
{
var userHistory = new UserHistory
{
Id = item.Id,
//User = user,
//UserId = user.Id,
UserId = item.UserId,
//Campaign = campaign,
//CampaignId = campaign?.Id,
CampaignId = item.CampaignId,
ConnectionId = item.ConnectionId,
CreationDate = item.CreationDate,
Duration = item.Duration,
IsDeleted = item.IsDeleted,
LastUpdate = item.LastUpdate,
LoggedIn = item.LoggedIn,
LoggedOff = item.LoggedOff,
};
container.UsersHistory.Add(userHistory);
}
ctx.Forms.AddRange(container.Forms);
ctx.AgentLogs.AddRange(container.AgentLogs);
//ctx.CampaignCallCodes.AddRange(container.CampaignCallCodes);
ctx.ExtraFields.AddRange(container.ExtraFields);
ctx.UserCampaigns.AddRange(container.UserCampaigns);
ctx.UserProjects.AddRange(container.UserProjects);
ctx.UsersHistory.AddRange(container.UsersHistory);
ctx.SaveChanges();
}
catch (Exception ex)
{
var str = ex.ToString();
System.Diagnostics.Debug.WriteLine(str);
}
}
