protected void btnLogin_Click(object sender, ImageClickEventArgs e)
{
try
{
Encrypting ObjEncrypting = new Encrypting();
tbl_UserMasterProp Objtbl_UserMasterProp = new tbl_UserMasterProp();
Objtbl_UserMasterProp.UserName = ObjEncrypting.Encrypt(txtUserName.Text);
Objtbl_UserMasterProp.Password = ObjEncrypting.Encrypt(txtPassword.Text);
tbl_UserMasterBAL Objtbl_UserMasterBAL = new tbl_UserMasterBAL();
DataSet dsData = Objtbl_UserMasterBAL.Select_Data(Objtbl_UserMasterProp);
if (dsData.Tables[0].Rows.Count > 0)
{
Session["UserName"] = txtUserName.Text;
Response.Redirect("HomePage.aspx");
}
else
{
tdError.Visible = true;
tdError.InnerText = "Invalid Username/Password";
}
}
catch (Exception ex)
{
tdError.Visible = true;
tdError.InnerText = ex.Message;
}
}
public DataSet Search_Data(tbl_UserMasterProp Objtbl_UserMasterProp)
{
try
{
tbl_UserMasterDAL Objtbl_UserMasterDAL = new tbl_UserMasterDAL();
return Objtbl_UserMasterDAL.Search_Data(Objtbl_UserMasterProp);
}
catch (Exception ex)
{
throw ex;
}
}
public int Delete_Data(tbl_UserMasterProp Objtbl_UserMasterProp)
{
try
{
tbl_UserMasterDAL Objtbl_UserMasterDAL = new tbl_UserMasterDAL();
return Objtbl_UserMasterDAL.Delete_Data(Objtbl_UserMasterProp);
}
catch (Exception ex)
{
throw ex;
}
}
public int Delete_Data(tbl_UserMasterProp Objtbl_UserMasterProp)
{
try
{
Database DB = DatabaseFactory.CreateDatabase("AppConNagar");
DbCommand DBCmd = DB.GetStoredProcCommand("Delete_tbl_UserMaster");
return(DB.ExecuteNonQuery(DBCmd));
}
catch (Exception ex)
{
throw ex;
}
}
public DataSet Select_Data(tbl_UserMasterProp Objtbl_UserMasterProp)
{
try
{
tbl_UserMasterDAL Objtbl_UserMasterDAL = new tbl_UserMasterDAL();
DataSet dsData = Objtbl_UserMasterDAL.Select_Data(Objtbl_UserMasterProp);
return dsData;
}
catch (Exception ex)
{
throw ex;
}
}
public DataSet Search_Data(tbl_UserMasterProp Objtbl_UserMasterProp)
{
try
{
Database DB = DatabaseFactory.CreateDatabase("AppConNagar");
DbCommand DBCmd = DB.GetStoredProcCommand("Search_tbl_UserMaster");
DB.AddInParameter(DBCmd, "@SearchBy", DbType.String, Objtbl_UserMasterProp.SearchBy);
DB.AddInParameter(DBCmd, "@SearchVal", DbType.String, Objtbl_UserMasterProp.SearchVal);
return(DB.ExecuteDataSet(DBCmd));
}
catch (Exception ex)
{
throw ex;
}
}
public int InsertUpdate_Data(tbl_UserMasterProp Objtbl_UserMasterProp)
{
try
{
Database DB = DatabaseFactory.CreateDatabase("AppConNagar");
DbCommand DBCmd = DB.GetStoredProcCommand("InsertUpdate_tbl_UserMaster");
DB.AddInParameter(DBCmd, "@UserName", DbType.String, Objtbl_UserMasterProp.UserName);
DB.AddInParameter(DBCmd, "@Password", DbType.String, Objtbl_UserMasterProp.Password);
return(DB.ExecuteNonQuery(DBCmd));
}
catch (Exception ex)
{
throw ex;
}
}
public DataSet Select_Data(tbl_UserMasterProp Objtbl_UserMasterProp)
{
try
{
Database DB = DatabaseFactory.CreateDatabase("AppConNagar");
DbCommand DBCmd = DB.GetStoredProcCommand("Select_tbl_UserMaster");
DB.AddInParameter(DBCmd, "@UserName", DbType.String, Objtbl_UserMasterProp.UserName);
DB.AddInParameter(DBCmd, "@Password", DbType.String, Objtbl_UserMasterProp.Password);
DataSet dsData = DB.ExecuteDataSet(DBCmd);
return(dsData);
}
catch (Exception ex)
{
throw ex;
}
}
protected void imgbtnSave_Click(object sender, ImageClickEventArgs e)
{
try
{
Encrypting ObjEncrypting = new Encrypting();
tbl_UserMasterProp Objtbl_UserMasterProp = new tbl_UserMasterProp();
Objtbl_UserMasterProp.UserName = ObjEncrypting.Encrypt(txtUserName.Text);
Objtbl_UserMasterProp.Password = ObjEncrypting.Encrypt(txtPassword.Text);
tbl_UserMasterBAL Objtbl_UserMasterBAL = new tbl_UserMasterBAL();
Objtbl_UserMasterBAL.InsertUpdate_Data(Objtbl_UserMasterProp);
ShowGuidMessage(1, null);
}
catch (Exception ex)
{
ShowGuidMessage(0, ex); //MessageBox.Show(ex.Message);
}
}
