public int MemberJob_Save(Model.MemberJob memberJob)
{
int rowsAffacted = 0;
using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["constr"].ToString()))
{
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = con;
cmd.CommandText = "usp_MemberJob_Save";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@MemberJobDetailsId", memberJob.MemberJobDetailsId);
cmd.Parameters.AddWithValue("@MemberId", memberJob.MemberId);
cmd.Parameters.AddWithValue("@CompanyName", memberJob.CompanyName);
cmd.Parameters.AddWithValue("@CompanyAddress", memberJob.CompanyAddress);
cmd.Parameters.AddWithValue("@Emirates", memberJob.Emirates);
cmd.Parameters.AddWithValue("@CreatedBy", memberJob.CreatedBy);
if (con.State == ConnectionState.Closed)
{
con.Open();
}
rowsAffacted = cmd.ExecuteNonQuery();
con.Close();
}
}
return(rowsAffacted);
}
private void MemberJob_GetAll()
{
DataTable dtMemberJob;
Model.MemberJob memberJob = new Model.MemberJob()
{
MemberId = this.MemberId
};
using (var scope = Startup.Container.BeginLifetimeScope())
{
var MemberJob = scope.Resolve <IMemberJob>();
dtMemberJob = MemberJob.MemberJob_GetAll(memberJob);
}
gvJob.DataSource = dtMemberJob;
gvJob.DataBind();
}
protected void btnJobSave_Click(object sender, EventArgs e)
{
try
{
if (ValidateJob())
{
int response = 0;
Model.MemberJob memberJob = new Model.MemberJob()
{
MemberJobDetailsId = this.MemberJobDetailsId,
MemberId = this.MemberId,
Emirates = txtCompanyEmirates.Text.Trim(),
CompanyAddress = txtCompanyAddress.Text.Trim(),
CompanyName = txtCompanyName.Text.Trim(),
CreatedBy = int.Parse(HttpContext.Current.User.Identity.Name),
};
using (var scope = Startup.Container.BeginLifetimeScope())
{
var MemberJob = scope.Resolve <IMemberJob>();
response = MemberJob.MemberJob_Save(memberJob);
}
if (response > 0)
{
ClearJobControls();
MemberJob_GetAll();
MessageJob.IsSuccess = true;
MessageJob.Text = "Saved Successfully";
}
else
{
MessageJob.IsSuccess = false;
MessageJob.Text = "Not saved.";
}
}
}
catch (Exception ex)
{
MessageJob.IsSuccess = false;
MessageJob.Text = ex.Message;
}
finally { ModalPopupExtender1.Show(); }
}
public DataTable MemberJob_GetAll(Model.MemberJob memberJob)
{
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_MemberJob_GetAll";
if (memberJob.MemberJobDetailsId == 0)
{
cmd.Parameters.AddWithValue("@MemberJobDetailsId", DBNull.Value);
}
else
{
cmd.Parameters.AddWithValue("@MemberJobDetailsId", memberJob.MemberJobDetailsId);
}
if (memberJob.MemberId == 0)
{
cmd.Parameters.AddWithValue("@MemberId", DBNull.Value);
}
else
{
cmd.Parameters.AddWithValue("@MemberId", memberJob.MemberId);
}
if (con.State == ConnectionState.Closed)
{
con.Open();
}
using (SqlDataAdapter da = new SqlDataAdapter(cmd))
{
da.Fill(dt);
}
con.Close();
}
}
return(dt);
}
}
private void MemberJob_GetById()
{
DataTable dtMemberJob;
Model.MemberJob memberJob = new Model.MemberJob()
{
MemberJobDetailsId = this.MemberJobDetailsId,
MemberId = this.MemberId
};
using (var scope = Startup.Container.BeginLifetimeScope())
{
var MemberJob = scope.Resolve <IMemberJob>();
dtMemberJob = MemberJob.MemberJob_GetAll(memberJob);
}
if (dtMemberJob != null && dtMemberJob.Rows.Count > 0)
{
txtCompanyName.Text = dtMemberJob.Rows[0]["CompanyName"].ToString();
txtCompanyAddress.Text = dtMemberJob.Rows[0]["CompanyAddress"].ToString();
txtCompanyEmirates.Text = dtMemberJob.Rows[0]["Emirates"].ToString();
}
}
public DataTable MemberJob_GetAll(Model.MemberJob memberJob)
{
return(_MemberJob.MemberJob_GetAll(memberJob));
}
public int MemberJob_Save(Model.MemberJob memberJob)
{
return(_MemberJob.MemberJob_Save(memberJob));
}
