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