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); } }