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