private void MemberActivity_GetAll() { DataTable dtMemberActivity; Model.MemberActivity memberActivity = new Model.MemberActivity() { MemberId = this.MemberId }; using (var scope = Startup.Container.BeginLifetimeScope()) { var MemberActivity = scope.Resolve <IMemberActivity>(); dtMemberActivity = MemberActivity.MemberActivity_GetAll(memberActivity); } gvActivity.DataSource = dtMemberActivity; gvActivity.DataBind(); }
protected void btnActivitySave_Click(object sender, EventArgs e) { try { if (ValidateActivity()) { int response = 0; Model.MemberActivity memberActivity = new Model.MemberActivity() { MemberActivityId = this.MemberActivityId, MemberId = this.MemberId, ActivityId = int.Parse(ddlActivity.SelectedValue), FromDate = (string.IsNullOrEmpty(txtFromDate.Text.Trim())) ? DateTime.MinValue : Convert.ToDateTime(txtFromDate.Text.Trim()), ToDate = (string.IsNullOrEmpty(txtToDate.Text.Trim())) ? DateTime.MinValue : Convert.ToDateTime(txtToDate.Text.Trim()), LikeActivity = Convert.ToBoolean(rbtnLikeActivity.SelectedValue), Location = txtLocation.Text.Trim(), CreatedBy = int.Parse(HttpContext.Current.User.Identity.Name), }; using (var scope = Startup.Container.BeginLifetimeScope()) { var MemberActivity = scope.Resolve <IMemberActivity>(); response = MemberActivity.MemberActivity_Save(memberActivity); } if (response > 0) { ClearActivityControls(); MemberActivity_GetAll(); MessageActivity.IsSuccess = true; MessageActivity.Text = "Saved Successfully"; } else { MessageActivity.IsSuccess = false; MessageActivity.Text = "Not saved."; } } } catch (Exception ex) { MessageActivity.IsSuccess = false; MessageActivity.Text = ex.Message; } finally { ModalPopupExtender1.Show(); } }
public int MemberActivity_Save(Model.MemberActivity memberActivity) { int rowsAffacted = 0; using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["constr"].ToString())) { using (SqlCommand cmd = new SqlCommand()) { cmd.Connection = con; cmd.CommandText = "usp_MemberActivity_Save"; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@MemberActivityId", memberActivity.MemberActivityId); cmd.Parameters.AddWithValue("@MemberId", memberActivity.MemberId); cmd.Parameters.AddWithValue("@ActivityId", memberActivity.ActivityId); cmd.Parameters.AddWithValue("@Location", memberActivity.Location); if (memberActivity.FromDate == DateTime.MinValue) { cmd.Parameters.AddWithValue("@FromDate", DBNull.Value); } else { cmd.Parameters.AddWithValue("@FromDate", memberActivity.FromDate); } if (memberActivity.ToDate == DateTime.MinValue) { cmd.Parameters.AddWithValue("@ToDate", DBNull.Value); } else { cmd.Parameters.AddWithValue("@ToDate", memberActivity.ToDate); } cmd.Parameters.AddWithValue("@LikeActivity", memberActivity.LikeActivity); cmd.Parameters.AddWithValue("@CreatedBy", memberActivity.CreatedBy); if (con.State == ConnectionState.Closed) { con.Open(); } rowsAffacted = cmd.ExecuteNonQuery(); con.Close(); } } return(rowsAffacted); }
public DataTable MemberActivity_GetAll(Model.MemberActivity memberActivity) { 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_MemberActivity_GetAll"; if (memberActivity.MemberActivityId == 0) { cmd.Parameters.AddWithValue("@MemberActivityId", DBNull.Value); } else { cmd.Parameters.AddWithValue("@MemberActivityId", memberActivity.MemberActivityId); } if (memberActivity.MemberId == 0) { cmd.Parameters.AddWithValue("@MemberId", DBNull.Value); } else { cmd.Parameters.AddWithValue("@MemberId", memberActivity.MemberId); } if (con.State == ConnectionState.Closed) { con.Open(); } using (SqlDataAdapter da = new SqlDataAdapter(cmd)) { da.Fill(dt); } con.Close(); } } return(dt); } }
private void MemberActivity_GetById() { DataTable dtMemberActivity; Model.MemberActivity memberActivity = new Model.MemberActivity() { MemberActivityId = this.MemberActivityId, MemberId = this.MemberId }; using (var scope = Startup.Container.BeginLifetimeScope()) { var MemberActivity = scope.Resolve <IMemberActivity>(); dtMemberActivity = MemberActivity.MemberActivity_GetAll(memberActivity); } if (dtMemberActivity != null && dtMemberActivity.Rows.Count > 0) { ddlActivity.SelectedValue = dtMemberActivity.Rows[0]["ActivityId"].ToString(); txtLocation.Text = dtMemberActivity.Rows[0]["Location"].ToString(); txtFromDate.Text = (dtMemberActivity.Rows[0]["FromDate"] == DBNull.Value) ? string.Empty : Convert.ToDateTime(dtMemberActivity.Rows[0]["FromDate"].ToString()).ToString("dd MMM yyyy"); txtToDate.Text = (dtMemberActivity.Rows[0]["ToDate"] == DBNull.Value) ? string.Empty : Convert.ToDateTime(dtMemberActivity.Rows[0]["ToDate"].ToString()).ToString("dd MMM yyyy"); rbtnLikeActivity.SelectedValue = (dtMemberActivity.Rows[0]["LikeActivity"] == DBNull.Value) ? "1" : dtMemberActivity.Rows[0]["LikeActivity"].ToString(); } }
public DataTable MemberActivity_GetAll(Model.MemberActivity memberActivity) { return(_MemberActivity.MemberActivity_GetAll(memberActivity)); }
public int MemberActivity_Save(Model.MemberActivity memberActivity) { return(_MemberActivity.MemberActivity_Save(memberActivity)); }