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