}       //	prepare

        /// <summary>
        /// Perrform Process.
        /// </summary>
        /// <returns>Message (clear text)</returns>
        protected override String DoIt()
        {
            _C_Project_ID = GetRecord_ID();
            log.Info("doIt - C_Project_ID=" + _C_Project_ID + ", C_ProjectType_ID=" + _C_ProjectType_ID);
            //
            MProject project = new MProject(GetCtx(), _C_Project_ID, Get_Trx());

            if (project.GetC_Project_ID() == 0 || project.GetC_Project_ID() != _C_Project_ID)
            {
                throw new ArgumentException("Project not found C_Project_ID=" + _C_Project_ID);
            }

            if (project.GetC_ProjectType_ID_Int() > 0)
            {
                throw new ArgumentException("Project already has Type (Cannot overwrite) " + project.GetC_ProjectType_ID());
            }
            //
            MProjectType type = new MProjectType(GetCtx(), _C_ProjectType_ID, Get_Trx());

            if (type.GetC_ProjectType_ID() == 0 || type.GetC_ProjectType_ID() != _C_ProjectType_ID)
            {
                throw new ArgumentException("Project Type not found C_ProjectType_ID=" + _C_ProjectType_ID);
            }
            //	Set & Copy if Service
            project.SetProjectType(type);
            if (!project.Save())
            {
                return(GetRetrievedError(project, "@Error@"));
                // throw new Exception("@Error@");
            }
            //
            return("@OK@");
        } //	doIt
Esempio n. 2
0
        public static int Insert(MProject ent)
        {
            using (SqlConnection con = new SqlConnection(ConnectionDB.GetConnectionString()))
            {
                try
                {
                    SqlCommand cmd = new SqlCommand("sp_Project_Ins", con);
                    cmd.CommandTimeout = 0;
                    cmd.CommandType    = CommandType.StoredProcedure;
                    cmd.Parameters.Add("@IProjectId", SqlDbType.VarChar).Value    = ent.ProjectId;
                    cmd.Parameters.Add("@IPProjectCode", SqlDbType.VarChar).Value = ent.ProjectCode;
                    cmd.Parameters.Add("@IDescription", SqlDbType.VarChar).Value  = ent.Description;
                    cmd.Parameters.Add("@IType", SqlDbType.VarChar).Value         = ent.Type;
                    cmd.Parameters.Add("@IStatus", SqlDbType.VarChar).Value       = ent.Status;
                    cmd.Parameters.Add("@IStartDate", SqlDbType.Int).Value        = ent.StartDate;
                    cmd.Parameters.Add("@IEndDate", SqlDbType.Int).Value          = ent.EndDate;
                    cmd.Parameters.Add("@ITitle", SqlDbType.VarChar).Value        = ent.Title;
                    cmd.Parameters.Add("@IAwardId", SqlDbType.VarChar).Value      = ent.AwardId;
                    cmd.Parameters.Add("@IAwardStatus", SqlDbType.VarChar).Value  = ent.AwardStatus;

                    con.Open();

                    cmd.ExecuteNonQuery();

                    con.Close();
                }
                catch (Exception ex)
                {
                    return(2);
                }
            }

            return(0);
        }
Esempio n. 3
0
        }       //	prepare

        /// <summary>
        /// Process
        /// </summary>
        /// <returns>summary</returns>
        protected override String DoIt()
        {
            log.Info("C_Lead_ID=" + _C_Lead_ID + ",C_ProjectType_ID=" + _C_ProjectType_ID);
            if (_C_Lead_ID == 0)
            {
                throw new Exception("@C_Lead_ID@ ID=0");
            }
            if (_C_ProjectType_ID == 0)
            {
                throw new Exception("@C_ProjectType_ID@ ID=0");
            }

            MLead lead = new MLead(GetCtx(), _C_Lead_ID, Get_TrxName());

            if (lead.Get_ID() != _C_Lead_ID)
            {
                throw new Exception("@NotFound@: @C_Lead_ID@ ID=" + _C_Lead_ID);
            }
            //
            String retValue = lead.CreateProject(_C_ProjectType_ID);

            if (retValue != null)
            {
                throw new SystemException(retValue);
            }
            lead.Save();
            MProject project = lead.GetProject();

            //
            return("@C_Project_ID@ " + project.GetName());
        } //	doIt
Esempio n. 4
0
        }       //	prepare

        /// <summary>
        /// Perrform Process.
        /// </summary>
        /// <returns>Message (translated text)</returns>
        protected override String DoIt()
        {
            MProject project = new MProject(GetCtx(), m_C_Project_ID, Get_TrxName());

            log.Info("doIt - " + project);

            MProjectLine[] projectLines = project.GetLines();
            if (MProject.PROJECTCATEGORY_WorkOrderJob.Equals(project.GetProjectCategory()) ||
                MProject.PROJECTCATEGORY_AssetProject.Equals(project.GetProjectCategory()))
            {
                /** @todo Check if we should close it */
            }

            //	Close lines
            for (int line = 0; line < projectLines.Length; line++)
            {
                projectLines[line].SetProcessed(true);
                projectLines[line].Save();
            }

            project.SetProcessed(true);
            project.Save();

            return("");
        } //	doIt
Esempio n. 5
0
        public List <MProject> GetProjects(MProject eProject)
        {
            List <MProject>  projects = new List <MProject>();
            ProjectsRequest  request  = new ProjectsRequest();
            ProjectsResponse response = new ProjectsResponse();

            request.Project = eProject;

            request.ApplicationToken = ConfigurationManager.AppSettings["ApplicationToken"].ToString();

            string bodyrequest  = JsonConvert.SerializeObject(request);
            string statuscode   = string.Empty;
            string bodyresponse = new Helper().InvokeApi("Project/api/project", "Getprojects", bodyrequest, ref statuscode);

            if (statuscode.Equals("OK"))
            {
                response = JsonConvert.DeserializeObject <ProjectsResponse>(bodyresponse);

                if (response.Code.Equals("0"))
                {
                    projects = response.projects;
                }
            }

            return(projects);
        }
Esempio n. 6
0
        public MProject GetProject()
        {
            MProject    proj  = new MProject();
            IIfcProject iProj = _model.Instances.OfType <IIfcProject>().First();

            proj.FileName = file;

            proj.Author = iProj.OwnerHistory.OwningUser.ThePerson.ToString();

            var createTime = DateTimeOffset.FromUnixTimeSeconds(iProj.OwnerHistory.CreationDate);

            proj.Created = createTime.DateTime;

            if (iProj.OwnerHistory.LastModifiedDate.HasValue == false)
            {
                proj.LastChanged = createTime.DateTime;
            }
            else
            {
                var time = DateTimeOffset.FromUnixTimeSeconds(iProj.OwnerHistory.LastModifiedDate.Value);
                proj.LastChanged = time.DateTime;
            }

            proj.ProjectName = iProj.Name;

            return(proj);
        }
Esempio n. 7
0
        public ProjectsResponse GetProjects([FromBody] ProjectRequest request)
        {
            ProjectsResponse response = new ProjectsResponse();

            try
            {
                if (!BAplication.ValidateAplicationToken(request.ApplicationToken))
                {
                    response.Code    = "2";
                    response.Message = Messages.ApplicationTokenNoAutorize;
                    return(response);
                }

                MProject project = new MProject();
                project.Status    = request.Project.Status;
                project.Title     = request.Project.Title;
                project.StartDate = request.Project.StartDate;
                project.EndDate   = request.Project.EndDate;

                List <MProject> projects = BProject.List(project);

                response.Code     = "0";
                response.Message  = "Success";
                response.Projects = projects.ToArray();
            }
            catch (Exception ex)
            {
                response.Code    = "2";
                response.Message = ex.Message;
            }

            return(response);
        }
Esempio n. 8
0
        public static MProject GetProject(int projectid)
        {
            Dictionary <int, MProject> projs = new Dictionary <int, MProject>();

            SqliteCommand cm = _sqliteConn.CreateCommand();

            cm.CommandText = "SELECT id, version, projectName, author, filename, created, lastChanged FROM projects WHERE id = @projectid;";
            cm.Prepare();

            cm.Parameters.AddWithValue("@projectid", projectid);

            SqliteDataReader rd = cm.ExecuteReader();

            if (rd.HasRows)
            {
                rd.Read();
                MProject p = new MProject();
                p.ProjectID      = rd.GetInt32(0);
                p.ProjectVersion = rd.GetInt32(1);
                p.ProjectName    = rd.GetString(2);
                p.Author         = rd.GetString(3);
                p.FileName       = rd.GetString(4);
                p.Created        = rd.GetDateTime(5);
                p.LastChanged    = rd.GetDateTime(6);
                projs.Add(p.ProjectID, p);

                return(p);
            }

            return(null);
        }
Esempio n. 9
0
        private void mnuContextMenu_Click(object sender, RoutedEventArgs e)
        {
            MenuItem mnu  = (sender as MenuItem);
            string   name = mnu.Name;

            if (name.Equals("mnuEdit"))
            {
                showEditWindow();
            }
            else if (name.Equals("mnuCopy"))
            {
                CUtil.EnableForm(false, ParentControl);
                CTable newobj = OnixWebServiceAPI.CopyProject(currentObj.GetDbObject());

                if (newobj != null)
                {
                    MProject ivd = new MProject(newobj);
                    itemSources.Insert(0, ivd);
                }
                else
                {
                    //Error here
                    CHelper.ShowErorMessage(OnixWebServiceAPI.GetLastErrorDescription(), "ERROR_USER_ADD", null);
                }

                CUtil.EnableForm(true, ParentControl);
            }
        }
        private void LoadData()
        {
            cboProduct.Focus();

            CTable t = new CTable("");

            vw = new MProject(t);
            vw.CreateDefaultValue();
            DataContext = vw;

            CUtil.EnableForm(false, this);

            if (Mode.Equals("E"))
            {
                CTable m = OnixWebServiceAPI.SubmitObjectAPI("GetProjectInfo", actualView.GetDbObject());
                if (m != null)
                {
                    vw.SetDbObject(m);
                    vw.NotifyAllPropertiesChanged();
                }
            }

            vw.IsModified = false;

            CUtil.EnableForm(true, this);
        }
        private Boolean ValidateData()
        {
            Boolean result = false;

            result = CHelper.ValidateTextBox(lblDesc, txtDesc, false);
            if (!result)
            {
                return(result);
            }

            result = CHelper.ValidateComboBox(lblRole, cboRole, false);
            if (!result)
            {
                return(result);
            }

            CTable   ug = new CTable("");
            MProject uv = new MProject(ug);

            if (vw != null)
            {
                uv.ProjectID   = (vw as MProject).ProjectID;
                uv.ProjectCode = (vw as MProject).ProjectCode;
            }

            if (OnixWebServiceAPI.IsObjectExistAPI("SassIsDiskImageExist", uv.GetDbObject()))
            {
                CHelper.ShowKeyExist(lblName, txtName);
                return(false);
            }

            return(result);
        }
Esempio n. 12
0
        /**
         *  Perrform process.
         *  @return Message (clear text)
         *  @throws Exception if not successful
         */
        protected override string DoIt()
        {
            //	Check Parameter
            m_project = new MProject(GetCtx(), m_C_Project_ID, Get_TrxName());
            if (!(MProject.PROJECTCATEGORY_WorkOrderJob.Equals(m_project.GetProjectCategory()) ||
                  MProject.PROJECTCATEGORY_AssetProject.Equals(m_project.GetProjectCategory())))
            {
                throw new ArgumentException("Project not Work Order or Asset =" + m_project.GetProjectCategory());
            }
            log.Info(m_project.ToString());

            //
            if (m_M_InOut_ID != 0)
            {
                return(IssueReceipt());
            }
            if (m_S_TimeExpense_ID != 0)
            {
                return(IssueExpense());
            }
            if (m_M_Locator_ID == 0)
            {
                throw new ArgumentException("Locator missing");
            }
            if (m_C_ProjectLine_ID != 0)
            {
                return(IssueProjectLine());
            }
            return(IssueInventory());
            //return "";
        }
Esempio n. 13
0
        /// <summary>
        /// Create Facts (the accounting logic) for
        ///  PJI
        ///  <pre>
        ///  Issue
        ///      ProjectWIP      DR
        ///      Inventory               CR
        ///  </pre>
        ///  Project Account is either Asset or WIP depending on Project Type
        /// </summary>
        /// <param name="?"></param>
        /// <returns>fact</returns>
        public override List <Fact> CreateFacts(MAcctSchema as1)
        {
            //  create Fact Header
            Fact fact = new Fact(this, as1, Fact.POST_Actual);

            SetC_Currency_ID(as1.GetC_Currency_ID());

            MProject project         = new MProject(GetCtx(), _issue.GetC_Project_ID(), null);
            String   ProjectCategory = project.GetProjectCategory();
            MProduct product         = MProduct.Get(GetCtx(), _issue.GetM_Product_ID());

            //  Line pointers
            FactLine dr = null;
            FactLine cr = null;

            //  Issue Cost
            Decimal?cost = null;

            if (_issue.GetM_InOutLine_ID() != 0)
            {
                cost = GetPOCost(as1);
            }
            else if (_issue.GetS_TimeExpenseLine_ID() != 0)
            {
                cost = GetLaborCost(as1);
            }
            if (cost == null)   //	standard Product Costs
            {
                cost = _line.GetProductCosts(as1, GetAD_Org_ID(), false);
            }

            //  Project         DR
            int acctType = ACCTTYPE_ProjectWIP;

            if (MProject.PROJECTCATEGORY_AssetProject.Equals(ProjectCategory))
            {
                acctType = ACCTTYPE_ProjectAsset;
            }
            dr = fact.CreateLine(_line,
                                 GetAccount(acctType, as1), as1.GetC_Currency_ID(), cost, null);
            dr.SetQty((Decimal?)Decimal.Negate(Utility.Util.GetValueOfDecimal(_line.GetQty())));

            //  Inventory               CR
            acctType = ProductCost.ACCTTYPE_P_Asset;
            if (product.IsService())
            {
                acctType = ProductCost.ACCTTYPE_P_Expense;
            }
            cr = fact.CreateLine(_line,
                                 _line.GetAccount(acctType, as1),
                                 as1.GetC_Currency_ID(), null, cost);
            cr.SetM_Locator_ID(_line.GetM_Locator_ID());
            cr.SetLocationFromLocator(_line.GetM_Locator_ID(), true);   // from Loc
            //
            List <Fact> facts = new List <Fact>();

            facts.Add(fact);
            return(facts);
        }
Esempio n. 14
0
 private void OnProjectListItemSelectionChange(List <object> obj)
 {
     if (projectList.selectedIndex < this.sceneContainer.projects.Count)
     {
         currentSelectedProject = (MProject)this.sceneContainer.projects[projectList.selectedIndex];
     }
     this.RefreshVideoClips();
 }
        private void addAccountDocItems(ArrayList items)
        {
            int ind = 0;

            MProject firstProj = null;

            foreach (MAuxilaryDocItem ai in items)
            {
                MAccountDocItem di = new MAccountDocItem(new CTable(""));
                di.ExtFlag = "A";

                di.SelectType         = ai.SelectType;
                di.ItemCode           = ai.ItemCode;
                di.ItemNameThai       = ai.ItemNameThai;
                di.ItemId             = ai.ItemId;
                di.FreeText           = ai.FreeText;
                di.ServiceCode        = ai.ServiceCode;
                di.ServiceName        = ai.ServiceName;
                di.ServiceID          = ai.ServiceID;
                di.Quantity           = ai.Quantity;
                di.Discount           = ai.Discount;
                di.UnitPrice          = ai.UnitPrice;
                di.TotalAfterDiscount = ai.TotalAfterDiscount;
                di.VatTaxFlag         = ai.VatTaxFlag;
                di.WHTaxFlag          = ai.WHTaxFlag;
                di.WHTaxPct           = ai.WHTaxPct;
                di.VatTaxPct          = ai.VatTaxPct;
                di.ItemNote           = ai.DocumentNo;
                di.ProjectID          = ai.ProjectID;
                di.ProjectCode        = ai.ProjectCode;
                di.ProjectName        = ai.ProjectName;
                di.ProjectGroupName   = ai.ProjectGroupName;
                di.RefPoNo            = ai.DocumentNo;
                di.WhGroupCriteria    = ai.WhGroup;
                di.PoItemID           = ai.AuxilaryDocItemID;
                di.PoID = ai.AuxilaryDocID;

                if (ind == 0)
                {
                    firstProj = (MProject)di.ProjectObj;
                }

                ind++;

                vw.AddAccountDocItem(di);
            }

            if (vw.ProjectID.Equals("") && (firstProj != null))
            {
                //If not yet been set
                vw.ProjectObj = firstProj;
            }

            String poString = vw.GetRefPoString();

            vw.RefPoNo = poString;
        }
Esempio n. 16
0
        /// <summary>
        /// Create Opportunity Lines
        /// </summary>
        /// <param name="ctx"></param>
        /// <param name="ReqLines">Related Product data</param>
        /// <param name="Record_ID">Record ID</param>
        /// <returns>Message as string</returns>
        public string CreateOppLines(Ctx ctx, List <RelatedProductData> ReqLines, int Record_ID)
        {
            int          TotalCount, SavedCount = 0;
            int          LineNo;
            Decimal      Discount;
            string       msg;
            MProjectLine POLine;

            LineNo = Util.GetValueOfInt(DB.ExecuteScalar("SELECT MAX(Line) FROM C_ProjectLine WHERE C_Project_ID=" + Record_ID));
            MProject PO = new MProject(ctx, Record_ID, null);

            TotalCount = ReqLines.Count;
            for (int i = 0; i < ReqLines.Count; i++)
            {
                LineNo += 10;
                POLine  = new MProjectLine(PO);
                POLine.SetM_Product_ID(ReqLines[i].Product_ID);
                if (POLine.Get_ColumnIndex("M_AttributeSetInstance_ID") >= 0)
                {
                    POLine.SetM_AttributeSetInstance_ID(ReqLines[i].AttributeSetInstance_ID);
                }
                if (POLine.Get_ColumnIndex("C_UOM_ID") >= 0)
                {
                    POLine.Set_Value("C_UOM_ID", ReqLines[i].UOM_ID);
                }
                POLine.SetPlannedQty(ReqLines[i].QtyEntered);
                POLine.SetLine(LineNo);

                if (Math.Sign(ReqLines[i].PriceList) == 0)
                {
                    Discount = Env.ZERO;
                }
                else
                {
                    Decimal multiplier = Decimal.Round(Decimal.Divide(Decimal.Multiply(ReqLines[i].PriceStd, Env.ONEHUNDRED)
                                                                      , ReqLines[i].PriceList), 2, MidpointRounding.AwayFromZero);
                    Discount = Decimal.Subtract(Env.ONEHUNDRED, multiplier);
                }
                POLine.SetDiscount(Discount);
                POLine.SetPlannedPrice(ReqLines[i].PriceStd);
                POLine.SetPriceList(ReqLines[i].PriceList);
                if (POLine.Save())
                {
                    SavedCount++;
                }
            }
            if (TotalCount == SavedCount)
            {
                msg = Msg.GetMsg(ctx, "VIS_SuccessFullyInserted");
            }
            else
            {
                msg = SavedCount + Msg.GetMsg(ctx, "VIS_NoOfLineSaved") + TotalCount + ".";
            }
            return(msg);
        }
Esempio n. 17
0
        /// <summary>
        /// Get DocumentNo
        /// </summary>
        /// <returns>document no</returns>
        public new String GetDocumentNo()
        {
            MProject p = _issue.GetParent();

            if (p != null)
            {
                return(p.GetValue() + " #" + _issue.GetLine());
            }
            return("(" + _issue.Get_ID() + ")");
        }
 /// <summary>
 /// Checks duplicates of project.
 /// </summary>
 /// <param name="mProject"></param>
 /// <returns></returns>
 private bool isContain(MProject mProject)
 {
     for (int i = 0; i < Projects.Count; i++)
     {
         if (Projects[i].ProjectID == mProject.ProjectID)
         {
             return(true);
         }
     }
     return(false);
 }
Esempio n. 19
0
        public ProjectResponse InsertProject([FromBody] ProjectsRequest request)
        {
            ProjectResponse response = new ProjectResponse();

            using (TransactionScope scope = new TransactionScope())
            {
                try
                {
                    if (!BAplication.ValidateAplicationToken(request.ApplicationToken))
                    {
                        response.Code    = "2";
                        response.Message = Messages.ApplicationTokenNoAutorize;
                        return(response);
                    }

                    string webRoot     = _env.ContentRootPath;
                    string rootPath    = _appSettings.Value.rootPath;
                    string ProjectPath = _appSettings.Value.ProjectPath;

                    BaseRequest baseRequest = new BaseRequest();

                    foreach (MProject model in request.Projects)
                    {
                        MProject project = new MProject();

                        project.ProjectCode = model.ProjectCode;
                        project.Description = model.Description;
                        project.Type        = model.Type;
                        project.Status      = model.Status;
                        project.StartDate   = model.StartDate;
                        project.EndDate     = model.EndDate;
                        project.Title       = model.Title;
                        project.AwardId     = model.AwardId;
                        project.AwardStatus = model.AwardStatus;

                        BProject.Insert(project);
                    }

                    response.Code    = "0";
                    response.Message = "Success";

                    scope.Complete();
                }
                catch (Exception ex)
                {
                    response.Code    = "2";
                    response.Message = ex.Message;

                    scope.Dispose();
                }
            }

            return(response);
        }
Esempio n. 20
0
        public void Add(MProject mProject)
        {
            this._context.Projects.Add(new Project
            {
                ProjectId     = new Guid(),
                ProjectName   = mProject.ProjectName,
                ProjectNumber = mProject.ProjectNumber,
                ModifiedDate  = DateTime.Now,
            });

            this._context.SaveChanges();
        }
Esempio n. 21
0
        public void Update(MProject mProject, Guid projectId)
        {
            var _project = this._context.Projects
                           .Where(p => p.ProjectId == projectId)
                           .First <Project>();

            _project.ProjectName   = mProject.ProjectName;
            _project.ProjectNumber = mProject.ProjectNumber;

            _context.Projects.Update(_project);
            _context.SaveChanges();
        }
        private Boolean ValidateData()
        {
            Boolean result = false;

            if (!projectGroupMap.ContainsKey("SASS"))
            {
                CMessageBox.Show(CLanguage.getValue("ERROR_NO_SASS_PROJECT_FOUND"), "ERROR", MessageBoxButton.OK, MessageBoxImage.Error);
                return(false);
            }

            result = CHelper.ValidateComboBox(lblCode, cboProduct, false);
            if (!result)
            {
                return(result);
            }

            result = CHelper.ValidateTextBox(lblCode, txtCBU, false);
            if (!result)
            {
                return(result);
            }

            result = CHelper.ValidateTextBox(lblCode, txtSystem, false);
            if (!result)
            {
                return(result);
            }

            result = CHelper.ValidateTextBox(lblName, txtName, false);
            if (!result)
            {
                return(result);
            }

            CTable   ug = new CTable("");
            MProject uv = new MProject(ug);

            if (vw != null)
            {
                uv.ProjectID   = (vw as MProject).ProjectID;
                uv.ProjectCode = (vw as MProject).ProjectCode;
            }

            if (OnixWebServiceAPI.IsObjectExistAPI("IsProjectExist", uv.GetDbObject()))
            {
                CHelper.ShowKeyExist(lblCode, txtName);
                return(false);
            }

            return(result);
        }
Esempio n. 23
0
        private void showEditWindow()
        {
            if (!CHelper.VerifyAccessRight("SASS_PROJECT_VIEW"))
            {
                return;
            }

            MProject v = (MProject)currentObj;

            WinAddEditSassProject w = new WinAddEditSassProject("E");

            w.ViewData = v;
            w.Title    = CLanguage.getValue("edit") + " " + CLanguage.getValue("project");
            w.ShowDialog();
        }
Esempio n. 24
0
        private void OnAddProjectButtonClick()
        {
            var p = MProject.CreateInstance <MProject>();

            p.name        = Guid.NewGuid().ToString();
            p.ProjectName = "Project " + (this.sceneContainer.projects.Count + 1);

            AssetDatabase.AddObjectToAsset(p, this.sceneContainer);
            this.sceneContainer.projects.Add(p);
            EditorUtility.SetDirty(this.sceneContainer);

            AssetDatabase.SaveAssets();

            projectList.selectedIndex = this.sceneContainer.projects.Count - 1;
        }
Esempio n. 25
0
        //TODO: We need to refactor this later, this is just a quick and dirty hack for sqlite support. Create an interface and generalize db usage to multiple backend providers (MariaDB)
        public static long InsertProject(MProject p)
        {
            SqliteCommand cm = _sqliteConn.CreateCommand();

            cm.CommandText = "INSERT INTO projects (version, projectName, author, filename, created, lastChanged) VALUES (@version, @projectName, @author, @filename, @created, @lastChanged); SELECT last_insert_rowid();";
            cm.Prepare();

            cm.Parameters.AddWithValue("@version", p.ProjectVersion);
            cm.Parameters.AddWithValue("@projectName", p.ProjectName);
            cm.Parameters.AddWithValue("@author", p.Author);
            cm.Parameters.AddWithValue("@filename", p.FileName);
            cm.Parameters.AddWithValue("@created", p.Created);
            cm.Parameters.AddWithValue("@lastChanged", p.LastChanged);

            return((long)cm.ExecuteScalar());
        }
        private void addItemFromPayroll(ArrayList arr, int type)
        {
            String projectVariable = "PAYROLL_PROJECT_CODE";
            String serviceVariable = "PAYROLL_SERVICE_CODE";

            if (type == 2)
            {
                serviceVariable = "SOCIAL_SECURITY_SERVICE_CODE";
            }

            String   projectCode = CGlobalVariable.GetGlobalVariableValue(projectVariable);
            CTable   p           = getObject(projectCode, "PROJECT_CODE", "GetProjectList", "PROJECT_LIST");
            MProject pj          = new MProject(p);

            String   serviceCode = CGlobalVariable.GetGlobalVariableValue(serviceVariable);
            CTable   s           = getObject(serviceCode, "SERVICE_CODE", "GetServiceList", "SERVICE_LIST");
            MService sv          = new MService(s);

            foreach (MVPayrollDocument pd in arr)
            {
                CTable          t   = new CTable("");
                MAccountDocItem mdi = new MAccountDocItem(t);
                mdi.CreateDefaultValue();
                mdi.SelectType = "1";
                mdi.ServiceObj = sv;
                mdi.ProjectObj = pj;

                vw.AddAccountDocItem(mdi);

                MAuxilaryDocSubItem mi = new MAuxilaryDocSubItem(new CTable(""));
                mi.Description = String.Format("{0}-{1} {2}", pd.FromSalaryDateFmt, pd.ToSalaryDateFmt, pd.EmployeeTypeDesc);
                mi.SubItemDate = pd.ToSalaryDate;
                mi.UnitPrice   = pd.ReceiveAmount;

                if (type == 2)
                {
                    mi.UnitPrice = pd.SocialSecurityCompanyAmount;
                }

                mi.Quantity = "1.00";
                mdi.AddItemDetail(mi);

                mdi.CalculateSubItemTotal();
                mdi.SerializeItemDetails();
            }
        }
Esempio n. 27
0
        /// <summary>
        /// 添加项目
        /// </summary>
        /// <param name="mProject"></param>
        /// <returns></returns>
        public bool EditProject(MProject mProjectEdit)
        {
            if (mProjectEdit == null || mProjectEdit.Id <= 0)
            {
                return(false);
            }
            var datas = GetList();
            var index = datas.FindIndex(d => d.Id == mProjectEdit.Id);

            if (index < 0)
            {
                return(false);
            }
            datas[index] = mProjectEdit;
            datas.XmlSerializeToFile(_filePath, Encoding.UTF8);
            return(true);
        }
Esempio n. 28
0
        public IHttpContext InsertTestProject(IHttpContext ctx)
        {
            MProject test = new MProject();

            test.ProjectVersion = 1337;
            test.Author         = "TestAuthor";
            test.ProjectName    = "A Testproject";
            test.Created        = DateTime.Now;
            test.LastChanged    = DateTime.Now;

            long id = SqliteDb.InsertProject(test);

            test.ProjectID = (int)id;

            HttpResponseExtensions.SendResponse(ctx.Response, HttpStatusCode.Ok, JsonConvert.SerializeObject(test, Formatting.Indented));
            return(ctx);
        }
        /// <summary>
        /// Gets and returns serializable projects.
        /// </summary>
        /// <param name="dataModel"></param>
        /// <returns></returns>
        private MProject[] GetMProjects(DataModel dataModel)
        {
            MProject[] mProjects = new MProject[dataModel.Projects.Length];
            for (int i = 0; i < mProjects.Length; i++)
            {
                mProjects[i] = new MProject()
                {
                    ProjectID          = dataModel.Projects[i].ProjectID,
                    ProjectName        = dataModel.Projects[i].ProjectName,
                    ProjectCreatedDate = dataModel.Projects[i].ProjectCreatedDate,
                    ProjectDueDate     = dataModel.Projects[i].ProjectDueDate,
                    ProjectDescription = dataModel.Projects[i].ProjectDescription
                };
            }

            return(mProjects);
        }
Esempio n. 30
0
        public ActionResult Register(LoadProjectsViewModel model, HttpPostedFileBase imageFile)
        {
            JSonResult objResult = new JSonResult();
            string     response  = string.Empty;

            try
            {
                Session objSession = new Session()
                {
                    UserId = AutenticationManager.GetUser().IdUsuario,
                };

                List <MProject>           entList     = new List <MProject>();
                List <ModelProjectResult> entListData = new List <ModelProjectResult>();
                entListData = (List <ModelProjectResult>)Session["ListProjects"];

                foreach (ModelProjectResult item in entListData)
                {
                    MProject mProject = new MProject();
                    mProject.ProjectCode = item.ProjectCode;
                    mProject.Description = item.Description;
                    mProject.Type        = item.Type;
                    mProject.Status      = item.Status;
                    mProject.StartDate   = Convert.ToInt32(Extension.ToFormatDateYYYYMMDD(item.StartDateStr));
                    mProject.EndDate     = Convert.ToInt32(Extension.ToFormatDateYYYYMMDD(item.EndDateStr));//item.EndDate;
                    mProject.Title       = item.Title;
                    mProject.AwardId     = item.AwardId;
                    mProject.AwardStatus = item.AwardStatus;
                    entList.Add(mProject);
                }

                response = new WebApiProject().InsertProject(entList, objSession);

                string statusCode    = response.Split('|')[0];
                string statusMessage = response.Split('|')[1];

                objResult.isError = statusCode.Equals("2");
                objResult.message = string.Format(MessageResource.SaveSuccess, "Projects");;
            }
            catch (Exception ex)
            {
                objResult.message = string.Format(MessageResource.SaveError + "Error :" + ex.Message, "Projects");
            }
            return(Json(objResult));
        }