//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); } }