public ActionResult AssignmentDetail(int AnchorTransactionID, int TransactionTypeID) { ViewBag.Title = ""; ViewBag.Message = ""; AssignmentBussines.GetAssignmentRequest request = new AssignmentBussines.GetAssignmentRequest() { AssignmentID = AnchorTransactionID, }; TransactionConfigurateBussines.GetTransactionConfigurateRequest requestTransaction = new TransactionConfigurateBussines.GetTransactionConfigurateRequest() { AnchorTransactionID = AnchorTransactionID, TransactionTypeID = TransactionTypeID }; AssignmentBussines.GetAssignmentResponse c = AssignmentBussines.Select.GetAssignment(request); int to = TransactionConfigurateBussines.Select.GetTotalAmountToTransaction(requestTransaction).TotalAmount; request.ProductID = (int)c.Assignment.idProduct; var model = new AssignmentViewModels() { Error = c.Error, total = to, Assignment = c.Assignment, Transaction = new Transactions(), TransactionList = TransactionConfigurateBussines.Select.GetTransactionList(requestTransaction).TransactionList, ProductList = ProductBussines.Select.GetProduct().ProductList, AssignmentList = AssignmentBussines.Select.GetAssignmentByProductID(request).AssignmentList, ProviderList = ProviderBussines.Select.GetProviderList().ProviderList, ConditionProductList = ConditionProductBussines.Select.GetConditionProductList().ConditionProductList }; return(PartialView(model)); }
public ActionResult AssignmentCreate(string FatherCateogryID, string CategoryID, string CellarArea) { ViewBag.Title = ""; ViewBag.Message = ""; ProductBussines.GetProductRequest request = new ProductBussines.GetProductRequest() { CellarAreaID = Convert.ToInt16(CellarArea), CategoryID = Convert.ToInt16(CategoryID.ToString()) }; var model = new AssignmentViewModels() { Assignment = new Assignments(), CategoryID = CategoryID, CategoryIDFhater = FatherCateogryID, CellarArea = CellarArea, ProductList = ProductBussines.Select.GetProductListByDepartmentAndCategory(request, Convert.ToInt16(FatherCateogryID)).ProductList, EmployeesList = EmployeeBussines.Select.GetEmployeeList().EmployeeList, ConditionProductList = ConditionProductBussines.Select.GetConditionProductList().ConditionProductList }; model.Assignment.idCategory = Convert.ToInt16(CategoryID); return(PartialView(model)); }
public ActionResult AssignmentView(string CategoryID, string FatherCateogryID, string CellarArea, bool successful = false, string ResultAction = "") { ViewBag.Title = ""; ViewBag.successful = successful; ViewBag.Message = ResultAction; AssignmentBussines.GetAssignmentRequest request = new AssignmentBussines.GetAssignmentRequest() { CategoryID = Convert.ToInt16(CategoryID), TransactionTypeID = 2 }; AssignmentBussines.GetAssignmentRequest requestFather = new AssignmentBussines.GetAssignmentRequest() { CategoryID = Convert.ToInt16(CategoryID) }; var BussinesData = AssignmentBussines.Select.GetAssignmentList(request); var model = new AssignmentViewModels() { Error = BussinesData.Error, CategoryID = CategoryID, CategoryIDFhater = FatherCateogryID, CellarArea = CellarArea, AssignmentList = BussinesData.AssignmentList, GetCategoryName = CategoryBussines.Select.GetCategoryName(Convert.ToInt16(CategoryID)).Category.name, GetCategoryFaherName = CategoryBussines.Select.GetCategoryName(Convert.ToInt16(FatherCateogryID)).Category.name, ConditionProductList = ConditionProductBussines.Select.GetConditionProductList().ConditionProductList }; return(View(model)); }
public ActionResult AssignmentUpdate(int id, string CategoryID, string FatherCateogryID, string CellarArea) { AssignmentBussines.GetAssignmentRequest request = new AssignmentBussines.GetAssignmentRequest() { AssignmentID = id, }; AssignmentBussines.GetAssignmentResponse a = AssignmentBussines.Select.GetAssignment(request); request.ProductID = (int)a.Assignment.idProduct; ProductBussines.GetProductRequest request2 = new ProductBussines.GetProductRequest() { ProductID = (int)a.Assignment.idProduct }; var model = new AssignmentViewModels() { Error = a.Error, Assignment = a.Assignment, CategoryID = CategoryID, CategoryIDFhater = FatherCateogryID, CellarArea = CellarArea, EmployeesList = EmployeeBussines.Select.GetEmployeeList().EmployeeList }; ViewBag.Title = "Update Asignment To " + ProductBussines.Select.GetProduct(request2).Product.name; ViewBag.Message = ""; return(PartialView(model)); }
public ActionResult AssignmentUpdate(AssignmentViewModels data) { AssignmentBussines.GetAssignmentResponse assignmentData = new AssignmentBussines.GetAssignmentResponse() { Assignment = data.Assignment }; result = AssignmentBussines.Update.Assignments(assignmentData).Message; return(RedirectToAction("AssignmentView", new { CategoryID = data.CategoryID, FatherCateogryID = data.CategoryIDFhater, CellarArea = data.CellarArea, successful = true, ResultAction = "All Changes was successful" })); }
public ActionResult AssignmentNewInflow(string CategoryID, string FatherCateogryID, string CellarArea, int AnchorTransactionID, int TransactionTypeID) { ViewBag.Title = ""; ViewBag.Message = ""; AssignmentBussines.GetAssignmentRequest request = new AssignmentBussines.GetAssignmentRequest() { AssignmentID = AnchorTransactionID, }; TransactionConfigurateBussines.GetTransactionConfigurateRequest requestTransaction = new TransactionConfigurateBussines.GetTransactionConfigurateRequest() { AnchorTransactionID = AnchorTransactionID, TransactionTypeID = TransactionTypeID }; ProductBussines.GetProductRequest requestProduct = new ProductBussines.GetProductRequest() { CellarAreaID = Convert.ToInt16(CellarArea) }; AssignmentBussines.GetAssignmentResponse c = AssignmentBussines.Select.GetAssignment(request); int to = TransactionConfigurateBussines.Select.GetTotalAmountToTransaction(requestTransaction).TotalAmount; request.ProductID = (int)c.Assignment.idProduct; var model = new AssignmentViewModels() { Error = c.Error, total = to, Assignment = c.Assignment, Transaction = new Transactions(), TransactionList = TransactionConfigurateBussines.Select.GetTransactionList(requestTransaction).TransactionList, AssignmentList = AssignmentBussines.Select.GetAssignmentByProductID(request).AssignmentList, ConditionProductList = ConditionProductBussines.Select.GetConditionProductList().ConditionProductList, CategoryID = CategoryID, CategoryIDFhater = FatherCateogryID, CellarArea = CellarArea, ProductList = ProductBussines.Select.GetProductByAssignmentType(requestProduct).ProductList, EmployeesList = EmployeeBussines.Select.GetEmployeeList().EmployeeList, }; model.Assignment.idCategory = Convert.ToInt16(CategoryID); return(PartialView(model)); }
public ActionResult AssignmentNewInflow(AssignmentViewModels data) { AssignmentBussines.GetAssignmentResponse assignmentData = new AssignmentBussines.GetAssignmentResponse() { Assignment = data.Assignment, transaction = data.Transaction }; AssignmentBussines.GetAssignmentRequest request = new AssignmentBussines.GetAssignmentRequest() { AssignmentID = data.Assignment.id, TransactionTypeID = 2, CellarArea = Convert.ToInt16(data.CellarArea), amount = (int)data.Assignment.amount + (int)data.Transaction.amount }; result = AssignmentBussines.Update.Assignment(assignmentData, request).Message; return(RedirectToAction("AssignmentView", new { CategoryID = data.CategoryID, FatherCateogryID = data.CategoryIDFhater, CellarArea = data.CellarArea, successful = true, ResultAction = "All Changes was successful" })); }
public ActionResult InstructorWithCourses() { SqlConnection con = new SqlConnection(connection); con.Open(); List <AssignmentViewModels> lists = new List <AssignmentViewModels>(); string query = "select FirstName,LastName,Name,Title from Person inner join Instructor on Person.Id=Instructor.InstructorId inner join AssignInstructor on Instructor.InstructorId=AssignInstructor.InstructorId inner join Course on AssignInstructor.CourseId=Course.Id inner join Department on Course.DepartmentId = Department.Id "; SqlCommand cmd = new SqlCommand(query, con); SqlDataReader rdr = cmd.ExecuteReader(); while (rdr.Read()) { var intsWithCourse = new AssignmentViewModels(); intsWithCourse.FirstName = rdr[0].ToString(); intsWithCourse.LastName = rdr[1].ToString(); intsWithCourse.Name = rdr[2].ToString(); intsWithCourse.Title = rdr[3].ToString(); lists.Add(intsWithCourse); } rdr.Close(); return(View(lists)); }