public Boolean Update(MST_CategoryTypeENT entMST_CategoryType) { try { SqlDatabase sqlDB = new SqlDatabase(myConnectionString); DbCommand dbCMD = sqlDB.GetStoredProcCommand("PR_MST_CategoryType_UpdateByPK"); sqlDB.AddInParameter(dbCMD, "@CategoryTypeID", SqlDbType.Int, entMST_CategoryType.CategoryTypeID); sqlDB.AddInParameter(dbCMD, "@CategoryType", SqlDbType.VarChar, entMST_CategoryType.CategoryType); sqlDB.AddInParameter(dbCMD, "@ModificationDate", SqlDbType.DateTime, entMST_CategoryType.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); } }
public Boolean Update(MST_CategoryTypeENT entMST_CategoryType) { MST_CategoryTypeDAL dalMST_CategoryType = new MST_CategoryTypeDAL(); if (dalMST_CategoryType.Update(entMST_CategoryType)) { return(true); } else { this.Message = dalMST_CategoryType.Message; return(false); } }
private void FillControls(Int32 CategoryTypeID) { //lblPageHeader.Text = CV.PageHeaderEdit + " CategoryType"; MST_CategoryTypeBAL balMST_CategoryType = new MST_CategoryTypeBAL(); MST_CategoryTypeENT entMST_CategoryType = new MST_CategoryTypeENT(); entMST_CategoryType = balMST_CategoryType.SelectPK(CategoryTypeID); if (!entMST_CategoryType.CategoryType.IsNull) { txtCategoryType.Text = entMST_CategoryType.CategoryType.Value.ToString(); } }
public MST_CategoryTypeENT SelectPK(SqlInt32 CategoryTypeID) { try { SqlDatabase sqlDB = new SqlDatabase(myConnectionString); DbCommand dbCMD = sqlDB.GetStoredProcCommand("PR_MST_CategoryType_SelectByPK"); sqlDB.AddInParameter(dbCMD, "@CategoryTypeID", SqlDbType.Int, CategoryTypeID); MST_CategoryTypeENT entMST_CategoryType = new MST_CategoryTypeENT(); DataBaseHelper DBH = new DataBaseHelper(); using (IDataReader dr = DBH.ExecuteReader(sqlDB, dbCMD)) { while (dr.Read()) { if (!dr["CategoryTypeID"].Equals(System.DBNull.Value)) { entMST_CategoryType.CategoryTypeID = Convert.ToInt32(dr["CategoryTypeID"]); } if (!dr["CategoryType"].Equals(System.DBNull.Value)) { entMST_CategoryType.CategoryType = Convert.ToString(dr["CategoryType"]); } } } return(entMST_CategoryType); } 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["CategoryTypeID"] == null) { MST_CategoryTypeENT entMST_CategoryType = new MST_CategoryTypeENT(); if (txtCategoryType.Text.ToString().Trim() != "") { entMST_CategoryType.CategoryType = txtCategoryType.Text.ToString().Trim(); } entMST_CategoryType.CreationDate = DateTime.Now; entMST_CategoryType.ModificationDate = DateTime.Now; entMST_CategoryType.UserID = Convert.ToInt32(Session["UserID"]); MST_CategoryTypeBAL balMST_CategoryType = new MST_CategoryTypeBAL(); if (balMST_CategoryType.Insert(entMST_CategoryType)) { pnlAlert.Visible = true; lblMessage.Text = "Data Inserted Successfully."; ClearControls(); } } else { MST_CategoryTypeENT entMST_CategoryType = new MST_CategoryTypeENT(); if (txtCategoryType.Text.ToString().Trim() != "") { entMST_CategoryType.CategoryType = txtCategoryType.Text.ToString().Trim(); } entMST_CategoryType.CategoryTypeID = Convert.ToInt32(Request.QueryString["CategoryTypeID"]); entMST_CategoryType.ModificationDate = DateTime.Now; entMST_CategoryType.UserID = Convert.ToInt32(Session["UserID"]); MST_CategoryTypeBAL balMST_CategoryType = new MST_CategoryTypeBAL(); if (balMST_CategoryType.Update(entMST_CategoryType)) { Response.Redirect("~/AdminPanel/Master/MST_CategoryType/MST_CategoryTypeList.aspx"); } } }