public void Index_User()
{
var routes = new RouteCollection();
Console.WriteLine("Team Member Listing.\n");
MRPEntities db = new MRPEntities();
HttpContext.Current = DataHelper.SetUserAndPermission();
UserController objUserController = new UserController();
objUserController.ControllerContext = new ControllerContext(MockHelpers.FakeUrlHelper.FakeHttpContext(), new RouteData(), objUserController);
objUserController.Url = MockHelpers.FakeUrlHelper.UrlHelper();
int PlanId = DataHelper.GetPlanId();
Sessions.User.CID = DataHelper.GetClientId(PlanId);
Sessions.PlanId = PlanId;
Sessions.User.ID = DataHelper.GetUserId(PlanId);
var result = objUserController.Index() as ViewResult;
Assert.IsNotNull(result.Model);
var serializedData = new RouteValueDictionary(result.Model);
var resultvalue = serializedData["Count"];
Console.WriteLine(System.Reflection.MethodBase.GetCurrentMethod().Name + "\n The Assert Value resultvalue: " + resultvalue.ToString());
Assert.IsNotNull(resultvalue.ToString());
}
public void Edit_User_Form()
{
var routes = new RouteCollection();
Console.WriteLine("To Edit User Form.\n");
MRPEntities db = new MRPEntities();
HttpContext.Current = DataHelper.SetUserAndPermission();
UserController objUserController = new UserController();
objUserController.ControllerContext = new ControllerContext(MockHelpers.FakeUrlHelper.FakeHttpContext(), new RouteData(), objUserController);
objUserController.Url = MockHelpers.FakeUrlHelper.UrlHelper();
int PlanId = DataHelper.GetPlanId();
Sessions.User.CID = DataHelper.GetClientId(PlanId);
Sessions.PlanId = PlanId;
Sessions.User.ID = DataHelper.GetUserId(PlanId);
var result = objUserController.Edit() as ViewResult;
Assert.IsNotNull(result.ViewName);
var serializedData = new RouteValueDictionary(result.ViewData);
var resultvalue = serializedData["IsUserAdminAuthorized"];
Console.WriteLine(System.Reflection.MethodBase.GetCurrentMethod().Name + "\n The Assert Value resultvalue: " + "UserID: " + resultvalue.ToString());
Assert.IsNotNull(resultvalue.ToString());
}
public void Email_Exist_with_Old_EmailId()
{
var routes = new RouteCollection();
Console.WriteLine("To Check Email Exist or Not with existing emailId.\n");
MRPEntities db = new MRPEntities();
HttpContext.Current = DataHelper.SetUserAndPermission();
UserController objUserController = new UserController();
objUserController.ControllerContext = new ControllerContext(MockHelpers.FakeUrlHelper.FakeHttpContext(), new RouteData(), objUserController);
objUserController.Url = MockHelpers.FakeUrlHelper.UrlHelper();
int PlanId = DataHelper.GetPlanId();
Sessions.User.CID = DataHelper.GetClientId(PlanId);
Sessions.PlanId = PlanId;
Sessions.User.ID = DataHelper.GetUserId(PlanId);
BDSService.BDSServiceClient objBDSServiceClient = new BDSService.BDSServiceClient();
var objUser = objBDSServiceClient.GetTeamMemberDetailsEx(Sessions.User.ID, Sessions.ApplicationId);
if (objUser != null)
{
string Email = objUser.Email;
var result = objUserController.IsEmailExist(Email) as JsonResult;
Console.WriteLine(System.Reflection.MethodBase.GetCurrentMethod().Name + "\n The Assert Value result: " + result.Data);
Assert.IsNotNull(result.Data);
}
}
public void Save_Deploye_Improvement_TacticType()
{
var routes = new RouteCollection();
Console.WriteLine("Save Deployed Status for Improvement Tactic Type.\n");
MRPEntities db = new MRPEntities();
HttpContext.Current = DataHelper.SetUserAndPermission();
BoostController objBoostController = new BoostController();
objBoostController.ControllerContext = new ControllerContext(MockHelpers.FakeUrlHelper.FakeHttpContext(), new RouteData(), objBoostController);
objBoostController.Url = MockHelpers.FakeUrlHelper.UrlHelper();
int ModelId = DataHelper.GetModelId();
Sessions.User.CID = DataHelper.GetClientId(0, ModelId);
ImprovementTacticType ImprovementTacticTypeData = DataHelper.GetImprovementTacticType(Sessions.User.CID);
if (ImprovementTacticTypeData != null)
{
Sessions.User.ID = ImprovementTacticTypeData.CreatedBy;
int improvementId = ImprovementTacticTypeData.ImprovementTacticTypeId;
bool deploye = ImprovementTacticTypeData.IsDeployed;
int UserId = ImprovementTacticTypeData.CreatedBy;
var result = objBoostController.SaveDeployedToIntegrationStatus(improvementId, deploye, UserId) as JsonResult;
var serializedData = new RouteValueDictionary(result.Data);
var resultvalue = serializedData["message"];
Console.WriteLine(System.Reflection.MethodBase.GetCurrentMethod().Name + "\n The Assert Value result.data: " + result.Data);
Assert.IsNotNull(result.Data);
Console.WriteLine(System.Reflection.MethodBase.GetCurrentMethod().Name + "\n The Assert Value resultvalue : " + resultvalue.ToString());
Assert.IsNotNull(resultvalue.ToString());
}
}
public void Check_Current_Password()
{
var routes = new RouteCollection();
Console.WriteLine("Save Budget Allocation.\n");
MRPEntities db = new MRPEntities();
HttpContext.Current = DataHelper.SetUserAndPermission();
UserController objUserController = new UserController();
objUserController.ControllerContext = new ControllerContext(MockHelpers.FakeUrlHelper.FakeHttpContext(), new RouteData(), objUserController);
objUserController.Url = MockHelpers.FakeUrlHelper.UrlHelper();
int PlanId = DataHelper.GetDeletedPlanId();
Sessions.User.CID = DataHelper.GetClientId(PlanId);
Sessions.PlanId = PlanId;
Sessions.User.ID = DataHelper.GetUserId(PlanId);
string currentPassword = "******";
var result = objUserController.CheckCurrentPassword(currentPassword) as JsonResult;
Console.WriteLine(System.Reflection.MethodBase.GetCurrentMethod().Name + "\n The Assert Value result: " + result.Data);
Assert.IsNotNull(result.Data);
}
public void SaveAlertrule()
{
MRPEntities db = new MRPEntities();
HttpContext.Current = DataHelper.SetUserAndPermission();
UserController objUserController = new UserController();
objUserController.ControllerContext = new ControllerContext(MockHelpers.FakeUrlHelper.FakeHttpContext(), new RouteData(), objUserController);
objUserController.Url = MockHelpers.FakeUrlHelper.UrlHelper();
AlertRuleDetail objRule = new AlertRuleDetail();
objRule.RuleId = 0;
objRule.EntityID = Convert.ToString(DataHelper.GetPlanId());
objRule.RuleSummary = "<h4> Responses are less than 75% of Goal</h4><br/><span>Start at 50% completion</span><span>Repeat Daily</span>";
objRule.EntityType = "Plan";
objRule.Indicator = "MQL";
objRule.IndicatorComparision = "LT";
objRule.IndicatorGoal = "25";
objRule.CompletionGoal = "25";
objRule.Frequency = "Daily";
var result = objUserController.SaveAlertRule(objRule, 0) as JsonResult;
Console.WriteLine(System.Reflection.MethodBase.GetCurrentMethod().Name + " \n The Assert Value result : " + result.Data);
Assert.IsNotNull(result.Data);
}
public void DeleteAlertrule()
{
MRPEntities db = new MRPEntities();
HttpContext.Current = DataHelper.SetUserAndPermission();
UserController objUserController = new UserController();
objUserController.ControllerContext = new ControllerContext(MockHelpers.FakeUrlHelper.FakeHttpContext(), new RouteData(), objUserController);
objUserController.Url = MockHelpers.FakeUrlHelper.UrlHelper();
AlertRuleDetail objRule = new AlertRuleDetail();
int ruleId = 0;
int entityid = (DataHelper.GetPlanId());
objRule.RuleId = 0;
objRule.EntityID = Convert.ToString(entityid);
objRule.RuleSummary = "test alert rule";
objRule.EntityType = "Plan";
objRule.Indicator = "MQL";
objRule.IndicatorComparision = "LT";
objRule.IndicatorGoal = "25";
objRule.CompletionGoal = "25";
objRule.Frequency = "Daily";
var result = objUserController.SaveAlertRule(objRule, 0) as JsonResult;
var rules = db.Alert_Rules.Where(a => a.RuleSummary == "test alert rule" && a.EntityId == entityid).Select(a => a).FirstOrDefault();
if (rules != null)
{
ruleId = rules.RuleId;
}
result = objUserController.DeleteAlertRule(ruleId) as JsonResult;
Console.WriteLine(System.Reflection.MethodBase.GetCurrentMethod().Name + " \n The Assert Value result : " + result.Data);
Assert.IsNotNull(result.Data);
}
public void Save_Improvement_TacticType_New()
{
var routes = new RouteCollection();
Console.WriteLine("Save Improvement Tactic Type Details New Existing Tactic Type.\n");
MRPEntities db = new MRPEntities();
HttpContext.Current = DataHelper.SetUserAndPermission();
BoostController objBoostController = new BoostController();
objBoostController.ControllerContext = new ControllerContext(MockHelpers.FakeUrlHelper.FakeHttpContext(), new RouteData(), objBoostController);
objBoostController.Url = MockHelpers.FakeUrlHelper.UrlHelper();
int ModelId = DataHelper.GetModelId();
Sessions.User.CID = DataHelper.GetClientId(0, ModelId);
Sessions.User.ID = DataHelper.GetUserId(0, ModelId);
int improvementId = 0;
string improvementDetails = "[{\"StageId\":\"106\",\"StageType\":\"SV\",\"Value\":\"5\"}]";
bool status = true;
double cost = 25000;
string desc = "";
string title = "New Improvement Tactic Type Test 1234";
bool deployToIntegrationStatus = false;
int UserId = Sessions.User.ID;
var result = objBoostController.saveImprovementTacticData(improvementId, improvementDetails, status, cost, desc, title, deployToIntegrationStatus, UserId) as JsonResult;
Console.WriteLine(System.Reflection.MethodBase.GetCurrentMethod().Name + " \n The Assert Value result.Data: " + result.Data);
Assert.IsNotNull(result.Data);
}
public void Assign_User()
{
var routes = new RouteCollection();
Console.WriteLine("Assign Other Application User.\n");
MRPEntities db = new MRPEntities();
HttpContext.Current = DataHelper.SetUserAndPermission();
UserController objUserController = new UserController();
objUserController.ControllerContext = new ControllerContext(MockHelpers.FakeUrlHelper.FakeHttpContext(), new RouteData(), objUserController);
objUserController.Url = MockHelpers.FakeUrlHelper.UrlHelper();
int PlanId = DataHelper.GetPlanId();
Sessions.User.CID = DataHelper.GetClientId(PlanId);
Sessions.PlanId = PlanId;
Sessions.User.ID = DataHelper.GetUserId(PlanId);
BDSService.BDSServiceClient objBDSServiceClient = new BDSService.BDSServiceClient();
var objUser = objBDSServiceClient.GetTeamMemberDetailsEx(Sessions.User.ID, Sessions.ApplicationId);
if (objUser != null)
{
int userId = objUser.ID;
string RoleId = objUser.RoleId.ToString();
var result = objUserController.AssignUser(userId, RoleId) as JsonResult;
Console.WriteLine(System.Reflection.MethodBase.GetCurrentMethod().Name + "\n The Assert Value result: " + result.Data);
Assert.IsNotNull(result.Data);
}
}
public void Save_Improvement_TacticType_Old()
{
var routes = new RouteCollection();
Console.WriteLine("Save Improvement Tactic Type Details for Existing Tactic Type.\n");
MRPEntities db = new MRPEntities();
HttpContext.Current = DataHelper.SetUserAndPermission();
BoostController objBoostController = new BoostController();
objBoostController.ControllerContext = new ControllerContext(MockHelpers.FakeUrlHelper.FakeHttpContext(), new RouteData(), objBoostController);
objBoostController.Url = MockHelpers.FakeUrlHelper.UrlHelper();
int ModelId = DataHelper.GetModelId();
Sessions.User.CID = DataHelper.GetClientId(0, ModelId);
ImprovementTacticType ImprovementTacticTypeData = DataHelper.GetImprovementTacticType(Sessions.User.CID);
if (ImprovementTacticTypeData != null)
{
int improvementId = ImprovementTacticTypeData.ImprovementTacticTypeId;
string improvementDetails = "[{\"StageId\":\"106\",\"StageType\":\"SV\",\"Value\":\"5\"}]";
bool status = ImprovementTacticTypeData.IsDeleted;
double cost = ImprovementTacticTypeData.Cost;
string desc = ImprovementTacticTypeData.Description;
string title = ImprovementTacticTypeData.Title;
bool deployToIntegrationStatus = ImprovementTacticTypeData.IsDeployedToIntegration;
int UserId = ImprovementTacticTypeData.CreatedBy;
var result = objBoostController.saveImprovementTacticData(improvementId, improvementDetails, status, cost, desc, title, deployToIntegrationStatus, UserId) as JsonResult;
Console.WriteLine(System.Reflection.MethodBase.GetCurrentMethod().Name + "\n The Assert Value result.Data: " + result.Data);
Assert.IsNotNull(result.Data);
}
}
public void Email_Exist_with_New_EmailId()
{
var routes = new RouteCollection();
Console.WriteLine("To Check Email Exist or Not with new emailId.\n");
MRPEntities db = new MRPEntities();
HttpContext.Current = DataHelper.SetUserAndPermission();
UserController objUserController = new UserController();
objUserController.ControllerContext = new ControllerContext(MockHelpers.FakeUrlHelper.FakeHttpContext(), new RouteData(), objUserController);
objUserController.Url = MockHelpers.FakeUrlHelper.UrlHelper();
int PlanId = DataHelper.GetDeletedPlanId();
Sessions.User.CID = DataHelper.GetClientId(PlanId);
Sessions.PlanId = PlanId;
Sessions.User.ID = DataHelper.GetUserId(PlanId);
string Email = "*****@*****.**";
var result = objUserController.IsEmailExist(Email) as JsonResult;
Console.WriteLine(System.Reflection.MethodBase.GetCurrentMethod().Name + "\n The Assert Value result: " + result.Data);
Assert.IsNotNull(result.Data);
}
public void ResetPassword_Post()
{
var routes = new RouteCollection();
Console.WriteLine("To Reset Password Post.\n");
MRPEntities db = new MRPEntities();
HttpContext.Current = DataHelper.SetUserAndPermission();
BDSService.BDSServiceClient objBDSServiceClient = new BDSService.BDSServiceClient();
LoginController objLoginController = new LoginController();
objLoginController.ControllerContext = new ControllerContext(MockHelpers.FakeUrlHelper.FakeHttpContext(), new RouteData(), objLoginController);
objLoginController.Url = MockHelpers.FakeUrlHelper.UrlHelper();
int PlanId = DataHelper.GetPlanId();
Sessions.User.CID = DataHelper.GetClientId(PlanId);
Sessions.User.ID = DataHelper.GetUserId(PlanId);
ResetPasswordModel form = new ResetPasswordModel();
form.UserId = Sessions.User.ID;
form.NewPassword = Convert.ToString(ConfigurationManager.AppSettings["Password"]);
form.ConfirmNewPassword = Convert.ToString(ConfigurationManager.AppSettings["Password"]);
var result = objLoginController.ResetPassword(form) as ViewResult;
var serializedData = new RouteValueDictionary(result.Model);
var resultvalue = serializedData["UserId"];
Console.WriteLine(System.Reflection.MethodBase.GetCurrentMethod().Name + " : Pass \n The Assert Value: " + resultvalue.ToString());
Assert.AreEqual(Sessions.User.ID.ToString(), resultvalue.ToString());
}
public static void SaveIntegrationInstanceLogDetails(int _entityId, int?IntegrationInstanceLogId, Enums.MessageOperation MsgOprtn, string functionName, Enums.MessageLabel MsgLabel, string logMsg)
{
string logDescription = string.Empty, preMessage = string.Empty;
try
{
if (MsgOprtn.Equals(Enums.MessageOperation.None))
{
preMessage = (MsgLabel.Equals(Enums.MessageLabel.None) ? string.Empty : MsgLabel.ToString() + " : ") + "---"; // if message operation "None" than Message prefix should be "---" ex: .
}
else
{
preMessage = (MsgLabel.Equals(Enums.MessageLabel.None) ? string.Empty : (MsgOprtn.Equals(Enums.MessageOperation.Start)) ? string.Empty : (MsgLabel.ToString() + " : ")) + MsgOprtn.ToString() + " :";
}
logDescription = preMessage + " " + functionName + " : " + logMsg;
using (MRPEntities db = new MRPEntities())
{
IntegrationInstanceLogDetail objLogDetails = new IntegrationInstanceLogDetail();
objLogDetails.EntityId = _entityId;
objLogDetails.IntegrationInstanceLogId = IntegrationInstanceLogId;
objLogDetails.LogTime = System.DateTime.Now;
objLogDetails.LogDescription = logDescription;
db.Entry(objLogDetails).State = System.Data.EntityState.Added;
db.SaveChanges();
}
}
catch (System.Exception ex)
{
throw ex;
}
}
public void Get_ManagersList_With_Passing_All_Parameter()
{
var routes = new RouteCollection();
Console.WriteLine("To Get Managers List with passing All Parameter.\n");
MRPEntities db = new MRPEntities();
HttpContext.Current = DataHelper.SetUserAndPermission();
UserController objUserController = new UserController();
objUserController.ControllerContext = new ControllerContext(MockHelpers.FakeUrlHelper.FakeHttpContext(), new RouteData(), objUserController);
objUserController.Url = MockHelpers.FakeUrlHelper.UrlHelper();
objUserController.Url = new UrlHelper(
new RequestContext(
objUserController.HttpContext, new RouteData()
),
routes
);
int PlanId = DataHelper.GetPlanId();
Sessions.User.CID = DataHelper.GetClientId(PlanId);
Sessions.PlanId = PlanId;
Sessions.User.ID = DataHelper.GetUserId(PlanId);
int UserId = Sessions.User.ID;
int ClientId = Sessions.User.CID;
var result = objUserController.GetManagers(ClientId, UserId) as JsonResult;
Assert.IsNotNull(result.Data);
var serializedData = new RouteValueDictionary(result.Data);
var resultvalue = serializedData["Count"];
Console.WriteLine(System.Reflection.MethodBase.GetCurrentMethod().Name + "\n The Assert Value resultvalue: " + resultvalue.ToString());
Assert.IsNotNull(resultvalue.ToString());
}
public void Login_View_With_Error_Message()
{
var routes = new RouteCollection();
Console.WriteLine("To Create Login View.\n");
MRPEntities db = new MRPEntities();
HttpContext.Current = DataHelper.SetUserAndPermission();
LoginController objLoginController = new LoginController();
objLoginController.ControllerContext = new ControllerContext(MockHelpers.FakeUrlHelper.FakeHttpContext(), new RouteData(), objLoginController);
objLoginController.Url = MockHelpers.FakeUrlHelper.UrlHelper();
int PlanId = DataHelper.GetPlanId();
Sessions.User.CID = DataHelper.GetClientId(PlanId);
MockHelpers.MockHelpers.TestTempDataHttpContext tempDataHttpContext = new MockHelpers.MockHelpers.TestTempDataHttpContext();
objLoginController.TempData["ErrorMessage"] = "Unit";
var result = objLoginController.Index() as ViewResult;
var serializedData = new RouteValueDictionary(result.ViewData);
var resultvalue = serializedData["ApplicationReleaseVersion"];
Console.WriteLine(System.Reflection.MethodBase.GetCurrentMethod().Name + " : Pass \n The Assert Value resultvalue: " + resultvalue.ToString());
Assert.IsNotNull(resultvalue.ToString());
Console.WriteLine(System.Reflection.MethodBase.GetCurrentMethod().Name + " : Pass \n The Assert Value ViewName: " + result.ViewName);
Assert.IsNotNull(result.ViewName);
}
public void Get_Detail_Improvement_TacticType_Boost_for_New_TacticType()
{
var routes = new RouteCollection();
Console.WriteLine("Get Deatail Improvement Tactic Type for Boost.\n");
MRPEntities db = new MRPEntities();
HttpContext.Current = DataHelper.SetUserAndPermission();
BoostController objBoostController = new BoostController();
objBoostController.ControllerContext = new ControllerContext(MockHelpers.FakeUrlHelper.FakeHttpContext(), new RouteData(), objBoostController);
objBoostController.Url = MockHelpers.FakeUrlHelper.UrlHelper();
int ModelId = DataHelper.GetModelId();
Sessions.User.CID = DataHelper.GetClientId(0, ModelId);
var result = objBoostController.DetailImprovementTacticData(0) as PartialViewResult;
Assert.IsNotNull(result.ViewName);
var serializedData = new RouteValueDictionary(result.ViewData);
var resultvalue = serializedData["Title"];
var resultvalue1 = serializedData["CanDelete"];
var resultvalue2 = serializedData["IsCreated"];
Console.WriteLine(System.Reflection.MethodBase.GetCurrentMethod().Name + "\n The Assert Value: " + " Title: " + resultvalue.ToString());
Console.WriteLine(System.Reflection.MethodBase.GetCurrentMethod().Name + "\n The Assert Value: " + " CanDelete: " + resultvalue1.ToString());
Console.WriteLine(System.Reflection.MethodBase.GetCurrentMethod().Name + "\n The Assert Value: " + " IsCreated: " + resultvalue2.ToString());
Assert.IsNotNull(resultvalue.ToString());
Assert.IsNotNull(resultvalue1.ToString());
Assert.IsNotNull(resultvalue2.ToString());
}
// Added By Viral
// Desc :: Get SFDC Field Mappings list.
public DataSet GetSFDCFieldMappings(int clientId, int IntegrationTypeId, int IntegrationInstanceID, bool isSFDCSyncMarketo)
{
string clientid = clientId.ToString();
DataTable datatable = new DataTable();
DataSet dataset = new DataSet();
MRPEntities db = new MRPEntities();
///If connection is closed then it will be open
var Connection = db.Database.Connection as SqlConnection;
if (Connection.State == System.Data.ConnectionState.Closed)
{
Connection.Open();
}
SqlCommand command = null;
command = new SqlCommand("GetSFDCFieldMappings", Connection);
using (command)
{
command.CommandType = CommandType.StoredProcedure;
command.Parameters.AddWithValue("@clientId", clientid);
command.Parameters.AddWithValue("@integrationTypeId", IntegrationTypeId);
command.Parameters.AddWithValue("@id", IntegrationInstanceID);
command.Parameters.AddWithValue("@isSFDCMarketoIntegration", isSFDCSyncMarketo);
SqlDataAdapter adp = new SqlDataAdapter(command);
command.CommandTimeout = 0;
adp.Fill(dataset);
if (Connection.State == System.Data.ConnectionState.Open)
{
Connection.Close();
}
}
return(dataset);
}
/// <summary>
/// Function to retrieve comma separated list of custom restrictions for Search filter
/// </summary>
/// <param name="userId">user id</param>
/// <returns></returns>
//Get tactic list for report
public static List <Plan_Campaign_Program_Tactic> GetTacticForReporting(bool isBugdet = false)
{
MRPEntities db = new MRPEntities();
//// Getting current year's all published plan for all custom fields of clientid of director.
List <Plan_Campaign_Program_Tactic> tacticList = new List <Plan_Campaign_Program_Tactic>();
List <int> planIds = new List <int>();
List <int> ownerIds = new List <int>();
List <int> TactictypeIds = new List <int>();
if (Sessions.ReportPlanIds != null && Sessions.ReportPlanIds.Count > 0)
{
planIds = Sessions.ReportPlanIds;
}
//// Get Tactic list.
if (isBugdet)
{
tacticList = db.Plan_Campaign_Program_Tactic.Where(tactic => tactic.IsDeleted == false &&
planIds.Contains(tactic.Plan_Campaign_Program.Plan_Campaign.PlanId)
).ToList();
}
else
{
List <string> tacticStatus = Common.GetStatusListAfterApproved();
tacticList = db.Plan_Campaign_Program_Tactic.Where(tactic => tactic.IsDeleted == false &&
tacticStatus.Contains(tactic.Status) &&
planIds.Contains(tactic.Plan_Campaign_Program.Plan_Campaign.PlanId)
).ToList();
}
//Added by Komal Rawal
if (Sessions.ReportOwnerIds != null && Sessions.ReportOwnerIds.Count > 0)
{
ownerIds = Sessions.ReportOwnerIds.Select(owner => owner).ToList();
tacticList = tacticList.Where(tactic => ownerIds.Contains(tactic.CreatedBy)
).ToList();
}
if (Sessions.ReportTacticTypeIds != null && Sessions.ReportTacticTypeIds.Count > 0)
{
TactictypeIds = Sessions.ReportTacticTypeIds;
tacticList = tacticList.Where(tactic => TactictypeIds.Contains(tactic.TacticTypeId)
).ToList();
}
//End
if (Sessions.ReportCustomFieldIds != null && Sessions.ReportCustomFieldIds.Count() > 0)
{
List <int> tacticids = tacticList.Select(tactic => tactic.PlanTacticId).ToList();
List <CustomFieldFilter> lstCustomFieldFilter = Sessions.ReportCustomFieldIds.ToList();
tacticids = Common.GetTacticBYCustomFieldFilter(lstCustomFieldFilter, tacticids);
tacticList = tacticList.Where(tactic => tacticids.Contains(tactic.PlanTacticId)).ToList();
}
return(tacticList);
}
public void ExecuteStoreProcedure(MRPEntities context, string storeProcName, params object[] parameters)
{
string command = "EXEC " + storeProcName;
foreach (var parameter in parameters)
{
command += " @" + parameter + ",";
}
command = command.TrimEnd(',');
context.Database.ExecuteSqlCommand(command, parameters);
context.SaveChanges();
}
/// <summary>
/// To update log in IntegrationInstanceSection
/// Added by Dharmraj on 18-8-2014, PL#684
/// </summary>
/// <param name="IntegrationInstanceSectionId"></param>
/// <param name="Status"></param>
/// <param name="SyncEnd"></param>
/// <param name="Description"></param>
public static void UpdateIntegrationInstanceSection(int IntegrationInstanceSectionId, StatusResult Status, string Description)
{
using (MRPEntities db = new MRPEntities())
{
IntegrationInstanceSection objIntegrationInstanceSection = db.IntegrationInstanceSections.FirstOrDefault(i => i.IntegrationInstanceSectionId == IntegrationInstanceSectionId);
objIntegrationInstanceSection.Status = Status.ToString();
objIntegrationInstanceSection.Description = Description;
objIntegrationInstanceSection.SyncEnd = DateTime.Now;
db.Entry(objIntegrationInstanceSection).State = EntityState.Modified;
db.SaveChanges();
}
}
/// <summary>
/// Created By : Viral Kadiya
/// Created Date : 27/02/2014
/// Desciption : Calculate the ActualCost of the tactic list
/// </summary>
/// <param name="PlanTacticId"></param>
/// <returns>Actual cost of a Tactic</returns>
public static Dictionary <int, string> CalculateActualCostTacticslist(List <int> PlanTacticIds)
{
string cost = "Cost";
string strActualCost = "0";
Dictionary <int, string> dicTactic_ActualCost = new Dictionary <int, string>();
List <int> lstLineItems = new List <int>();
List <Plan_Campaign_Program_Tactic_LineItem_Actual> lstLineItemActuals = new List <Plan_Campaign_Program_Tactic_LineItem_Actual>();
List <Plan_Campaign_Program_Tactic_Actual> lstPlanTacticsActuals = new List <Plan_Campaign_Program_Tactic_Actual>();
try
{
using (MRPEntities db = new MRPEntities())
{
List <Plan_Campaign_Program_Tactic_LineItem> tblLineItems = db.Plan_Campaign_Program_Tactic_LineItem.Where(li => PlanTacticIds.Contains(li.PlanTacticId) && li.IsDeleted.Equals(false)).ToList();
/// Added By Bhavesh Date: 21/07/2015 - remove tolist from actual table
List <int> lineItemIds = tblLineItems.Select(lineitem => lineitem.PlanLineItemId).ToList();
List <Plan_Campaign_Program_Tactic_LineItem_Actual> tblLineItemActuals = db.Plan_Campaign_Program_Tactic_LineItem_Actual.Where(lia => lineItemIds.Contains(lia.PlanLineItemId)).ToList();
List <Plan_Campaign_Program_Tactic_Actual> tblPlanTacticsActuals = db.Plan_Campaign_Program_Tactic_Actual.Where(pta => PlanTacticIds.Contains(pta.PlanTacticId) && pta.StageTitle.Equals(cost)).ToList();
foreach (int keyTactic in PlanTacticIds)
{
lstLineItems = new List <int>();
lstLineItems = tblLineItems.Where(line => line.PlanTacticId.Equals(keyTactic)).Select(li => li.PlanLineItemId).ToList();
if (lstLineItems.Count > 0)
{
lstLineItemActuals = new List <Plan_Campaign_Program_Tactic_LineItem_Actual>();
lstLineItemActuals = tblLineItemActuals.Where(lia => lstLineItems.Contains(lia.PlanLineItemId)).ToList();
if (lstLineItemActuals.Count > 0)
{
var actualCostSum = lstLineItemActuals.Sum(lia => lia.Value);
strActualCost = actualCostSum.ToString();
}
}
else
{
lstPlanTacticsActuals = new List <Plan_Campaign_Program_Tactic_Actual>();
lstPlanTacticsActuals = tblPlanTacticsActuals.Where(pta => pta.PlanTacticId.Equals(keyTactic)).ToList();
if (lstPlanTacticsActuals.Count > 0)
{
var actualCostSum = lstPlanTacticsActuals.Sum(pta => pta.Actualvalue);
strActualCost = actualCostSum.ToString();
}
}
dicTactic_ActualCost.Add(keyTactic, strActualCost);
}
}
return(dicTactic_ActualCost);
}
catch
{
return(dicTactic_ActualCost);
}
}
/// <summary>
/// </summary>
public static string GetClosedWon(int _clientId)
{
string ClosedWonTitle = ClosedWon;
using (MRPEntities db = new MRPEntities())
{
ClosedWonTitle = db.Stages.FirstOrDefault(i => i.ClientId == _clientId && !i.IsDeleted && i.Code == StageCW).Title;
if (string.IsNullOrEmpty(ClosedWonTitle))
{
ClosedWonTitle = ClosedWon;
}
}
return(ClosedWonTitle);
}
public void SaveColumnview_withnullvalue()
{
MRPEntities db = new MRPEntities();
HttpContext.Current = DataHelper.SetUserAndPermission();
ColumnViewController objUserController = new ColumnViewController();
objUserController.ControllerContext = new ControllerContext(MockHelpers.FakeUrlHelper.FakeHttpContext(), new RouteData(), objUserController);
objUserController.Url = MockHelpers.FakeUrlHelper.UrlHelper();
var result = objUserController.SaveColumnView(null) as JsonResult;
Console.WriteLine(System.Reflection.MethodBase.GetCurrentMethod().Name + " \n The Assert Value result : " + result.Data);
Assert.IsNotNull(result.Data);
}
public void Load_Session_Warning()
{
var routes = new RouteCollection();
Console.WriteLine("Load Session Warning.\n");
MRPEntities db = new MRPEntities();
HttpContext.Current = DataHelper.SetUserAndPermission();
CommonController objCommonController = new CommonController();
objCommonController.ControllerContext = new ControllerContext(MockHelpers.FakeUrlHelper.FakeHttpContext(), new RouteData(), objCommonController);
objCommonController.Url = MockHelpers.FakeUrlHelper.UrlHelper();
var result = objCommonController.LoadSessionWarning() as PartialViewResult;
Console.WriteLine(System.Reflection.MethodBase.GetCurrentMethod().Name + "\n The Assert Value result.ViewName: " + result.ViewName);
Assert.IsNotNull(result.ViewName);
}
public void SaveLastSetOfViews_With_Null_CustomFields_Tactictypeid()
{
Console.WriteLine("To Save last set data with null CustomFields and tactictypeid.\n");
MRPEntities db = new MRPEntities();
HttpContext.Current = DataHelper.SetUserAndPermission();
FilterController objFilterController = new FilterController();
var result = objFilterController.SaveLastSetofViews(null, null, null, null, null, null, null, null) as JsonResult;
Console.WriteLine(System.Reflection.MethodBase.GetCurrentMethod().Name + " \n The Assert Value result.Data: " + result.Data);
Assert.IsNotNull(result.Data);
Console.WriteLine(System.Reflection.MethodBase.GetCurrentMethod().Name + " \n The Assert Value ViewName: " + result.GetValue("ViewName"));
Assert.AreEqual(null, result.GetValue("ViewName"));
}
public void GetAttributeList_Budget()
{
MRPEntities db = new MRPEntities();
HttpContext.Current = DataHelper.SetUserAndPermission();
ColumnViewController objUserController = new ColumnViewController();
objUserController.ControllerContext = new ControllerContext(MockHelpers.FakeUrlHelper.FakeHttpContext(), new RouteData(), objUserController);
objUserController.Url = MockHelpers.FakeUrlHelper.UrlHelper();
var result = objUserController.GetAttributeList_ColumnView(false) as PartialViewResult;
Console.WriteLine(System.Reflection.MethodBase.GetCurrentMethod().Name + " \n The Assert Value result : " + result.ViewName);
Assert.IsNotNull(result.Model);
Assert.AreEqual("_AddColumnView", result.ViewName);
}
/// <summary>
/// Function to retrieve comma separated list of custom restrictions for Search filter
/// </summary>
/// <param name="userId">user id</param>
/// <returns></returns>
public static string GetSearchFilterForCustomRestriction(int userId)
{
StringBuilder sbCustomRestrictions = new StringBuilder(string.Empty);
using (MRPEntities objDB = new MRPEntities())
{
var lstCustomRestriction = objDB.CustomRestrictions.Where(customRestriction => customRestriction.UserId == userId).Select(customRestriction => customRestriction).ToList();
if (lstCustomRestriction.Count > 0)
{
lstCustomRestriction.ForEach(customRestriction => sbCustomRestrictions.Append(customRestriction.CustomFieldId + "_" + customRestriction.CustomFieldOptionId + ","));
return(sbCustomRestrictions.ToString().TrimEnd(",".ToCharArray()));
}
}
return(sbCustomRestrictions.ToString());
}
public void SearchListEntity()
{
MRPEntities db = new MRPEntities();
HttpContext.Current = DataHelper.SetUserAndPermission();
UserController objUserController = new UserController();
objUserController.ControllerContext = new ControllerContext(MockHelpers.FakeUrlHelper.FakeHttpContext(), new RouteData(), objUserController);
objUserController.Url = MockHelpers.FakeUrlHelper.UrlHelper();
string SearchTerm = "plan test";
var result = objUserController.ListEntity(SearchTerm) as JsonResult;
Console.WriteLine(System.Reflection.MethodBase.GetCurrentMethod().Name + " \n The Assert Value result : " + result.Data);
Assert.IsNotNull(result.Data);
}
public void Edit_User()
{
var routes = new RouteCollection();
Console.WriteLine("To Edit User.\n");
MRPEntities db = new MRPEntities();
HttpContext.Current = DataHelper.SetUserAndPermission();
UserController objUserController = new UserController();
objUserController.ControllerContext = new ControllerContext(MockHelpers.FakeUrlHelper.FakeHttpContext(), new RouteData(), objUserController);
objUserController.Url = MockHelpers.FakeUrlHelper.UrlHelper();
objUserController.Url = new UrlHelper(
new RequestContext(
objUserController.HttpContext, new RouteData()
),
routes
);
//objUserController.ControllerContext.HttpContext.Request.UrlReferrer.AbsolutePath = "";
int PlanId = DataHelper.GetPlanId();
Sessions.User.CID = DataHelper.GetClientId(PlanId);
Sessions.PlanId = PlanId;
Sessions.User.ID = DataHelper.GetUserId(PlanId);
UserModel form = new UserModel();
form.DisplayName = "Test@Hive9";
form.FirstName = "Test";
form.LastName = "Hive9";
form.Email = "*****@*****.**";
form.Password = "******";
form.ConfirmPassword = "******";
form.RoleTitle = "Admin";
form.ClientId = Sessions.User.CID;
form.Client = Sessions.User.Client.ToString();
form.ManagerName = "Hive9";
form.JobTitle = "Admin";
FormCollection formCollection = new FormCollection();
formCollection.Add("UserId", "UserId");
var result = objUserController.Edit(form, null, formCollection) as ActionResult;
Console.WriteLine(System.Reflection.MethodBase.GetCurrentMethod().Name + "\n The Assert Value result: " + result);
Assert.IsNotNull(result);
}
public void ForgotPassword_View()
{
var routes = new RouteCollection();
Console.WriteLine("To Forgot Password View.\n");
MRPEntities db = new MRPEntities();
HttpContext.Current = DataHelper.SetUserAndPermission();
LoginController objLoginController = new LoginController();
objLoginController.ControllerContext = new ControllerContext(MockHelpers.FakeUrlHelper.FakeHttpContext(), new RouteData(), objLoginController);
objLoginController.Url = MockHelpers.FakeUrlHelper.UrlHelper();
var result = objLoginController.ForgotPassword() as ViewResult;
Console.WriteLine(System.Reflection.MethodBase.GetCurrentMethod().Name + " : Pass \n The Assert Value ViewName: " + result.ViewName);
Assert.IsNotNull(result.ViewName);
}
