コード例 #1
0
 /// <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;
     }
 }
コード例 #2
0
ファイル: TitlePanel.cs プロジェクト: IgorLevyy/UnityScripts
    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);
                }
            }
        }
    }
コード例 #3
0
        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);
                }
            }
        }
コード例 #4
0
ファイル: ProjectController.cs プロジェクト: U3DC/Team_Open
        public MyResult Create(string par0)
        {
            EProject obj    = JsonConvert.DeserializeObject <EProject>(par0);
            EProject newObj = CreateProject(obj, MySession.UserID);

            return(ServiceResult(newObj));
        }
コード例 #5
0
 /// <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();
     }
 }
コード例 #6
0
    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, "Результат выполнения задания");
        }
    }
コード例 #7
0
    // 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);
            }
        }
    }
コード例 #8
0
        /// <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;
            }
        }
コード例 #9
0
        /// <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);
        }
コード例 #10
0
        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);
        }
コード例 #11
0
        /// <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);
        }
コード例 #12
0
        /// <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);
        }
コード例 #13
0
        /// <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);
        }
コード例 #14
0
        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));
        }
コード例 #15
0
 /// <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; }
 }
コード例 #16
0
        /// <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);
        }
コード例 #17
0
ファイル: ProjectModel.cs プロジェクト: Sansagol/dragonfly
        private void FillModel(EProject dbProject)
        {
            Id           = dbProject.Id;
            ProjectName  = dbProject.ProjectName;
            Description  = dbProject.Description;
            DateCreation = dbProject.DateCreation;

            LoadUsers();
        }
コード例 #18
0
ファイル: PlanController.cs プロジェクト: U3DC/Team_Open
        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);
        }
コード例 #19
0
        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);
        }
コード例 #20
0
        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);
        }
コード例 #21
0
 /// <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);
 }
コード例 #22
0
        /// <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);
        }
コード例 #23
0
 /// <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);
 }
コード例 #24
0
 /// <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);
 }
コード例 #25
0
ファイル: Page_Project_Team.cs プロジェクト: U3DC/Team_Open
 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();
     });
 }
コード例 #26
0
ファイル: ProjectModel.cs プロジェクト: Sansagol/dragonfly
        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);
        }
コード例 #27
0
        /// <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);
        }
コード例 #28
0
 /// <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;
     }
 }
コード例 #29
0
        /// <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);
        }
コード例 #30
0
 /// <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);
 }