private void FillAlbumName() { try { tbl_AlbumMasterProp Objtbl_AlbumMasterProp = new tbl_AlbumMasterProp(); Objtbl_AlbumMasterProp.AlbumCode = 0; tbl_AlbumMasterBAL Objtbl_AlbumMasterBAL = new tbl_AlbumMasterBAL(); DataSet dsData = Objtbl_AlbumMasterBAL.SelectCombo_Data(); DataRow drNew = dsData.Tables[0].NewRow(); drNew["AlbumName"] = "--- Select Any ---"; drNew["AlbumCode"] = 0; dsData.Tables[0].Rows.InsertAt(drNew, 0); ddlAlbumName.DataSource = dsData.Tables[0]; ddlAlbumName.DataTextField = "AlbumName"; ddlAlbumName.DataValueField = "AlbumCode"; ddlAlbumName.DataBind(); } catch (Exception ex) { throw ex; } }
public DataSet Search_Data(tbl_AlbumMasterProp Objtbl_AlbumMasterProp) { try { tbl_AlbumMasterDAL Objtbl_AlbumMasterDAL = new tbl_AlbumMasterDAL(); return(Objtbl_AlbumMasterDAL.Search_Data(Objtbl_AlbumMasterProp)); } catch (Exception ex) { throw ex; } }
public int Delete_Data(tbl_AlbumMasterProp Objtbl_AlbumMasterProp) { try { tbl_AlbumMasterDAL Objtbl_AlbumMasterDAL = new tbl_AlbumMasterDAL(); return(Objtbl_AlbumMasterDAL.Delete_Data(Objtbl_AlbumMasterProp)); } catch (Exception ex) { throw ex; } }
public int Delete_Data(tbl_AlbumMasterProp Objtbl_AlbumMasterProp) { try { Database DB = DatabaseFactory.CreateDatabase("AppConNagar"); DbCommand DBCmd = DB.GetStoredProcCommand("Delete_tbl_AlbumMaster"); DB.AddInParameter(DBCmd, "@AlbumCode", DbType.Int32, Objtbl_AlbumMasterProp.AlbumCode); return(DB.ExecuteNonQuery(DBCmd)); } catch (Exception ex) { throw ex; } }
public DataSet Search_Data(tbl_AlbumMasterProp Objtbl_AlbumMasterProp) { try { Database DB = DatabaseFactory.CreateDatabase("AppConNagar"); DbCommand DBCmd = DB.GetStoredProcCommand("Search_tbl_AlbumMaster"); DB.AddInParameter(DBCmd, "@SearchBy", DbType.String, Objtbl_AlbumMasterProp.SearchBy); DB.AddInParameter(DBCmd, "@SearchVal", DbType.String, Objtbl_AlbumMasterProp.SearchVal); return(DB.ExecuteDataSet(DBCmd)); } catch (Exception ex) { throw ex; } }
public int InsertUpdate_Data(tbl_AlbumMasterProp Objtbl_AlbumMasterProp) { try { Database DB = DatabaseFactory.CreateDatabase("AppConNagar"); DbCommand DBCmd = DB.GetStoredProcCommand("InsertUpdate_tbl_AlbumMaster"); DB.AddInParameter(DBCmd, "@AlbumCode", DbType.Int32, Objtbl_AlbumMasterProp.AlbumCode); DB.AddInParameter(DBCmd, "@AlbumName", DbType.String, Objtbl_AlbumMasterProp.AlbumName); DB.AddOutParameter(DBCmd, "@RetVal", DbType.Int32, 18); DB.ExecuteNonQuery(DBCmd); return(Convert.ToInt32(DBCmd.Parameters["@RetVal"].Value)); } catch (Exception ex) { throw ex; } }
private void DeleteData(int AlbumCode) { try { tbl_AlbumMasterProp Objtbl_AlbumMasterProp = new tbl_AlbumMasterProp(); Objtbl_AlbumMasterProp.AlbumCode = AlbumCode; tbl_AlbumMasterBAL Objtbl_AlbumMasterBAL = new tbl_AlbumMasterBAL(); Objtbl_AlbumMasterBAL.Delete_Data(Objtbl_AlbumMasterProp); FillData(); } catch (Exception ex) { throw ex; } }
public DataSet Select_Data(tbl_AlbumMasterProp Objtbl_AlbumMasterProp, ref int TotalCount) { try { Database DB = DatabaseFactory.CreateDatabase("AppConNagar"); DbCommand DBCmd = DB.GetStoredProcCommand("Select_tbl_AlbumMaster"); DB.AddInParameter(DBCmd, "@AlbumCode", DbType.Int32, Objtbl_AlbumMasterProp.AlbumCode); DB.AddInParameter(DBCmd, "@PageNo", DbType.Int32, Objtbl_AlbumMasterProp.PageNo); DB.AddInParameter(DBCmd, "@RecordCount", DbType.Int32, Objtbl_AlbumMasterProp.RecordCount); DB.AddOutParameter(DBCmd, "@TotalCount", DbType.Int32, 18); DataSet dsData = DB.ExecuteDataSet(DBCmd); TotalCount = Convert.ToInt32(DBCmd.Parameters["@TotalCount"].Value); return(dsData); } catch (Exception ex) { throw ex; } }
private void EditData(int AlbumCode) { try { tbl_AlbumMasterProp Objtbl_AlbumMasterProp = new tbl_AlbumMasterProp(); Objtbl_AlbumMasterProp.AlbumCode = AlbumCode; int PageCount = 0; tbl_AlbumMasterBAL Objtbl_AlbumMasterBAL = new tbl_AlbumMasterBAL(); DataSet dsData = Objtbl_AlbumMasterBAL.Select_Data(Objtbl_AlbumMasterProp, ref PageCount); txtAlbumName.Text = Convert.ToString(dsData.Tables[0].Rows[0]["AlbumName"]); ViewState["EditCode"] = AlbumCode; } catch (Exception ex) { throw ex; } }
protected void imgbtnSave_Click(object sender, ImageClickEventArgs e) { try { tbl_AlbumMasterProp Objtbl_AlbumMasterProp = new tbl_AlbumMasterProp(); Objtbl_AlbumMasterProp.AlbumCode = Convert.ToInt32(ViewState["EditCode"]); Objtbl_AlbumMasterProp.AlbumName = txtAlbumName.Text; tbl_AlbumMasterBAL Objtbl_AlbumMasterBAL = new tbl_AlbumMasterBAL(); Objtbl_AlbumMasterBAL.InsertUpdate_Data(Objtbl_AlbumMasterProp); ShowGuidMessage(1, null); mdlPopupNewEntry.Hide(); FillData(); } catch (Exception ex) { ShowGuidMessage(0, ex); //MessageBox.Show(ex.Message); } }
private void FillData() { try { int PageCount = 0; tbl_AlbumMasterProp Objtbl_AlbumMasterProp = new tbl_AlbumMasterProp(); Objtbl_AlbumMasterProp.AlbumCode = 0; Objtbl_AlbumMasterProp.PageNo = Convert.ToInt32(txtCurPage.Text); Objtbl_AlbumMasterProp.RecordCount = Convert.ToInt32(20); tbl_AlbumMasterBAL Objtbl_AlbumMasterBAL = new tbl_AlbumMasterBAL(); DataSet dsData = Objtbl_AlbumMasterBAL.Select_Data(Objtbl_AlbumMasterProp, ref PageCount); lblTotalPage.Text = Convert.ToString(PageCount); grdData.DataSource = dsData.Tables[0]; grdData.DataBind(); } catch (Exception ex) { throw ex; } }
public DataSet Select_Data(tbl_AlbumMasterProp Objtbl_AlbumMasterProp, ref int PageCount) { try { if (Objtbl_AlbumMasterProp.AlbumCode != 0) { Objtbl_AlbumMasterProp.PageNo = 1; Objtbl_AlbumMasterProp.RecordCount = 1; } int RecordCount = 0; tbl_AlbumMasterDAL Objtbl_AlbumMasterDAL = new tbl_AlbumMasterDAL(); DataSet dsData = Objtbl_AlbumMasterDAL.Select_Data(Objtbl_AlbumMasterProp, ref RecordCount); double Page = Convert.ToDouble(RecordCount) / Convert.ToDouble(Objtbl_AlbumMasterProp.RecordCount); if (dsData.Tables[0].Rows.Count > 0) { string[] PageDecimal = Page.ToString().Split('.'); if (PageDecimal.Length > 1 && Convert.ToInt32(PageDecimal[1]) > 0) { PageCount = Convert.ToInt32(Page.ToString().Split('.')[0]) + 1; } else { PageCount = Convert.ToInt32(Page); } } else { PageCount = 0; } return(dsData); } catch (Exception ex) { throw ex; } }