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