private JlNavigatorTDS SubmitSearchForViews() { string sqlCommand = ""; int viewId = Int32.Parse(ddlView.SelectedValue.Trim()); JlNavigator jlNavigator = new JlNavigator(); string workType = "Junction Lining Lateral"; int companyId = Int32.Parse(hdfCompanyId.Value.Trim()); int currentProjectId = Int32.Parse(hdfCurrentProjectId.Value.Trim()); // ... Load SqlCommand WorkViewGateway workViewGateway = new WorkViewGateway(); workViewGateway.LoadByViewId(viewId, companyId); sqlCommand = workViewGateway.GetSqlCommand(viewId); // ... Load data jlNavigator.LoadForViewsProjectIdCompanyIdWorkType(sqlCommand, currentProjectId, companyId, workType); return (JlNavigatorTDS)jlNavigator.Data; }
private MrNavigatorTDS SubmitSearchForViews() { string sqlCommand = ""; int viewId = Int32.Parse(ddlView.SelectedValue.Trim()); MrNavigator mrNavigator = new MrNavigator(); string workType = hdfWorkType.Value.Trim(); int companyId = Int32.Parse(hdfCompanyId.Value.Trim()); int currentProjectId = Int32.Parse(hdfCurrentProjectId.Value.Trim()); bool inProject = bool.Parse(hdfInProject.Value); // ... Load SqlCommand WorkViewGateway workViewGateway = new WorkViewGateway(); workViewGateway.LoadByViewId(viewId, companyId); sqlCommand = workViewGateway.GetSqlCommand(viewId); // ... Load data mrNavigator.LoadForViewsProjectIdCompanyIdWorkType(sqlCommand, currentProjectId, companyId, workType, inProject); return (MrNavigatorTDS)mrNavigator.Data; }
/// <summary> /// SaveForEdit /// </summary> /// <param name="viewId">viewId</param> /// <param name="loginId">loginId</param> /// <param name="name">name</param> /// <param name="type">type</param> /// <param name="logic">logic</param> /// <param name="sqlCommand">sqlCommand</param> /// <param name="workType">workType</param> /// <param name="companyId">companyId</param> public void SaveForEdit(int viewId, int loginId, string name, string type, string logic, string sqlCommand, string workType, int companyId, string newName, string newType) { WorkViewGateway workViewGateway = new WorkViewGateway(); workViewGateway.LoadByViewId(viewId, companyId); int originalViewId = viewId; int originalLoginId = workViewGateway.GetLoginId(viewId); string originalName = workViewGateway.GetName(viewId); string originalType = workViewGateway.GetType(viewId); string originalLogic = workViewGateway.GetLogic(viewId); string originalSqlCommand = workViewGateway.GetSqlCommand(viewId); string originalWorkType = workViewGateway.GetWorkType(viewId); bool originalDeleted = workViewGateway.GetDeleted(viewId); int originalCompanyId = workViewGateway.GetCompanyId(viewId); UpdateDirect(originalViewId, originalLoginId, originalName, originalType, originalLogic, originalSqlCommand, originalWorkType, originalDeleted, originalCompanyId, viewId, loginId, newName, newType, logic, sqlCommand, workType, false, companyId); }