public AgreementInvitationInfo GetAUserAgreementInvitation(string p_user_name, int p_agreement_id)
{
AgreementInvitationInfo result_agreement_invitation = null;
string command_string = "select * from agreements, agreement_invitations, agreement_result, agreement_type where " +
"agreements.id = " + p_agreement_id + " AND agreements.id = agreement_invitations.id AND agreement_invitations.result = agreement_result.result_num AND " +
"agreements.Type = agreement_type.Type_Num AND invited_user_name = '" + p_user_name + "' AND agreement_result.result= " +
"'unanswered';";
using (SqlCommand command = new SqlCommand(command_string, db_connection))
{
if (db_connection.State == ConnectionState.Closed)
{
db_connection.Open();
}
DataTable user_agreement_invitations_table = new DataTable();
SqlDataReader t = command.ExecuteReader();
user_agreement_invitations_table.Load(t);
TypeOfAgreement temp_agreement_type = TypeOfAgreement.Add;
if (user_agreement_invitations_table.Rows.Count > 0)
{
temp_agreement_type = TypeOfAgreement.Add;
DataRow t_row = user_agreement_invitations_table.Rows[0];
result_agreement_invitation = new AgreementInvitationInfo(t_row["starter_user_name"].ToString(),
t_row["type_text"].ToString(), Convert.ToInt32(t_row["ID"].ToString()), temp_agreement_type);
}
}
return(result_agreement_invitation);
}
public AgreementInvitationInfo(string p_inviting_user_id, string p_agreement_text, int p_agreement_id, TypeOfAgreement p_agreement_type)
{
agreement_type = p_agreement_type;
inviting_user_id = p_inviting_user_id;
agreement_id = p_agreement_id;
agreement_text = p_agreement_text;
}
public List <AgreementInvitationInfo> GetUserAgreementInvitation(string p_user_name)
{
List <AgreementInvitationInfo> user_agreement_invitations = new List <AgreementInvitationInfo>();
string command_string = "select * from agreements, agreement_invitations, agreement_result, agreement_type where " +
"agreements.id = agreement_invitations.id AND agreement_invitations.result = agreement_result.result_num AND " +
"agreements.Type = agreement_type.Type_Num AND invited_user_name = '" + p_user_name + "' AND agreement_result.result= " +
"'unanswered';";
using (SqlCommand command = new SqlCommand(command_string, db_connection))
{
if (db_connection.State == ConnectionState.Closed)
{
db_connection.Open();
}
DataTable user_agreement_invitations_table = new DataTable();
SqlDataReader t = command.ExecuteReader();
user_agreement_invitations_table.Load(t);
foreach (DataRow t_row in user_agreement_invitations_table.Rows)
{
TypeOfAgreement temp_agreement_type = TypeOfAgreement.Add;
if (t_row["Type"].ToString().ToLower().Trim() == "add")
{
temp_agreement_type = TypeOfAgreement.Add;
}
user_agreement_invitations.Add(new AgreementInvitationInfo(t_row["starter_user_name"].ToString(),
t_row["type_text"].ToString(), Convert.ToInt32(t_row["ID"].ToString()), temp_agreement_type));
}
}
return(user_agreement_invitations);
}
public void BaseConstruct(TypeOfAgreement p_agreement_type, int p_max_invited_persons, CreateFormalMessageRequest p_send_formal_message_to_user
, DB_IsThereUser p_is_there_user, StartClientInvitedAgreementInform p_start_client_invited_agreement_inform, IsLoggedIn p_is_logged_in)
{
agreement_type = p_agreement_type;
send_formal_message_to_user = p_send_formal_message_to_user;
start_client_invited_agreement_inform = p_start_client_invited_agreement_inform;
is_logged_in = p_is_logged_in;
is_there_user = p_is_there_user;
max_invited_persons = p_max_invited_persons;
}
protected void BaseConstruct(TypeOfAgreement p_agreement_type, int p_agreement_id, string p_starter_user_name
, int p_max_invited_persons, RemoveAgr p_remove_agreement_from_manager, CreateFormalMessageRequest p_send_formal_message_to_user
, DB_IsThereUser p_is_there_user, Dictionary <string, bool> p_all_users_invited, IsLoggedIn p_is_logged_in)
{
all_users_invited = p_all_users_invited;
agreement_id = p_agreement_id;
max_invited_persons = p_max_invited_persons;
agreement_type = p_agreement_type;
starter_user_name = p_starter_user_name;
remove_agreement_from_manager = p_remove_agreement_from_manager;
send_formal_message_to_user = p_send_formal_message_to_user;
is_there_user = p_is_there_user;
is_logged_in = p_is_logged_in;
}
public void Se_GetAgreementAnswer(string p_user_name, int p_agreement_id, bool p_answer, TypeOfAgreement p_agreement_type)
{
all_agreements.GetAgreementAnswer(p_user_name, p_agreement_id, p_answer, p_agreement_type);
}
public void Mo_CreateGetAgreementAnswerDialog(int p_agreement_id, TypeOfAgreement p_agreement_type, bool p_answer)
{
all_dialogs.CreateGetAgreementAnswerDialog(p_agreement_id, p_agreement_type, p_answer);
}
public Di_Mess_AgreementAnswer(int p_agreement_id, bool p_answer, TypeOfAgreement p_agreement_type)
{
agreement_type = p_agreement_type;
agreement_id = p_agreement_id;
answer = p_answer;
}
public Di_Mess_CreateAddAgreementRequest(string p_user_id_to_add)
{
user_id_to_add = p_user_id_to_add;
type_of_agreement = TypeOfAgreement.Add;
}
public void GetAgreementAnswer(string p_user_name, int p_agreement_id, bool p_answer, TypeOfAgreement p_agreement_type)
{
if (p_agreement_type == TypeOfAgreement.Add)
{
ma_add_agreement_manager.GetAgreementAnswer(p_user_name, p_agreement_id, p_answer);
}
}
