public JsonResult RegIdea(IDEA idea, string division, string department, int action)
{
EmployeeManager em = EmployeeManager.GetInstance();
IdeaManager ideaManager = IdeaManager.GetInstance();
int affectedRows = 0;
if (action == 0)
{
affectedRows = ideaManager.Insert(idea.EMP_ID, idea.IDEA_TITLE, idea.DETAIL, idea.QUANTITATIVE, idea.QUALITATIVE);
if (affectedRows > 0)
{
try
{
var emails = em.GetListEmail();
GMailer.GmailUsername = "******";
GMailer.GmailPassword = "******";
GMailer mailer = new GMailer();
mailer.Subject = "[Project Management - New idea uploaded]";
mailer.Body = " Employee " + idea.EMP_ID + " Has uploaded an idea: " + idea.IDEA_TITLE + ".<br> Please check it out at<br> <a href='http://172.25.215.17/idea'>Project Management</a>";
mailer.IsHtml = true;
foreach (var email in emails)
{
mailer.ToEmail = email.EMAIL.Trim();
mailer.Send();
}
}
catch
{
return(Json(affectedRows));
}
}
}
else
{
affectedRows = ideaManager.Update(idea.ID, idea.EMP_ID, idea.IDEA_TITLE, idea.DETAIL, idea.QUANTITATIVE, idea.QUALITATIVE);
}
if (!string.IsNullOrWhiteSpace(division))
{
em.UpdateDivision(idea.EMP_ID, division.Trim());
}
if (!string.IsNullOrWhiteSpace(department))
{
em.UpdateDepartment(idea.EMP_ID, department.Trim());
}
return(Json(affectedRows));
}
//-----------------------------------------------------------------------------------------------------------
public Result SendNewIdea(NewIdeaDto newIdea)
{
Result result = new Result();
using (_db = new IdeaManagmentDatabaseEntities())
{
IDEA idea = new IDEA()
{
USERNAME = newIdea.Username,
TITLE = newIdea.Title,
SAVE_DATE = DateTime.Now,
ADVANTAGES = newIdea.Advantages,
PREREQUISITE = newIdea.Prerequisite,
STEPS = newIdea.Steps,
CURRENT_SITUATION = newIdea.CurrentSituation
};
_db.IDEAS.Add(idea);
_db.SaveChanges();
result.Value = true;
result.Content = "ایده جدید ایجاد شد";
}
return(result);
}
//-----------------------------------------------------------------------------------------------------------
public Result SendNewIdea(NewIdeaDto newIdea)
{
Result result = new Result();
using (_db = new IdeaManagmentDatabaseEntities())
{
IDEA idea = new IDEA()
{
USERNAME = newIdea.USERNAME,
TITLE = newIdea.TITLE,
SAVE_DATE = DateTime.Now,
ADVANTAGES = newIdea.ADVANTAGES,
PREREQUISITE = newIdea.PREREQUISITE,
STEPS = newIdea.STEPS,
CURRENT_SITUATION = newIdea.CURRENT_SITUATION
};
_db.IDEAS.Add(idea);
_db.SaveChanges();
result.value = true;
result.content = "ایده جدید ایجاد شد";
return(result);
}
}
