/// <summary> /// Code to insert new LV section into database after user apporval /// </summary> /// <param name="strNewLVSection"></param> /// <param name="ProjectID"></param> /// <param name="ObjEProject"></param> public void InsertLVSection(string strNewLVSecction, int ProjectID, EProject ObjEProject) { try { DataSet dsLVSection = new DataSet(); using (SqlCommand cmd = new SqlCommand()) { cmd.Connection = SQLCon.Sqlconn(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "[P_Ins_LVSection]"; cmd.Parameters.AddWithValue("@LVSection", strNewLVSecction); cmd.Parameters.AddWithValue("@ProjectID", ProjectID); using (SqlDataAdapter da = new SqlDataAdapter(cmd)) { da.Fill(dsLVSection); } if (dsLVSection != null && dsLVSection.Tables.Count > 0 && dsLVSection.Tables[0].Rows.Count > 0) { ObjEProject.LVSectionID = dsLVSection.Tables[0].Rows[0][0]; if (dsLVSection.Tables.Count > 1) { ObjEProject.dtLVSection = dsLVSection.Tables[1]; } } } } catch (Exception ex) { throw; } }
void OnGUI() { GUI.skin.font = font; // Resources.GetBuiltinResource(typeof(Font), "Times.ttf") as Font; GUI.color = Color.black; GUI.Label(new Rect(400, 10, 200, 100), title); InitSceneScript scriptSetActive = gameObject.GetComponent <InitSceneScript>(); if (scriptSetActive != null) { EProject eProject = scriptSetActive.eProject; if (eProject != null) { if (eProject.InventoryItemCurrent != null) { GUI.color = Color.white; // GUI.Label(new Rect(Screen.width / 2.5f, Screen.height / 1.1f, 75, 150), eProject.InventoryItemCurrent.Title, new GUIStyle() { fontSize = 15 }); //Текст GUI.color = Color.white; //GUI.Box(new Rect(900f, 820f, 50f, 60f), ""); //GUI.Box(new Rect(Screen.width / 2, Screen.height / 1.1f, Screen.width / 38, Screen.height / 15), ""); //GUI.DrawTexture(new Rect(Screen.width / 2, Screen.height / 1.1f, Screen.width / 38, Screen.height / 15), eProject.InventoryItemCurrent.Texture); } } } }
public void CreateProject(EProject newProject) { CheckTheEProjectData(newProject); Project proj = newProject.ToDbProject(); if (proj.Date_Create == default(DateTime)) { proj.Date_Create = DateTime.Now; } using (var context = _ContextGenerator.GenerateContext()) { SaveNewProjectInDB(proj, context); newProject.Id = proj.ID_Project; //Hardcoded load the admin Project_Role prRole = (from pr in context.Project_Role where pr.Is_Admin select pr).FirstOrDefault(); if (prRole == null) { throw new InvalidOperationException("An admin role for project not found."); } foreach (decimal userId in newProject.UserIds) { User_Project usProj = new User_Project() { ID_Project = proj.ID_Project, ID_User = userId, ID_Project_Role = prRole.ID_Project_Role }; KeepUserProject(proj.ID_Project, usProj, context); } } }
public MyResult Create(string par0) { EProject obj = JsonConvert.DeserializeObject <EProject>(par0); EProject newObj = CreateProject(obj, MySession.UserID); return(ServiceResult(newObj)); }
/// <summary> /// Code to update article setting of a project /// </summary> /// <param name="ObjEProject"></param> public void UpdateArticleSettings(EProject ObjEProject) { try { using (SqlCommand cmd = new SqlCommand()) { cmd.Connection = SQLCon.Sqlconn(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "[P_Upd_ArticleSettings]"; cmd.Parameters.AddWithValue("@projectID", ObjEProject.ProjectID); cmd.Parameters.AddWithValue("@dtArticleSettings", ObjEProject.dtArticleSettings); cmd.Parameters.AddWithValue("@UserID", ObjEProject.UserID); object oReturn = cmd.ExecuteScalar(); int IValue = 0; if (!int.TryParse(Convert.ToString(oReturn), out IValue)) { throw new Exception(Convert.ToString(oReturn)); } } } catch (Exception ex) { throw; } finally { SQLCon.Close(); } }
void OnGUI() { if (GUI.Button(new Rect(10, Screen.height - 50, 70, 40), "Звонок")) { eProject.GetLogActions(); } if (panelshow && eProject != null) { int width = 350; int heightP1 = 200; int widthButton = 330; int border = 10; int borderText = 10; } else { InitSceneScript scriptSetActive = gameObject.GetComponent <InitSceneScript>(); eProject = scriptSetActive.eProject; } if (isShowDialogResult) { GUI.color = Color.black; GUI.backgroundColor = Color.white; GUI.contentColor = Color.black; int xc = Screen.width / 2 + 100; int yc = Screen.height / 2; int dx = Screen.width - 210; int dy = Screen.height - 10; GUI.Window(1, new Rect(xc - dx / 2, yc - dy / 2, dx, dy), CreateResultDialog, "Результат выполнения задания"); } }
// Update is called once per frame virtual protected void Update() { if (Cursor.lockState == CursorLockMode.Locked && Input.GetMouseButtonDown(0) && chosenGameObject == gameObject)//&& isActive { GameObject gameObjectPlayer = GameObject.Find("Player"); InitSceneScript initSceneScript = gameObjectPlayer.GetComponent <InitSceneScript>(); EProject eProject = initSceneScript.eProject; //if (eProject.InventoryItemCurrent != null && StartInventoryEvent != null) //{ // StartInventoryEvent(gameObject.name, eProject.InventoryItemCurrent.Id, open.ToString()); // eProject.InventoryItemCurrent = null; //} if (ClickActiveObjectEvent != null) { string subject = ""; if (eProject.InventoryItemCurrent != null) { subject = eProject.InventoryItemCurrent.Title; } ClickActiveObjectEvent(gameObject.name, subject); } } }
/// <summary> /// Business Logic for Saving the project details /// </summary> /// <param name="ObjEObject"></param> /// <returns></returns> public void SaveProjectDetails(EProject ObjEObject) { int ProjectID = -1; try { if (ObjEObject != null) { ProjectID = ObjDAL.SaveProjectDetails(ObjEObject); if (ProjectID < 0) { if (System.Threading.Thread.CurrentThread.CurrentCulture.Name.ToString() == "de-DE") { throw new Exception("Fehler beim Speichern der Projektangaben"); } else { throw new Exception("Failed to Save the Project Details"); } } else { ObjEObject.ProjectID = ProjectID; } } } catch (Exception ex) { throw; } }
/// <summary> /// Code to Insert data to OTTO Projects /// </summary> /// <param name="ObjEProject"></param> /// <returns></returns> public string InssertCockpitData(EProject ObjEProject) { string strError = string.Empty; try { using (SqlCommand cmd = new SqlCommand()) { cmd.Connection = SQLCon.CockpitConnection(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "[P_Ins_InsertOTTOProData]"; cmd.Parameters.Add("@dtData", ObjEProject.dtCockpitData); cmd.Parameters.Add("@ProjectNumber", ObjEProject.ProjectNumber); cmd.Parameters.Add("@SValue", ObjEProject.SValue); cmd.Parameters.Add("@XValue", ObjEProject.XValue); cmd.Parameters.Add("@UmlageCost", ObjEProject.UmlageCost); cmd.Parameters.Add("@RevenueTotal", ObjEProject.RevenueTotal); cmd.Parameters.Add("@ProjectDescription", ObjEProject.ProjectDescription); cmd.Parameters.Add("@ProjectStartDate", ObjEProject.ProjectStartDate); cmd.Parameters.Add("@ProjectEndDate", ObjEProject.ProjectEndDate); cmd.Parameters.Add("@UserName", ObjEProject.UserName); object returnObj = cmd.ExecuteScalar(); strError = Convert.ToString(returnObj); } } catch (Exception ex) { throw; } finally { SQLCon.Close(); } return(strError); }
public EProject GetProjectById(decimal projectId) { if (projectId < 1) { throw new ArgumentException("Project id can't be less than 1", nameof(projectId)); } EProject model = null; try { using (var context = _ContextGenerator.GenerateContext()) { Project proj = RetrieveProjectById(projectId, context); if (proj != null) { model = proj.ToEProject(); } } } catch (Exception ex) { throw new InvalidOperationException("Unable to retrieve a project.", ex); } return(model); }
/// <summary> /// Code to get Cover sheets and template paths /// </summary> /// <param name="ObjEProject"></param> /// <returns></returns> public EProject GetPath(EProject ObjEProject) { DataSet dsPath = new DataSet(); try { using (SqlCommand cmd = new SqlCommand()) { cmd.Connection = SQLCon.Sqlconn(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "[P_Get_Path]"; using (SqlDataAdapter da = new SqlDataAdapter(cmd)) { da.Fill(dsPath); } if (dsPath != null && dsPath.Tables.Count > 0 && dsPath.Tables[0].Rows.Count > 0) { ObjEProject.CoverSheetPath = Convert.ToString(dsPath.Tables[0].Rows[0][0]); if (dsPath.Tables.Count > 1 && dsPath.Tables[1].Rows.Count > 0) { ObjEProject.TemplatePath = Convert.ToString(dsPath.Tables[1].Rows[0][0]); } } } } catch (Exception ex) { throw; } finally { SQLCon.Close(); } return(ObjEProject); }
/// <summary> /// /// Business Logic for retreiving the existing project details to show on project screen /// </summary> /// <param name="ObjEProject"></param> public DataSet GetProjectDetails(EProject ObjEProject) { DataSet dsProjectList = new DataSet(); try { using (SqlCommand cmd = new SqlCommand()) { cmd.Connection = SQLCon.Sqlconn(); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@ProjectID", ObjEProject.ProjectID); cmd.CommandText = "[P_Get_ProjectDetails]"; using (SqlDataAdapter da = new SqlDataAdapter(cmd)) { da.Fill(dsProjectList, "ProjectDetails"); } } } catch (Exception ex) { if (System.Threading.Thread.CurrentThread.CurrentCulture.Name.ToString() == "de-DE") { throw new Exception("Fehler beim Laden der generiert werden"); } else { throw new Exception("Error Occured While Retreiving ProjectList"); } } finally{ SQLCon.Close(); } return(dsProjectList); }
/// <summary> /// Code to retreive the existing project details to show on project screen /// </summary> /// <param name="ObjEProject"></param> /// <returns></returns> public DataTable GetProjectDetails(EProject ObjEProject) { DataTable dtProjectList = new DataTable(); try { using (SqlCommand cmd = new SqlCommand()) { cmd.Connection = SQLCon.Sqlconn(); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@ProjectID", ObjEProject.ProjectID); cmd.CommandText = "[P_Get_ProjectDetails]"; using (SqlDataAdapter da = new SqlDataAdapter(cmd)) { da.Fill(dtProjectList); } } } catch (Exception ex) { throw new Exception("Error Occured While Retreiving ProjectList"); } finally { SQLCon.Sqlconn().Close(); } return(dtProjectList); }
public MyResult Create(string par0, string par1) { Assembly asmb = Assembly.GetAssembly(typeof(ServiceReturn)); Type type = asmb.GetType(par0); object obj = JsonConvert.DeserializeObject(par1, type); object newObj = DBBase.Create(obj); if (type == typeof(ETask)) { ETask task = (ETask)obj; if (MySession.UserID != task.ExecutorID && task.ExecutorID != 0) { EUser myuser = DBBase.Get <EUser>(MySession.UserID); EUser excuteuser = DBBase.Get <EUser>(task.ExecutorID); List <string> ulist = new List <string>(); ulist.Add(excuteuser.PushClientID); PushMessageToList.PushToList(task.Title, "指派人" + myuser.Name, ulist, true); } } else if (type == typeof(EPlan)) { EPlan plan = (EPlan)obj; EProject project = DBBase.Get <EProject>(plan.ProjectID); EUserSearch userSearch = new EUserSearch() { IsDefault = false, Name = project.Name + "-" + plan.Name, UserID = MySession.UserID, ProjectID = plan.ProjectID, PlanID = plan.ID }; DBBase.Create(userSearch); } return(ServiceResult(newObj)); }
/// <summary> /// Code to insert new LV section into database after user apporval /// </summary> /// <param name="strNewLVSection"></param> /// <param name="ProjectID"></param> /// <param name="ObjEProject"></param> public void InsertNewLVSection(string strNewLVSection, int ProjectID, EProject ObjEProject) { try { ObjDPosition.InsertLVSection(strNewLVSection, ProjectID, ObjEProject); } catch (Exception ex) { throw; } }
/// <summary> /// Code to save the project details into database /// </summary> /// <param name="ObjEProject"></param> /// <returns></returns> public int SaveProjectDetails(EProject ObjEProject) { int ProjectID = -1; try { using (SqlCommand cmd = new SqlCommand()) { cmd.Connection = SQLCon.Sqlconn(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "P_Ins_Project"; cmd.Parameters.AddWithValue("@ProjectID", ObjEProject.ProjectID); cmd.Parameters.AddWithValue("@Location", ObjEProject.Location); cmd.Parameters.AddWithValue("@ProjectNumber", ObjEProject.ProjectNumber); cmd.Parameters.AddWithValue("@ComissionNumber", ObjEProject.CommissionNumber); cmd.Parameters.AddWithValue("@CustomerID", ObjEProject.KundeID); cmd.Parameters.AddWithValue("@ProjectDescription", ObjEProject.ProjectDescription); cmd.Parameters.AddWithValue("@PlannerID", ObjEProject.PlannedID); cmd.Parameters.AddWithValue("@LV_Raster", ObjEProject.LVRaster); cmd.Parameters.AddWithValue("@LV_Raster_GAEB", ObjEProject.LVRaster_GAEB); cmd.Parameters.AddWithValue("@LV_Sprung", ObjEProject.LVSprunge); cmd.Parameters.AddWithValue("@Intern_X", ObjEProject.InternX); cmd.Parameters.AddWithValue("@Intern_S", ObjEProject.InternS); cmd.Parameters.AddWithValue("@Vat", ObjEProject.Vat); cmd.Parameters.AddWithValue("@Submit_Location", ObjEProject.Submitlocation); cmd.Parameters.AddWithValue("@Submit_Date", ObjEProject.SubmitDate); cmd.Parameters.AddWithValue("@Submit_Time", ObjEProject.SubmitTime); cmd.Parameters.AddWithValue("@Estimated_LV", ObjEProject.EstimatedLvs); cmd.Parameters.AddWithValue("@Round_Off", ObjEProject.RoundingPrice); cmd.Parameters.AddWithValue("@Remarks", ObjEProject.Remarks); cmd.Parameters.AddWithValue("@Project_Discount", ObjEProject.Discount); cmd.Parameters.AddWithValue("@Lock_LVHierarchy", ObjEProject.LockHierarchy); cmd.Parameters.AddWithValue("@UserID", ObjEProject.UserID); cmd.Parameters.AddWithValue("@CustomerName", ObjEProject.KundeName); cmd.Parameters.AddWithValue("@CustomerNumber", ObjEProject.KundeNr); cmd.Parameters.AddWithValue("@PlannerName", ObjEProject.PlannerName); cmd.Parameters.AddWithValue("@ProjectStartDate", ObjEProject.ProjectStartDate); cmd.Parameters.AddWithValue("@ProjectEndDate", ObjEProject.ProjectEndDate); object returnObj = cmd.ExecuteScalar(); if (returnObj != null) { if (!int.TryParse(returnObj.ToString(), out ProjectID)) { throw new Exception("Error Occured While Saving the Project Details"); } } } } catch (Exception ex) { throw; } finally { SQLCon.Sqlconn().Close(); } return(ProjectID); }
private void FillModel(EProject dbProject) { Id = dbProject.Id; ProjectName = dbProject.ProjectName; Description = dbProject.Description; DateCreation = dbProject.DateCreation; LoadUsers(); }
public MyResult GetPlan(int par0) { EPlan plan = DBBase.Query <EPlan>("ProjectID=" + par0).FirstOrDefault(); MyResult ret = ServiceResult(plan); EProject project = DBBase.Get <EProject>(par0); ret.ServiceReturn.AddData("ProjectName", project.Name); return(ret); }
public static EProject ToProjectModel(this Project project) { EProject model = new EProject() { DateCreation = project.Date_Create, Description = project.Description, Id = project.ID_Project, ProjectName = project.Name, }; return(model); }
public static Project ToDbProject(this EProject project) { Project dbProj = new Project() { Date_Create = project.DateCreation, Description = project.Description, ID_Project = project.Id, Name = project.ProjectName }; return(dbProj); }
/// <summary> /// Code to fatch data from data to transfer to OTTOPRO projects /// </summary> /// <param name="ObjEProject"></param> /// <returns></returns> public EProject GetCockpitData(EProject ObjEProject) { try { ObjEProject = ObjDAL.GetCockpitData(ObjEProject); } catch (Exception ex) { throw; } return(ObjEProject); }
/// <summary> /// Convert a project from DB oject into model project. /// </summary> /// <param name="project">Project object which need to convert.</param> /// <param name="provider">Provider of database.</param> /// <returns>Created project model.</returns> /// <exception cref="ArgumentNullException">Empty provider was set.</exception> public static EProject ToEProject(this Project project) { EProject projMod = new EProject() { Id = project.ID_Project, ProjectName = project.Name, Description = project.Description, DateCreation = project.Date_Create, }; return(projMod); }
/// <summary> /// Code to get Cover sheets and template paths /// </summary> /// <param name="ObjEProject"></param> /// <returns></returns> public EProject GetPath(EProject ObjEProject) { try { ObjEProject = ObjDAL.GetPath(ObjEProject); } catch (Exception ex) { throw; } return(ObjEProject); }
/// <summary> /// Code to delete discount positions /// </summary> /// <param name="ObjEProject"></param> /// <returns></returns> public EProject DeleteDiscount(EProject ObjEProject) { try { ObjEProject = ObjDAL.DeleteDiscount(ObjEProject); } catch (Exception ex) { throw; } return(ObjEProject); }
protected override void Init() { base.Init(); EventListener.Get(QQYQ.gameObject).onClick = onQQYQ; BaseOperation_Service.Get <EProject>(GetPar <int>(0), t => { EProject = t.GetData() as EProject; PageTitle.Init("项目团队", App.Instance.Theme.TitleBgColor, App.Instance.Theme.TitleFontColor, BtnBack); PageTitle.AddButton("", App.Instance.ImageManger.ImageList[1], OnAddClicked); ProjectList.OnItemClicked = OnItemClicked; BindData(); }); }
public EProject ToDbProject() { EProject dbProject = new EProject() { Id = Id, ProjectName = ProjectName, Description = Description, DateCreation = DateCreation }; dbProject.UserIds.AddRange(Users.Select(u => u.Id)); return(dbProject); }
/// <summary> /// Code to compare article prices with in project and acrossthe projects /// </summary> /// <param name="ObjEProject"></param> /// <param name="_wg"></param> /// <param name="_wa"></param> /// <param name="_wi"></param> /// <param name="_a"></param> /// <param name="_b"></param> /// <param name="_l"></param> /// <param name="_typ"></param> /// <param name="_Type"></param> /// <param name="_PosID"></param> /// <returns></returns> public EProject GetComparePrice(EProject ObjEProject, string _wg, string _wa, string _wi, string _a, string _b, string _l, string _typ, string _Type, int _PosID) { DataSet dsComnparePrice = new DataSet(); try { using (SqlCommand cmd = new SqlCommand()) { cmd.Connection = SQLCon.Sqlconn(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "[P_Get_ComparePrice]"; cmd.Parameters.AddWithValue("@ProjectID", ObjEProject.ProjectID); cmd.Parameters.AddWithValue("@CustomerID", ObjEProject.KundeNr); cmd.Parameters.AddWithValue("@WG", _wg); cmd.Parameters.AddWithValue("@WA", _wa); cmd.Parameters.AddWithValue("@WI", _wi); cmd.Parameters.AddWithValue("@A", _a); cmd.Parameters.AddWithValue("@B", _b); cmd.Parameters.AddWithValue("@L", _l); cmd.Parameters.AddWithValue("@TYP", _typ); cmd.Parameters.AddWithValue("@TYPE", _Type); cmd.Parameters.AddWithValue("@PositionID", _PosID); using (SqlDataAdapter da = new SqlDataAdapter(cmd)) { da.Fill(dsComnparePrice); } if (dsComnparePrice.Tables.Count > 0) { ObjEProject.dsComaparePrice = dsComnparePrice; } } } catch (Exception ex) { if (System.Threading.Thread.CurrentThread.CurrentCulture.Name.ToString() == "de-DE") { throw new Exception("Fehler beim Laden der generiert werden"); } else { throw new Exception("Error Occured While Retreiving Projects"); } } finally { SQLCon.Close(); } return(ObjEProject); }
/// <summary> /// /// Business Logic for retreiving the project list to show on load project screen /// </summary> /// <param name="ObjEObject"></param> public void GetProjectList(EProject ObjEObject) { try { if (ObjEObject != null) { ObjEObject.dtProjectList = ObjDAL.GetProjectList(); } } catch (Exception ex) { throw ex; } }
/// <summary> /// Code to Insert data to OTTO Projects /// </summary> /// <param name="ObjEProject"></param> /// <returns></returns> public string InssertCockpitData(EProject ObjEProject) { string str = string.Empty; try { str = ObjDAL.InssertCockpitData(ObjEProject); } catch (Exception ex) { throw; } return(str); }
/// <summary> /// Code to fatch data from data to transfer to OTTOPRO projects /// </summary> /// <param name="ObjEProject"></param> /// <returns></returns> public EProject GetCockpitData(EProject ObjEProject) { try { DataSet dsCockpitData = new DataSet(); ObjEProject.dtCockpitData = new DataTable(); using (SqlCommand cmd = new SqlCommand()) { cmd.Connection = SQLCon.Sqlconn(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "[P_Get_CockpitData]"; cmd.Parameters.AddWithValue("@ProjectID", ObjEProject.ProjectID); cmd.Parameters.AddWithValue("@dtCockpitData", ObjEProject.dtTemplateData); using (SqlDataAdapter da = new SqlDataAdapter(cmd)) { da.Fill(dsCockpitData); } if (dsCockpitData != null && dsCockpitData.Tables.Count > 0) { ObjEProject.dtCockpitData = dsCockpitData.Tables[0]; if (dsCockpitData.Tables.Count > 1 && dsCockpitData.Tables[1].Rows.Count > 0) { decimal DValue = 0; if (decimal.TryParse(Convert.ToString(dsCockpitData.Tables[1].Rows[0]["SValue"]), out DValue)) { ObjEProject.SValue = DValue; } if (decimal.TryParse(Convert.ToString(dsCockpitData.Tables[1].Rows[0]["XValue"]), out DValue)) { ObjEProject.XValue = DValue; } if (decimal.TryParse(Convert.ToString(dsCockpitData.Tables[1].Rows[0]["UmlageCost"]), out DValue)) { ObjEProject.UmlageCost = DValue; } if (decimal.TryParse(Convert.ToString(dsCockpitData.Tables[1].Rows[0]["RevenueTotal"]), out DValue)) { ObjEProject.RevenueTotal = DValue; } } } } } catch (Exception ex) { throw; } return(ObjEProject); }