public static object[] LoadProjectUsers()
{
StringBuilder sb = new StringBuilder();
Int16 devCount = 0;
//get total amount of developers assigned to project
List <MembershipUser> users = ProjectsDB.GetProjectUsers(ProjectsDB.GetProject(project_id));
List <ProjectUser> all_users = new List <ProjectUser>();
try
{
project this_project = ProjectsDB.GetProject(project_id);
devCount = (Int16)users.Count;
foreach (MembershipUser user in users)
{
ProjectUser new_user = new ProjectUser()
{
Username = user.UserName,
User_id = user.ProviderUserKey.ToString(),
Ticket_count = TicketsDB.GetUserProjectTicketCount(this_project, user),
Remove_button = String.Format("<input type='button' value='X' data-user='******' class='RemoveUserFromProject' onclick='RemoveUserFromProject(this);'/>", user.ProviderUserKey)
};
all_users.Add(new_user);
}
}
catch (Exception ex)
{
LogsDB.AddLog("Error building project developers table", LogsDB.GetLogType("error").id, project_id, ex);
}
return(new object[] { all_users, devCount });
}
protected void btnCreateTicket_Click(object sender, EventArgs e)
{
ticket new_ticket = new ticket();
string ticket_message = null;
try
{
new_ticket.created_by = new Guid(Session["userid"].ToString().Trim());
new_ticket.created_date = DateTime.Now;
new_ticket.title = txtTicketTitle.Text;
new_ticket.description = txtTicketDescr.Text;
new_ticket.priority = Convert.ToInt32(ddlTicketPriority.SelectedValue);
new_ticket.status = TicketsDB.GetStatus("Open").id;
TicketsDB.AddEditTicket(new_ticket);
ticket_message = TicketsDB.GenerateTicketNumber(new_ticket);
}
catch (Exception ex)
{
log_type type = LogsDB.GetLogType("error");
LogsDB.AddLog("Error creating new ticket", type.id, ex);
ticket_message = "Unexpected error creating ticket. Refresh page and try again or contact IT";
}
ltlMessage.Text = String.Format("<span class='success-message'>{0}</span>", ticket_message);
}
public override async Task Execute(Message message, TelegramBotClient botClient)
{
var chatId = message.Chat.Id;
LogsDB log = new LogsDB();
UserDB userDb = new UserDB();
TelegramKeybord keyboard = new TelegramKeybord();
if (!userDb.CheckUser(chatId))
{
log.AddLog("why");
userDb.CreateUser(chatId);
log.AddLog("why1");
}
else
{
log.AddLog("why2");
userDb.RecreateUser(chatId);
log.AddLog("why3");
}
string[][] actions = { new[] { "Войти по ивент-коду" }, new[] { "Личный кабинет" } };
userDb.CurrentActionOn(chatId, "EventCode");
await botClient.SendTextMessageAsync(chatId, "Чудненько " + "😇".ToString() + " Можем приступить", parseMode : Telegram.Bot.Types.Enums.ParseMode.Markdown);
await botClient.SendTextMessageAsync(chatId, "У вас есть личный кабинет? Если нет, то войдите по <b>ивент-коду</b> \n P.S.<b>Ивент-код</b> отправлен в письме регистрации", Telegram.Bot.Types.Enums.ParseMode.Html, replyMarkup : keyboard.GetKeyboard(actions));
}
public static bool RemoveUserFromProject(string user_id)
{
bool removed = false;
try
{
ProjectsDB.RemoveUserFromProject(project_id, user_id);
removed = true;
}
catch (Exception ex)
{
LogsDB.AddLog(String.Format("Project - Remove user. Error removing user {0} from project {1}", user_id, project_id), LogsDB.GetLogType("error").id, project_id, ex);
}
return(removed);
}
public static bool AddUserToProject(string user_id)
{
bool added = false;
try
{
ProjectsDB.AddUserToProject(project_id, user_id);
added = true;
}
catch (Exception ex)
{
LogsDB.AddLog(String.Format("Project - Add User. Error adding user {0} to project id {1}", user_id, project_id), LogsDB.GetLogType("error").id, project_id, ex);
}
return(added);
}
public static bool UnlockAccount(string user_id)
{
bool unlocked = false;
try
{
MembershipUser user = Membership.GetUser(user_id);
user.UnlockUser();
unlocked = true;
}
catch (Exception ex)
{
LogsDB.AddLog(String.Format("Error unlocking account for user id {0}", user_id), LogsDB.GetLogType("error").id, ex);
}
return(unlocked);
}
public static bool ResetPassword(string user_id)
{
bool password_reset = false;
WebFunctions wf = new WebFunctions();
try
{
MembershipUser user = Membership.GetUser(user_id);
/*NOT AVAILABLE FOR DEMO*/
/*UNCOMMENT WHEN EMAIL SETTINGS ARE READY*/
//wf.SendNewUserEmail(user.UserName, Membership.GeneratePassword(8, 2), user.Email);
password_reset = true;
}
catch (Exception ex)
{
LogsDB.AddLog(String.Format("Error resetting password for user id {0}", user_id), LogsDB.GetLogType("error").id, ex);
}
return(password_reset);
}
public static bool SaveProjectDescr(string project_descr)
{
bool updated = false;
object obj = HttpContext.Current.Request.QueryString["id"];
try
{
project this_project = ProjectsDB.GetProject(project_id);
this_project.description = project_descr;
this_project = ProjectsDB.AddEditProject(this_project);
if (this_project != null)
{
updated = true;
}
}
catch (Exception ex)
{
LogsDB.AddLog("Error updating project description", LogsDB.GetLogType("error").id, project_id, ex);
}
return(updated);
}
