public Boolean Update(MST_CategoryENT entMST_Category) { try { SqlDatabase sqlDB = new SqlDatabase(myConnectionString); DbCommand dbCMD = sqlDB.GetStoredProcCommand("PR_MST_Category_UpdateByPK"); sqlDB.AddInParameter(dbCMD, "@CategoryID", SqlDbType.Int, entMST_Category.CategoryID); sqlDB.AddInParameter(dbCMD, "@CategoryName", SqlDbType.VarChar, entMST_Category.CategoryName); sqlDB.AddInParameter(dbCMD, "@ModificationDate", SqlDbType.DateTime, entMST_Category.ModificationDate); DataBaseHelper DBH = new DataBaseHelper(); DBH.ExecuteNonQuery(sqlDB, dbCMD); return(true); } catch (SqlException sqlex) { Message = SQLDataExceptionMessage(sqlex); if (SQLDataExceptionHandler(sqlex)) { throw; } return(false); } catch (Exception ex) { Message = ExceptionMessage(ex); if (ExceptionHandler(ex)) { throw; } return(false); } }
private void FillControls(Int32 CategoryID) { //lblPageHeader.Text = CV.PageHeaderEdit + " Category"; MST_CategoryBAL balMST_Category = new MST_CategoryBAL(); MST_CategoryENT entMST_Category = new MST_CategoryENT(); entMST_Category = balMST_Category.SelectPK(CategoryID); if (!entMST_Category.CategoryName.IsNull) { txtCategoryName.Text = entMST_Category.CategoryName.Value.ToString(); } }
public Boolean Update(MST_CategoryENT entMST_Category) { MST_CategoryDAL dalMST_Category = new MST_CategoryDAL(); if (dalMST_Category.Update(entMST_Category)) { return(true); } else { this.Message = dalMST_Category.Message; return(false); } }
public MST_CategoryENT SelectPK(SqlInt32 CategoryID) { try { SqlDatabase sqlDB = new SqlDatabase(myConnectionString); DbCommand dbCMD = sqlDB.GetStoredProcCommand("PR_MST_Category_SelectByPK"); sqlDB.AddInParameter(dbCMD, "@CategoryID", SqlDbType.Int, CategoryID); MST_CategoryENT entMST_Category = new MST_CategoryENT(); DataBaseHelper DBH = new DataBaseHelper(); using (IDataReader dr = DBH.ExecuteReader(sqlDB, dbCMD)) { while (dr.Read()) { if (!dr["CategoryID"].Equals(System.DBNull.Value)) { entMST_Category.CategoryID = Convert.ToInt32(dr["CategoryID"]); } if (!dr["CategoryName"].Equals(System.DBNull.Value)) { entMST_Category.CategoryName = Convert.ToString(dr["CategoryName"]); } } } return(entMST_Category); } catch (SqlException sqlex) { Message = SQLDataExceptionMessage(sqlex); if (SQLDataExceptionHandler(sqlex)) { throw; } return(null); } catch (Exception ex) { Message = ExceptionMessage(ex); if (ExceptionHandler(ex)) { throw; } return(null); } }
protected void btnAdd_Click(object sender, EventArgs e) { if (Request.QueryString["CategoryID"] == null) { MST_CategoryENT entMST_Category = new MST_CategoryENT(); if (txtCategoryName.Text.ToString().Trim() != "") { entMST_Category.CategoryName = txtCategoryName.Text.ToString().Trim(); } entMST_Category.CreationDate = DateTime.Now; entMST_Category.ModificationDate = DateTime.Now; entMST_Category.UserID = Convert.ToInt32(Session["UserID"]); MST_CategoryBAL balMST_Category = new MST_CategoryBAL(); if (balMST_Category.Insert(entMST_Category)) { pnlAlert.Visible = true; lblMessage.Text = "Data Inserted Successfully."; ClearControls(); } } else { MST_CategoryENT entMST_Category = new MST_CategoryENT(); if (txtCategoryName.Text.ToString().Trim() != "") { entMST_Category.CategoryName = txtCategoryName.Text.ToString().Trim(); } entMST_Category.CategoryID = Convert.ToInt32(Request.QueryString["CategoryID"]); entMST_Category.ModificationDate = DateTime.Now; entMST_Category.UserID = Convert.ToInt32(Session["UserID"]); MST_CategoryBAL balMST_Category = new MST_CategoryBAL(); if (balMST_Category.Update(entMST_Category)) { Response.Redirect("~/AdminPanel/Master/MST_Category/MST_CategoryList.aspx"); } } }