public void deleteSubUser(BE_SubUSers besub)
{
SqlParameter[] param = new SqlParameter[1];
param[0] = new SqlParameter("@email", SqlDbType.NVarChar, 100);
param[0].Value = besub.Email;
SqlHelper.ExecuteNonQuery(connectionString, CommandType.StoredProcedure, "spsDeleteSubUser", param);
}
public DataSet CheckNumUsers(BE_SubUSers besub)
{
SqlParameter[] param = new SqlParameter[1];
param[0] = new SqlParameter("@MemID", SqlDbType.VarChar, 100);
param[0].Value = besub.MemID;
return(SqlHelper.ExecuteDataset(connectionString, CommandType.StoredProcedure, "spsCheckUsers", param));
}
public DataSet GetSubUSers(BE_SubUSers beviewselected)
{
SqlParameter[] param = new SqlParameter[1];
param[0] = new SqlParameter("@company", SqlDbType.VarChar, 100);
param[0].Value = beviewselected.Company;
return(SqlHelper.ExecuteDataset(connectionString, CommandType.StoredProcedure, "spsgetSubUsers", param));
}
public DataSet countSubUser(BE_SubUSers besubuser)
{
SqlParameter[] param = new SqlParameter[1];
param[0] = new SqlParameter("@refid", SqlDbType.NVarChar, 100);
param[0].Value = besubuser.MemID;
//param[1] = new SqlParameter("@id", SqlDbType.Int);
//param[1].Value = besubuser.MemID;
return(SqlHelper.ExecuteDataset(connectionString, CommandType.StoredProcedure, "spsCountSubUser", param));
}
protected void FillGrid()
{
DataSet ds = new DataSet();
BA_SubUsers basubusers = new BA_SubUsers();
BE_SubUSers besubusers = new BE_SubUSers();
besubusers.Company = Session["PSEName"].ToString();
ds = basubusers.getSubUSers(besubusers);
if (ds.Tables[0].Rows.Count > 0)
{
Session["PSERefID"] = ds.Tables[0].Rows[0]["RefID"];
}
else
{
Session["PSERefID"] = "";
}
s = Session["PSERefID"].ToString();
session = Session["PSERefID"].ToString();
Session["session"] = session;
if (ds != null)
{
if (ds.Tables[0].Rows.Count > 0)
{
pnlMain.Visible = true;
pnlSub.Visible = false;
_PageDataSource.DataSource = ds.Tables[0].DefaultView;
_PageDataSource.AllowPaging = true;
_PageDataSource.PageSize = PageSize;
_PageDataSource.CurrentPageIndex = CurrentPage;
ViewState["TotalPages"] = _PageDataSource.PageCount;
this.lblPageInfo.Text = "Page " + (CurrentPage + 1) + " of " + _PageDataSource.PageCount;
this.lbtnPrevious.Enabled = !_PageDataSource.IsFirstPage;
this.lbtnNext.Enabled = !_PageDataSource.IsLastPage;
this.lbtnFirst.Enabled = !_PageDataSource.IsFirstPage;
dljobdet.DataSource = _PageDataSource;
dljobdet.DataBind();
this.doPaging();
}
else
{
pnlMain.Visible = false;
pnlSub.Visible = true;
}
}
else
{
pnlMain.Visible = false;
pnlSub.Visible = true;
}
}
protected void dljobdet_RowCommand(object sender, GridViewCommandEventArgs e)
{
BA_SubUsers basubuser = new BA_SubUsers();
BE_SubUSers besub = new BE_SubUSers();
string[] id = e.CommandArgument.ToString().Split(',');
besub.MemID = Session["session"].ToString();
DataSet ds = new DataSet();
if (e.CommandName == "Update")
{
if (id[0] != "Active")
{
ds = basubuser.countSubUser(besub);
if (ds.Tables[0].Rows.Count > 1)
{
HttpContext.Current.Response.Write("<script>alert(' You Should not Activate More Than Two Users ');</script>");
}
else
{
//string id = dljobdet.Rows[e.RowIndex].Cells[2].Text.ToString();
DA_ActiveSubUSer active = new DA_ActiveSubUSer();
active.updatestatus(id[1]);
//dsys.updatestatus(id);
//divUserDetails.Visible = false;
FillGrid();
}
}
else
{
DA_ActiveSubUSer active = new DA_ActiveSubUSer();
active.updatestatus(id[1]);
//dsys.updatestatus(id);
//divUserDetails.Visible = false;
FillGrid();
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
lblsuccess.Visible = false;
pnlStatus.Visible = false;
email = Session["PSEMail"].ToString();
DA_SubUsers dasubuser = new DA_SubUsers();
BE_Employer beemp = new BE_Employer();
BA_SubUsers basub = new BA_SubUsers();
beemp.Company = email;
DataSet ds = new DataSet();
ds = basub.getUserListInSubUser(beemp);
company = ds.Tables[0].Rows[0]["companyname"].ToString();
MemID = ds.Tables[0].Rows[0]["MemID"].ToString();
Category = ds.Tables[0].Rows[0]["Category"].ToString();
ContactNo = ds.Tables[0].Rows[0]["ContactNo"].ToString();
City = ds.Tables[0].Rows[0]["City"].ToString();
State = ds.Tables[0].Rows[0]["State"].ToString();
ZipCode = ds.Tables[0].Rows[0]["zipcode"].ToString();
Address = ds.Tables[0].Rows[0]["Address1"].ToString();
Website = ds.Tables[0].Rows[0]["Website"].ToString();
// code forchecking number of users
DataSet dsChk = new DataSet();
BE_SubUSers besub = new BE_SubUSers();
besub.MemID = MemID;
dsChk = basub.getNumUsers(besub);
if (dsChk.Tables[0].Rows.Count > 1)
{
pnl.Visible = false;
pnlStatus.Visible = true;
}
}
public void DeleteSubUser(BE_SubUSers besub)
{
sub.deleteSubUser(besub);
}
public DataSet countSubUser(BE_SubUSers besub)
{
return(sub.countSubUser(besub));
}
public DataSet getNumUsers(BE_SubUSers besub)
{
return(dasubusers.CheckNumUsers(besub));
}
public DataSet getSubUSers(BE_SubUSers besubusers)
{
return(dasubusers.GetSubUSers(besubusers));
}
