private void btnSearch_Click(object sender, EventArgs e)
{
int published, promID;
string promName;
if (txtPromID.Text.ToString() != "")
{
promID = Int32.Parse(txtPromID.Text.ToString());
}
else
{
promID = 0;
}
promName = txtPromName.Text.ToString();
if (chkActive.Checked)
{
published = 1;
}
else
{
published = 0;
}
this.promotionTableAdapter.Connection.ConnectionString = MetriconCommon.getConnectionString();
//when dataAdapter fill the dataset, query was written in PMO006STGDataSet.xsd file.
this.promotionTableAdapter.FillBy(this.pMO006STGDataSet.promotion, promID, promName, published);
}
private void btnLogin_Click(object sender, EventArgs e)
{
this.Authenticated = true;
if (radDev.Checked)
{
MetriconCommon.Environment = "DEV";
SQSAdmin_WpfCustomControlLibrary.CommonVariables.Environment = "DEV";
}
else if (radTest.Checked)
{
MetriconCommon.Environment = "STG";
SQSAdmin_WpfCustomControlLibrary.CommonVariables.Environment = "STG";
}
else
{
MetriconCommon.Environment = "LIVE";
SQSAdmin_WpfCustomControlLibrary.CommonVariables.Environment = "LIVE";
}
MetriconCommon.State = cmbState.SelectedValue.ToString();
MetriconCommon.UserState = cmbState.SelectedValue.ToString();
MetriconCommon.UserStateName = cmbState.Text;
MetriconCommon.WindowTitleInfo = "Logged in as " + MetriconCommon.UserName + " Using " + cmbState.Text + " " + MetriconCommon.Environment + " environment";
SQSAdmin_WpfCustomControlLibrary.CommonVariables.UserCode = ((DataRowView)comboBox1.SelectedItem)["AdministratorID"].ToString();
SQSAdmin_WpfCustomControlLibrary.CommonVariables.WcfEndpoint = MetriconCommon.getWcfEndpoint();
SQSAdmin_WpfCustomControlLibrary.CommonVariables.WindowTitleInfo = MetriconCommon.WindowTitleInfo;
this.Close();
}
public DataSet ExecuteSQLQuery(string sqlQuery)
{
try
{
mySQLConnection = new SqlConnection(this.sSQLConnectionString);
mySQLAdapter = new SqlDataAdapter(sqlQuery, mySQLConnection);
myDataSet = new DataSet();
mySQLConnection.Open();
mySQLAdapter.FillSchema(myDataSet, SchemaType.Source);
mySQLAdapter.Fill(myDataSet);
}
catch (Exception e)
{
MetriconCommon.LogToFile("", "", "ServerManager.ExecuteSQLQuery", e.Message.ToString());
}
finally
{
//if there are no tables add default table
if (myDataSet.Tables.Count == 0)
{
myDataSet.Tables.Add(new DataTable("NoRecords"));
}
mySQLConnection.Close();
mySQLConnection.Dispose();
}
return(myDataSet);
}
private void ApplyCMA()
{
double dbcCost = 0;
double btpCost = 0;
double sellPrice = 0;
double gst = 1.1;
double.TryParse(textBoxDBCCost.Text.ToString().Replace("$", ""), out dbcCost);
if (checkBoxApplyCMA.Checked)
{
double cmaPercent = 0;
double.TryParse(textBoxCMAPercent.Text.ToString(), out cmaPercent);
btpCost = dbcCost + dbcCost * (cmaPercent / 100);
}
else
{
btpCost = dbcCost;
}
double.TryParse(txtSellPrice.Text.ToString().Replace("$", ""), out sellPrice);
textBoxBTPCost.Text = btpCost.ToString();
if (sellPrice > 0)
{
textBoxBTPTargetMargin.Text = Math.Round(100 * ((sellPrice / gst) - btpCost) / (sellPrice / gst), 2).ToString();
}
MetriconCommon.ToCurrency(ref textBoxBTPCost);
}
public bool LoadVariablesFromFile()
{
//loading from web.config file
MetriconCommon.LogToFile("", "", "ServerManager.LoadVariablesFromFile", "");
SetConnectionString();
return(true);
}
private void frmPromotionLookup_Load(object sender, EventArgs e)
{
// TODO: This line of code loads data into the 'pMO006STGDataSet.promotion' table. You can move, or remove it, as needed.
this.Text = this.Text + " - " + MetriconCommon.WindowTitleInfo;
this.promotionTableAdapter.Connection.ConnectionString = MetriconCommon.getConnectionString();
//when dataAdapter fill the dataset, query was written in PMO006STGDataSet.xsd file.
this.promotionTableAdapter.Fill(this.pMO006STGDataSet.promotion);
// classCustomizeScreenLookAndFeel.customizeMyScreen(this);
}
public static void Configuration_Set()
{
try
{
// default #ccddff
backColorSelected = ColorTranslator.FromHtml(MetriconCommon.GetSettings("BackColor").ToString());
}
catch (Exception ex)
{
// log error ex
}
}
private void buttonBackColorPicker_Click(object sender, EventArgs e)
{
// Show the color dialog.
DialogResult result = colorDialog1.ShowDialog();
// See if user pressed ok.
if (result == DialogResult.OK)
{
// Set form background to the selected color.
textBoxBackColorPicker.BackColor = colorDialog1.Color;
classCustomizeScreenLookAndFeel.customizeMyScreen(this, textBoxBackColorPicker.BackColor);
MetriconCommon.SetSettings("BackColor", "#" + colorDialog1.Color.Name);
}
}
private void frmHomeDisplayLookup_Load(object sender, EventArgs e)
{
this.Text = this.Text + " - " + MetriconCommon.WindowTitleInfo;
this.homeTableAdapter.Connection.ConnectionString = MetriconCommon.getConnectionString();
//when dataAdapter fill the dataset, query was written in PMO006STGDataSet.xsd file.
//this.homeTableAdapter.FillHomeDisplayData(this.pMO006STGDataSet.Home);
loadStateDropdown();
LoadBrandList();
loadStatusDropdown();
fillByToolStripButton_Click(sender, e);
// classCustomizeScreenLookAndFeel.customizeMyScreen(this);
}
private void frmHomeLookup_Load(object sender, EventArgs e)
{
// TODO: This line of code loads data into the 'pMO006STGDataSet.Home' table. You can move, or remove it, as needed.
this.Text = this.Text + " - " + MetriconCommon.WindowTitleInfo;
this.homeTableAdapter.Connection.ConnectionString = MetriconCommon.getConnectionString();
//this.homeTableAdapter.Fill(this.pMO006STGDataSet.Home);
loadStateDropdown();
LoadBrandList();
loadStatusDropdown();
loadShowOnPriceListDropdown();
fillByToolStripButton_Click(sender, e);
// classCustomizeScreenLookAndFeel.customizeMyScreen(this);
}
private void btnSaveNewArea_Click(object sender, EventArgs e)
{
int sortOrder, active, sortOrder2;
if (txtNewAreaName.Text.ToString() != "")
{
sortOrder = MetriconCommon.initIntVariables(txtAreaSortOrder.Text.ToString());
sortOrder2 = MetriconCommon.initIntVariables(txtDoubleSortOrder.Text.ToString());
if (chkActive.Checked)
{
active = 1;
}
else
{
active = 0;
}
try
{
MetriconCommon.DatabaseManager.ExecuteSQLQuery("spa_AdminAddEditArea", new System.Data.SqlClient.SqlParameter[7] {
new System.Data.SqlClient.SqlParameter("@areaID", -1)
, new System.Data.SqlClient.SqlParameter("@areaName", txtNewAreaName.Text)
, new System.Data.SqlClient.SqlParameter("@sortOrder", sortOrder)
, new System.Data.SqlClient.SqlParameter("@sortOrderDouble", sortOrder2)
, new System.Data.SqlClient.SqlParameter("@active", active)
, new System.Data.SqlClient.SqlParameter("@action", "NEW")
, new System.Data.SqlClient.SqlParameter("@CreatedBy", MetriconCommon.UserCode)
});
}
catch (SqlException ex1)
{
MessageBox.Show(ex1.Message.ToString());
}
panel1.Visible = false;
loadAreas();
}
else
{
MessageBox.Show("Please enter area name.");
}
}
private void btnSaveNewGroup_Click(object sender, EventArgs e)
{
int sortOrder, active, studiomsortorder;
if (txtNewGroupName.Text.ToString() != "")
{
sortOrder = MetriconCommon.initIntVariables(txtNewGroupSortOrder.Text.ToString());
studiomsortorder = MetriconCommon.initIntVariables(txtStudioMsortorder.Text.ToString());
if (chkActive2.Checked)
{
active = 1;
}
else
{
active = 0;
}
try
{
MetriconCommon.DatabaseManager.ExecuteSQLQuery("spa_AdminAddEditGroup", new System.Data.SqlClient.SqlParameter[7] {
new System.Data.SqlClient.SqlParameter("@groupID", -1)
, new System.Data.SqlClient.SqlParameter("@groupName", txtNewGroupName.Text)
, new System.Data.SqlClient.SqlParameter("@sortOrder", txtNewGroupSortOrder.Text)
, new System.Data.SqlClient.SqlParameter("@active", active)
, new System.Data.SqlClient.SqlParameter("@action", "NEW")
, new System.Data.SqlClient.SqlParameter("@CreatedBy", MetriconCommon.UserCode)
, new System.Data.SqlClient.SqlParameter("@studiomsortorder", studiomsortorder)
});
}
catch (SqlException ex1)
{
MessageBox.Show(ex1.Message.ToString());
}
panel2.Visible = false;
loadGroups();
}
else
{
MessageBox.Show("Please enter group name.");
}
}
public DataSet ExecuteSQLQuery(string sqlStoredProcedure, SqlParameter[] myParameters)
{
try
{
mySQLConnection = new SqlConnection(this.sSQLConnectionString);
mySQLAdapter = new SqlDataAdapter(sqlStoredProcedure, mySQLConnection);
myDataSet = new DataSet();
//mySQLAdapter.SelectCommand = new SqlCommand(sqlStoredProcedure);
mySQLAdapter.SelectCommand.CommandTimeout = 7200;
mySQLAdapter.SelectCommand.Connection = mySQLConnection;
mySQLAdapter.SelectCommand.CommandType = CommandType.StoredProcedure;
mySQLConnection.Open();
foreach (SqlParameter tempParam in myParameters)
{
mySQLAdapter.SelectCommand.Parameters.Add(tempParam);
}
mySQLAdapter.Fill(myDataSet);
}
catch (Exception e)
{
MetriconCommon.LogToFile("", "", "ServerManager.ExecuteSQLQuery", e.Message.ToString());
throw e;
}
finally
{
//if there are no tables add default table
if (myDataSet.Tables.Count == 0)
{
myDataSet.Tables.Add(new DataTable("NoRecords"));
}
mySQLConnection.Close();
mySQLConnection.Dispose();
}
return(myDataSet);
}
private void textBoxDBCCost_Leave(object sender, EventArgs e)
{
ApplyCMA();
MetriconCommon.ToCurrency(ref textBoxDBCCost);
}
private void textBoxDBCCost_Enter(object sender, EventArgs e)
{
MetriconCommon.ToDouble(ref textBoxDBCCost);
}
public void SetConnectionString()
{
this.sSQLConnectionString = MetriconCommon.getConnectionString();
}
private void txtSellPrice_Enter(object sender, EventArgs e)
{
MetriconCommon.ToDouble(ref txtSellPrice);
}
private void txtSellPrice_Leave(object sender, EventArgs e)
{
MetriconCommon.ToCurrency(ref txtSellPrice);
}
public void SaveForm()
{
string action, suburb, postcode, estatename;
int bedroom, bathroom, storey, brandID, sortOrder, parentHomeID, HomeID, regionID, originalparentHomeID, originaldisplayHomeID, stateID;
double houseArea, houseAreaSquare, alfrescoArea, alfrescoAreaSquares, garageArea, garageAreaSquares, blocksize;
double totalArea, totalAreaSquares, minimumBlockWidth, houseLength, houseWidth, garageBays;
string displayclosedate = "";
//initialize all blank integer field
if (txtParentHomeID.Text != "")
{
if (txtProductID.Text != "")
{
success = 1;
bedroom = MetriconCommon.initIntVariables(dropBedrooms.Text.ToString());
bathroom = MetriconCommon.initIntVariables(dropBathrooms.Text.ToString());
storey = MetriconCommon.initIntVariables(dropStoreys.Text.ToString());
dropBrand.Enabled = true;
brandID = MetriconCommon.initIntVariables(dropBrand.SelectedValue.ToString());
dropBrand.Enabled = false;
stateID = Int32.Parse(dropdownState.SelectedValue.ToString());
sortOrder = MetriconCommon.initIntVariables(txtSortOrder.Text.ToString());
HomeID = MetriconCommon.initIntVariables(txtHomeID.Text.ToString());
parentHomeID = MetriconCommon.initIntVariables(txtParentHomeID.Text.ToString());
//regionID = MetriconCommon.initIntVariables(dropRegion.SelectedValue.ToString());
originalparentHomeID = MetriconCommon.initIntVariables(txtOriginalHomeID.Text.ToString());
originaldisplayHomeID = MetriconCommon.initIntVariables(txtOriginalDisHomeID.Text.ToString());
//initialize all blank decimal field
houseArea = MetriconCommon.initDoubleVariables(txtHouseArea.Text.ToString());
houseAreaSquare = MetriconCommon.initDoubleVariables(txtHouseAreaSquares.Text.ToString());
alfrescoArea = MetriconCommon.initDoubleVariables(txtAlfrescoArea.Text.ToString());
alfrescoAreaSquares = MetriconCommon.initDoubleVariables(txtAlfrescoAreaSquares.Text.ToString());
garageArea = MetriconCommon.initDoubleVariables(txtGarageArea.Text.ToString());
garageAreaSquares = MetriconCommon.initDoubleVariables(txtGarageAreaSquares.Text.ToString());
totalArea = MetriconCommon.initDoubleVariables(txtTotalArea.Text.ToString());
totalAreaSquares = MetriconCommon.initDoubleVariables(txtTotalAreaSquares.Text.ToString());
minimumBlockWidth = MetriconCommon.initDoubleVariables(txtMinimumBlockWidth.Text.ToString());
houseLength = MetriconCommon.initDoubleVariables(txtHouseLength.Text.ToString());
houseWidth = MetriconCommon.initDoubleVariables(txtHouseWidth.Text.ToString());
garageBays = MetriconCommon.initDoubleVariables(txtGarageBays.Text.ToString());
if (txtclosedate.Text != "")
{
displayclosedate = dateTimePicker1.Value.ToString("dd/MMM/yyyy");
}
string sb;
try
{
sb = dropSuburb.SelectedItem.ToString();
}
catch (Exception ex)
{
sb = dropSuburb.Text;
}
try
{
estatename = dropEstate.SelectedItem.ToString();
}
catch (Exception ex)
{
estatename = dropEstate.Text;
}
if (txtLotAddress.Text == "")
{
success = 0;
MessageBox.Show("Please enter the lot address!");
return;
}
if (sb == "")
{
suburb = "";
postcode = "";
success = 0;
MessageBox.Show("Please select appropriate suburb!");
return;
}
else
{
suburb = sb.Substring(0, sb.IndexOf("(") - 1);
postcode = sb.Substring(sb.IndexOf("(") + 1, sb.IndexOf(")") - sb.IndexOf("(") - 1);
}
if (estatename == "")
{
success = 0;
MessageBox.Show("Please select the estate!");
return;
}
try
{
if (txtBlockSize.Text != "")
{
blocksize = double.Parse(txtBlockSize.Text);
}
else
{
success = 0;
MessageBox.Show("Please select appropriate block size!!");
return;
}
}
catch
{
success = 0;
MessageBox.Show("Please select appropriate block size!!");
return;
}
//if (radioButton1.Checked)
//{
// if (dropSuburb.SelectedValue != null)
// {
// suburb = dropSuburb.SelectedValue.ToString();
// }
// else
// {
// suburb = "";
// success = 0;
// MessageBox.Show("Please select appropriate suburb!!");
// }
//}
//else
//{
// suburb = txtSuburb.Text.ToString();
//}
if (mode == InputFormMode.New)
{
action = "NEW";
}
else
{
action = "EDIT";
}
if (suburb != "")
{
//execute procedure to save data
//this.pictureBox1.Visible = true;
MetriconCommon.DatabaseManager.ExecuteSQLQuery("AdminAddEditHomeDisplay", new System.Data.SqlClient.SqlParameter[52]
{
new System.Data.SqlClient.SqlParameter("@HomeID", HomeID)
, new System.Data.SqlClient.SqlParameter("@HomePlan", txtHomePlan.Text)
, new System.Data.SqlClient.SqlParameter("@HomeFacade", txtHomeFacade.Text)
, new System.Data.SqlClient.SqlParameter("@StateID", stateID)
, new System.Data.SqlClient.SqlParameter("@BrandID", brandID)
, new System.Data.SqlClient.SqlParameter("@ProductID", txtProductID.Text)
, new System.Data.SqlClient.SqlParameter("@HouseArea", houseArea)
, new System.Data.SqlClient.SqlParameter("@HouseAreaSquares", houseAreaSquare)
, new System.Data.SqlClient.SqlParameter("@AlfrescoArea", alfrescoArea)
, new System.Data.SqlClient.SqlParameter("@AlfrescoAreaSquares", alfrescoAreaSquares)
, new System.Data.SqlClient.SqlParameter("@GarageArea", garageArea)
, new System.Data.SqlClient.SqlParameter("@GarageAreaSquares", garageAreaSquares)
, new System.Data.SqlClient.SqlParameter("@TotalArea", totalArea)
, new System.Data.SqlClient.SqlParameter("@TotalAreaSquares", totalAreaSquares)
, new System.Data.SqlClient.SqlParameter("@Min_Block_Width", minimumBlockWidth)
, new System.Data.SqlClient.SqlParameter("@HouseLength", houseLength)
, new System.Data.SqlClient.SqlParameter("@HouseWidth", houseWidth)
, new System.Data.SqlClient.SqlParameter("@GarageBays", garageBays)
, new System.Data.SqlClient.SqlParameter("@Bedrooms", bedroom)
, new System.Data.SqlClient.SqlParameter("@Bathrooms", bathroom)
, new System.Data.SqlClient.SqlParameter("@Stories", storey)
, new System.Data.SqlClient.SqlParameter("@DESC", txtDesc.Text)
, new System.Data.SqlClient.SqlParameter("@EDESC", txtEdesc.Text)
, new System.Data.SqlClient.SqlParameter("@CSTCTR", txtCstctr.Text)
, new System.Data.SqlClient.SqlParameter("@SUOFM", txtSuofm.Text)
, new System.Data.SqlClient.SqlParameter("@PUOFM", txtPuofm.Text)
, new System.Data.SqlClient.SqlParameter("@PRDCAT", txtPrdcat.Text)
, new System.Data.SqlClient.SqlParameter("@TAXCD", txtTaxcd.Text)
, new System.Data.SqlClient.SqlParameter("@PRDSOP", txtPrdsop.Text)
, new System.Data.SqlClient.SqlParameter("@USRDEF", txtUsrdef.Text)
, new System.Data.SqlClient.SqlParameter("@LDESC", txtLdesc.Text)
, new System.Data.SqlClient.SqlParameter("@BRAND", txtBrand.Text)
, new System.Data.SqlClient.SqlParameter("@SPECYEAR", txtSpecyear.Text)
, new System.Data.SqlClient.SqlParameter("@HOUSECODE", txtHousecode.Text)
, new System.Data.SqlClient.SqlParameter("@HOUSESIZE", txtHousesize.Text)
, new System.Data.SqlClient.SqlParameter("@HOUSEFACADE", txtHousefacade.Text)
, new System.Data.SqlClient.SqlParameter("@STOREY", txtStorey.Text)
, new System.Data.SqlClient.SqlParameter("@MARK", txtMark.Text)
, new System.Data.SqlClient.SqlParameter("@SortOrder", txtSortOrder.Text)
, new System.Data.SqlClient.SqlParameter("@CreatedBy", MetriconCommon.UserCode)
, new System.Data.SqlClient.SqlParameter("@Active", chkActive.Checked)
, new System.Data.SqlClient.SqlParameter("@draft", chkDraft.Checked)
, new System.Data.SqlClient.SqlParameter("@parentHomeID", parentHomeID)
, new System.Data.SqlClient.SqlParameter("@action", action)
, new System.Data.SqlClient.SqlParameter("@lotAddress", txtLotAddress.Text)
, new System.Data.SqlClient.SqlParameter("@suburb", suburb)
, new System.Data.SqlClient.SqlParameter("@postcode", postcode)
, new System.Data.SqlClient.SqlParameter("@blocksize", blocksize)
, new System.Data.SqlClient.SqlParameter("@originalParentHomeID", originalparentHomeID)
, new System.Data.SqlClient.SqlParameter("@originalDisplayHomeID", originaldisplayHomeID)
, new System.Data.SqlClient.SqlParameter("@estatename", estatename)
, new System.Data.SqlClient.SqlParameter("@displayclosedate", displayclosedate)
}
);
//get the id of the new house that was inserted
//DataSet dsTemp = MetriconCommon.DatabaseManager.ExecuteSQLQuery("select max(homeid) as homeid from home");
//this.txtHomeID.Text = dsTemp.Tables[0].Rows.Count == 1 ? dsTemp.Tables[0].Rows[0]["homeid"].ToString() : "";
if (action == "NEW")
{
DataSet dsTemp = MetriconCommon.DatabaseManager.ExecuteSQLQuery("select max(homeid) as homeid from home");
this.txtHomeID.Text = dsTemp.Tables[0].Rows.Count == 1 ? dsTemp.Tables[0].Rows[0]["homeid"].ToString() : "";
}
this.pictureBox1.Visible = false;
}
}
else
{
success = 0;
MessageBox.Show("Please select a facade!", "Missing Fields", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
else
{
success = 0;
MessageBox.Show("Please select a parent home!", "Missing Fields", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
private void dataGridView1_CellEndEdit(object sender, DataGridViewCellEventArgs e)
{
string enterdesc = "";
int active, active2;
decimal qty;
qty = 0;
bool so, si, changeqty, changeprice, addextradesc;
try
{
if (dataGridView1.Rows.Count != 0)
{
this.adminSearchHomeDisplayOptionTableAdapter.Connection.ConnectionString = MetriconCommon.getConnectionString();
DataRow modifiedRow = ((DataRowView)this.dataGridView1.Rows[e.RowIndex].DataBoundItem).Row;
DataSet dsHome = MetriconCommon.DatabaseManager.ExecuteSQLQuery("select active from homedisplayoption_Staging where productareagroupid=" + modifiedRow["productareagroupid"].ToString() + " and homeid=" + modifiedRow["homeid"].ToString() + " and homedisplayid=" + modifiedRow["homedisplayid"].ToString());
if (dsHome.Tables[0].Rows[0][0].ToString() == "False")
{
active = 0;
}
else
{
active = 1;
}
if (modifiedRow["active"].ToString() == "True")
{
active2 = 1;
}
else
{
active2 = 0;
}
//modifiedRow["EnterDesc"] = "Note: Stained finish to KDHW components on this stair are non-standard and cannot be offered." + DateTime.Now.ToLongTimeString();
if (modifiedRow["EnterDesc"] != null && modifiedRow["EnterDesc"].ToString() != "")
{
enterdesc = modifiedRow["EnterDesc"].ToString();
}
if (modifiedRow["quantity"] != null && modifiedRow["quantity"].ToString() != "")
{
try
{
qty = decimal.Parse(modifiedRow["quantity"].ToString());
}
catch (Exception ex)
{
MessageBox.Show("Quantity should be a number.");
return;
}
}
if (modifiedRow["standardoption"] != null && modifiedRow["standardoption"].ToString().ToUpper() == "TRUE")
{
so = true;
}
else
{
so = false;
}
if (modifiedRow["standardinclusion"] != null && modifiedRow["standardinclusion"].ToString().ToUpper() == "TRUE")
{
si = true;
}
else
{
si = false;
}
if (modifiedRow["changeqty"] != null && modifiedRow["changeqty"].ToString().ToUpper() == "TRUE")
{
changeqty = true;
}
else
{
changeqty = false;
}
if (modifiedRow["addextradesc"] != null && modifiedRow["addextradesc"].ToString().ToUpper() == "TRUE")
{
addextradesc = true;
}
else
{
addextradesc = false;
}
if (modifiedRow["changeprice"] != null && modifiedRow["changeprice"].ToString().ToUpper() == "TRUE")
{
changeprice = true;
}
else
{
changeprice = false;
}
if (active != active2)
{
var confirmResult = MessageBox.Show("Are you sure to delete this item ?",
"Confirm Delete!!",
MessageBoxButtons.YesNo);
if (confirmResult == DialogResult.Yes)
{
dsHome = MetriconCommon.DatabaseManager.ExecuteSQLQuery("[AdminEditHDO]", new System.Data.SqlClient.SqlParameter[12]
{
new System.Data.SqlClient.SqlParameter("@StandardOption", so),
new System.Data.SqlClient.SqlParameter("@GeneralOption", false),
new System.Data.SqlClient.SqlParameter("@StandardInclusion", si),
new System.Data.SqlClient.SqlParameter("@Quantity", qty),
new System.Data.SqlClient.SqlParameter("@ModifiedDate", DateTime.Now),
new System.Data.SqlClient.SqlParameter("@ModifiedBy", MetriconCommon.UserCode),
new System.Data.SqlClient.SqlParameter("@Active", active2),
new System.Data.SqlClient.SqlParameter("@ChangeQty", changeqty),
new System.Data.SqlClient.SqlParameter("@AddExtraDesc", addextradesc),
new System.Data.SqlClient.SqlParameter("@EnterDesc", enterdesc),
new System.Data.SqlClient.SqlParameter("@ChangePrice", changeprice),
new System.Data.SqlClient.SqlParameter("@OptionID", Int32.Parse(modifiedRow["optionID"].ToString())),
}
);
dataGridView1.Rows.RemoveAt(e.RowIndex);
}
else
{
modifiedRow["active"] = "True";
return;
}
}
else
{
dsHome = MetriconCommon.DatabaseManager.ExecuteSQLQuery("[AdminEditHDO]", new System.Data.SqlClient.SqlParameter[12]
{
new System.Data.SqlClient.SqlParameter("@StandardOption", so),
new System.Data.SqlClient.SqlParameter("@GeneralOption", false),
new System.Data.SqlClient.SqlParameter("@StandardInclusion", si),
new System.Data.SqlClient.SqlParameter("@Quantity", qty),
new System.Data.SqlClient.SqlParameter("@ModifiedDate", DateTime.Now),
new System.Data.SqlClient.SqlParameter("@ModifiedBy", MetriconCommon.UserCode),
new System.Data.SqlClient.SqlParameter("@Active", active2),
new System.Data.SqlClient.SqlParameter("@ChangeQty", changeqty),
new System.Data.SqlClient.SqlParameter("@AddExtraDesc", addextradesc),
new System.Data.SqlClient.SqlParameter("@EnterDesc", enterdesc),
new System.Data.SqlClient.SqlParameter("@ChangePrice", changeprice),
new System.Data.SqlClient.SqlParameter("@OptionID", Int32.Parse(modifiedRow["optionID"].ToString())),
}
);
}
}
}
catch (IndexOutOfRangeException ex1)
{
//MessageBox.Show(ex1.Message.ToString());
}
catch (Exception ex2)
{
MessageBox.Show(ex2.Message.ToString());
}
}
private void verticalFormatToolStripMenuItem_Click(object sender, EventArgs e)
{
MetriconCommon.GenerateExcel("Price", "VERTICAL");
}
private void downloadFormatSheetToolStripMenuItem1_Click(object sender, EventArgs e)
{
MetriconCommon.GenerateExcel("Quantity", "");
}
private void horizToolStripMenuItem_Click(object sender, EventArgs e)
{
MetriconCommon.GenerateExcel("Price", "HORIZONTAL");
}
private void downLoadFormatSheetToolStripMenuItem_Click(object sender, EventArgs e)
{
MetriconCommon.GenerateExcel("Product", "");
}
private void savePromotion()
{
int promID, promTypeID, active, published, stories, sortorder, brandID, goAhead;;
double promCost, promBudget;
string tempdate, action;
tempdate = "";
goAhead = 1;
if (txtBaseProductID.Text.ToString() != "")
{
promID = MetriconCommon.initIntVariables(txtPromID.Text.ToString());
promTypeID = MetriconCommon.initIntVariables(dropPromType.SelectedValue.ToString());
brandID = MetriconCommon.initIntVariables(dropBrand.SelectedValue.ToString());
stories = MetriconCommon.initIntVariables(txtStories.Text.ToString());
sortorder = MetriconCommon.initIntVariables(txtSortOrder.Text.ToString());
if (this.chkActive.Checked)
{
active = 1;
}
else
{
active = 0;
}
if (this.chkPublished.Checked)
{
goAhead = checkPAG();
published = 1;
if (txtEffectiveDate.Text == "")
{
MessageBox.Show("Please enter an effective date!");
}
else
{
try
{
DateTime tempdate3 = DateTime.Parse(txtEffectiveDate.Text.ToString());
tempdate = tempdate3.ToString("dd/MMM/yyyy");
}
catch (FormatException ex)
{
MessageBox.Show("Please enter a valid effective date! " + ex.ToString());
}
}
}
else
{
published = 0;
}
if (goAhead == 1)
{
promCost = MetriconCommon.initDoubleVariables(txtPromCost.Text.ToString());
promBudget = MetriconCommon.initDoubleVariables(txtPromBudget.Text.ToString());
if (txtPromID.Text == "")
{
action = "NEW";
}
else
{
action = "EDIT";
}
// insert data to tabel
MetriconCommon.DatabaseManager.ExecuteSQLQuery("AdminAddEditPromotion", new System.Data.SqlClient.SqlParameter[15] {
new System.Data.SqlClient.SqlParameter("@promID", promID)
, new System.Data.SqlClient.SqlParameter("@promTypeID", promTypeID)
, new System.Data.SqlClient.SqlParameter("@promname", txtPromName.Text)
, new System.Data.SqlClient.SqlParameter("@baseProductID", txtBaseProductID.Text)
, new System.Data.SqlClient.SqlParameter("@budgetProductID", txtBudgetProductID.Text)
, new System.Data.SqlClient.SqlParameter("@promCost", promCost)
, new System.Data.SqlClient.SqlParameter("@promBudget", promBudget)
, new System.Data.SqlClient.SqlParameter("@published", published)
, new System.Data.SqlClient.SqlParameter("@sortorder", sortorder)
, new System.Data.SqlClient.SqlParameter("@brandID", brandID)
, new System.Data.SqlClient.SqlParameter("@stories", stories)
, new System.Data.SqlClient.SqlParameter("@effectiveDate", tempdate)
, new System.Data.SqlClient.SqlParameter("@active", active)
, new System.Data.SqlClient.SqlParameter("@CreatedBy", MetriconCommon.UserCode)
, new System.Data.SqlClient.SqlParameter("@action", action)
}
);
// get new promotion ID and show on screen
if (action == "NEW")
{
DataSet dsTemp = MetriconCommon.DatabaseManager.ExecuteSQLQuery("select max(promotionID) as promID from promotion");
this.txtPromID.Text = dsTemp.Tables[0].Rows.Count == 1 ? dsTemp.Tables[0].Rows[0]["promID"].ToString() : "";
this.btnAddPAG.Enabled = true;
}
MessageBox.Show("Data saved successfully!");
}
else
{
MessageBox.Show("No PAG in current promotion! Please add PAG to this promotion and publish again!");
}
}
else
{
MessageBox.Show("Please enter a base product ID!");
}
}
private void textBoxTargetMargin_Leave(object sender, EventArgs e)
{
MetriconCommon.ToDouble(ref textBoxTargetMargin);
}
private void txtQuantity_Enter(object sender, EventArgs e)
{
MetriconCommon.ToDouble(ref txtQuantity);
}
private void dataGridView1_CellEndEdit(object sender, DataGridViewCellEventArgs e)
{
int active, active2, qty;
bool so, si, changeprice, changeqty, addextradesc;
qty = 0;
try
{
if (dataGridView1.Rows.Count != 0)
{
this.adminSearchHomeDisplayOptionTableAdapter.Connection.ConnectionString = MetriconCommon.getConnectionString();
DataRow modifiedRow = ((DataRowView)this.dataGridView1.Rows[e.RowIndex].DataBoundItem).Row;
DataSet dsHome = MetriconCommon.DatabaseManager.ExecuteSQLQuery("select active from homedisplayoption_Staging where productareagroupid=" + modifiedRow["productareagroupid"].ToString() + " and homeid=" + modifiedRow["homeid"].ToString());
if (dsHome.Tables[0].Rows[0][0].ToString() == "False")
{
active = 0;
}
else
{
active = 1;
}
if (modifiedRow["active"].ToString() == "True")
{
active2 = 1;
}
else
{
active2 = 0;
}
//modifiedRow["EnterDesc"] = "Note: Stained finish to KDHW components on this stair are non-standard and cannot be offered." + DateTime.Now.ToLongTimeString();
if (modifiedRow["standardoption"] != null && modifiedRow["standardoption"].ToString().ToUpper() == "TRUE")
{
so = true;
}
else
{
so = false;
}
if (modifiedRow["standardinclusion"] != null && modifiedRow["standardinclusion"].ToString().ToUpper() == "TRUE")
{
si = true;
}
else
{
si = false;
}
if (modifiedRow["changeqty"] != null && modifiedRow["changeqty"].ToString().ToUpper() == "TRUE")
{
changeqty = true;
}
else
{
changeqty = false;
}
if (modifiedRow["addextradesc"] != null && modifiedRow["addextradesc"].ToString().ToUpper() == "TRUE")
{
addextradesc = true;
}
else
{
addextradesc = false;
}
if (modifiedRow["changeprice"] != null && modifiedRow["changeprice"].ToString().ToUpper() == "TRUE")
{
changeprice = true;
}
else
{
changeprice = false;
}
if (active != active2)
{
dsHome = MetriconCommon.DatabaseManager.ExecuteSQLQuery("[AdminEditHDO]", new System.Data.SqlClient.SqlParameter[12]
{
new System.Data.SqlClient.SqlParameter("@StandardOption", so),
new System.Data.SqlClient.SqlParameter("@GeneralOption", false),
new System.Data.SqlClient.SqlParameter("@StandardInclusion", si),
new System.Data.SqlClient.SqlParameter("@Quantity", qty),
new System.Data.SqlClient.SqlParameter("@ModifiedDate", "01/01/06"),
new System.Data.SqlClient.SqlParameter("@ModifiedBy", MetriconCommon.UserCode),
new System.Data.SqlClient.SqlParameter("@Active", active2),
new System.Data.SqlClient.SqlParameter("@ChangeQty", changeqty),
new System.Data.SqlClient.SqlParameter("@AddExtraDesc", addextradesc),
new System.Data.SqlClient.SqlParameter("@EnterDesc", "none"),
new System.Data.SqlClient.SqlParameter("@ChangePrice", changeprice),
new System.Data.SqlClient.SqlParameter("@OptionID", Int32.Parse(modifiedRow["optionID"].ToString())),
}
);
//modifiedRow["ModifiedBy"] = MetriconCommon.UserCode;
//modifiedRow["ModifiedDate"] = DateTime.Now.ToString();
//this.adminSearchHomeDisplayOptionTableAdapter.Update(modifiedRow);
}
}
}
catch (IndexOutOfRangeException ex1)
{
//MessageBox.Show(ex1.Message.ToString());
}
catch (Exception ex2)
{
MessageBox.Show(ex2.Message.ToString());
}
}
private void frmDisplayHomeDisplayOption_Load(object sender, EventArgs e)
{
this.adminSearchHomeDisplayOptionTableAdapter.Connection.ConnectionString = MetriconCommon.getConnectionString();
btnSearchDisHomeID_Click(sender, e);
loadArea();
loadGroup();
if (txtDisHomeID.Text.ToString() != "")
{
loadPAGList();
loadPAGList2();
LoadDisplayHomeDetails();
}
this.listView2.ItemChecked += new System.Windows.Forms.ItemCheckedEventHandler(this.listView2_ItemChecked);
// classCustomizeScreenLookAndFeel.customizeMyScreen(this);
}