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 + "\", \"\");");
}
}
