//void
public void DeleteCategory(ResponseBase response, int CategoryId, int AddedByUserId)
{
if (this.CheckIfIdeaExistsForCategory(response, CategoryId))
{
DatabaseWrapper.databaseOperation(response,
(context, query) =>
{
IdeaCategory ideaCategory = query.GetCategoreById(context, CategoryId);
if (ideaCategory != null)
{
query.DeleteIdeaCategory(context, ideaCategory);
response.Status = Enum.GetName(typeof(ResponseStatusType), ResponseStatusType.Success);
}
else
{
response.Status = Enum.GetName(typeof(ResponseStatusType), ResponseStatusType.Failure);
response.ErrorList.Add(Faults.IdeaCategoriesIDNotExists);
return;
}
context.SubmitChanges();
}
, readOnly: false
);
if (response == null && response.ErrorList.Count != 0)
{
response.ErrorList.Add(Faults.ServerIsBusy);
return;
}
}
return;
}
public ActionResult Update(IdeaCategory model)
{
model.ModifiedBy = ((UserLogin)Session[ModelPr.CommonClass.CommonCls.User_session]).Username;
var result = new IdeaCategoryDao().UpdateIdeaCategory(model);
return(RedirectToAction("Index/" + (int)TempData["grID"]));
}
public void AddIdeaCategory(IIdeaDatabaseDataContext dc, IdeaCategory ideacategory)
{
if (ideacategory != null)
{
dc.IdeaCategories.Add(ideacategory);
}
}
public void InsertCategory(RestAPIAddIdeaCatrgoryResponse response, string Category, int AddedByUserId)
{
IdeaCategory ideacategory;
DatabaseWrapper.databaseOperation(response,
(context, query) =>
{
IdeaCategory ideaCategory = query.GetCategoreByName(context, Category);
if (ideaCategory == null)
{
ideacategory = new IdeaCategory()
{
CategoriesName = Category, CreatedDate = DateTime.UtcNow, ModifiedDate = DateTime.UtcNow, AddedByUserId = AddedByUserId
};
query.AddIdeaCategory(context, ideacategory);
response.Status = Enum.GetName(typeof(ResponseStatusType), ResponseStatusType.Success);
}
else
{
response.Status = Enum.GetName(typeof(ResponseStatusType), ResponseStatusType.Failure);
response.ErrorList.Add(Faults.IdeaCategoriesNameExists);
return;
}
context.SubmitChanges();
}
, readOnly: false
);
if (response == null && response.ErrorList.Count != 0)
{
response.ErrorList.Add(Faults.ServerIsBusy);
return;
}
}
public static String IdeaCategoryString(IdeaCategory category)
{
String returnValue = "";
switch (category)
{
case IdeaCategory.ApplicantSatisfaction:
returnValue = "Applicant satisfaction";
break;
case IdeaCategory.CostReduction:
returnValue = "Cost reduction";
break;
case IdeaCategory.EmployeeSatisfaction:
returnValue = "Employee satisfaction";
break;
case IdeaCategory.GreenIdea:
returnValue = "Green idea";
break;
case IdeaCategory.Others:
returnValue = "Others";
break;
case IdeaCategory.Productivity:
returnValue = "Productivity";
break;
case IdeaCategory.RevenueGeneration:
returnValue = "Revenue generation";
break;
case IdeaCategory.TATReduction:
returnValue = "TAT reduction";
break;
case IdeaCategory.TimeSaving:
returnValue = "Time saving";
break;
case IdeaCategory.CSR:
returnValue = "CSR";
break;
default:
returnValue = "Select";
break;
}
return(returnValue);
}
public bool InsertIdeaCategory(IdeaCategory model)
{
try
{
model.IdeaCateViewC = 0;
model.CreatedDate = DateTime.Now;
model.ModifiedDate = DateTime.Now;
model.FinalCloseDate = DateTime.Now.AddDays(90);
db.IdeaCategories.Add(model);
db.SaveChanges();
return(true);
}
catch (Exception)
{
throw;
}
}
public bool UpdateIdeaCategory(IdeaCategory model)
{
try
{
var idc = db.IdeaCategories.Find(model.IdeaCategoryID);
idc.ModifiedDate = DateTime.Now;
idc.IdeaCateStatus = model.IdeaCateStatus;
idc.ModifiedBy = model.ModifiedBy;
idc.GroupCateIdea = model.GroupCateIdea;
DateTime sqlDate = DateTime.Now;
idc.FinalCloseDate = Convert.ToDateTime(model.FinalCloseDate.Date.ToString("dd-MM-yyyy"));
db.SaveChanges();
return(true);
}
catch (Exception)
{
throw;
}
}
private static BladeAttribute[] IdeaToAttributes(IdeaCategory idea)
{
switch (idea)
{
case IdeaCategory.Bravery:
return(new[] { BladeAttribute.Fire, BladeAttribute.Water });
case IdeaCategory.Truth:
return(new[] { BladeAttribute.Wind, BladeAttribute.Ice });
case IdeaCategory.Compassion:
return(new[] { BladeAttribute.Earth, BladeAttribute.Electric });
case IdeaCategory.Justice:
return(new[] { BladeAttribute.Light, BladeAttribute.Dark });
default:
throw new ArgumentOutOfRangeException();
}
}
//public bool GetCategoreByName(IIdeaDatabaseDataContext dc, string categoriesName, int addedByUserId)
//{
// bool result = dc.IdeaCategories.Any(x => (x.CategoriesName == categoriesName && x.AddedByUserId == addedByUserId));
// return result;
//}
public void DeleteIdeaCategory(IIdeaDatabaseDataContext ctx, IdeaCategory ideacategory)
{
ctx.IdeaCategories.Remove(ideacategory);
}
public void SubmitIdeaRequest(RestAPISubmitIdeaResponse response, SubmitIdeaRequest submitIdeaRequest, int UserId)
{
DatabaseWrapper.databaseOperation(response,
(context, query) =>
{
Idea idea = new Idea();
IdeaCategory category = query.GetIdeaFromCategoryID(context, submitIdeaRequest.CategoryId);
IdeaChallenge ideaChallenge = query.GetChallengeByID(context, submitIdeaRequest.ChallengeId);
// insert category
if (category != null)
{
idea.IdeaCategory = category;
}
//insert challenge
if (ideaChallenge != null)
{
idea.ChallengeId = ideaChallenge.IdeaChallengeId;
}
//insert Ideacontributors
if (!string.IsNullOrEmpty(submitIdeaRequest.IdeaContributors))
{
List <string> contributors = GetContributorList(submitIdeaRequest.IdeaContributors);
List <User> userList = query.GetUserByNames(context, contributors);
foreach (var user in userList)
{
idea.IdeaContributors.Add(new IdeaContributor()
{
IdeaId = idea.IdeaId, UserId = user.UserId, CreatedDate = DateTime.UtcNow, ModifiedDate = DateTime.UtcNow
});
}
}
//insert idea status
IdeaStatusLog ideaStatusLog = new IdeaStatusLog()
{
CreatedDate = DateTime.UtcNow,
ModifiedByUserId = UserId,
IsActive = true,
IdeaState = submitIdeaRequest.IsDraft ? (int)IdeaStatusTypes.SubmitPending : (int)IdeaStatusTypes.ReviewPending
};
idea.IdeaStatusLogs.Add(ideaStatusLog);
idea.Title = submitIdeaRequest.Title;
idea.Description = submitIdeaRequest.Description;
idea.IsActive = true;
idea.CreatedDate = DateTime.UtcNow;
idea.ModifiedDate = DateTime.UtcNow;
idea.BusinessImpact = submitIdeaRequest.BusinessImpact;
idea.UserId = UserId;
idea.IsSensitive = true;
idea.Solution = submitIdeaRequest.Solution;
idea.IsDraft = submitIdeaRequest.IsDraft;
query.AddIdea(context, idea);
context.SubmitChanges();
response.IdeaId = idea.IdeaId;
response.Status = Success;
}
, readOnly: false
);
if (response.ErrorList.Count != 0)
{
response.ErrorList.Add(Faults.ServerIsBusy);
}
}
