//check whether user login in already
public int checklog()
{
current_date = DateTime.Now;
MyCommand2 = new OdbcCommand("select tms_logsheet.logsheet_id from tms_logsheet inner join jos_users on tms_logsheet.employee_id =jos_users.id where jos_users.username='******' and tms_logsheet.date_year='" + current_date.Year + "' and tms_logsheet.date_month='" + current_date.Month + "' and tms_logsheet.date_day=' " + current_date.Day + "' and (tms_logsheet.out_time is null or tms_logsheet.out_time='" + String.Empty + "')", Connection.MyConnection);
if (Convert.ToInt32(MyCommand2.ExecuteScalar()) != 0)
{
MyCommand2.CommandText = "Select id from jos_users where username='******' ";
userid = Convert.ToInt32(MyCommand2.ExecuteScalar());
MyCommand2.CommandText = "Select cb_departmentid from jos_comprofiler where user_id='" + userid + "' ";
userdepid = Convert.ToInt32(MyCommand2.ExecuteScalar());
MyCommand2.CommandText = "Select name from jos_users where id='" + userid + "' ";
userfname = (string)MyCommand2.ExecuteScalar();
etimehh = Notification.GetEndTimeHH();
etimemm = Notification.GetEndTimeMM();
TaskReminderCount.TaskCount();
if (TaskReminderCount.rid != 0)
{
TaskReminderCount.startTaskRemindTimer();
}
git.callForIdletime();
return(1);
}
MyCommand2.CommandText = "select tms_logsheet.logsheet_id from tms_logsheet inner join jos_users on tms_logsheet.employee_id =jos_users.id where jos_users.username='******' and tms_logsheet.date_year='" + current_date.Year + "' and tms_logsheet.date_month='" + current_date.Month + "' and tms_logsheet.date_day=' " + current_date.Day + "' and (tms_logsheet.out_time is not null or tms_logsheet.out_time!='" + String.Empty + "')";
if (Convert.ToInt32(MyCommand2.ExecuteScalar()) != 0)
{
MessageBoxResult result = Microsoft.Windows.Controls.MessageBox.Show("Hi " + UserConfig.configlist[0] + ", our system tracked that you have already signed out for the day. Do you want to continue?", "BQuTMSWithJira Sign out Alert", MessageBoxButton.YesNo, MessageBoxImage.Question);
if (result == MessageBoxResult.Yes)
{
MyCommand2.CommandText = "Select id from jos_users where username='******' ";
userid = Convert.ToInt32(MyCommand2.ExecuteScalar());
MyCommand2.CommandText = "Select name from jos_users where id='" + userid + "' ";
userfname = (string)MyCommand2.ExecuteScalar();
return(2); //login alredy to system
}
else
{
Connection.MyConnection.Close();
Environment.Exit(0);
return(3);
}
}
MyCommand2 = new OdbcCommand("select tms_logsheet.logsheet_id from tms_logsheet inner join jos_users on tms_logsheet.employee_id =jos_users.id where jos_users.username='******' and tms_logsheet.date_year='" + current_date.Year + "' and tms_logsheet.date_month='" + current_date.Month + "' and tms_logsheet.date_day=' " + current_date.Day + "'", Connection.MyConnection);
if (Convert.ToInt32(MyCommand2.ExecuteScalar()) == 0)
{
return(0);
}
else
{
return(4);
}
}
public void userLoginAgain()
{
if (checkuser(UserConfig.configlist[0], UserConfig.configlist[1]) == true)
{
MyCommand2.CommandText = "Select id from jos_users where username='******'";
userid = Convert.ToInt32(MyCommand2.ExecuteScalar());
MyCommand2.CommandText = "Select name from jos_users where id='" + userid + "' ";
userfname = (string)MyCommand2.ExecuteScalar();
TimeSpan timeSpentAwayFromOffice = calculateAwayTimeFromOffice(userid.ToString(), DateTime.Now.Year.ToString(), DateTime.Now.Month.ToString(), DateTime.Now.Day.ToString(), DateTime.Now.Hour.ToString(), DateTime.Now.Minute.ToString(), DateTime.Now.Second.ToString());
updateSignedOutTimeAndTimeSpentAwayFromOffice(userid.ToString(), DateTime.Now.Year.ToString(), DateTime.Now.Month.ToString(), DateTime.Now.Day.ToString(), timeSpentAwayFromOffice);
TaskReminderCount.TaskCount();
if (TaskReminderCount.rid != 0)
{
TaskReminderCount.startTaskRemindTimer(); //task reminder timer on
}
git.callForIdletime(); //idle time timer on
}
}
//login method
public void userLogin()
{
//if (checkuser(UserConfig.configlist[0], UserConfig.configlist[1]) == true)
//{
MyCommand2 = new OdbcCommand("Select id from jos_users where username='******'", Connection.MyConnection);
userid = Convert.ToInt32(MyCommand2.ExecuteScalar());
MyCommand2.CommandText = "Select name from jos_users where id='" + userid + "' ";
userfname = (string)MyCommand2.ExecuteScalar();
//etimehh = Notification.GetEndTimeHH();
//etimemm = Notification.GetEndTimeMM();
//loginReminder(1);
//MyCommand2.CommandText = "insert into tms_logsheet(employee_id,date_year,date_month,date_day,in_time) values('" + userid + "','" + current_date.Year + "','" + current_date.Month + "','" + current_date.Day + "','" + string.Format("{0:HH:mm}", current_date) + "')";
//MyCommand2.ExecuteNonQuery();
TaskReminderCount.TaskCount();
if (TaskReminderCount.rid != 0)
{
TaskReminderCount.startTaskRemindTimer(); //task reminder timer on
}
git.callForIdletime(); //idle time timer on
//LatearriArlyDep(Convert.ToInt32(Login.current_date.Hour), Convert.ToInt32(Login.current_date.Minute), Notification.GetStartingTimeHH(), Notification.GetStartingTimeMM(), "Late arrival");
//}
}
////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
//items delete code
void DeleteSelected()
{
try
{
if (Connection.MyConnection.State == ConnectionState.Open)
{
var selectedStockObject = add_lBox.SelectedItems[0] as AddTask;//select id
if (selectedStockObject == null)
{
return;
}
if (Microsoft.Windows.Controls.MessageBox.Show("Do you really want to delete this item?", "BQuTMSWithJira Delete confirmation", MessageBoxButton.YesNo) == MessageBoxResult.Yes)
{
using (OdbcCommand MyCommand = new OdbcCommand("DELETE FROM tms_reminders WHERE rid='" + selectedStockObject.ID + "'", Connection.MyConnection))
{
MyCommand.ExecuteNonQuery();
tasklist.RemoveAt(add_lBox.SelectedIndex);
add_lBox.ItemsSource = tasklist;
add_lBox.Items.Refresh();
if (TaskReminderCount.rid != 0)
{
TaskReminderCount.TaskCount();
}
}
}
}
else
{
Microsoft.Windows.Controls.MessageBox.Show("Unable to connect to the server. Please refresh (Help -> Refresh) and try again.", "BQuTMSWithJira Connection Failed", MessageBoxButton.OK, MessageBoxImage.Error);
}
}
catch (Exception)
{
// MessageBox.Show(ex+"");
}
}
