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