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;
}
