public DataSet BAL_SYS_Standard_SelectForUserList(SYS_Standard SYS_Standard)
{
DAL_SYS_Standard = new DataAccess();
arrParameter = new ArrayList();
arrParameter.Add(new parameter("UserRoleID", SYS_Standard.userroleid));
arrParameter.Add(new parameter("EmployeeID", SYS_Standard.employeeid));
arrParameter.Add(new parameter("SchoolID", SYS_Standard.Schoolid));
return(DAL_SYS_Standard.DAL_Select("proc_Select_Standard_ForUserList", arrParameter));
}
public DataSet BAL_SYS_Standard_Select(SYS_Standard SYS_Standard, string mode)
{
DAL_SYS_Standard = new DataAccess();
arrParameter = new ArrayList();
arrParameter.Add(new parameter("mode", mode));
arrParameter.Add(new parameter("StandardID", SYS_Standard.standardid));
arrParameter.Add(new parameter("StandardIDStr", SYS_Standard.standardidStr));
arrParameter.Add(new parameter("BoardID", SYS_Standard.boardid));
arrParameter.Add(new parameter("MediumID", SYS_Standard.mediumid));
return(DAL_SYS_Standard.DAL_Select("SELECT_DELETE_SYS_Standard", arrParameter));
}
public int BAL_SYS_Standard_Delete(SYS_Standard SYS_Standard, string mode)
{
DAL_SYS_Standard = new DataAccess();
arrParameter = new ArrayList();
arrParameter.Add(new parameter("mode", mode));
arrParameter.Add(new parameter("StandardID", SYS_Standard.standardid));
arrParameter.Add(new parameter("StandardIDStr", SYS_Standard.standardidStr));
arrParameter.Add(new parameter("BoardID", SYS_Standard.boardid));
arrParameter.Add(new parameter("MediumID", SYS_Standard.mediumid));
arrParameter.Add(new parameter("IsActive", SYS_Standard.isactive));
return(DAL_SYS_Standard.DAL_Delete_Return("SELECT_DELETE_SYS_Standard", arrParameter));
}
public int BAL_SYS_Standard_Update(SYS_Standard SYS_Standard, string mode)
{
DAL_SYS_Standard = new DataAccess();
arrParameter = new ArrayList();
arrParameter.Add(new parameter("mode", mode));
arrParameter.Add(new parameter("StandardID", SYS_Standard.standardid));
arrParameter.Add(new parameter("Standard", SYS_Standard.standard));
arrParameter.Add(new parameter("Code", SYS_Standard.code));
arrParameter.Add(new parameter("Description", SYS_Standard.description));
arrParameter.Add(new parameter("CreatedBy", SYS_Standard.createdby));
arrParameter.Add(new parameter("ModifiedBy", SYS_Standard.modifiedby));
return(DAL_SYS_Standard.DAL_InsertUpdate_Return("Proc_SYS_StandardInsertUpdate", arrParameter));
}
public void BindStandardListForUserList(DropDownList DDL, SYS_Standard SysStandard)
{
try
{
DataSet dsStandardsForUser = new DataSet();
dsStandardsForUser = this.BAL_SYS_Standard_SelectForUserList(SysStandard);
if (dsStandardsForUser.Tables[0].Rows.Count > 0 && dsStandardsForUser.Tables[0] != null)
{
DDL.DataSource = dsStandardsForUser;
DDL.DataTextField = "Standard";
DDL.DataValueField = "StandardID";
DDL.DataBind();
}
DDL.Items.Insert(0, "-- Select --");
DDL.Items[0].Value = "0";
}
catch (Exception ex)
{
WebMsg.Show(ex.Message);
}
}
