protected void btnSave_Click(object sender, EventArgs e)
{
int response = 0;
Model.Enrolment enrolment = new Model.Enrolment()
{
BatchId = Convert.ToInt32(ddlBatch.SelectedValue),
CreatedBy = 1,
EnrolmentId = this.EnrolmentId,
EnrolmentNo = txtEnrolmentNo.Text.Trim(),
StartDate = Convert.ToDateTime(txtStartDate.Text),
StudentId = Convert.ToInt32(hfStudentId.Value)
};
using (var scope = Startup.Container.BeginLifetimeScope())
{
var Enrolment = scope.Resolve <IEnrolment>();
response = Enrolment.Enrolment_Save(enrolment);
}
if (response > 0)
{
ClearControls();
LoadEnrolmentList();
Message.IsSuccess = true;
Message.Text = "Saved Successfully";
}
else
{
Message.IsSuccess = false;
Message.Text = "Host Name Exists";
}
}
public int Enrolment_Save(Model.Enrolment enrolment)
{
int EnrolmentId = 0;
using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["constr"].ToString()))
{
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = con;
cmd.CommandText = "usp_Enrolment_Save";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@EnrollmentId", enrolment.EnrolmentId).Direction = ParameterDirection.InputOutput;
cmd.Parameters.AddWithValue("@BatchId", enrolment.BatchId);
cmd.Parameters.AddWithValue("@EnrolmentNo", enrolment.EnrolmentNo);
cmd.Parameters.AddWithValue("@StudentId", enrolment.StudentId);
cmd.Parameters.AddWithValue("@StartDate", enrolment.StartDate);
cmd.Parameters.AddWithValue("@CreatedBy", enrolment.CreatedBy);
if (con.State == ConnectionState.Closed)
{
con.Open();
}
cmd.ExecuteNonQuery();
EnrolmentId = Convert.ToInt32(cmd.Parameters["@EnrollmentId"].Value);
con.Close();
}
}
return(EnrolmentId);
}
private void LoadEnrolmentList()
{
DataTable dtEnrolment;
Model.Enrolment enrolment = new Model.Enrolment()
{
};
using (var scope = Startup.Container.BeginLifetimeScope())
{
var Enrolment = scope.Resolve <IEnrolment>();
dtEnrolment = Enrolment.Enrolment_GetAll(enrolment);
}
if (dtEnrolment != null)
{
dgvEnrolment.DataSource = dtEnrolment;
dgvEnrolment.DataBind();
}
}
private DataTable LoadEnrolmentList()
{
DataTable dtEnrolment;
Model.Enrolment enrolment = new Model.Enrolment()
{
BatchId = Convert.ToInt32(string.IsNullOrEmpty(txtBatchId.Text) ? "0" : txtBatchId.Text.Trim()),
EnrolmentId = Convert.ToInt32(string.IsNullOrEmpty(txtEnrolmentId.Text) ? "0" : txtEnrolmentId.Text.Trim()),
EnrolmentNo = txtEnrolmentNo.Text.Trim(),
StudentId = Convert.ToInt32(string.IsNullOrEmpty(txtStudentId.Text) ? "0" : txtStudentId.Text.Trim()),
StartFromDate = (string.IsNullOrEmpty(txtStartDate.Text) ? DateTime.MinValue : Convert.ToDateTime(txtStartDate.Text)),
StartToDate = (string.IsNullOrEmpty(txtEndDate.Text) ? DateTime.MinValue : Convert.ToDateTime(txtEndDate.Text))
};
using (var scope = Startup.Container.BeginLifetimeScope())
{
var Enrolment = scope.Resolve <IEnrolment>();
dtEnrolment = Enrolment.Enrolment_GetAll(enrolment);
}
return(dtEnrolment);
}
private void LoadEnrolmentById()
{
DataTable dtEnrolment;
Model.Enrolment enrolment = new Model.Enrolment()
{
EnrolmentId = this.EnrolmentId
};
using (var scope = Startup.Container.BeginLifetimeScope())
{
var Enrolment = scope.Resolve <IEnrolment>();
dtEnrolment = Enrolment.Enrolment_GetAll(enrolment);
}
if (dtEnrolment != null && dtEnrolment.Rows.Count > 0)
{
txtEnrolmentNo.Text = dtEnrolment.Rows[0]["EnrolmentNo"].ToString();
txtStartDate.Text = Convert.ToDateTime(dtEnrolment.Rows[0]["StartDate"].ToString()).ToString("dd MMM yyyy");
txtStudentName.Text = dtEnrolment.Rows[0]["Name"].ToString();
ddlBatch.SelectedValue = dtEnrolment.Rows[0]["BatchId"].ToString();
ddlClass.SelectedValue = dtEnrolment.Rows[0]["ClassId"].ToString();
hfStudentId.Value = dtEnrolment.Rows[0]["StudentId"].ToString();
}
}
public DataTable Enrolment_GetAll(Model.Enrolment enrolment)
{
using (DataTable dt = new DataTable())
{
using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["constr"].ToString()))
{
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = con;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "usp_Enrolment_GetAll";
if (enrolment.EnrolmentId == 0)
{
cmd.Parameters.AddWithValue("@EnrollmentId", DBNull.Value);
}
else
{
cmd.Parameters.AddWithValue("@EnrollmentId", enrolment.EnrolmentId);
}
if (enrolment.BatchId == 0)
{
cmd.Parameters.AddWithValue("@BatchId", DBNull.Value);
}
else
{
cmd.Parameters.AddWithValue("@BatchId", enrolment.BatchId);
}
if (enrolment.StudentId == 0)
{
cmd.Parameters.AddWithValue("@StudentId", DBNull.Value);
}
else
{
cmd.Parameters.AddWithValue("@StudentId", enrolment.StudentId);
}
if (enrolment.StartFromDate == DateTime.MinValue)
{
cmd.Parameters.AddWithValue("@StartFromDate", DBNull.Value);
}
else
{
cmd.Parameters.AddWithValue("@StartFromDate", enrolment.StartFromDate);
}
if (enrolment.StartToDate == DateTime.MinValue)
{
cmd.Parameters.AddWithValue("@StartToDate", DBNull.Value);
}
else
{
cmd.Parameters.AddWithValue("@StartToDate", enrolment.StartToDate);
}
if (string.IsNullOrEmpty(enrolment.EnrolmentNo))
{
cmd.Parameters.AddWithValue("@EnrolmentNo", DBNull.Value);
}
else
{
cmd.Parameters.AddWithValue("@EnrolmentNo", enrolment.EnrolmentNo);
}
if (con.State == ConnectionState.Closed)
{
con.Open();
}
using (SqlDataAdapter da = new SqlDataAdapter(cmd))
{
da.Fill(dt);
}
con.Close();
}
}
return(dt);
}
}
public DataTable Enrolment_GetAll(Model.Enrolment enrolment)
{
return(_Enrolment.Enrolment_GetAll(enrolment));
}
public int Enrolment_Save(Model.Enrolment enrolment)
{
return(_Enrolment.Enrolment_Save(enrolment));
}
