public static Guid? GetCashflowClauseID(Entities db, CashflowClause clause1c, Company company) { string clauseCode = "1С" + String.Format("{0,5}", clause1c.Код).Replace(" ", "0"); if (clauses.Count == 0) { clauses = (from x in db.tbl_CashflowClause select x).ToList(); } if (clauses.Count(x => x.Code == clauseCode) == 0) { string clauseName = clause1c.Наименование.Trim(); if(clauseName.Length> 200) { clauseName = clauseName.Substring(0, 200); } string clauseDescr = (clause1c.ВидДвижения + ": " + clause1c.РазрезДеятельности).Trim(); if (clauseDescr.Length > 200) { clauseDescr = clauseDescr.Substring(0, 200); } clauseCode = clauseCode.Trim(); if (clauseCode.Length > 200) { clauseCode = clauseCode.Substring(0, 200); } //add clause tbl_CashflowClause clauseTs = new tbl_CashflowClause { ID = Guid.NewGuid(), Name = clauseName, Code = clauseCode, CreatedByID = new Guid(Constants.DefaultAdminID), CreatedOn = DateTime.Now, Description = clauseDescr, ExpenseDevideType = null, ExpenseTypeID = null, GroupID = null, IsTZP = null, ModifiedByID = new Guid(Constants.DefaultAdminID), ModifiedOn = DateTime.Now, TypeID = null }; db.tbl_CashflowClause.Add(clauseTs); db.SaveChanges(); clauses.Add(clauseTs); return clauseTs.ID; } return clauses.FirstOrDefault(x => x.Code == clauseCode).ID; }
private CashflowClause GetCashflowClauseDetails(double cashflowClauseCode) { CashflowClause res = new CashflowClause(); res.RowNum = cashflowClauseCode.ToString(); res.Код = ImportedRows.FirstOrDefault(r => (double)r[1] == cashflowClauseCode && r[2].ToString() == "Код")[5].ToString().Trim(); res.Наименование = ImportedRows.FirstOrDefault(r => (double)r[1] == cashflowClauseCode && r[2].ToString() == "Наименование")[5].ToString().Trim(); res.ВидДвижения = ImportedRows.FirstOrDefault(r => (double)r[1] == cashflowClauseCode && r[2].ToString() == "ВидДвижения")[5].ToString().Trim(); res.РазрезДеятельности = ImportedRows.FirstOrDefault(r => (double)r[1] == cashflowClauseCode && r[2].ToString() == "РазрезДеятельности")[5].ToString().Trim(); return res; }