public void GetLogHistoryDetails()
{
try
{
Log_History_Manager objLogHistory = new Log_History_Manager();
NandanaResult dsgethistorydetails = objLogHistory.GetLogHistoryDetails();
if (!dsgethistorydetails.HasError && dsgethistorydetails.resultDS.Tables[0].Rows.Count > 0)
{
dgvLogHistory.DataSource = dsgethistorydetails.resultDS.Tables[0];
}
else
{
dgvLogHistory.DataSource = null;
}
}
catch (Exception x)
{
MessageBox.Show(x.Message, "Error While retriving data from GetLogHistoryDetails SP");
}
}
private void btnSearch_Click(object sender, EventArgs e)
{
pnlError.Visible = false;
if (dtpLogDate.Value != null && cmbType.Text != "-Select Type-" && cmbType.Text != string.Empty)
{
try
{
Log_History_Manager objLogHistory = new Log_History_Manager();
NandanaResult dsgethistorydetailsusingDate = objLogHistory.GetLogHistoryDetailsGO(dtpLogDate.Value.ToString("dd-MM-yyyy"));
if (!dsgethistorydetailsusingDate.HasError && dsgethistorydetailsusingDate.resultDS.Tables[0].Rows.Count > 0)
{
if (cmbType.Text != "-Select Type-" && cmbType.Text.Length != 0)
{
DataView dv = new DataView(dsgethistorydetailsusingDate.resultDS.Tables[0]);
dv.RowFilter = "Type='" + cmbType.Text.ToUpper() + "'";
if (dv.Count > 0)
{
dgvLogHistory.DataSource = dv;
}
else
{
pnlError.Visible = true;
pnlError.Location = new Point((this.Width - pnlError.ClientSize.Width) / 2, 12);
pnlError.BackColor = System.Drawing.ColorTranslator.FromHtml("#f5b7b7");
lblErrorMsg.Text = "No results found, try a new search.";
lblErrorMsg.Location = new Point((pnlError.Width - lblErrorMsg.ClientSize.Width) / 2, (pnlError.Height - lblErrorMsg.ClientSize.Height) / 2);
dgvLogHistory.DataSource = null;
}
}
else
{
dgvLogHistory.DataSource = dsgethistorydetailsusingDate.resultDS.Tables[0];
}
}
else
{
pnlError.Visible = true;
pnlError.Location = new Point((this.Width - pnlError.ClientSize.Width) / 2, 12);
pnlError.BackColor = System.Drawing.ColorTranslator.FromHtml("#f5b7b7");
lblErrorMsg.Text = "No results found, try a new search.";
lblErrorMsg.Location = new Point((pnlError.Width - lblErrorMsg.ClientSize.Width) / 2, (pnlError.Height - lblErrorMsg.ClientSize.Height) / 2);
dgvLogHistory.DataSource = null;
}
}
catch (Exception x)
{
MessageBox.Show(x.Message, "Error While retriving data from GetLogHistoryDetailsGO SP");
}
}
else if (cmbType.Text == "-Select Type-" || cmbType.Text == string.Empty)
{
lblErrorMsg.Visible = false;
try
{
Log_History_Manager objLogHistory = new Log_History_Manager();
NandanaResult dsgethistorydetailsusingDate = objLogHistory.GetLogHistoryDetailsGO(dtpLogDate.Value.ToString("dd-MM-yyyy"));
if (!dsgethistorydetailsusingDate.HasError && dsgethistorydetailsusingDate.resultDS.Tables[0].Rows.Count > 0)
{
dgvLogHistory.DataSource = dsgethistorydetailsusingDate.resultDS.Tables[0];
}
else
{
pnlError.Visible = true;
pnlError.Location = new Point((this.Width - pnlError.ClientSize.Width) / 2, 12);
pnlError.BackColor = System.Drawing.ColorTranslator.FromHtml("#f5b7b7");
lblErrorMsg.Text = "No results found, try a new search.";
lblErrorMsg.Location = new Point((pnlError.Width - lblErrorMsg.ClientSize.Width) / 2, (pnlError.Height - lblErrorMsg.ClientSize.Height) / 2);
dgvLogHistory.DataSource = null;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error while Retrieving Data from GetLogHistoryDetailsGO SP");
}
}
}
private void btnLogin_Click(object sender, EventArgs e)
{
bool status = true;
lblError.Visible = false;
if (txtusername.Text == string.Empty || txtusername.Text == "Username")
{
//MessageBox.Show("Please Enter User Name");
lblError.Visible = true;
lblError.Text = "Username is required";
status = false;
txtusername.Focus();
return;
}
if (txtpassword.Text == string.Empty || txtpassword.Text == "Password")
{
//MessageBox.Show("Please Enter Password");
lblError.Visible = true;
lblError.Text = "Password is required";
status = false;
txtpassword.Focus();
return;
}
//if (cmbUserType.Text == string.Empty || cmbUserType.Text == " UserType ")
//{
// MessageBox.Show("Please Select User Type");
// status = false;
// cmbUserType.Focus();
// return;
//}
if (!status)
{
MessageBox.Show("Please enter required data");
}
else
{
cmbUserType.Text = "admin";
//bool matchFound = false;
System.Configuration.ConfigurationSettings.AppSettings["UserName"] = txtusername.Text;
try
{
String strRoleId = string.Empty;
String strUserId = string.Empty;
//MySqlConnection con = new MySqlConnection(System.Configuration.ConfigurationSettings.AppSettings["MYSQL_ConnString"]);
//con.Open();
//MySqlCommand cmd = new MySqlCommand("sp_Users", con);
//cmd.CommandType = CommandType.StoredProcedure;
//cmd.Parameters.Add(new MySqlParameter("User_Name", txtusername.Text.Trim()));
//cmd.Parameters.Add(new MySqlParameter("Password", txtpassword.Text.Trim()));
//cmd.Parameters.Add(new MySqlParameter("Role_Name", cmbUserType.Text));
//MySqlDataReader dr = cmd.ExecuteReader();
//if (dr.Read())
//{
// //strUserId = Convert.ToString(((((MySql.Data.MySqlClient.MySqlDataReader)(dr))).ResultSet.Values[0]).Value);
// //strRoleId = Convert.ToString(((((MySql.Data.MySqlClient.MySqlDataReader)(dr))).ResultSet.Values[3]).Value);
// System.Configuration.ConfigurationSettings.AppSettings["RoleID"] = strRoleId;
// AssignConfigParamValues(strRoleId, strUserId);
// //CheckScanDocCountValue();
// //CheckLicenseExpired();
// NewMenu objAdminHomePage = new NewMenu();
// objAdminHomePage.Show();
// this.Hide();
//}
//con.Close();
UserManager objUserManager = new UserManager();
NandanaResult dsUserData = objUserManager.GetUserDetailsByCredentials(txtusername.Text.Trim(), this.Encrypt(txtpassword.Text.Trim()));
if (!dsUserData.HasError && dsUserData.resultDS.Tables[0].Rows.Count > 0)
{
strRoleId = Convert.ToString(dsUserData.resultDS.Tables[0].Rows[0]["Role_ID"]);
strUserId = Convert.ToString(dsUserData.resultDS.Tables[0].Rows[0]["User_ID"]);
System.Configuration.ConfigurationSettings.AppSettings["RoleID"] = strRoleId;
System.Configuration.ConfigurationSettings.AppSettings["UserID"] = strUserId;
//* inserting log details in log table *//
string currentSystemName = Environment.MachineName;
string Description = "User logged in the applicaton from " + currentSystemName + ".";
string PresentDateTime = DateTime.Now.ToString("dd-MM-yyyy h:mm:ss tt");
string presentdate = DateTime.Now.ToString("dd-MM-yyyy");
string Type = "Login";
Log_History_Manager objLogHistoryManager = new Log_History_Manager();
NandanaResult ival = objLogHistoryManager.InsertLogHistoryDetails((DateTime.Now.ToString("dd-MM-yyyy h:mm:ss tt")), txtusername.Text.Trim(), Description.Trim(), Type.Trim(), (DateTime.Now.ToString("dd-MM-yyyy")));
//* End *//
AssignConfigParamValues(strRoleId, strUserId);
CheckScanDocCountValue();
GetConfigValuesOfIsExpired();
CheckLicenseExpired();
NewMenu objAdminHomePage = new NewMenu();
objAdminHomePage.Show();
this.Hide();
}
else
{
lblError.Visible = true;
lblError.Text = "Invalid Username or Password";
}
}
catch (Exception ex)
{
//return (new (ErrorHandling.ErrorType.ERR_RETRIEVING_DATA, "Error While retrieving data from users xml.", ex));
MessageBox.Show(ex.Message, "Error While retriving data from Users");
}
}
}
