public DataTable SaveSalesPerson(SalesPersonBLL salesPerson, LumexDBPlayer db) { try { db.AddParameters("@SalesPersonName", salesPerson.SalesPersonName.Trim()); db.AddParameters("@Address", salesPerson.Address.Trim()); db.AddParameters("@PostalCode", salesPerson.PostalCode.Trim()); db.AddParameters("@City", salesPerson.City.Trim()); db.AddParameters("@District", salesPerson.District.Trim()); db.AddParameters("@Country", salesPerson.Country.Trim()); db.AddParameters("@NationalId", salesPerson.NationalId.Trim()); db.AddParameters("@PassportNumber", salesPerson.PassportNumber.Trim()); db.AddParameters("@ContactNumber", salesPerson.ContactNumber.Trim()); db.AddParameters("@Email", salesPerson.Email.Trim()); db.AddParameters("@JoiningSalesCenterId", salesPerson.JoiningSalesCenterId.Trim()); db.AddParameters("@WorkingSalesCenterId", salesPerson.WorkingSalesCenterId.Trim()); db.AddParameters("@JoinDate", salesPerson.JoinDate.Trim()); db.AddParameters("@CreatedBy", LumexSessionManager.Get("ActiveUserId").ToString()); db.AddParameters("@CreatedFrom", LumexLibraryManager.GetTerminal()); DataTable dt = db.ExecuteDataTable("INSERT_SALES_PERSON", true); return dt; } catch (Exception) { throw; } finally { salesPerson = null; } }
protected void GetSalesPersonList() { SalesPersonBLL salesPerson = new SalesPersonBLL(); try { DataTable dt = salesPerson.GetSalesPersonList(); salesPersonListGridView.DataSource = dt; salesPersonListGridView.DataBind(); if (dt.Rows.Count < 1) { msgbox.Visible = true; msgTitleLabel.Text = "Sales Person List Data Not Found!!!"; msgDetailLabel.Text = ""; msgbox.Attributes.Add("class", "alert alert-warning"); } } catch (Exception ex) { string message = ex.Message; if (ex.InnerException != null) { message += " --> " + ex.InnerException.Message; } MyAlertBox("ErrorAlert(\"" + ex.GetType() + "\", \"" + message + "\", \"\");"); } finally { salesPerson = null; } }
protected void GetSalesPersonById(string salesPersonId) { SalesPersonBLL salesPerson = new SalesPersonBLL(); try { DataTable dt = salesPerson.GetSalesPersonById(salesPersonId); if (dt.Rows.Count > 0) { salesPersonNameTextBox.Text = dt.Rows[0]["SalesPersonName"].ToString(); countryTextBox.Text = dt.Rows[0]["Country"].ToString(); cityTextBox.Text = dt.Rows[0]["City"].ToString(); districtTextBox.Text = dt.Rows[0]["District"].ToString(); postalCodeTextBox.Text = dt.Rows[0]["PostalCode"].ToString(); nationalIdTextBox.Text = dt.Rows[0]["NationalId"].ToString(); passportNumberTextBox.Text = dt.Rows[0]["PassportNumber"].ToString(); contactNumberTextBox.Text = dt.Rows[0]["ContactNumber"].ToString(); emailTextBox.Text = dt.Rows[0]["Email"].ToString(); addressTextBox.Text = dt.Rows[0]["Address"].ToString(); joinDateTextBox.Text = LumexLibraryManager.GetAppDateView(dt.Rows[0]["joinDate"].ToString()); joiningSalesCenterDropDownList.SelectedValue = dt.Rows[0]["JoiningSalesCenterId"].ToString(); if (joiningSalesCenterDropDownList.SelectedValue != dt.Rows[0]["JoiningSalesCenterId"].ToString()) { joiningSalesCenterDropDownList.Items.Insert(1, new ListItem(dt.Rows[0]["JoiningSalesCenterName"].ToString(), dt.Rows[0]["JoiningSalesCenterId"].ToString())); joiningSalesCenterDropDownList.SelectedIndex = 1; } workingSalesCenterDropDownList.SelectedValue = dt.Rows[0]["WorkingSalesCenterId"].ToString(); if (workingSalesCenterDropDownList.SelectedValue != dt.Rows[0]["WorkingSalesCenterId"].ToString()) { workingSalesCenterDropDownList.Items.Insert(1, new ListItem(dt.Rows[0]["WorkingSalesCenterName"].ToString(), dt.Rows[0]["WorkingSalesCenterId"].ToString())); workingSalesCenterDropDownList.SelectedIndex = 1; } } else { msgbox.Visible = true; msgTitleLabel.Text = "Sales Person Data Not Found!!!"; msgDetailLabel.Text = ""; msgbox.Attributes.Add("class", "alert alert-warning"); } } catch (Exception ex) { string message = ex.Message; if (ex.InnerException != null) { message += " --> " + ex.InnerException.Message; } MyAlertBox("ErrorAlert(\"" + ex.GetType() + "\", \"" + message + "\", \"\");"); } finally { salesPerson = null; } }
protected void deletedListButton_Click(object sender, EventArgs e) { SalesPersonBLL salesPerson = new SalesPersonBLL(); try { if (fromDateTextBox.Text.Trim() == "" || LumexLibraryManager.ParseAppDate(fromDateTextBox.Text.Trim()) == "False") { msgbox.Visible = true; msgTitleLabel.Text = "Validation!!!"; msgDetailLabel.Text = "Date From field is required."; } else if (toDateTextBox.Text.Trim() == "" || LumexLibraryManager.ParseAppDate(toDateTextBox.Text.Trim()) == "False") { msgbox.Visible = true; msgTitleLabel.Text = "Validation!!!"; msgDetailLabel.Text = "Date To field is required."; } else { string fromDate = LumexLibraryManager.ParseAppDate(fromDateTextBox.Text.Trim()); string toDate = LumexLibraryManager.ParseAppDate(toDateTextBox.Text.Trim()); DataTable dt = salesPerson.GetDeletedSalesPersonListByDateRangeAll(fromDate, toDate, ""); deletedListGridView.DataSource = dt; deletedListGridView.DataBind(); if (deletedListGridView.Rows.Count > 0) { deletedListGridView.UseAccessibleHeader = true; deletedListGridView.HeaderRow.TableSection = TableRowSection.TableHeader; } else { msgbox.Visible = true; msgTitleLabel.Text = "Deleted Sales Person List Data Not Found!!!"; msgDetailLabel.Text = ""; msgbox.Attributes.Add("class", "alert alert-info"); } } } catch (Exception ex) { string message = ex.Message; if (ex.InnerException != null) { message += " --> " + ex.InnerException.Message; } MyAlertBox("ErrorAlert(\"" + ex.GetType() + "\", \"" + message + "\", \"\");"); } finally { salesPerson = null; MyAlertBox("MyOverlayStop();"); } }
protected void saveButton_Click(object sender, EventArgs e) { SalesPersonBLL salesPerson = new SalesPersonBLL(); try { if (salesPersonNameTextBox.Text.Trim() == "") { msgbox.Visible = true; msgTitleLabel.Text = "Validation!!!"; msgDetailLabel.Text = "Sales Person Name field is required."; } else if (emailTextBox.Text.Trim() == "") { msgbox.Visible = true; msgTitleLabel.Text = "Validation!!!"; msgDetailLabel.Text = "Email field is required."; } else if (addressTextBox.Text.Trim() == "") { msgbox.Visible = true; msgTitleLabel.Text = "Validation!!!"; msgDetailLabel.Text = "Address field is required."; } else if (joinDateTextBox.Text.Trim() == "" || LumexLibraryManager.ParseAppDate(joinDateTextBox.Text.Trim()) == "False") { msgbox.Visible = true; msgTitleLabel.Text = "Validation!!!"; msgDetailLabel.Text = "Join Date field is required."; } else if (joiningSalesCenterDropDownList.Text == "") { msgbox.Visible = true; msgTitleLabel.Text = "Validation!!!"; msgDetailLabel.Text = "Joining Sales Center field is required."; } else if (workingSalesCenterDropDownList.Text == "") { msgbox.Visible = true; msgTitleLabel.Text = "Validation!!!"; msgDetailLabel.Text = "Working Sales Center field is required."; } else { salesPerson.SalesPersonName = salesPersonNameTextBox.Text.Trim(); salesPerson.ContactNumber = contactNumberTextBox.Text.Trim(); salesPerson.Email = emailTextBox.Text.Trim(); salesPerson.Country = countryTextBox.Text.Trim(); salesPerson.City = cityTextBox.Text.Trim(); salesPerson.District = districtTextBox.Text.Trim(); salesPerson.PostalCode = postalCodeTextBox.Text.Trim(); salesPerson.Address = addressTextBox.Text.Trim(); salesPerson.NationalId = nationalIdTextBox.Text.Trim(); salesPerson.PassportNumber = passportNumberTextBox.Text.Trim(); salesPerson.JoinDate = LumexLibraryManager.ParseAppDate(joinDateTextBox.Text.Trim()); salesPerson.JoiningSalesCenterId = joiningSalesCenterDropDownList.SelectedValue.Trim(); salesPerson.WorkingSalesCenterId = workingSalesCenterDropDownList.SelectedValue.Trim(); DataTable dt = salesPerson.SaveSalesPerson(); if (dt.Rows.Count > 0) { string message = "Sales Person <span class='actionTopic'>Created</span> Successfully with Sales Person ID: <span class='actionTopic'>" + dt.Rows[0][0].ToString() + "</span>."; MyAlertBox("var callbackOk = function () { MyOverlayStart(); window.location = \"/UI/SalesPerson/List.aspx\"; }; SuccessAlert(\"" + "Process Succeed" + "\", \"" + message + "\", callbackOk);"); } else { string message = "<span class='actionTopic'>Failed</span> to Create Sales Person."; MyAlertBox("ErrorAlert(\"" + "Process Failed" + "\", \"" + message + "\");"); } } } catch (Exception ex) { string message = ex.Message; if (ex.InnerException != null) { message += " --> " + ex.InnerException.Message; } MyAlertBox("ErrorAlert(\"" + ex.GetType() + "\", \"" + message + "\", \"\");"); } finally { salesPerson = null; } }
public void UpdateSalesPerson(SalesPersonBLL salesPerson, LumexDBPlayer db) { try { db.AddParameters("@SalesPersonId", salesPerson.SalesPersonId.Trim()); db.AddParameters("@SalesPersonName", salesPerson.SalesPersonName.Trim()); db.AddParameters("@Address", salesPerson.Address.Trim()); db.AddParameters("@PostalCode", salesPerson.PostalCode.Trim()); db.AddParameters("@City", salesPerson.City.Trim()); db.AddParameters("@District", salesPerson.District.Trim()); db.AddParameters("@Country", salesPerson.Country.Trim()); db.AddParameters("@NationalId", salesPerson.NationalId.Trim()); db.AddParameters("@PassportNumber", salesPerson.PassportNumber.Trim()); db.AddParameters("@ContactNumber", salesPerson.ContactNumber.Trim()); db.AddParameters("@Email", salesPerson.Email.Trim()); db.AddParameters("@JoiningSalesCenterId", salesPerson.JoiningSalesCenterId.Trim()); db.AddParameters("@WorkingSalesCenterId", salesPerson.WorkingSalesCenterId.Trim()); db.AddParameters("@JoinDate", salesPerson.JoinDate.Trim()); db.AddParameters("@ModifiedBy", LumexSessionManager.Get("ActiveUserId").ToString()); db.AddParameters("@ModifiedFrom", LumexLibraryManager.GetTerminal()); db.ExecuteNonQuery("UPDATE_SALES_PERSON_BY_ID", true); } catch (Exception) { throw; } finally { salesPerson = null; } }
protected void activateLinkButton_Click(object sender, EventArgs e) { try { LinkButton lnkBtn = (LinkButton)sender; GridViewRow row = (GridViewRow)lnkBtn.NamingContainer; SalesPersonBLL salesPerson = new SalesPersonBLL(); salesPerson.UpdateSalesPersonActivation(salesPersonListGridView.Rows[row.RowIndex].Cells[0].Text.ToString(), "True"); salesPersonListGridView.Rows[row.RowIndex].Cells[4].Text = "True"; string message = "Sales Person <span class='actionTopic'>Activated</span> Successfully."; MyAlertBox("SuccessAlert(\"" + "Process Succeed" + "\", \"" + message + "\", \"\");"); } catch (Exception ex) { string message = ex.Message; if (ex.InnerException != null) { message += " --> " + ex.InnerException.Message; } MyAlertBox("ErrorAlert(\"" + ex.GetType() + "\", \"" + message + "\", \"\");"); } }