protected void btnSave_Click(object sender, EventArgs e)
{
try
{
SYS_Board = new SYS_Board();
BAL_SYS_Board = new SYS_Board_BLogic();
SYS_Board.board = txtBoard.Text;
SYS_Board.code = txtCode.Text;
SYS_Board.description = txtDescription.Text;
SYS_Board.createdby = Convert.ToInt32(Session["EmpolyeeID"]);
SYS_Board.modifiedby = Convert.ToInt32(Session["EmpolyeeID"]);
int status = BAL_SYS_Board.BAL_SYS_Board_Insert(SYS_Board, "Insert");
if (status == 1)
{
ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "Message", "<script> alert('Record successfully inserted.')</script>", false);
}
else
{
ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "Message", "<script> alert('Record not inserted.')</script>", false);
}
bindgrvSYS_Boarddetail();
RefereshPageControls();
ClearControls();
}
catch (Exception ex)
{
throw ex;
}
////finally
////{ }
}
private void bindgrvSYS_Boarddetail()
{
SYS_Board = new SYS_Board();
BAL_SYS_Board = new SYS_Board_BLogic();
DataSet dsSelect = new DataSet();
dsSelect = BAL_SYS_Board.BAL_SYS_Board_Select(SYS_Board, "SelectAll");
if (dsSelect.Tables.Count > 0)
{
string searchCondition = string.Empty;
if (txtBoardSearch.Text != string.Empty)
{
searchCondition = "Board like '%" + txtBoardSearch.Text + "%'";
}
if (txtCodeSearch.Text != string.Empty)
{
if (searchCondition != string.Empty)
{
searchCondition = searchCondition + " and ";
}
searchCondition = searchCondition + " Code like '%" + txtCodeSearch.Text + "%'";
}
if (rlstActive.SelectedValue == "0")
{
if (searchCondition != string.Empty)
{
searchCondition = searchCondition + " and ";
}
searchCondition = searchCondition + " IsActive = 0";
}
else if (rlstActive.SelectedValue == "1")
{
if (searchCondition != string.Empty)
{
searchCondition = searchCondition + " and ";
}
searchCondition = searchCondition + " IsActive = 1";
}
DataView dv = new DataView(dsSelect.Tables[0]);
dv.RowFilter = searchCondition;
DataSet dsSelectSub = new DataSet();
dsSelectSub.Tables.Add(dv.ToTable());
GridViewOperations GrvOperation = new GridViewOperations();
GrvOperation.BindGridWithSorting(grvSYS_Boarddetail, dsSelectSub, this.SortField, this.SortDirection);
}
else
{
grvSYS_Boarddetail.DataSource = null;
grvSYS_Boarddetail.DataBind();
}
}
public DataSet BAL_SYS_Board_Select(SYS_Board SYS_Board, string mode)
{
DAL_SYS_Board = new DataAccess();
arrParameter = new ArrayList();
arrParameter.Add(new parameter("mode", mode));
arrParameter.Add(new parameter("BoardID", SYS_Board.boardid));
arrParameter.Add(new parameter("BoardIDStr", ""));
arrParameter.Add(new parameter("IsActive", SYS_Board.isactive));
return(DAL_SYS_Board.DAL_Select("SELECT_DELETE_SYS_Board", arrParameter));
}
public int BAL_SYS_Board_Delete(SYS_Board SYS_Board, string mode)
{
DAL_SYS_Board = new DataAccess();
arrParameter = new ArrayList();
arrParameter.Add(new parameter("mode", mode));
arrParameter.Add(new parameter("BoardID", Convert.ToInt32(EnumFile.AssignValue.Zero)));
arrParameter.Add(new parameter("BoardIDStr", SYS_Board.boardidStr));
arrParameter.Add(new parameter("IsActive", SYS_Board.isactive));
return(DAL_SYS_Board.DAL_Delete_Return("SELECT_DELETE_SYS_Board", arrParameter));
}
public int BAL_SYS_Board_Update(SYS_Board SYS_Board, string mode)
{
DAL_SYS_Board = new DataAccess();
arrParameter = new ArrayList();
arrParameter.Add(new parameter("mode", mode));
arrParameter.Add(new parameter("BoardID", SYS_Board.boardid));
arrParameter.Add(new parameter("Board", SYS_Board.board));
arrParameter.Add(new parameter("Code", SYS_Board.code));
arrParameter.Add(new parameter("Description", SYS_Board.description));
arrParameter.Add(new parameter("CreatedBy", SYS_Board.createdby));
arrParameter.Add(new parameter("ModifiedBy", SYS_Board.modifiedby));
return(DAL_SYS_Board.DAL_InsertUpdate_Return("Proc_SYS_BoardInsertUpdate", arrParameter));
}
public int BAL_SYS_Board_Insert(SYS_Board SYS_Board, string mode)
{
DAL_SYS_Board = new DataAccess();
arrParameter = new ArrayList();
arrParameter.Add(new parameter("mode", mode));
arrParameter.Add(new parameter("BoardID", Convert.ToInt32(EnumFile.AssignValue.Zero)));
arrParameter.Add(new parameter("Board", SYS_Board.board));
arrParameter.Add(new parameter("Code", SYS_Board.code));
arrParameter.Add(new parameter("Description", SYS_Board.description));
arrParameter.Add(new parameter("CreatedBy", SYS_Board.createdby));
arrParameter.Add(new parameter("ModifiedBy", SYS_Board.modifiedby));
return(DAL_SYS_Board.DAL_InsertUpdate_Return("Proc_SYS_BoardInsertUpdate", arrParameter));
}
protected void BtnUpdate_Click(object sender, EventArgs e)
{
SYS_Board = new SYS_Board();
BAL_SYS_Board = new SYS_Board_BLogic();
SYS_Board.boardid = Convert.ToInt32(ViewState["boardid"].ToString());
SYS_Board.board = txtBoardEdit.Text;
SYS_Board.code = txtCodeEdit.Text;
SYS_Board.description = txtDescriptionEdit.Text;
SYS_Board.createdby = Convert.ToInt32(Session["EmpolyeeID"]);
SYS_Board.modifiedby = Convert.ToInt32(Session["EmpolyeeID"]);
int status = BAL_SYS_Board.BAL_SYS_Board_Update(SYS_Board, "Update");
if (status == 1)
{
ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "Message", "<script> alert('Record successfully updated.')</script>", false);
}
else
{
ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "Message", "<script> alert('Record not updated.')</script>", false);
}
RefereshPageControls();
}
protected void BtnActDeactSub_Click(object sender, EventArgs e)
{
int CountChecked = 0;
string BoardIDStr = string.Empty;
foreach (GridViewRow gr in grvSYS_Boarddetail.Rows)
{
CheckBox chk = new CheckBox();
chk = (CheckBox)gr.FindControl("chkSelect");
if (chk.Checked == true)
{
if (CountChecked == 0)
{
BoardIDStr = grvSYS_Boarddetail.DataKeys[gr.RowIndex]["BoardID"].ToString();
}
else
{
BoardIDStr = BoardIDStr + "," + grvSYS_Boarddetail.DataKeys[gr.RowIndex]["BoardID"].ToString();
}
CountChecked = CountChecked + 1;
}
}
if (CountChecked == 0)
{
ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "Message", "<script> alert('Please select one record to Active/Deactive.')</script>", false);
}
else
{
SYS_Board = new SYS_Board();
BAL_SYS_Board = new SYS_Board_BLogic();
SYS_Board.boardidStr = BoardIDStr;
//////////////////////////////////////////
if (rbActive.Checked == true)
{
SYS_Board.isactive = true;
}
if (rbDeactive.Checked == true)
{
SYS_Board.isactive = false;
}
status = BAL_SYS_Board.BAL_SYS_Board_Delete(SYS_Board, "UpdateStatus");
if (status == 1)
{
string status1 = string.Empty;
if (rbActive.Checked == true)
{
status1 = "Active.";
}
else if (rbDeactive.Checked == true)
{
status1 = "Deactive.";
}
string message = string.Format("Selected records successfully {0}", status1);
ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "Message", "<script> alert('" + message + "')</script>", false);
//////////////////////////////////////////////////
}
else
{
ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "Message", "<script> alert('Selected record not Active/Deactive.')</script>", false);
}
RefereshPageControls();
}
}
