public ActionResult <DropDownViewModel> GetAcademicYearList(DropDownViewModel downViewModel)
{
DropDownViewModel dropDownViewModel = new DropDownViewModel();
try
{
if (downViewModel.SchoolId > 0)
{
dropDownViewModel = _markingPeriodService.GetAcademicYearList(downViewModel);
}
else
{
dropDownViewModel._token = downViewModel._token;
dropDownViewModel._tenantName = downViewModel._tenantName;
dropDownViewModel._failure = true;
dropDownViewModel._message = "Please enter valid school id";
}
}
catch (Exception es)
{
dropDownViewModel._failure = true;
dropDownViewModel._message = es.Message;
}
return(dropDownViewModel);
}
public DropDownViewModel GetAcademicYearList(DropDownViewModel downViewModel)
{
DropDownViewModel dropDownViewModel = new DropDownViewModel();
var data = this.context?.SchoolYears.Where(x => x.TenantId == downViewModel.TenantId && x.SchoolId == downViewModel.SchoolId).Select(m => new AcademicYear()
{
StartDate = m.StartDate,
EndDate = m.EndDate,
Year = m.StartDate.HasValue == true && m.StartDate.Value.Year != m.EndDate.Value.Year && m.EndDate.HasValue == true ? m.StartDate.Value.Year.ToString() + "-" + m.EndDate.Value.Year.ToString() :
m.StartDate.HasValue == true && m.StartDate.Value.Year == m.EndDate.Value.Year && m.EndDate.HasValue == true ? m.EndDate.Value.Year.ToString() : m.StartDate.HasValue == true && m.EndDate.HasValue == false ? m.StartDate.Value.Year.ToString()
: m.StartDate.HasValue == false && m.EndDate.HasValue == true ? m.EndDate.Value.Year.ToString() : null, AcademyYear = (int)m.AcademicYear
}).ToList();
dropDownViewModel.AcademicYears = data;
dropDownViewModel.SchoolId = downViewModel.SchoolId;
dropDownViewModel.TenantId = downViewModel.TenantId;
dropDownViewModel._tenantName = downViewModel._tenantName;
if (data.Count() > 0)
{
dropDownViewModel._failure = false;
}
else
{
dropDownViewModel._failure = true;
dropDownViewModel._message = NORECORDFOUND;
}
return(dropDownViewModel);
}
//Load Student By Program and Batch
public List <DropDownViewModel> GetAllStudents(string programId, string batch)
{
connection.Open();
string query = "usp_projectCommon";
Command = new SqlCommand(query, connection);
Command.CommandType = CommandType.StoredProcedure;
Command.Parameters.AddWithValue("mode", "loadStudentByBatchAndProgramId");
Command.Parameters.AddWithValue("programId", programId);
Command.Parameters.AddWithValue("batchName", batch);
Reader = Command.ExecuteReader();
List <DropDownViewModel> Students = new List <DropDownViewModel>();
if (Reader.HasRows)
{
while (Reader.Read())
{
DropDownViewModel student = new DropDownViewModel();
student.Id = Reader["id"].ToString();
student.Name = Reader["name"].ToString();
Students.Add(student);
}
}
connection.Close();
return(Students);
}
public List <DropDownViewModel> GetProgramsByUserId(int userId)
{
connection.Open();
string query = "usp_projectCommon";
Command = new SqlCommand(query, connection);
Command.CommandType = CommandType.StoredProcedure;
Command.Parameters.AddWithValue("mode", "loadProgramsByUserId");
Command.Parameters.AddWithValue("userId", userId);
Reader = Command.ExecuteReader();
List <DropDownViewModel> Programs = new List <DropDownViewModel>();
if (Reader.HasRows)
{
while (Reader.Read())
{
DropDownViewModel program = new DropDownViewModel();
program.Id = Reader["id"].ToString();
program.Name = Reader["degreefullname"].ToString();
Programs.Add(program);
}
}
connection.Close();
return(Programs);
}
//Load All Department
public List <DropDownViewModel> GetAllDepartment()
{
connection.Open();
string query = "usp_projectCommon";
Command = new SqlCommand(query, connection);
Command.CommandType = CommandType.StoredProcedure;
Command.Parameters.AddWithValue("mode", "loadAllDepartment");
Reader = Command.ExecuteReader();
List <DropDownViewModel> Departments = new List <DropDownViewModel>();
if (Reader.HasRows)
{
while (Reader.Read())
{
DropDownViewModel department = new DropDownViewModel();
department.Id = Reader["id"].ToString();
department.Name = Reader["department_fullname"].ToString();
Departments.Add(department);
}
}
connection.Close();
return(Departments);
}
//Load Teachers By user Id
public List <DropDownViewModel> GetAllTeachers(int userId)
{
connection.Open();
string query = "usp_projectCommon";
Command = new SqlCommand(query, connection);
Command.CommandType = CommandType.StoredProcedure;
Command.Parameters.AddWithValue("mode", "loadAllTeachers");
Command.Parameters.AddWithValue("userId", userId);
Reader = Command.ExecuteReader();
List <DropDownViewModel> Teachers = new List <DropDownViewModel>();
if (Reader.HasRows)
{
while (Reader.Read())
{
DropDownViewModel teacher = new DropDownViewModel();
teacher.Id = Reader["id"].ToString();
teacher.Name = Reader["fullname"].ToString();
Teachers.Add(teacher);
}
}
connection.Close();
return(Teachers);
}
public ActionResult DropDown(SpaceObjectTypeDto item)
{
var spaceObjects = Repository.Get(x => x.SpaceObjectTypeId == item.Id);
var model = new DropDownViewModel(item, spaceObjects);
return(PartialView(model));
}
public ActionResult Index()
{
List <Dept> depts = new List <Dept>();
depts.Add(new Dept(1, "IT"));
depts.Add(new Dept(3, "Computer"));
depts.Add(new Dept(4, "CIVILS"));
depts.Add(new Dept(2, "EC"));
depts.Add(new Dept(5, "MECH"));
var deptlist = new List <SelectListItem>();
foreach (var d in depts)
{
deptlist.Add(new SelectListItem
{
Value = d.Id.ToString(),
Text = d.Name
});
}
DropDownViewModel ddvm = new DropDownViewModel();
ddvm.Departments = deptlist;
return(View(ddvm));
}
public ActionResult Index(DropDownViewModel mod)
{
mod.units = Convert.ToInt32(Request["units"]);
mod.withoutDiscount = Convert.ToInt32(Request["withoutdiscount"]);
decimal discountPrice = 0;
if (mod.Discount.Equals("1"))
{
discountPrice = mod.withoutDiscount - Decimal.Multiply(mod.withoutDiscount, Convert.ToDecimal(0.3));
}
else if (mod.Discount.Equals("2"))
{
if (mod.units < 100)
{
discountPrice = mod.withoutDiscount - Decimal.Multiply(mod.withoutDiscount, Convert.ToDecimal(0.1));
}
else if (mod.units >= 100)
{
discountPrice = mod.withoutDiscount - Decimal.Multiply(mod.withoutDiscount, Convert.ToDecimal(0.25));
}
}
else if (mod.Discount.Equals("3"))
{
discountPrice = mod.withoutDiscount - Decimal.Multiply(mod.withoutDiscount, Convert.ToDecimal(0.5));
}
else
{
discountPrice = mod.withoutDiscount;
}
string output = "<br /> Price with discount: " + String.Format("{0:0.00}", discountPrice);
return(Content(output));
}
public void GetProductData(CreateOrUpdateOrder model)
{
model.OrderDetailsFormModel = new OrderDetailViewModel();
model.OrderDetailsFormModel.Items = new List <DropDownViewModel>();
{
string constr = ConfigurationManager.ConnectionStrings["Constring"].ConnectionString;
using (SqlConnection con = new SqlConnection(constr))
{
string query = " SELECT Id,ItemName,Amount FROM Products";
using (SqlCommand cmd = new SqlCommand(query))
{
cmd.Connection = con;
con.Open();
using (SqlDataReader sdr = cmd.ExecuteReader())
{
while (sdr.Read())
{
var item = new DropDownViewModel()
{
Name = sdr["ItemName"].ToString(),
Id = Convert.ToInt32(sdr["Id"]),
};
model.OrderDetailsFormModel.Items.Add(item);
}
}
con.Close();
}
}
}
}
//Load Batch By Program
public List <DropDownViewModel> GetAllBatch(string programId)
{
connection.Open();
string query = "usp_projectCommon";
Command = new SqlCommand(query, connection);
Command.CommandType = CommandType.StoredProcedure;
Command.Parameters.AddWithValue("mode", "loadBatchByProgram");
Command.Parameters.AddWithValue("programId", programId);
Reader = Command.ExecuteReader();
List <DropDownViewModel> Batches = new List <DropDownViewModel>();
if (Reader.HasRows)
{
while (Reader.Read())
{
DropDownViewModel batch = new DropDownViewModel();
batch.Id = Reader["batchId"].ToString();
batch.Name = Reader["batch_name"].ToString();
Batches.Add(batch);
}
}
connection.Close();
return(Batches);
}
// GET: DropDown
public ActionResult Index()
{
DropDownViewModel model = new DropDownViewModel()
{
Ddllist = GetDDL(),
DealerIdRef = 1
};
return(View(model));
}
public async Task <IViewComponentResult> InvokeAsync(FiltroDropDown Dados)
{
var model = new DropDownViewModel();
await Task.Run(() => InicializaListas(Dados, model));
return(View("DropDownList", model));
}
// GET: DP
public ActionResult Index()
{
DropDownViewModel model = new DropDownViewModel
{
NameDropDownProperty = GetDetailsForDropDown(),
DiscountDropDownProperty = GetDiscountDropDown()
};
return(View(model));
}
public static void SetDropDownSelect(
this PropertyInfo p, List <DropDownViewModel> selector, Type relatedType, string postValue, IEnumerable <string> postValues = null)
{
List <String> values;
if (postValues != null && postValues.Count() > 0)
{
values = postValues.ToList();
}
else
{
values = !String.IsNullOrEmpty(postValue) ? new List <string>()
{
postValue
} : new List <string>();
}
var targetType = p.PropertyType;
Type targetElementType;
if (targetType.IsIEnumerable())
{
targetElementType = targetType.GetIElementType();
}
else
{
targetElementType = targetType;
}
if (targetElementType.IsEnum)
{
Array enumValues = targetElementType.GetEnumValues();
foreach (var item in enumValues)
{
var select = new DropDownViewModel();
select.Name = item.ToString();
select.Value = item.ToString();
select.Select = values.Contains(select.Value);
selector.Add(select);
}
}
else
{
//dropdown Classes
var allSelect = ContentBase.context.GetDropDownsByName(relatedType.Name).ToList();
var selects = new List <DropDownViewModel>();
foreach (var item in allSelect)
{
var select = new DropDownViewModel();
select.Name = item.Name;
select.Value = item.Id;
select.Select = values.Contains(select.Value);
selector.Add(select);
}
}
}
private void InicializaListas(FiltroDropDown Dados, DropDownViewModel model)
{
switch (Dados.DropDown)
{
case "Comarcas":
if (Dados.IdEstado != null)
{
model.PopulaLista(_appService.ObterComarcas().ToList()
.FindAll(a => a.IdEstado == long.Parse(Dados.IdEstado)));
}
else
{
model.PopulaLista(_appService.ObterComarcas().ToList());
}
break;
case "Cidades":
if (Dados.IdEstado != null && Dados.IdComarca != null)
{
model.PopulaLista(_appService.ObterCidades().ToList()
.FindAll(a => a.IdEstado == long.Parse(Dados.IdEstado) && a.IdComarca == long.Parse(Dados.IdComarca)));
}
else
{
model.PopulaLista(_appService.ObterCidades().ToList());
}
break;
case "Bairros":
if (Dados.IdCidade != null)
{
model.PopulaLista(_appService.ObterBairros().ToList()
.FindAll(a => a.IdCidade == long.Parse(Dados.IdCidade)));
}
else
{
model.PopulaLista(_appService.ObterBairros().ToList());
}
break;
default:
model.PopulaLista(_appService.ObterEstados().ToList());
break;
}
}
public IViewComponentResult Invoke(string selectedValue)
{
var vm = new DropDownViewModel {
SelectedValue = selectedValue,
DefaultValue = BooksGridDTO.DefaultFilter,
Items = new Dictionary <string, string> {
{ "under7", "Under $7" },
{ "7to14", "$7 to $14" },
{ "over14", "Over $14" }
}
};
return(View(SharedPath.Select, vm));
}
protected virtual void ReplaceTokensIfApplicable(DropDownViewModel viewModel)
{
Assert.ArgumentNotNull(viewModel, nameof(viewModel));
Assert.ArgumentNotNull(viewModel.Value, nameof(viewModel.Value));
if (viewModel.ShowValues || viewModel.IsDynamic)
{
return;
}
var value = string.Join(",", viewModel.Value);
if (string.IsNullOrEmpty(value))
{
return;
}
var values = value.Split(',');
if (values == null)
{
return;
}
foreach (var v in values)
{
if (!ID.TryParse(v, out ID valueId))
{
continue;
}
if (!ID.IsNullOrEmpty(valueId))
{
var it = Context.Database.GetItem(valueId);
if (it != null)
{
var itemValue = !string.IsNullOrEmpty(viewModel.ValueFieldName) && it.Fields[viewModel.ValueFieldName] != null ? it.Fields[viewModel.ValueFieldName].ToString() : it.DisplayName;
if (!string.IsNullOrEmpty(itemValue) && itemValue != (viewModel.Value == null ? string.Empty : string.Join(",", viewModel.Value)))
{
viewModel.Value = itemValue.Split(',').ToList();
}
}
}
}
}
public DropDownViewModel GetAcademicYearList(DropDownViewModel dropdownModel)
{
DropDownViewModel dropDownViewModel = new DropDownViewModel();
try
{
if (TokenManager.CheckToken(dropdownModel._tenantName + dropdownModel._userName, dropdownModel._token))
{
dropDownViewModel = this.markingperiodRepository.GetAcademicYearList(dropdownModel);
}
else
{
dropDownViewModel._failure = true;
dropDownViewModel._message = TOKENINVALID;
}
}
catch (Exception es)
{
dropDownViewModel._failure = true;
dropDownViewModel._message = es.Message;
}
return(dropDownViewModel);
}
public static MvcHtmlString RPDropDownFor <TModel, TProperty>(
this HtmlHelper <TModel> htmlHelper,
Expression <Func <TModel, TProperty> > expression,
ICollection <SelectListItem> items,
string labelMessage = null,
string placeholderMessage = null,
bool hasFind = true,
string findMessage = null,
bool isMultiSelect = true,
string dataId = null,
string dataDepends = null,
string dataUrl = null)
{
var metadata = htmlHelper.GetModelMetadata(expression, labelMessage, placeholderMessage, findMessage);
var viewModel = new DropDownViewModel(metadata)
{
Items = new List <SelectListItem>(),
Name = ExpressionHelper.GetExpressionText(expression),
HasFind = hasFind,
DataId = dataId,
DataDepends = dataDepends,
DataUrl = dataUrl
};
if (items != null)
{
viewModel.Items = items.ToList();
}
viewModel.IsMultiSelect = isMultiSelect;
viewModel.Input = htmlHelper.RPHiddenFor(expression);
if (viewModel.Model != null && viewModel.Items != null && viewModel.Items.Count > 0)
{
foreach (var item in viewModel.Items)
{
if (viewModel.IsMultiSelect)
{
if (((IEnumerable)viewModel.Model).Cast <object>().Any() &&
((IEnumerable)viewModel.Model).Cast <object>().Contains(int.Parse(item.Value)))
{
viewModel.SelectedValue = string.IsNullOrWhiteSpace(viewModel.SelectedValue) ? item.Text : string.Join("|", viewModel.SelectedValue, item.Text);
item.Selected = true;
}
}
else
{
object value = viewModel.Model;
if (viewModel.ModelMetadata.ModelType.IsEnum)
{
value = Convert.ChangeType(viewModel.Model, item.Value.GetType());
}
if (item.Value.Equals(value.ToString()))
{
viewModel.SelectedValue = item.Text;
item.Selected = true;
}
}
}
}
return(htmlHelper.Partial(Mvc.View.UI.DropDown, viewModel));
}
public void GetWBSByDeliverableNMOP_Test()
{
//Set Data
List <DropDownViewModel> lstdropDownViewModel = new List <DropDownViewModel>();
DropDownViewModel drpDownModel = new DropDownViewModel()
{
};
List <WBS_Deliverables> lstWBS = new List <WBS_Deliverables>();
WBS_Deliverables wbs1 = new WBS_Deliverables()
{
DeliverableId = 1234,
WBSElementId = 1,
DeliverableName = "Deliverable1",
FullWBSNumber = "11234.001.002"
};
WBS_Deliverables wbs2 = new WBS_Deliverables()
{
DeliverableId = 2345,
WBSElementId = 2,
FullWBSNumber = "12456.001.002",
DeliverableName = "Deliverable2",
};
WBS_Deliverables wbs3 = new WBS_Deliverables()
{
DeliverableId = 3456,
WBSElementId = 3,
FullWBSNumber = "11234.003.001",
DeliverableName = "Deliverable1",
};
lstWBS.Add(wbs1);
lstWBS.Add(wbs2);
lstWBS.Add(wbs3);
DropDownViewModel vm1 = new DropDownViewModel()
{
Text = "11234.001.002",
Value = "1"
};
DropDownViewModel vm2 = new DropDownViewModel()
{
Text = "12456.001.002",
Value = "2"
};
DropDownViewModel vm3 = new DropDownViewModel()
{
Text = "11234.003.001",
Value = "3"
};
lstdropDownViewModel.Add(vm1);
lstdropDownViewModel.Add(vm2);
lstdropDownViewModel.Add(vm3);
//Inputs
bool isExternal = false;
string filter = "";
int mrmUserid = 1234;
string networkLogin = "******";
int deliverableId = 1234;
int mopId = 542;
#region Mock
//Mock
//FinanceService Service Mock
mockFinanceService.Setup(x => x.GetWBSByDeliverableNMOP(It.IsAny <int>(), It.IsAny <int>(), It.IsAny <bool>())).Returns(lstWBS);
//iWBS_DeliverablesRepository Mock
mockWBS_DeliverablesRepository.Setup(x => x.GetWBSByDeliverableNMOP(It.IsAny <int>(), It.IsAny <int>(), It.IsAny <bool>())).Returns(lstWBS);
var financeService = new FinanceServiceMock(
_iWBS_DeliverablesRepository: mockWBS_DeliverablesRepository.Object);
//Finance Controller Mock
var DropDownController = new DropDownControllerMock(financeService: mockFinanceService.Object);
#endregion
//Assertions
mockFinanceService.Verify();
mockWBS_DeliverablesRepository.Verify();
var serviceResult = financeService.GetWBSByDeliverableNMOP(deliverableId, mopId, isExternal);
#region "Assertion of GetWBSByDeliverableNMOP"
Assert.IsNotNull(serviceResult); //Result is not Null
Assert.AreEqual(serviceResult, lstWBS); //Asserting the expected return object with dummy data
Assert.AreEqual(serviceResult.Count, 3); //Assert matching the return data with my input
var controllerResult = DropDownController.GetWBSByDeliverableNMOP(deliverableId, mopId, isExternal, filter, mrmUserid, networkLogin);
Assert.IsNotNull(controllerResult);//Result is not Null
Assert.AreEqual(controllerResult.Count, 3);
isExternal = true;
var controllerResultForExternalTrue = DropDownController.GetWBSByDeliverableNMOP(deliverableId, mopId, isExternal, filter, mrmUserid, networkLogin);
Assert.IsNotNull(controllerResultForExternalTrue);//Result is not Null
Assert.AreSame(controllerResultForExternalTrue[2].Text.Trim(), "11234.003.001");
filter = "Deliverable1";
var controllerResultForFilter = DropDownController.GetWBSByDeliverableNMOP(deliverableId, mopId, isExternal, filter, mrmUserid, networkLogin);
Assert.IsNotNull(controllerResultForExternalTrue);//Result is not Null
Assert.AreSame(controllerResultForExternalTrue[0].Text.Trim(), "11234.001.002");
#endregion
}
public void GetDeliverableForInvoice_Test()
{
//Set Data
List <DropDownViewModel> lstdropDownViewModel = new List <DropDownViewModel>();
DropDownViewModel drpDownModel = new DropDownViewModel()
{
};
List <WBS_Deliverables> lstWBS = new List <WBS_Deliverables>();
WBS_Deliverables wbs1 = new WBS_Deliverables()
{
DeliverableId = 1234,
DeliverableName = "Deliverable1",
ExternalWBSFlag = false
};
WBS_Deliverables wbs2 = new WBS_Deliverables()
{
DeliverableId = 2345,
DeliverableName = "Deliverable2",
ExternalWBSFlag = true
};
WBS_Deliverables wbs3 = new WBS_Deliverables()
{
DeliverableId = 3456,
DeliverableName = "Deliverable3",
ExternalWBSFlag = false
};
lstWBS.Add(wbs1);
lstWBS.Add(wbs2);
lstWBS.Add(wbs3);
DropDownViewModel vm1 = new DropDownViewModel()
{
Text = "1234 ( Deliverable1 )",
Value = "1234"
};
DropDownViewModel vm2 = new DropDownViewModel()
{
Text = "2345 ( Deliverable2 )",
Value = "2345"
};
DropDownViewModel vm3 = new DropDownViewModel()
{
Text = "3456 ( ExternalDeliverable )",
Value = "3456"
};
lstdropDownViewModel.Add(vm1);
lstdropDownViewModel.Add(vm2);
lstdropDownViewModel.Add(vm3);
//Inputs
bool isExternal = false;
string filter = "";
int mrmUserid = 1234;
string networkLogin = "******";
//Mock
//FinanceService Service Mock
mockFinanceService.Setup(x => x.GetDeliverablesForInvoiceLine(It.IsAny <bool>())).Returns(lstWBS);
//iWBS_DeliverablesRepository Mock
mockWBS_DeliverablesRepository.Setup(x => x.GetDeliverablesForInvoiceLine(It.IsAny <bool>())).Returns(lstWBS);
var financeService = new FinanceServiceMock(_iWBS_DeliverablesRepository: mockWBS_DeliverablesRepository.Object);
//Finance Controller Mock
var DropDownController = new DropDownControllerMock(financeService: mockFinanceService.Object);
//Assertions
mockFinanceService.Verify();
mockWBS_DeliverablesRepository.Verify();
var serviceResult = financeService.GetDeliverablesForInvoiceLine(isExternal);
#region "Assertion ofGetDeliverableForInvoice"
Assert.IsNotNull(serviceResult); //Result is not Null
Assert.AreEqual(serviceResult, lstWBS); //Asserting the expected return object with dummy data
Assert.AreEqual(serviceResult.Count, 3); //Assert matching the return data with my input
var controllerResult = DropDownController.GetDeliverableForInvoice(isExternal, filter, mrmUserid, networkLogin);
Assert.IsNotNull(controllerResult);//Result is not Null
Assert.AreEqual(controllerResult.Count, 3);
isExternal = true;
var controllerResultForExternalTrue = DropDownController.GetDeliverableForInvoice(isExternal, filter, mrmUserid, networkLogin);
Assert.IsNotNull(controllerResultForExternalTrue);//Result is not Null
Assert.AreEqual(controllerResultForExternalTrue.Count, 3);
filter = "Deliverable1";
var controllerResultForfiltereingonDeliverableText = DropDownController.GetDeliverableForInvoice(isExternal, filter, mrmUserid, networkLogin);
Assert.IsNotNull(controllerResultForfiltereingonDeliverableText);//Result is not Null
Assert.AreEqual(controllerResultForfiltereingonDeliverableText.Count, 1);
#endregion
}
public void GetDeliverableNameByMopNWBS_Test()
{
//Set Data
List <DropDownViewModel> lstdropDownViewModel = new List <DropDownViewModel>();
DropDownViewModel drpDownModel = new DropDownViewModel()
{
};
List <WBS_Deliverables> lstWBS = new List <WBS_Deliverables>();
WBS_Deliverables wbs1 = new WBS_Deliverables()
{
TypeOfWorkId = 542,
WBSElementId = 17,
FullWBSNumber = "11234.001.002",
ProductionMethodTypeId = 1,
ProductionMethodTypeName = "Post House",
DeliverableId = 1,
DeliverableName = "Deliverable1"
};
WBS_Deliverables wbs2 = new WBS_Deliverables()
{
TypeOfWorkId = 2345,
WBSElementId = 21,
FullWBSNumber = "12456.001.002",
ProductionMethodTypeId = 2,
ProductionMethodTypeName = "Contract Request",
DeliverableId = 2,
DeliverableName = "Deliverable2"
};
WBS_Deliverables wbs3 = new WBS_Deliverables()
{
TypeOfWorkId = 3456,
WBSElementId = 31,
FullWBSNumber = "11234.003.001",
ProductionMethodTypeId = 3,
ProductionMethodTypeName = "Miscellaneous",
DeliverableId = 3,
DeliverableName = "Deliverable3"
};
lstWBS.Add(wbs1);
lstWBS.Add(wbs2);
lstWBS.Add(wbs3);
DropDownViewModel vm1 = new DropDownViewModel()
{
Text = "Deliverable1",
Value = "1",
Id = 1
};
DropDownViewModel vm2 = new DropDownViewModel()
{
Text = "Deliverable2",
Value = "2",
Id = 2
};
DropDownViewModel vm3 = new DropDownViewModel()
{
Text = "Deliverable3",
Value = "3",
Id = 3
};
lstdropDownViewModel.Add(vm1);
lstdropDownViewModel.Add(vm2);
lstdropDownViewModel.Add(vm3);
//Inputs
bool isExternal = false;
string filter = "";
int mrmUserid = 1234;
string networkLogin = "******";
int wbsId = 31;
int mopId = 1;
#region Mock
//Mock
//FinanceService Service Mock
mockFinanceService.Setup(x => x.GetDeliverableNameByMopNWBS(It.IsAny <int>(), It.IsAny <int>(), It.IsAny <bool>())).Returns(lstWBS);
//iWBS_DeliverablesRepository Mock
mockWBS_DeliverablesRepository.Setup(x => x.GetDeliverableNameByMopNWBS(It.IsAny <int>(), It.IsAny <int>(), It.IsAny <bool>())).Returns(lstWBS);
var financeService = new FinanceServiceMock(
_iWBS_DeliverablesRepository: mockWBS_DeliverablesRepository.Object);
//Finance Controller Mock
var DropDownController = new DropDownControllerMock(financeService: mockFinanceService.Object);
#endregion
//Assertions
mockFinanceService.Verify();
mockWBS_DeliverablesRepository.Verify();
var serviceResult = financeService.GetDeliverableNameByMopNWBS(wbsId, mopId, isExternal);
#region "Assertion of GetWBSByTow"
Assert.IsNotNull(serviceResult); //Result is not Null
Assert.AreEqual(serviceResult, lstWBS); //Asserting the expected return object with dummy data
Assert.AreEqual(serviceResult.Count, 3); //Assert matching the return data with my input
var controllerResult = DropDownController.GetDeliverableNameByMopNWBS(wbsId, mopId, isExternal, filter, mrmUserid, networkLogin);
Assert.IsNotNull(controllerResult);//Result is not Null
Assert.AreEqual(controllerResult.Count, 3);
Assert.AreEqual(controllerResult[0].Text, "Deliverable1");
filter = "Deliverable2";
var controllerResultForFilter = DropDownController.GetDeliverableNameByMopNWBS(wbsId, mopId, isExternal, filter, mrmUserid, networkLogin);
Assert.IsNotNull(controllerResultForFilter);//Result is not Null
Assert.AreSame(controllerResultForFilter[0].Text.Trim(), "Deliverable2");
#endregion
}
public void GetDeliverableByWbs_Test()
{
//Set Data
List <DropDownViewModel> lstdropDownViewModel = new List <DropDownViewModel>();
DropDownViewModel drpDownModel = new DropDownViewModel()
{
};
List <WBS_Deliverables> lstWBS = new List <WBS_Deliverables>();
WBS_Deliverables wbs1 = new WBS_Deliverables()
{
WBSElementId = 17,
FullWBSNumber = "11234.001.002",
DeliverableId = 1,
DeliverableName = "Deliverable1",
SAPVendorId = 68,
DeliverableBudgetId = 123567
};
WBS_Deliverables wbs2 = new WBS_Deliverables()
{
WBSElementId = 21,
FullWBSNumber = "12456.001.002",
ProductionMethodTypeId = 2,
ProductionMethodTypeName = "Contract Request",
DeliverableId = 2,
DeliverableName = "Deliverable2",
SAPVendorId = 72,
DeliverableBudgetId = 123586
};
WBS_Deliverables wbs3 = new WBS_Deliverables()
{
TypeOfWorkId = 3456,
WBSElementId = 31,
FullWBSNumber = "11234.003.001",
ProductionMethodTypeId = 3,
ProductionMethodTypeName = "Miscellaneous",
DeliverableId = 3,
DeliverableName = "Deliverable3",
SAPVendorId = 74,
DeliverableBudgetId = 123521
};
lstWBS.Add(wbs1);
lstWBS.Add(wbs2);
lstWBS.Add(wbs3);
DropDownViewModel vm1 = new DropDownViewModel()
{
Text = "Deliverable1",
Value = "1",
Id = 1,
Description = "1" + "|" + "11234.001.002" + "|" + "Deliverable1" + "|" + "123567"
};
DropDownViewModel vm2 = new DropDownViewModel()
{
Text = "Deliverable2",
Value = "2",
Id = 2,
Description = "2" + "|" + "12456.001.002" + "|" + "Deliverable2" + "|" + "123586"
};
DropDownViewModel vm3 = new DropDownViewModel()
{
Text = "Deliverable3",
Value = "3",
Id = 3,
Description = "3" + "|" + "11234.003.001" + "|" + "Deliverable3" + "|" + "123521"
};
lstdropDownViewModel.Add(vm1);
lstdropDownViewModel.Add(vm2);
lstdropDownViewModel.Add(vm3);
//Inputs
bool isExternal = false;
string filter = "";
int mrmUserid = 1234;
string networkLogin = "******";
int wbsId = 31;
int SAPVendorId = 74;
#region Mock
//Mock
//FinanceService Service Mock
mockFinanceService.Setup(x => x.GetDeliverableByWbs(It.IsAny <int>(), It.IsAny <int>(), It.IsAny <bool>())).Returns(lstWBS);
//iWBS_DeliverablesRepository Mock
mockWBS_DeliverablesRepository.Setup(x => x.GetDeliverableByWbs(It.IsAny <int>(), It.IsAny <int>(), It.IsAny <bool>())).Returns(lstWBS);
var financeService = new FinanceServiceMock(
_iWBS_DeliverablesRepository: mockWBS_DeliverablesRepository.Object);
//Finance Controller Mock
var DropDownController = new DropDownControllerMock(financeService: mockFinanceService.Object);
#endregion
//Assertions
mockFinanceService.Verify();
mockWBS_DeliverablesRepository.Verify();
var serviceResult = financeService.GetDeliverableByWbs(wbsId, SAPVendorId, isExternal);
#region "Assertion of GetWBSByTow"
Assert.IsNotNull(serviceResult); //Result is not Null
Assert.AreEqual(serviceResult, lstWBS); //Asserting the expected return object with dummy data
Assert.AreEqual(serviceResult.Count, 3); //Assert matching the return data with my input
var controllerResult = DropDownController.GetDeliverableByWbs(isExternal, wbsId, SAPVendorId, mrmUserid, networkLogin);
Assert.IsNotNull(controllerResult);//Result is not Null
Assert.AreEqual(controllerResult.Count, 3);
Assert.AreEqual(controllerResult[0].Text, "1( Deliverable1 )");
Assert.AreEqual(controllerResult[0].Description, "1|11234.001.002|Deliverable1|123567");
SAPVendorId = 17;
wbsId = 68;
var controllerResult1 = DropDownController.GetDeliverableByWbs(isExternal, wbsId, SAPVendorId, mrmUserid, networkLogin);
Assert.IsNotNull(controllerResult1);//Result is not Null
Assert.AreEqual(controllerResult1[1].Text, "2( Deliverable2 )");
Assert.AreEqual(controllerResult1[1].Description, "2|12456.001.002|Deliverable2|123586");
#endregion
}
private void InitPaymentMethodsList(string paymentValues)
{
PaymentMethodsList = new DropDownViewModel
{
Name = PAYMENT_METHODS_ID,
ItemsList = string.IsNullOrEmpty(paymentValues)
? new DropDownItemsList()
: new DropDownItemsList(paymentValues)
};
}
public static void SetDropDownSelect(
this PropertyInfo p, List <DropDownViewModel> selector, Type relatedType, string postValue, IEnumerable <string> postValues = null)
{
List <String> values;
if (postValues != null && postValues.Count() > 0)
{
values = postValues.ToList();
}
else
{
values = !String.IsNullOrEmpty(postValue) ? new List <string>()
{
postValue
} : new List <string>();
}
if (relatedType.IsEnum)
{
Array enumValues = relatedType.GetEnumValues();
foreach (var item in enumValues)
{
var select = new DropDownViewModel();
select.Name = item.ToString();
select.Value = item.ToString();
select.Select = values.Contains(select.Value);
selector.Add(select);
}
}
else
{
//dropdown Classes
var isContent = relatedType.GetInterfaces().Any(b => b == typeof(IInt64Key));
if (isContent)
{
var allSelect = BaseCruds.Read <IBasicContent>(relatedType, b => true).ToList();
var selects = new List <DropDownViewModel>();
foreach (var item in allSelect)
{
var select = new DropDownViewModel();
select.Name = item.DisplayName();
select.Value = item.Id.ToString();
select.Select = values.Contains(select.Value);
selector.Add(select);
}
}
else
{
var allSelect = BaseCruds.Read <IStringKey>(relatedType, b => true).ToList();
var selects = new List <DropDownViewModel>();
foreach (var item in allSelect)
{
var select = new DropDownViewModel();
select.Name = item.ToString();
select.Value = item.Id;
select.Select = values.Contains(select.Value);
selector.Add(select);
}
}
}
}
public ActionResult ShowDDL(DropDownViewModel viewModel)
{
return(View(viewModel));
}
public void GetMethodOFProductionByDeliverableId_Test()
{
//Set Data
List <DropDownViewModel> lstdropDownViewModel = new List <DropDownViewModel>();
DropDownViewModel drpDownModel = new DropDownViewModel()
{
};
List <WBS_Deliverables> lstWBS = new List <WBS_Deliverables>();
WBS_Deliverables wbs1 = new WBS_Deliverables()
{
DeliverableId = 1234,
ExternalWBSFlag = false,
ProductionMethodTypeId = 1,
ProductionMethodTypeName = "Post House",
DeliverableName = "Deliverable1"
};
WBS_Deliverables wbs2 = new WBS_Deliverables()
{
DeliverableId = 2345,
DeliverableName = "Deliverable2",
ExternalWBSFlag = true,
ProductionMethodTypeId = 2,
ProductionMethodTypeName = "Contract Request"
};
WBS_Deliverables wbs3 = new WBS_Deliverables()
{
DeliverableId = 3456,
DeliverableName = "Deliverable3",
ExternalWBSFlag = false,
ProductionMethodTypeId = 3,
ProductionMethodTypeName = "Miscellaneous"
};
lstWBS.Add(wbs1);
lstWBS.Add(wbs2);
lstWBS.Add(wbs3);
DropDownViewModel vm1 = new DropDownViewModel()
{
Text = "Post House",
Value = "1"
};
DropDownViewModel vm2 = new DropDownViewModel()
{
Text = "Contract Request",
Value = "2"
};
DropDownViewModel vm3 = new DropDownViewModel()
{
Text = "Miscellaneous",
Value = "3"
};
lstdropDownViewModel.Add(vm1);
lstdropDownViewModel.Add(vm2);
lstdropDownViewModel.Add(vm3);
//Inputs
bool isExternal = false;
string filter = "";
int mrmUserid = 1234;
string networkLogin = "******";
int deliverableId = 1234;
int vendorid = 23;
int wbsid = 212;
#region Mock
//Mock
//FinanceService Service Mock
mockFinanceService.Setup(x => x.GetMethodOFProductionByDeliverableId(It.IsAny <int>(), It.IsAny <int>(), It.IsAny <int>(), It.IsAny <bool>())).Returns(lstWBS);
//iWBS_DeliverablesRepository Mock
mockWBS_DeliverablesRepository.Setup(x => x.GetMethodOFProductionByDeliverableId(It.IsAny <int>(), It.IsAny <int>(), It.IsAny <int>(), It.IsAny <bool>())).Returns(lstWBS);
var financeService = new FinanceServiceMock(
_iWBS_DeliverablesRepository: mockWBS_DeliverablesRepository.Object);
//Finance Controller Mock
var DropDownController = new DropDownControllerMock(financeService: mockFinanceService.Object);
#endregion
//Assertions
mockFinanceService.Verify();
mockWBS_DeliverablesRepository.Verify();
var serviceResult = financeService.GetMethodOFProductionByDeliverableId(deliverableId, vendorid, wbsid, isExternal);
#region "Assertion of GetMethodOFProductionByDeliverableId"
Assert.IsNotNull(serviceResult); //Result is not Null
Assert.AreEqual(serviceResult, lstWBS); //Asserting the expected return object with dummy data
Assert.AreEqual(serviceResult.Count, 3); //Assert matching the return data with my input
var controllerResult = DropDownController.GetMethodOFProductionByDeliverableId(deliverableId, vendorid, wbsid, isExternal, filter, mrmUserid, networkLogin);
Assert.IsNotNull(controllerResult);//Result is not Null
Assert.AreEqual(controllerResult.Count, 3);
isExternal = true;
var controllerResultForExternalTrue = DropDownController.GetMethodOFProductionByDeliverableId(deliverableId, vendorid, wbsid, isExternal, filter, mrmUserid, networkLogin);
Assert.IsNotNull(controllerResultForExternalTrue);//Result is not Null
Assert.AreSame(controllerResultForExternalTrue[0].Text.Trim(), "Post House");
filter = "deliverable1";
var controllerResultForFilter = DropDownController.GetMethodOFProductionByDeliverableId(deliverableId, vendorid, wbsid, isExternal, filter, mrmUserid, networkLogin);
Assert.IsNotNull(controllerResultForExternalTrue);//Result is not Null
Assert.AreSame(controllerResultForExternalTrue[0].Text.Trim(), "Post House");
#endregion
}
public DropDownController(PCPTDataContext context)
{
db = context;
viewModel = new DropDownViewModel(db);
}
public async Task <FilterParametersViewModel> GetFilterParameters(GetSalesRequestDto requestDto)
{
if (requestDto == null)
{
throw new ArgumentNullException(nameof(requestDto));
}
string getFilterParametersUrl = GetEndPointForGetSalesRequest(EndPoints.Api.GetFilterParameters, requestDto);
FilterParametersDto parametersDto = await httpClient.GetAsync <FilterParametersDto>(getFilterParametersUrl);
FilterParametersViewModel parameters = new FilterParametersViewModel();
parameters.Countries = new List <DropDownViewModel>();
DropDownViewModel allItem = new DropDownViewModel()
{
Value = default(int).ToString(), Label = "All"
};
foreach (var item in parametersDto.Countries)
{
parameters.Countries.Add(
new DropDownViewModel()
{
Label = item.CountryName,
Value = item.CountryId.ToString()
});
}
parameters.Countries.Insert(0, allItem);
parameters.ItemTypes = new List <DropDownViewModel>();
foreach (var item in parametersDto.ItemTypes)
{
parameters.ItemTypes.Add(
new DropDownViewModel()
{
Label = item.ItemTypeName,
Value = item.ItemTypeId.ToString()
});
}
parameters.ItemTypes.Insert(0, allItem);
parameters.OrderPriorities = new List <DropDownViewModel>();
foreach (var item in parametersDto.OrderPriorities)
{
parameters.OrderPriorities.Add(
new DropDownViewModel()
{
Label = item.OrderPriorityName,
Value = item.OrderPriorityId.ToString()
});
}
parameters.OrderPriorities.Insert(0, allItem);
parameters.Regions = new List <DropDownViewModel>();
foreach (var item in parametersDto.Regions)
{
parameters.Regions.Add(
new DropDownViewModel()
{
Label = item.RegionName,
Value = item.RegionId.ToString()
});
}
parameters.Regions.Insert(0, allItem);
parameters.SalesChannels = new List <DropDownViewModel>();
foreach (var item in parametersDto.SalesChannels)
{
parameters.SalesChannels.Add(
new DropDownViewModel()
{
Label = item.SalesChannelName,
Value = item.SalesChannelId.ToString()
});
}
parameters.SalesChannels.Insert(0, allItem);
return(parameters);
}
