private void FillDataRec(SqlDataReader reader, DFRec dfrec) { int resInt = 0; decimal resDec = 0; DateTime resDate = DateTime.MinValue; if (int.TryParse(reader["DFRec_Id"].ToString(), out resInt)) { dfrec.DFRec_Id = resInt; } if (int.TryParse(reader["DFRec_DFCt_Id"].ToString(), out resInt)) { dfrec.DFRec_DFCt_Id = resInt; } dfrec.DFRec_USREOU = reader["DFRec_USREOU"].ToString(); if (int.TryParse(reader["DFRec_Type"].ToString(), out resInt)) { dfrec.DFRec_Type = resInt; } dfrec.DFRec_FName = reader["DFRec_FName"].ToString(); dfrec.DFRec_MName = reader["DFRec_MName"].ToString(); dfrec.DFRec_LName = reader["DFRec_LName"].ToString(); dfrec.DFRec_TIN = reader["DFRec_TIN"].ToString(); if (decimal.TryParse(reader["DFRec_AccrIncSm"].ToString(), out resDec)) { dfrec.DFRec_AccrIncSm = resDec; } if (decimal.TryParse(reader["DFRec_PaidIncSm"].ToString(), out resDec)) { dfrec.DFRec_PaidIncSm = resDec; } if (decimal.TryParse(reader["DFRec_AccrTaxSm"].ToString(), out resDec)) { dfrec.DFRec_AccrTaxSm = resDec; } if (decimal.TryParse(reader["DFRec_TransfTaxSm"].ToString(), out resDec)) { dfrec.DFRec_TransfTaxSm = resDec; } if (int.TryParse(reader["DFRec_IncFlg"].ToString(), out resInt)) { dfrec.DFRec_IncFlg = resInt; } if (DateTime.TryParse(reader["DFRec_DOR"].ToString(), out resDate)) { dfrec.DFRec_DOR = resDate; } if (DateTime.TryParse(reader["DFRec_DOD"].ToString(), out resDate)) { dfrec.DFRec_DOD = resDate; } if (int.TryParse(reader["DFRec_SocBenefitFlg"].ToString(), out resInt)) { dfrec.DFRec_SocBenefitFlg = resInt; } if (int.TryParse(reader["DFRec_Flg"].ToString(), out resInt)) { dfrec.DFRec_Flg = resInt; } }
//Получить строки 1 ДФ public List <DFRec> GetAllDFRecByParams(int dfct_Id, out string error) { error = string.Empty; List <DFRec> dfRecs = new List <DFRec>(); if (conn == null) { error = "conn == null"; return(dfRecs); } if (dfct_Id == 0) { error = "Не задані вхідні параметри"; return(null); } SqlCommand command = new SqlCommand(spDFRecSelect, conn); command.CommandType = CommandType.StoredProcedure; command.Parameters.AddWithValue("@inDFRec_DFCt_Id", dfct_Id); SqlDataReader reader = null; try { reader = command.ExecuteReader(); while (reader.Read()) { DFRec dfRec = new DFRec(); FillDataRec(reader, dfRec); dfRecs.Add(dfRec); } } catch (Exception exc) { error = exc.Message; } finally { if (reader != null) { reader.Close(); } } return(dfRecs); }