public string EditWorkitem(Workitem id)
{
try
{
using (var entities = new WorkBountyDBEntities())
{
var getWorkitemData = entities.Workitems.Where(x => x.WorkitemID == id.WorkitemID).ToList();
getWorkitemData.ForEach(a =>
{
if (id.Amount != null)
{
a.Amount = id.Amount;
}
a.ModifyBy = id.ModifyBy;
if (id.ModifyDateTime != null)
{
a.ModifyDateTime = id.ModifyDateTime;
}
a.PublishedTo = id.PublishedTo;
if (id.Summary != null)
{
a.Summary = id.Summary;
}
if (id.Title != null)
{
a.Title = id.Title;
}
if (id.ProposedReward != "undefined")
{
a.ProposedReward = id.ProposedReward;
}
}
);
WorkitemStatu workitemstatusData = new WorkitemStatu();
string statusDescription = "Update";
workitemstatusData.StatusDescription = statusDescription;
workitemstatusData.WorkitemID = id.WorkitemID;
entities.WorkitemStatus.Add(workitemstatusData);
entities.SaveChanges();
WorkitemHistory workitemHistoryData = new WorkitemHistory();
workitemHistoryData.WorkitemID = id.WorkitemID;
workitemHistoryData.UpdatedBy = id.ModifyBy;
workitemHistoryData.UpdatedDateTIme = DateTime.Now;
var getWorkitemStatusID = entities.WorkitemStatus.Where(s => s.WorkitemID == id.WorkitemID).Select(s => s.WorkitemStatusID).FirstOrDefault();
workitemHistoryData.WorkitemStatusID = getWorkitemStatusID;
entities.WorkitemHistories.Add(workitemHistoryData);
entities.SaveChanges();
}
return("Success");
}
catch (Exception)
{
return("Error");
}
}
public string getUpdateTeamName(Team teamName)
{
try
{
using (var entities = new WorkBountyDBEntities())
{
var checkTeamName = entities.Teams.Where(x => x.TeamName == teamName.TeamName).FirstOrDefault();
if (checkTeamName == null)
{
var getTeamName = entities.Teams.Where(x => x.TeamUserInfoID == teamName.TeamUserInfoID).ToList();
getTeamName.ForEach(a =>
{
a.TeamName = teamName.TeamName;
});
entities.SaveChanges();
return("Success");
}
else
{
return("Error");
}
}
}
catch (Exception)
{
return("Error");
}
}
public string ApplyReward(Rewards id)
{
try
{
using (WorkBountyDBEntities entities = new WorkBountyDBEntities())
{
entities.Configuration.ValidateOnSaveEnabled = false;
string remarks = id.Remarks.ToString();
Workitem remark = new Workitem()
{
WorkitemID = id.WorkItemID, Remarks = id.Remarks
};
entities.Workitems.Attach(remark);
entities.Entry(remark).Property(u => u.Remarks).IsModified = true;
entities.SaveChanges();
}
List <WorkItemAssignment> checkUploadedWorkitem = entity.WorkItemAssignments.Where(s => s.WorkItemID == id.WorkItemID && s.UserID == id.UserID).ToList();
foreach (var data in checkUploadedWorkitem)
{
WorkItemAssignment item = entity.WorkItemAssignments.Where(s => s.WorkItemID == id.WorkItemID && s.UserID == id.UserID).FirstOrDefault();
item.IsRewarded = true;
entity.SaveChanges();
}
return("Success");
}
catch (Exception)
{
return("Error");
}
}
public int AddTeamData(Team teamData)
{
try
{
int i = 0;
do
{
var checkTeamName = entity.Teams.Where(s => s.TeamName == teamData.TeamName).FirstOrDefault();
if (checkTeamName == null)
{
var qwe = entity.Teams.Where(s => s.TeamUserInfoID == teamData.TeamUserInfoID).FirstOrDefault();
if (qwe == null)
{
var getID = Convert.ToInt32(teamData.TeamUserInfoID);
entity.Teams.Add(teamData);
entity.SaveChanges();
i++;
return(getID);
}
else
{
teamData.TeamUserInfoID = teamData.TeamUserInfoID + 1;
}
}
else
{
return(0);
}
}while (i == 0);
return(0);
}
catch (Exception)
{
return(0);
}
}
public string AddWorkitem(Workitem addWorkitemData)
{
try
{
if (ModelState.IsValid)
{
entity.Workitems.Add(addWorkitemData);
entity.SaveChanges();
return("Data Successfully saved");
}
else
{
return("Error");
}
}
catch (Exception)
{
return("error");
}
}
public UserInfo AddUserDetails(UserInfo userSignupData)
{
try
{
var checkUserSignupInfo = entity.UserInfoes.Where(a => a.Email.Equals(userSignupData.Email)).FirstOrDefault();
if (checkUserSignupInfo == null)
{
entity.UserInfoes.Add(userSignupData);
entity.SaveChanges();
return(userSignupData);
}
else
{
return(null);
}
}
catch (Exception)
{
return(null);
}
}
public string ApplyReward(Rewards id)
{
try
{
using (WorkBountyDBEntities entities = new WorkBountyDBEntities())
{
entities.Configuration.ValidateOnSaveEnabled = false;
string remarks = id.Remarks.ToString();
Workitem remark = new Workitem() { WorkitemID = id.WorkItemID, Remarks = id.Remarks };
entities.Workitems.Attach(remark);
entities.Entry(remark).Property(u => u.Remarks).IsModified = true;
entities.SaveChanges();
}
List<WorkItemAssignment> checkUploadedWorkitem = entity.WorkItemAssignments.Where(s => s.WorkItemID == id.WorkItemID && s.UserID == id.UserID).ToList();
foreach (var data in checkUploadedWorkitem)
{
WorkItemAssignment item = entity.WorkItemAssignments.Where(s => s.WorkItemID == id.WorkItemID && s.UserID == id.UserID).FirstOrDefault();
item.IsRewarded = true;
entity.SaveChanges();
}
return "Success";
}
catch (Exception)
{
return "Error";
}
}
public string EditWorkitem(Workitem id)
{
try
{
using (var entities = new WorkBountyDBEntities())
{
var getWorkitemData = entities.Workitems.Where(x => x.WorkitemID==id.WorkitemID).ToList();
getWorkitemData.ForEach(a =>
{
if(id.Amount!=null) a.Amount = id.Amount;
a.ModifyBy = id.ModifyBy;
if (id.ModifyDateTime != null) a.ModifyDateTime = id.ModifyDateTime;
a.PublishedTo = id.PublishedTo;
if (id.Summary != null) a.Summary = id.Summary;
if (id.Title != null) a.Title = id.Title;
if (id.ProposedReward != "undefined") a.ProposedReward = id.ProposedReward;
}
);
WorkitemStatu workitemstatusData = new WorkitemStatu();
string statusDescription = "Update";
workitemstatusData.StatusDescription = statusDescription;
workitemstatusData.WorkitemID = id.WorkitemID;
entities.WorkitemStatus.Add(workitemstatusData);
entities.SaveChanges();
WorkitemHistory workitemHistoryData = new WorkitemHistory();
workitemHistoryData.WorkitemID = id.WorkitemID;
workitemHistoryData.UpdatedBy = id.ModifyBy;
workitemHistoryData.UpdatedDateTIme = DateTime.Now;
var getWorkitemStatusID = entities.WorkitemStatus.Where(s => s.WorkitemID == id.WorkitemID).Select(s => s.WorkitemStatusID).FirstOrDefault();
workitemHistoryData.WorkitemStatusID = getWorkitemStatusID;
entities.WorkitemHistories.Add(workitemHistoryData);
entities.SaveChanges();
}
return "Success";
}
catch (Exception)
{
return "Error";
}
}
