public Boolean Update(MST_StateENT entMST_State) { try { SqlDatabase sqlDB = new SqlDatabase(myConnectionString); DbCommand dbCMD = sqlDB.GetStoredProcCommand("PR_MST_State_UpdateByPK"); sqlDB.AddInParameter(dbCMD, "@StateID", SqlDbType.Int, entMST_State.StateID); sqlDB.AddInParameter(dbCMD, "@StateName", SqlDbType.VarChar, entMST_State.StateName); sqlDB.AddInParameter(dbCMD, "@ModificationDate", SqlDbType.DateTime, entMST_State.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_StateENT entMST_State) { MST_StateDAL dalMST_State = new MST_StateDAL(); if (dalMST_State.Update(entMST_State)) { return(true); } else { this.Message = dalMST_State.Message; return(false); } }
private void FillControls(Int32 StateID) { //lblPageHeader.Text = CV.PageHeaderEdit + " State"; MST_StateBAL balMST_State = new MST_StateBAL(); MST_StateENT entMST_State = new MST_StateENT(); entMST_State = balMST_State.SelectPK(StateID); if (!entMST_State.StateName.IsNull) { txtStateName.Text = entMST_State.StateName.Value.ToString(); } }
public MST_StateENT SelectPK(SqlInt32 StateID) { try { SqlDatabase sqlDB = new SqlDatabase(myConnectionString); DbCommand dbCMD = sqlDB.GetStoredProcCommand("PR_MST_State_SelectByPK"); sqlDB.AddInParameter(dbCMD, "@StateID", SqlDbType.Int, StateID); MST_StateENT entMST_State = new MST_StateENT(); DataBaseHelper DBH = new DataBaseHelper(); using (IDataReader dr = DBH.ExecuteReader(sqlDB, dbCMD)) { while (dr.Read()) { if (!dr["StateID"].Equals(System.DBNull.Value)) { entMST_State.StateID = Convert.ToInt32(dr["StateID"]); } if (!dr["StateName"].Equals(System.DBNull.Value)) { entMST_State.StateName = Convert.ToString(dr["StateName"]); } } } return(entMST_State); } 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["StateID"] == null) { MST_StateENT entMST_State = new MST_StateENT(); if (txtStateName.Text.ToString().Trim() != "") { entMST_State.StateName = txtStateName.Text.ToString().Trim(); } entMST_State.CreationDate = DateTime.Now; entMST_State.ModificationDate = DateTime.Now; entMST_State.UserID = Convert.ToInt32(Session["UserID"]); MST_StateBAL balMST_State = new MST_StateBAL(); if (balMST_State.Insert(entMST_State)) { pnlAlert.Visible = true; lblMessage.Text = "Data Inserted Successfully."; ClearControls(); } } else { MST_StateENT entMST_State = new MST_StateENT(); if (txtStateName.Text.ToString().Trim() != "") { entMST_State.StateName = txtStateName.Text.ToString().Trim(); } entMST_State.StateID = Convert.ToInt32(Request.QueryString["StateID"]); entMST_State.ModificationDate = DateTime.Now; entMST_State.UserID = Convert.ToInt32(Session["UserID"]); MST_StateBAL balMST_State = new MST_StateBAL(); if (balMST_State.Update(entMST_State)) { Response.Redirect("~/AdminPanel/Master/MST_State/MST_StateList.aspx"); } } }