public INDIVIDUAL_ADDRESS ParseReaderCustom(DataRow row) { INDIVIDUAL_ADDRESS objReturn = new INDIVIDUAL_ADDRESS { ACCEPTS_TXT_MSG = (bool?)GetNullableObject(row.Field <object>("INDIVIDUAL_ADDRESS_ACCEPTS_TXT_MSG")), ADDRESS_ID = (Int32)GetNullableObject(row.Field <object>("INDIVIDUAL_ADDRESS_ADDRESS_ID")), ALT_EMAIL = (string)GetNullableObject(row.Field <object>("INDIVIDUAL_ADDRESS_ALT_EMAIL")), CELL_PHONE = (string)GetNullableObject(row.Field <object>("INDIVIDUAL_ADDRESS_CELL_PHONE")), CITY = (string)GetNullableObject(row.Field <object>("INDIVIDUAL_ADDRESS_CITY")), COMMENTS = (string)GetNullableObject(row.Field <object>("INDIVIDUAL_ADDRESS_COMMENTS")), CREATED = (DateTime?)GetNullableObject(row.Field <object>("INDIVIDUAL_ADDRESS_CREATED")), CREATEDBY = (string)GetNullableObject(row.Field <object>("INDIVIDUAL_ADDRESS_CREATEDBY")), EMAIL = (string)GetNullableObject(row.Field <object>("INDIVIDUAL_ADDRESS_EMAIL")), FAX = (string)GetNullableObject(row.Field <object>("INDIVIDUAL_ADDRESS_FAX")), IND_ID = (Int32)GetNullableObject(row.Field <object>("INDIVIDUAL_ADDRESS_IND_ID")), PHONE = (string)GetNullableObject(row.Field <object>("INDIVIDUAL_ADDRESS_PHONE")), POSTAL_CODE = (string)GetNullableObject(row.Field <object>("INDIVIDUAL_ADDRESS_POSTAL_CODE")), STD_ADDRESSTYPE_ID = (Int32)GetNullableObject(row.Field <object>("INDIVIDUAL_ADDRESS_STD_ADDRESSTYPE_ID")), STD_COUNTRY_ID = (Int32?)GetNullableObject(row.Field <object>("INDIVIDUAL_ADDRESS_STD_COUNTRY_ID")), STD_STATE_ID = (Int32?)GetNullableObject(row.Field <object>("INDIVIDUAL_ADDRESS_STD_STATE_ID")), STREET1 = (string)GetNullableObject(row.Field <object>("INDIVIDUAL_ADDRESS_STREET1")), STREET2 = (string)GetNullableObject(row.Field <object>("INDIVIDUAL_ADDRESS_STREET2")), STREET3 = (string)GetNullableObject(row.Field <object>("INDIVIDUAL_ADDRESS_STREET3")), UPDATED = (DateTime?)GetNullableObject(row.Field <object>("INDIVIDUAL_ADDRESS_UPDATED")), UPDATEDBY = (string)GetNullableObject(row.Field <object>("INDIVIDUAL_ADDRESS_UPDATEDBY")) }; return(objReturn); }
public static Int32 Save(string CURRENT_USER, Int32 CURRENT_REGISTRY_ID, INDIVIDUAL_ADDRESS objSave) { Int32 objReturn = 0; INDIVIDUAL_ADDRESSDB objDB = new INDIVIDUAL_ADDRESSDB(); objReturn = objDB.Save(CURRENT_USER, CURRENT_REGISTRY_ID, objSave); return(objReturn); }
public static INDIVIDUAL_ADDRESS GetItem(string CURRENT_USER, Int32 CURRENT_REGISTRY_ID, Int32 ADDRESS_ID) { INDIVIDUAL_ADDRESS objReturn = null; INDIVIDUAL_ADDRESSDB objDB = new INDIVIDUAL_ADDRESSDB(); objReturn = objDB.GetItem(CURRENT_USER, CURRENT_REGISTRY_ID, ADDRESS_ID); return(objReturn); }
public INDIVIDUAL_ADDRESS GetItem(string CURRENT_USER, Int32 CURRENT_REGISTRY_ID, Int32 ADDRESS_ID) { INDIVIDUAL_ADDRESS objReturn = null; SqlConnection sConn = null; SqlCommand sCmd = null; SqlDataAdapter sAdapter = null; DataSet objTemp = null; try { sConn = new SqlConnection(SqlConnectionString); sConn.Open(); sCmd = new SqlCommand("CRS.usp_INDIVIDUAL_ADDRESS_getitem", sConn); sCmd.CommandTimeout = SqlCommandTimeout; sCmd.CommandType = CommandType.StoredProcedure; sCmd.Parameters.AddWithValue("@CURRENT_USER", CURRENT_USER); sCmd.Parameters.AddWithValue("@CURRENT_REGISTRY_ID", CURRENT_REGISTRY_ID); sCmd.Parameters.AddWithValue("@ADDRESS_ID", ADDRESS_ID); objTemp = new DataSet(); sAdapter = new SqlDataAdapter(sCmd); LogDetails logDetails = new LogDetails(String.Format("{0}.{1}", System.Reflection.MethodBase.GetCurrentMethod().DeclaringType.FullName, System.Reflection.MethodBase.GetCurrentMethod().Name), CURRENT_USER, CURRENT_REGISTRY_ID); sAdapter.Fill(objTemp); LogManager.LogTiming(logDetails); CheckDataSet(objTemp); if (objTemp != null && objTemp.Tables.Count > 0 && objTemp.Tables[0].Rows.Count > 0) { objReturn = ParseReader(objTemp.Tables[0].Rows[0]); } sConn.Close(); } catch (Exception ex) { LogManager.LogError(ex.Message, String.Format("{0}.{1}", System.Reflection.MethodBase.GetCurrentMethod().DeclaringType.FullName, System.Reflection.MethodBase.GetCurrentMethod().Name), CURRENT_USER, CURRENT_REGISTRY_ID); throw ex; } finally { if (sAdapter != null) { sAdapter.Dispose(); sAdapter = null; } if (sCmd != null) { sCmd.Dispose(); sCmd = null; } if (sConn != null) { if (sConn.State != ConnectionState.Closed) { sConn.Close(); } sConn.Dispose(); sConn = null; } } return(objReturn); }
public Int32 Save(string CURRENT_USER, Int32 CURRENT_REGISTRY_ID, INDIVIDUAL_ADDRESS objSave) { Int32 objReturn = 0; SqlConnection sConn = null; SqlCommand sCmd = null; SqlParameter p = null; try { sConn = new SqlConnection(SqlConnectionString); sConn.Open(); sCmd = new SqlCommand("CRS.usp_INDIVIDUAL_ADDRESS_save", sConn); sCmd.CommandTimeout = SqlCommandTimeout; sCmd.CommandType = CommandType.StoredProcedure; sCmd.Parameters.AddWithValue("@CURRENT_USER", CURRENT_USER); sCmd.Parameters.AddWithValue("@CURRENT_REGISTRY_ID", CURRENT_REGISTRY_ID); p = new SqlParameter("@ACCEPTS_TXT_MSG", SqlDbType.Bit, 1); p.Precision = 1; p.Scale = 0; AddParameter(ref sCmd, ref p, objSave.ACCEPTS_TXT_MSG); p = new SqlParameter("@ADDRESS_ID", SqlDbType.Int, 4); p.Direction = ParameterDirection.InputOutput; p.Precision = 10; p.Scale = 0; AddParameter(ref sCmd, ref p, objSave.ADDRESS_ID); p = new SqlParameter("@ALT_EMAIL", SqlDbType.VarChar, 128); p.Precision = 0; p.Scale = 0; AddParameter(ref sCmd, ref p, objSave.ALT_EMAIL); p = new SqlParameter("@CELL_PHONE", SqlDbType.VarChar, 50); p.Precision = 0; p.Scale = 0; AddParameter(ref sCmd, ref p, objSave.CELL_PHONE); p = new SqlParameter("@CITY", SqlDbType.VarChar, 100); p.Precision = 0; p.Scale = 0; AddParameter(ref sCmd, ref p, objSave.CITY); p = new SqlParameter("@COMMENTS", SqlDbType.VarChar, 1000); p.Precision = 0; p.Scale = 0; AddParameter(ref sCmd, ref p, objSave.COMMENTS); p = new SqlParameter("@CREATED", SqlDbType.DateTime, 8); p.Precision = 23; p.Scale = 3; AddParameter(ref sCmd, ref p, objSave.CREATED); p = new SqlParameter("@CREATEDBY", SqlDbType.VarChar, 30); p.Precision = 0; p.Scale = 0; AddParameter(ref sCmd, ref p, objSave.CREATEDBY); p = new SqlParameter("@EMAIL", SqlDbType.VarChar, 128); p.Precision = 0; p.Scale = 0; AddParameter(ref sCmd, ref p, objSave.EMAIL); p = new SqlParameter("@FAX", SqlDbType.VarChar, 50); p.Precision = 0; p.Scale = 0; AddParameter(ref sCmd, ref p, objSave.FAX); p = new SqlParameter("@IND_ID", SqlDbType.Int, 4); p.Precision = 10; p.Scale = 0; AddParameter(ref sCmd, ref p, objSave.IND_ID); p = new SqlParameter("@PHONE", SqlDbType.VarChar, 50); p.Precision = 0; p.Scale = 0; AddParameter(ref sCmd, ref p, objSave.PHONE); p = new SqlParameter("@POSTAL_CODE", SqlDbType.VarChar, 10); p.Precision = 0; p.Scale = 0; AddParameter(ref sCmd, ref p, objSave.POSTAL_CODE); p = new SqlParameter("@STD_ADDRESSTYPE_ID", SqlDbType.Int, 4); p.Precision = 10; p.Scale = 0; AddParameter(ref sCmd, ref p, objSave.STD_ADDRESSTYPE_ID); p = new SqlParameter("@STD_COUNTRY_ID", SqlDbType.Int, 4); p.Precision = 10; p.Scale = 0; AddParameter(ref sCmd, ref p, objSave.STD_COUNTRY_ID); p = new SqlParameter("@STD_STATE_ID", SqlDbType.Int, 4); p.Precision = 10; p.Scale = 0; AddParameter(ref sCmd, ref p, objSave.STD_STATE_ID); p = new SqlParameter("@STREET1", SqlDbType.VarChar, 256); p.Precision = 0; p.Scale = 0; AddParameter(ref sCmd, ref p, objSave.STREET1); p = new SqlParameter("@STREET2", SqlDbType.VarChar, 256); p.Precision = 0; p.Scale = 0; AddParameter(ref sCmd, ref p, objSave.STREET2); p = new SqlParameter("@STREET3", SqlDbType.VarChar, 256); p.Precision = 0; p.Scale = 0; AddParameter(ref sCmd, ref p, objSave.STREET3); p = new SqlParameter("@UPDATED", SqlDbType.DateTime, 8); p.Precision = 23; p.Scale = 3; AddParameter(ref sCmd, ref p, objSave.UPDATED); p = new SqlParameter("@UPDATEDBY", SqlDbType.VarChar, 30); p.Precision = 0; p.Scale = 0; AddParameter(ref sCmd, ref p, objSave.UPDATEDBY); LogDetails logDetails = new LogDetails(String.Format("{0}.{1}", System.Reflection.MethodBase.GetCurrentMethod().DeclaringType.FullName, System.Reflection.MethodBase.GetCurrentMethod().Name), CURRENT_USER, CURRENT_REGISTRY_ID); int cnt = sCmd.ExecuteNonQuery(); LogManager.LogTiming(logDetails); objReturn = (Int32)sCmd.Parameters["@ADDRESS_ID"].Value; sConn.Close(); } catch (Exception ex) { LogManager.LogError(ex.Message, String.Format("{0}.{1}", System.Reflection.MethodBase.GetCurrentMethod().DeclaringType.FullName, System.Reflection.MethodBase.GetCurrentMethod().Name), CURRENT_USER, CURRENT_REGISTRY_ID); throw ex; } finally { if (sCmd != null) { sCmd.Dispose(); sCmd = null; } if (sConn != null) { if (sConn.State != ConnectionState.Closed) { sConn.Close(); } sConn.Dispose(); sConn = null; } } return(objReturn); }
public static Boolean Delete(string CURRENT_USER, Int32 CURRENT_REGISTRY_ID, INDIVIDUAL_ADDRESS objDelete) { return(Delete(CURRENT_USER, CURRENT_REGISTRY_ID, objDelete.ADDRESS_ID)); }