protected void btnSave_Click(object sender, EventArgs e) { #region server side validation String strErrorMessage = ""; if (txtReport.Text.Trim() == "") { strErrorMessage += "- Enter Report <br/>"; } if (strErrorMessage.Trim() != "") { lblErrorMessage.Text = strErrorMessage; return; } #endregion server side validation #region Collect Form Data ReportENT entReport = new ReportENT(); if (txtReport.Text.Trim() != "") { entReport.ReportName = txtReport.Text.Trim(); } #endregion Collect Form Data ReportBAL balReport = new ReportBAL(); if (Convert.ToBoolean(ViewState["ReportEditActive"]) == false) { if (balReport.Insert(entReport)) { fillGridViewReport(); ClientScript.RegisterStartupScript(GetType(), "SweetAlert", "swal({ type: 'success', title: 'City Inserted Successfully', showConfirmButton: false, timer: 2000});", true); ClearControls(); } else { lblErrorMessage.Text = balReport.Message; } } else { entReport.ReportID = Convert.ToInt32(ViewState["ReportID"]); if (balReport.Update(entReport)) { fillGridViewReport(); ClientScript.RegisterStartupScript(GetType(), "SweetAlert", "swal({ type: 'success', title: 'Report Edited Successfully', showConfirmButton: false, timer: 2000});", true); ClearControls(); ViewState["ReportEditActive"] = false; lblModalTitle.Text = "Report Add"; } else { lblErrorMessage.Text = balReport.Message; } } }
public ReportENT SelectByPK(SqlInt32 ReportID) { using (SqlConnection objConn = new SqlConnection(ConnectionString)) { objConn.Open(); using (SqlCommand objCmd = objConn.CreateCommand()) { try { #region Prepare Command objCmd.CommandType = CommandType.StoredProcedure; objCmd.CommandText = "PR_Report_SelectByPK"; objCmd.Parameters.Add("@ReportID", SqlDbType.Int).Value = ReportID; #endregion Prepare Command #region ReadData and Set Controls ReportENT entReport = new ReportENT(); using (SqlDataReader objSDR = objCmd.ExecuteReader()) { while (objSDR.Read()) { if (!objSDR["ReportID"].Equals(DBNull.Value)) { entReport.ReportID = Convert.ToInt32(objSDR["ReportID"]); } if (!objSDR["ReportName"].Equals(DBNull.Value)) { entReport.ReportName = Convert.ToString(objSDR["ReportName"]); } } } return(entReport); #endregion ReadData and Set Controls } catch (SqlException sqlEx) { Message = sqlEx.InnerException.Message; return(null); } catch (Exception ex) { Message = ex.InnerException.Message; return(null); } finally { if (objConn.State == ConnectionState.Open) { objConn.Close(); } } } } }
private void FillControls(SqlInt32 ReportID) { ReportBAL balReport = new ReportBAL(); ReportENT entReport = new ReportENT(); entReport = balReport.SelectByPK(ReportID); if (!entReport.ReportName.IsNull) { txtReport.Text = entReport.ReportName.Value.ToString(); } }
public Boolean Update(ReportENT entReport) { ReportDAL dalReport = new ReportDAL(); if (dalReport.Update(entReport)) { return(true); } else { Message = dalReport.Message; return(false); } }
public Boolean Insert(ReportENT entReport) { using (SqlConnection objConn = new SqlConnection(ConnectionString)) { objConn.Open(); using (SqlCommand objCmd = objConn.CreateCommand()) { try { #region Prepare Command objCmd.CommandType = CommandType.StoredProcedure; objCmd.CommandText = "PR_Report_Insert"; objCmd.Parameters.Add("@ReportID", SqlDbType.Int, 4).Direction = ParameterDirection.Output; objCmd.Parameters.Add("@ReportName", SqlDbType.VarChar).Value = entReport.ReportName; #endregion Prepare Command objCmd.ExecuteNonQuery(); if (objCmd.Parameters["@ReportID"] != null) { entReport.ReportID = Convert.ToInt32(objCmd.Parameters["@ReportID"].Value); } return(true); } catch (SqlException sqlEx) { Message = sqlEx.InnerException.Message; return(false); } catch (Exception ex) { Message = ex.InnerException.Message; return(false); } finally { if (objConn.State == ConnectionState.Open) { objConn.Close(); } } } } }
public Boolean Update(ReportENT entReport) { using (SqlConnection objConn = new SqlConnection(ConnectionString)) { objConn.Open(); using (SqlCommand objCmd = objConn.CreateCommand()) { try { #region Prepare Command objCmd.CommandType = CommandType.StoredProcedure; objCmd.CommandText = "PR_Report_UpdateByPK"; objCmd.Parameters.Add("@ReportID", SqlDbType.Int).Value = entReport.ReportID; objCmd.Parameters.Add("@ReportName", SqlDbType.VarChar).Value = entReport.ReportName; #endregion Prepare Command objCmd.ExecuteNonQuery(); return(true); } catch (SqlException sqlEx) { Message = sqlEx.InnerException.Message; return(false); } catch (Exception ex) { Message = ex.InnerException.Message; return(false); } finally { if (objConn.State == ConnectionState.Open) { objConn.Close(); } } } } }