public static bool CommunityAction_Update(CommunityAction oCOMAction)
{
SqlConnection conn = new SqlConnection(ConfigurationManager.AppSettings.Get("ConnectionString"));
conn.Open();
SqlCommand cmd = new SqlCommand("sp_CommunityAction_Update", conn);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@GuidSessionID", oCOMAction.WorkingSessionID);
cmd.Parameters.AddWithValue("@LastActionDate", oCOMAction.LastActionDate);
cmd.Parameters.AddWithValue("@ExitCommunity", oCOMAction.isExitCommunity);
cmd.Parameters.AddWithValue("@CommunityID", oCOMAction.CommunityID);
cmd.Parameters.AddWithValue("@PersonID", oCOMAction.PersonID);
try
{
cmd.ExecuteNonQuery();
conn.Close();
return(true);
}
catch (Exception ex)
{
conn.Close();
ErrorHandler pError = new ErrorHandler();
pError.addMessageToPoisonQueue(oCOMAction, ex);
return(false);
}
}
public static bool CommunityAction_Insert(CommunityAction oCOMAction)
{
SqlConnection conn = new SqlConnection(ConfigurationManager.AppSettings.Get("ConnectionString"));
conn.Open();
SqlCommand cmd = new SqlCommand("sp_CommunityAction_Insert", conn);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@GuidSessionID", oCOMAction.WorkingSessionID);
cmd.Parameters.AddWithValue("@AccessDate", oCOMAction.AccessDate);
cmd.Parameters.AddWithValue("@LastActionDate", oCOMAction.LastActionDate);
cmd.Parameters.AddWithValue("@PersonID", oCOMAction.PersonID);
cmd.Parameters.AddWithValue("@CommunityID", oCOMAction.CommunityID);
cmd.Parameters.AddWithValue("@ExitCommunity", oCOMAction.isExitCommunity);
cmd.Parameters.AddWithValue("@AccessDay", oCOMAction.AccessDate.Day);
cmd.Parameters.AddWithValue("@AccessMonth", oCOMAction.AccessDate.Month);
cmd.Parameters.AddWithValue("@AccessYear", oCOMAction.AccessDate.Year);
cmd.Parameters.AddWithValue("@AccessHour", oCOMAction.AccessDate.Hour);
cmd.Parameters.AddWithValue("@PersonRoleID", oCOMAction.PersonRoleID);
try
{
cmd.ExecuteNonQuery();
return(true);
}
catch (Exception ex)
{
ErrorHandler pError = new ErrorHandler();
pError.addMessageToPoisonQueue(oCOMAction, ex);
return(false);
}
finally
{
if (conn.State != System.Data.ConnectionState.Closed)
{
conn.Close();
}
cmd.Dispose();
conn.Dispose();
}
}
public void UpdateCommunityAction(CommunityAction oAction)
{
bool res = DALCommunityAction.CommunityAction_Update(oAction);
}
public void InsertCommunityAction(CommunityAction oAction)
{
bool res = DALCommunityAction.CommunityAction_Insert(oAction);
}
