public JsonResult GetFiori_Bar()
{
InstanceId = Guid.Parse(Session["InstanceId"].ToString());
GeneralList sP_ = _Base.sP_GetFiori_Bar(InstanceId);
return(Json(sP_, JsonRequestBehavior.AllowGet));
}
public JsonResult GetSimplificationReport_Bar(string LOB)
{
InstanceId = Guid.Parse(Session["InstanceId"].ToString());
GeneralList sP_ = _Base.sP_SimplificationReport_Bar(LOB, InstanceId);
return(Json(sP_, JsonRequestBehavior.AllowGet));
}
public JsonResult GetFioriAppsReportt_Bar(string Input)
{
InstanceId = Guid.Parse(Session["InstanceId"].ToString());
GeneralList sP_ = _Base.sP_GetSAPFioriAppsReport_Bar(Input, InstanceId);
return(Json(sP_, JsonRequestBehavior.AllowGet));
}
public JsonResult GetActivitiesReport_Bar(string Phase, string condition)
{
InstanceId = Guid.Parse(Session["InstanceId"].ToString());
GeneralList sP_ = _Base.sP_GetActivitiesReport_Bar(Phase, condition, InstanceId);
return(Json(sP_, JsonRequestBehavior.AllowGet));
}
internal List <SRL_Ingredient> GetGeneralList(int userId, ListTypes listType)
{
using (DataContext)
{
try
{
GeneralList generalList = (from p in DataContext.GeneralLists
where
p.CREATED_BY == userId && p.ACTIVE == true &&
p.LIST_TYPE == (int)listType
select p).Single();
if (generalList != null)
{
List <SRL_Ingredient> ingredients = (from p in DataContext.GeneralListDetails
where p.LIST_ID == generalList.ID
select
new SRL_Ingredient
{
IngredientId = p.ID,
FoodName = p.ITEM_NAME,
CompleteValue = p.COMPLETE_QUANTITY,
Quantity = decimal.Parse(p.COMPLETE_QUANTITY),
MeasurementUnitId = p.MEASUREMENT_UNIT_ID,
MeasurementUnitName = p.MEASUREMENT_UNIT
}).ToList();
return(ingredients);
}
return(null);
}
catch (Exception)
{
return(null);
}
}
}
private void LoadMainCombos() {
RecordingBook book = base.Recording.RecordingBook;
RecorderOffice office = base.Recording.RecordingBook.RecorderOffice;
HtmlSelectContent.LoadCombo(this.cboNotaryDocIssuePlace, office.GetNotaryOfficePlaces(), "Id", "Name",
"( Seleccionar )", String.Empty, "No consta");
HtmlSelectContent.LoadCombo(this.cboPrivateDocIssuePlace, office.GetPrivateDocumentIssuePlaces(), "Id", "Name",
"( Seleccionar )", String.Empty, "No consta");
HtmlSelectContent.LoadCombo(this.cboJudicialDocIssuePlace, office.GetJudicialDocumentIssuePlaces(), "Id", "Name",
"( Seleccionar )", String.Empty, "No consta");
ObjectList<Contact> signers = office.GetPropertyTitleSigners(book.RecordingsControlTimePeriod);
HtmlSelectContent.LoadCombo(this.cboPropTitleDocIssuedBy, signers, "Id", "FullName",
"( Seleccionar al C. Funcionario Público )", String.Empty, "No consta o no se puede determinar");
HtmlSelectContent.LoadCombo(this.cboPropTitleIssueOffice, office.GetPropertyTitleOffices(), "Id", "Alias",
"( Seleccionar )", String.Empty, "No consta");
GeneralList listType = GeneralList.Parse("PrivateContract.WitnessPosition.List");
ObjectList<TypeAssociationInfo> witnessRole = listType.GetTypeRelationItems<TypeAssociationInfo>();
HtmlSelectContent.LoadCombo(this.cboPrivateDocMainWitnessPosition, witnessRole, "Id", "DisplayName",
"( Seleccionar )", "No consta", String.Empty);
}
public JsonResult LoadInstance(string ProjectId)
{
GeneralList sP_ = _Base.GetPerConvertionUploadInstance(ProjectId);
SelectList items = new SelectList(sP_._List, "Value", "Name");
return(Json(items, JsonRequestBehavior.AllowGet));
}
public ActionResult PreConvertion_Upload()
{
int userType = 0;
if (User.IsInRole("Admin"))
{
userType = 1;
}
else if (User.IsInRole("Consultant"))
{
userType = 2;
}
else if (User.IsInRole("Customer"))
{
userType = 3;
}
GeneralList sP_ = _Base.spCustomerDropdown(Session["loginid"].ToString(), userType);
ViewBag.Customer = new SelectList(sP_._List, "Value", "Name");
List <SelectListItem> Project = new List <SelectListItem>();
var query = from u in db.Projects where (u.isActive == true) select u;
if (query.Count() > 0)
{
foreach (var v in query)
{
Project.Add(new SelectListItem {
Text = v.Project_Name, Value = v.Project_Id.ToString()
});
}
}
ViewBag.Project = Project;
return(View());
}
public JsonResult LoadInstance(string ProjectId)
{
GeneralList sP_ = _Base.GetInstanceDropdown(ProjectId);
SelectList items = new SelectList(sP_._List, "Value", "Name");
//List<SelectListItem> Instance = new List<SelectListItem>();
//foreach (var a in items)
//{
// Guid instanceid = Guid.Parse(a.Value.ToString());
// Guid Project_Id = Guid.Parse(ProjectId.ToString());
// var b = (from i in db.Instances
// join pm in db.ProjectMonitors on i.Instance_id equals pm.InstanceID
// where pm.PhaseId == 1 && pm.StatusId != 1 && pm.StatusId != 3 && i.Instance_id == instanceid && i.Project_ID == Project_Id
// select i);
//
// if (b.Count() == 0)
// {
// foreach (var v in b)
// {
// Instance.Add(new SelectListItem { Text = v.InstaceName, Value = v.Instance_id.ToString() });
// }
// }
//}
return(Json(items, JsonRequestBehavior.AllowGet));
}
public List <NameValueList> CommonLists(string operate, GeneralParameter parameter)
{
try
{
var sp = "[dbo].[SIC_sys_GeneralList]";
return(GeneralList.CommonList <NameValueList>(sp, parameter));
}
catch (Exception ex)
{
var em = ex.Message;
return(null);
}
}
public List <NameValueList> GCommonList(object parameter)
{
try
{
var sp = "[dbo].[SIC_sys_GeneralList] @Operate,@UserID,@UserRole,@SchoolYear,@SchoolCode,@Para1,@Para2,@Para3";
return(GeneralList.CommonList <NameValueList>(sp, parameter));
}
catch (Exception ex)
{
var em = ex.Message;
return(null);
}
}
public ActionResult ResourceMigration()
{
int userType = 0;
if (User.IsInRole("Admin"))
{
userType = 1;
}
else if (User.IsInRole("Consultant"))
{
userType = 2;
}
else if (User.IsInRole("Customer"))
{
userType = 3;
}
GeneralList sP_ = _Base.spCustomerDropdown(Session["loginid"].ToString(), userType);
ViewBag.Customer = new SelectList(sP_._List, "Value", "Name");
Guid InstanceID = Guid.Parse(Session["InstanceId"].ToString());
int inst = 0;
if (InstanceID != Guid.Empty)
{
var q = from u in db.Instances where (u.Instance_id == InstanceID && u.AssessmentUploadStatus == true) select u;
if (q.Count() > 0)
{
inst = 1;
}
else
{
inst = 0;
}
}
ViewBag.Instance = inst;
List <SelectListItem> Project = new List <SelectListItem>();
var query = from u in db.Projects where (u.isActive == true) select u;
if (query.Count() > 0)
{
foreach (var v in query)
{
Project.Add(new SelectListItem {
Text = v.Project_Name, Value = v.Project_Id.ToString()
});
}
}
ViewBag.Project = Project;
return(View());
}
public ActionResult CustomReport()
{
InstanceId = Guid.Parse(Session["InstanceId"].ToString());
if (InstanceId == Guid.Empty)
{
ViewBag.Message = String.Format("Hello {0},\n Kindly Select Instance", Session["UserName"].ToString()).Replace("\n", Environment.NewLine);
}
GeneralList sP_ = _Base.sP_SimplificationReport(InstanceId);
ViewBag.LOB = new SelectList(sP_._List, "_Value", "Name");
List <SAPInput_CustomCode> CR = _Base.SAPInput_CustomCodeReport(InstanceId);
ViewBag.CRReport = CR;
return(View());
}
public ActionResult FioriAppsReport()
{
InstanceId = Guid.Parse(Session["InstanceId"].ToString());
//InstanceId = Guid.Parse("d2708e9f-eda4-47c2-b028-2776353ae755");
if (InstanceId == Guid.Empty)
{
ViewBag.Message = String.Format("Hello {0},\n Kindly Select Instance", Session["UserName"].ToString()).Replace("\n", Environment.NewLine);
}
GeneralList sP_ = _Base.sp_GetFioriAppsReportDropdown(InstanceId);
ViewBag.Roles = new SelectList(sP_._List, "_Value", "Name");
//List<SAPFioriAppsModel> FiR = _Base.sp_GetSAPFioriAppsTable(InstanceId);
//ViewBag.FiRReport = FiR;
return(View());
}
private static void Main()
{
// Console.WriteLine("Plase type input data suing correct format in order to parse file data correctly");
// var inputText = Console.ReadLine();
const string inputText = @"Text: file.txt(6B); Some string content
Image: img.bmp(19MB); 1920x1080
Text:data.txt(12B); Another string
Text:data1.txt(7B); Yet another string
Movie:logan.2017.mkv(19GB); 1920x1080; 2h12m" ;
var generalList = new GeneralList();
//Parse input text and fill in File objects
generalList.SplitInputData(inputText);
generalList.PrintFileList();
}
public ActionResult CreateAnalysis()
{
InstanceId = Guid.Parse(Session["InstanceId"].ToString());
if (InstanceId == Guid.Empty)
{
ViewBag.Message = String.Format("Hello {0},\n Kindly Select Instance", Session["UserName"].ToString());
//return RedirectToAction("Home", "Home");
}
else
{
}
int userType = 0;
if (User.IsInRole("Admin"))
{
userType = 1;
}
else if (User.IsInRole("Consultant"))
{
userType = 2;
}
else if (User.IsInRole("Customer"))
{
userType = 3;
}
GeneralList sP_ = _Base.spCustomerDropdown(Session["loginid"].ToString(), userType);
ViewBag.Customer = new SelectList(sP_._List, "Value", "Name");
//List<SelectListItem> Project = new List<SelectListItem>();
//var query = from u in db.CustomerProjectConfigs where (u.isActive == true) select u;
//if (query.Count() > 0)
//{
// foreach (var v in query)
// {
// Project.Add(new SelectListItem { Text = v.ProjectName, Value = v.Id.ToString() });
// }
//}
//ViewBag.Project = Project;
return(View());
}
internal bool DeleteGeneralList(int listId)
{
using (DataContext)
{
try
{
GeneralList generalList =
(from p in DataContext.GeneralLists where p.ID == listId select p).Single();
DataContext.GeneralLists.DeleteOnSubmit(generalList);
DataContext.SubmitChanges();
return(true);
}
catch (Exception)
{
return(false);
}
}
}
internal int AddGeneralList(int userId, ListTypes listType)
{
using (DataContext)
{
try
{
int i =
(from p in DataContext.GeneralLists where p.CREATED_BY == userId && p.LIST_TYPE == (int)listType && p.ACTIVE == true select p).
Count();
GeneralList generalList;
if (i == 0)
{
generalList = new GeneralList
{
CREATED_BY = userId,
CREATE_DATE = DateTime.Today,
ACTIVE = true,
LIST_TYPE = (int)listType
};
DataContext.GeneralLists.InsertOnSubmit(generalList);
DataContext.SubmitChanges();
}
else
{
generalList =
(from p in DataContext.GeneralLists
where p.CREATED_BY == userId && p.ACTIVE == true && p.LIST_TYPE == (int)listType
select p).
Single();
}
return(generalList.ID);
}
catch
{
return(-1);
}
}
}
public JsonResult LoadCreateAnalysisInstance(string ProjectId)
{
GeneralList sP_ = _Base.GetInstanceDropdown(ProjectId);
List <Lis> Result = new List <Lis>();
for (int i = 0; i < sP_._List.Count; i++)
{
var A = Guid.Parse(sP_._List[i].Value);
Boolean S = GetInstanceStatus(A);
if (S)
{
Lis List = new Lis();
List.Name = sP_._List[i].Name.ToString();
List.Value = sP_._List[i].Value.ToString();
Result.Add(List);
}
}
SelectList items = new SelectList(Result, "Value", "Name");
return(Json(items, JsonRequestBehavior.AllowGet));
}
public void CeneralList_provideDataAndStudentObject_returnObjectList_Test()
{
//Arrange
var parameter = new
{
Operate = "Get",
UserID = "mif",
UserRole = "Admin",
SchoolYear = "20202021",
SchoolCode = "0501",
Grade = "10",
SearchBy = "",
SearchValue = "",
Scope = "School"
};
var sp = "SIC_sys_ListofStudents";
//Act
var result = GeneralList.CommonList <Student>(sp, parameter);
//Assert
Assert.IsNotNull(result, $"Stufent List Testing {result.Count}");
}
public List <T> ListOfT(string sp, object parameter)
{
return(GeneralList.CommonList <T>(sp, parameter));
}
public ActionResult PMUPload()
{
LogHelper _log = new LogHelper();
try
{
int userType = 0;
if (User.IsInRole("Admin"))
{
userType = 1;
}
else if (User.IsInRole("Consultant"))
{
userType = 2;
}
else if (User.IsInRole("Customer"))
{
userType = 3;
}
GeneralList sP_ = _Base.spCustomerDropdown(Session["loginid"].ToString(), userType);
//ViewBag.Customer = new SelectList(sP_._List, "Value", "Name");
TempData["Customer"] = new SelectList(sP_._List, "Value", "Name");
TempData["PhaseID"] = (from q in db.PhaseMasters where q.PhaseName == _Base.Phase_PreConversion && q.isActive == true select q.Id).FirstOrDefault();
Guid InstanceID = Guid.Parse(Session["InstanceId"].ToString());
int inst = 0;
if (InstanceID != Guid.Empty)
{
var q = from u in db.Instances where (u.Instance_id == InstanceID && u.AssessmentUploadStatus == true && u.isActive == true) select u;
if (q.Count() > 0)
{
inst = 1;
}
else
{
inst = 0;
}
}
//ViewBag.Instance = inst;
TempData["Instance"] = inst;
List <SelectListItem> Project = new List <SelectListItem>();
if (User.IsInRole("Customer"))
{
Guid LoginId = Guid.Parse(Session["loginid"].ToString());
var Data = (from a in db.UserMasters
join b in db.Projects on a.Customer_Id equals b.Customer_Id
where a.UserId == LoginId && b.isActive == true
orderby b.Project_Name
select new { b.Project_Id, b.Project_Name }).ToList();
if (Data.Count() > 0)
{
foreach (var v in Data)
{
Project.Add(new SelectListItem {
Text = v.Project_Name, Value = v.Project_Id.ToString()
});
}
}
}
else if (User.IsInRole("Project Manager"))
{
Guid LoginId = Guid.Parse(Session["loginid"].ToString());
var Data = (from a in db.UserMasters
join b in db.Projects on a.UserId equals b.ProjectManager_Id
where a.UserId == LoginId && b.isActive == true
orderby b.Project_Name
select new { b.Project_Id, b.Project_Name }).ToList();
if (Data.Count() > 0)
{
foreach (var v in Data)
{
Project.Add(new SelectListItem {
Text = v.Project_Name, Value = v.Project_Id.ToString()
});
}
}
}
//ViewBag.Project = Project;
TempData["Project"] = Project;
}
catch (Exception ex)
{
_log.createLog(ex, "");
}
return(View());
}
public ActionResult ReadinessReport()
{
InstanceId = Guid.Parse(Session["InstanceId"].ToString());
if (InstanceId == Guid.Empty)
{
ViewBag.Message = String.Format("Hello {0},\n Kindly Select Instance", Session["UserName"].ToString());
//return RedirectToAction("Home", "Home");
}
else
{
}
int userType = 0;
if (User.IsInRole("Admin"))
{
userType = 1;
}
else if (User.IsInRole("Consultant"))
{
userType = 2;
}
else if (User.IsInRole("Customer"))
{
userType = 3;
}
GeneralList sP_ = _Base.spCustomerDropdown(Session["loginid"].ToString(), userType);
ViewBag.Customer = new SelectList(sP_._List, "Value", "Name");
List <SelectListItem> Project = new List <SelectListItem>();
if (User.IsInRole("Customer"))
{
Guid customerId = Guid.Parse(Session["loginid"].ToString());
var Data = (from a in db.UserMasters
join b in db.Projects on a.Customer_Id equals b.Customer_Id
where a.UserId == customerId && b.isActive == true
orderby b.Project_Name
select new { b.Project_Id, b.Project_Name }).ToList();
if (Data.Count() > 0)
{
foreach (var v in Data)
{
Project.Add(new SelectListItem {
Text = v.Project_Name, Value = v.Project_Id.ToString()
});
}
}
}
else if (User.IsInRole("Project Manager"))
{
Guid LoginId = Guid.Parse(Session["loginid"].ToString());
var Data = (from a in db.UserMasters
join b in db.Projects on a.UserId equals b.ProjectManager_Id
where a.UserId == LoginId && b.isActive == true
orderby b.Project_Name
select new { b.Project_Id, b.Project_Name }).ToList();
if (Data.Count() > 0)
{
foreach (var v in Data)
{
Project.Add(new SelectListItem {
Text = v.Project_Name, Value = v.Project_Id.ToString()
});
}
}
}
//else
//{
// var query = from u in db.CustomerProjectConfigs where (u.isActive == true) select u;
// if (query.Count() > 0)
// {
// foreach (var v in query)
// {
// Project.Add(new SelectListItem { Text = v.ProjectName, Value = v.Id.ToString() });
// }
// }
//}
ViewBag.Project = Project;
return(View());
}
public ActionResult IndexPage()
{
int userType = 0;
if (User.IsInRole("Admin"))
{
userType = 1;
}
else if (User.IsInRole("Consultant"))
{
userType = 2;
}
else if (User.IsInRole("Customer"))
{
userType = 3;
}
GeneralList sP_ = _Base.spCustomerDropdown(Session["loginid"].ToString(), userType);
ViewBag.Customer = new SelectList(sP_._List, "Value", "Name");
//TempData["Customer"] = new SelectList(sP_._List, "Value", "Name");
//TempData["PhaseID"] = (from q in db.PhaseMasters where q.PhaseName == _Base.Phase_Assessment && q.isActive == true select q.Id).FirstOrDefault();
ViewBag.PhaseID = (from q in db.PhaseMasters where q.PhaseName == _Base.Phase_Assessment && q.isActive == true select q.Id).FirstOrDefault();
Guid InstanceID = Guid.Parse(Session["InstanceId"].ToString());
int inst = 0;
if (InstanceID != Guid.Empty)
{
var q = from u in db.Instances where (u.Instance_id == InstanceID && u.AssessmentUploadStatus == true && u.isActive == true) select u;
if (q.Count() > 0)
{
inst = 1;
}
else
{
inst = 0;
}
}
//ViewBag.Instance = inst;
TempData["Instance"] = inst;
List <SelectListItem> Project = new List <SelectListItem>();
if (User.IsInRole("Customer"))
{
Guid LoginId = Guid.Parse(Session["loginid"].ToString());
var Data = (from a in db.UserMasters
join b in db.Projects on a.Customer_Id equals b.Customer_Id
where a.UserId == LoginId && b.isActive == true
orderby b.Project_Name
select new { b.Project_Id, b.Project_Name }).ToList();
if (Data.Count() > 0)
{
foreach (var v in Data)
{
Project.Add(new SelectListItem {
Text = v.Project_Name, Value = v.Project_Id.ToString()
});
}
}
}
else if (User.IsInRole("Project Manager"))
{
Guid LoginId = Guid.Parse(Session["loginid"].ToString());
var Data = (from a in db.UserMasters
join b in db.Projects on a.UserId equals b.ProjectManager_Id
where a.UserId == LoginId && b.isActive == true
orderby b.Project_Name
select new { b.Project_Id, b.Project_Name }).ToList();
if (Data.Count() > 0)
{
foreach (var v in Data)
{
Project.Add(new SelectListItem {
Text = v.Project_Name, Value = v.Project_Id.ToString()
});
}
}
}
ViewBag.Project = Project;
//TempData["Project"] = Project;
////int userType = 0;
//List<IssueTrackModel> ITM = new List<IssueTrackModel>();
//if (User.IsInRole("Consultant"))
//{
// userType = 2;
//}
//else if (User.IsInRole("Customer"))
//{
// userType = 3;
//}
//else if (User.IsInRole("Project Manager"))
//{
// userType = 4;
//}
//ITM = _Base.Sp_GetIssueTrackData(Session["loginid"].ToString(), userType);
//ViewBag.ITM = ITM;
return(View());
}
public ActionResult Create()
{
int userType = 0;
if (User.IsInRole("Admin"))
{
userType = 1;
}
else if (User.IsInRole("Consultant"))
{
userType = 2;
}
else if (User.IsInRole("Customer"))
{
userType = 3;
}
GeneralList sP_ = _Base.spCustomerDropdown(Session["loginid"].ToString(), userType);
TempData["Customer"] = new SelectList(sP_._List, "Value", "Name");
Guid InstanceID = Guid.Parse(Session["InstanceId"].ToString());
int inst = 0;
if (InstanceID != Guid.Empty)
{
var q = from u in db.Instances where (u.Instance_id == InstanceID && u.AssessmentUploadStatus == true && u.isActive == true) select u;
if (q.Count() > 0)
{
inst = 1;
}
else
{
inst = 0;
}
}
TempData["Instance"] = inst;
List <SelectListItem> Project = new List <SelectListItem>();
if (User.IsInRole("Customer"))
{
Guid LoginId = Guid.Parse(Session["loginid"].ToString());
var Data = (from a in db.UserMasters
join b in db.Projects on a.Customer_Id equals b.Customer_Id
where a.UserId == LoginId && b.isActive == true
orderby b.Project_Name
select new { b.Project_Id, b.Project_Name }).ToList();
if (Data.Count() > 0)
{
foreach (var v in Data)
{
Project.Add(new SelectListItem {
Text = v.Project_Name, Value = v.Project_Id.ToString()
});
}
}
}
else if (User.IsInRole("Project Manager"))
{
Guid LoginId = Guid.Parse(Session["loginid"].ToString());
var Data = (from a in db.UserMasters
join b in db.Projects on a.UserId equals b.ProjectManager_Id
where a.UserId == LoginId && b.isActive == true
orderby b.Project_Name
select new { b.Project_Id, b.Project_Name }).ToList();
if (Data.Count() > 0)
{
foreach (var v in Data)
{
Project.Add(new SelectListItem {
Text = v.Project_Name, Value = v.Project_Id.ToString()
});
}
}
}
TempData["Project"] = Project;
//ViewBag.AssignedTo = db.UserMasters.Where(x => x.isActive == true).ToList();
ViewBag.PhaseMaster = new SelectList(db.PhaseMasters, "Id", "PhaseName");
return(View());
}
// GET: Home
public ActionResult Home()
{
int Count = 1;
int Sce = 0;
if (Session["loginid"].ToString() != null)
{
Lis Status = _Base.SpConvertionStatus(Session["InstanceId"].ToString());
Count = Convert.ToInt32(Status.Value);
}
int userType = 0;
if (User.IsInRole("Admin"))
{
userType = 1;
}
else if (User.IsInRole("Consultant"))
{
userType = 2;
}
else if (User.IsInRole("Customer"))
{
userType = 3;
}
GeneralList sP_ = _Base.spCustomerDropdown(Session["loginid"].ToString(), userType);
ViewBag.Customer = new SelectList(sP_._List, "Value", "Name");
Guid InstanceID = Guid.Parse(Session["InstanceId"].ToString());
int inst = 0;
if (InstanceID != Guid.Empty)
{
var ProId = db.Instances.Where(x => x.Instance_id == InstanceID).FirstOrDefault().Project_ID;
Sce = db.Projects.Where(x => x.isActive == true && x.Project_Id == ProId).FirstOrDefault().ScenarioId;
var q = from u in db.Instances where (u.Instance_id == InstanceID && u.AssessmentUploadStatus == true) orderby u.InstaceName select u;
if (q.Count() > 0)
{
inst = 1;
}
else
{
inst = 0;
}
}
ViewBag.Instance = inst;
List <SelectListItem> Project = new List <SelectListItem>();
if (User.IsInRole("Customer"))
{
Guid LoginId = Guid.Parse(Session["loginid"].ToString());
var Data = (from a in db.UserMasters
join b in db.Projects on a.Customer_Id equals b.Customer_Id
where a.UserId == LoginId && b.isActive == true
orderby b.Project_Name
select new { b.Project_Id, b.Project_Name }).ToList();
if (Data.Count() > 0)
{
foreach (var v in Data)
{
Project.Add(new SelectListItem {
Text = v.Project_Name, Value = v.Project_Id.ToString()
});
}
}
}
else if (User.IsInRole("Project Manager"))
{
Guid LoginId = Guid.Parse(Session["loginid"].ToString());
var Data = (from a in db.UserMasters
join b in db.Projects on a.UserId equals b.ProjectManager_Id
where a.UserId == LoginId && b.isActive == true
orderby b.Project_Name
select new { b.Project_Id, b.Project_Name }).ToList();
if (Data.Count() > 0)
{
foreach (var v in Data)
{
Project.Add(new SelectListItem {
Text = v.Project_Name, Value = v.Project_Id.ToString()
});
}
}
}
//var task = (from u in db.ProjectMonitors
// join v in db.ActivityMasters on u.ActivityID equals v.Activity_ID
// join w in db.StatusMasters on u.StatusId equals w.Id
// join x in db.UserMasters on u.UserID equals x.UserId
// join P in db.PhaseMasters on u.PhaseId equals P.Id
// where u.InstanceID == InstanceID
// orderby u.Modified_On descending
// select new { v.Task, x.Name,P.PhaseName, w.StatusName, u.Planed__En_Date }).ToList().Take(5);
//dynamic output = new List<dynamic>();
//foreach (var inputAttribute in task)
//{
// dynamic row = new ExpandoObject();
// row.Task = inputAttribute.Task;
// row.Name = inputAttribute.Name;
// row.StatusName = inputAttribute.StatusName;
// row.Planed__En_Date = inputAttribute.Planed__En_Date;
// row.PhaseName = inputAttribute.PhaseName;
// output.Add(row);
//}
ViewBag.count = Count;
//ViewBag.Taskdetails = output;
ViewBag.Project = Project;
ViewBag.Scen = Sce;
//Mail m = new Mail();
//m.SendEmail();
return(View());
}
