private void loadSalesControl(DateTime from, DateTime to)
{
lvSalesControl.Items.Clear();
lvSalesControl.SuspendLayout();
List <clsSales> list = new List <clsSales>();
clsSales salesClass = new clsSales();
list = salesClass.getSales(from, to);
foreach (clsSales oSales in list)
{
ListViewItem oItem = new ListViewItem();
oItem.Text = "[" + oSales.DateOfPurchase.ToString("MMM-dd-yyyy") + "] " + oSales.Code;
oItem.SubItems.Add(oSales.CustFullName);
oItem.ImageKey = "folder";
oItem.Tag = oSales;
lvSalesControl.Items.Add(oItem);
}
lvSalesControl.ResumeLayout();
}
private void loadSalesData(clsSales oSales)
{
lvSalesData.Items.Clear();
lvSalesData.SuspendLayout();
List <clsSalesData> list = new List <clsSalesData>();
clsSalesData salesDataClass = new clsSalesData();
list = salesDataClass.getSalesData(oSales);
foreach (clsSalesData clsSalesData in list)
{
ListViewItem oItem = new ListViewItem();
oItem.Text = clsSalesData.Inventory.TrackingCode;
oItem.SubItems.Add(clsSalesData.Inventory.Car.Name);
oItem.SubItems.Add(clsSalesData.Inventory.Details);
oItem.SubItems.Add(clsSalesData.Inventory.SoldDate.ToString("MMM dd, yyyy"));
oItem.ImageKey = "folder";
oItem.Tag = clsSalesData;
lvSalesData.Items.Add(oItem);
}
lvSalesData.ResumeLayout();
}
protected void BtnUpdate_Click(object sender, EventArgs e)
{
BLayer.Sales obj = InitalizeObject();
clsSales Dal = new clsSales();
Dal.UpdateSales(obj);
Dal.UpdateProductDetail(obj);
LoadGrid();
ClearAll();
}
protected void BtnVoid_Click(object sender, EventArgs e)
{
clsSales Dal = new clsSales();
ViewState["SalesId"] = txtSalesId.Text;
Dal.VoidSales(txtSalesId.Text);
LoadGrid();
GridView1.DataSource = null;
GridView1.DataBind();
}
protected void BtnNew_Click(object sender, EventArgs e)
{
ClearAll();
GridView1.DataSource = null;
clsSales Dal = new clsSales();
DataSet obj = new DataSet();
obj = Dal.GenerateNewSalesId();
txtSalesId.Text = (obj.Tables[0].Rows[0][0]).ToString();
}
protected void BtnSave_Click(object sender, EventArgs e)
{
clsSales Dal = new clsSales();
BLayer.Sales obj = InitalizeObject();
Dal.AddNewSales(obj);
obj.Qty = -(obj.Qty);
Dal.AddNewProductDetail(obj);
LoadGrid();
clearAfterSave();
}
public static bool addSale(clsSales newSalesData)
{
DataRow myRow = tabSales.NewRow();
myRow["refAgentid"] = newSalesData.AgentId;
myRow["refHouseId"] = newSalesData.HouseRefId;
myRow["refBuyerId"] = newSalesData.BuyerID;
myRow["refSellerId"] = newSalesData.SellerID;
myRow["refSalesDate"] = newSalesData.SellDate;
tabSales.Rows.Add(myRow);
syncSalesDB();
return(clsHouseData.removeHouse(newSalesData.HouseRefId));
}
private void btnSell_Click(object sender, EventArgs e)
{
//currId += 1;
string contractId = "ctr" + currId.ToString();
string agentId = comboBoxAgentName.SelectedItem.ToString();
string houseId = comboBoxHouse.SelectedItem.ToString();
string buyersId = comboBoxBuyer.SelectedItem.ToString();
string sellersId = comboBoxSeller.SelectedItem.ToString();
DateTime dealDate = dateTimePicker1.Value;
clsSales sale = new clsSales(contractId, agentId, houseId, buyersId, sellersId, dealDate);
clsSalesData.addSale(sale);
MessageBox.Show("HOUSEEE SOLDDD!!!");
reloadForm();
}
private void FindSaleBySalesId(string SalesId)
{
clsSales Dal = new clsSales();
DataSet Sales = Dal.LoadSales(SalesId);
if (Sales.Tables[0].Rows.Count != 0)
{
GridView1.DataSource = Sales.Tables[0];
GridView1.DataBind();
decimal total = Sales.Tables[0].AsEnumerable().Sum(row => row.Field <decimal>("Amount"));
GridView1.FooterRow.Cells[5].Text = "Total";
GridView1.FooterRow.Cells[5].HorizontalAlign = HorizontalAlign.Right;
GridView1.FooterRow.Cells[6].Text = total.ToString("N2");
}
}
private void btnSave_Click(object sender, EventArgs e)
{
clsAdmin admin = new clsAdmin();
clsSales sales = new clsSales();
sales.RefAgent = Convert.ToInt32(cboAgent.SelectedValue);
sales.RefClient = Convert.ToInt32(cboClient.SelectedValue);
sales.RefHouse = Convert.ToInt32(cboHouse.SelectedValue);
sales.Description = txtDescription.Text;
sales.SalesDate = DateTime.Parse(DateSales.Text);
if (Addmode)
{
if (admin.Add_Sales(sales))
{
MessageBox.Show("New Sales Record is successfully added", "New Sales Added");
}
else
{
MessageBox.Show("The Sales Record is not added.", "Try Again");
}
admin.Refresh_Database();
}
else
{
sales.RefSales = (int)gridAll.Rows[gridAll.CurrentRow.Index].Cells[0].Value;
if (admin.Edit_Sales(sales))
{
MessageBox.Show("New Sales Record ID " + sales.RefSales + " is successfully modified", "Sales Modified");
}
else
{
MessageBox.Show("The Sales Record " + sales.RefSales + " is not modified.", "Try Again");
}
}
if (permission != 2)
{
gridAll.DataSource = admin.All_Sales();
}
else
{
gridAll.DataSource = admin.Search_Sales_Belong_To_RefAgent(RefAgent);
}
ButtonControl(true, true, false, false, true, false);
}
private bool saveSales(string code, string custfullname, string custaddress, string contactno, DateTime dateofpurchase)
{
clsSales oSales = new clsSales();
oSales.Code = code;
oSales.CustFullName = custfullname;
oSales.CustAddress = custaddress;
oSales.CustContactNo = contactno;
oSales.DateOfPurchase = dateofpurchase;
if (oSales.save())
{
return(true);
}
return(false);
}
static public List <clsSales> All_Sales()
{
List <clsSales> temp_list = new List <clsSales>();
clsSales sales;
foreach (DataRow i in mySet.Tables["Sales"].Rows)
{
sales = new clsSales();
sales.RefSales = (int)i["RefSales"];
sales.RefHouse = (int)i["RefHouse"];
sales.RefClient = (int)i["RefClient"];
sales.RefAgent = (int)i["RefAgent"];
sales.Description = i["Description"].ToString();
sales.SalesDate = DateTime.Parse(i["SalesDate"].ToString());
temp_list.Add(sales);
}
return(temp_list);
}
static public clsSales Search_Sales_by_RefSales(int refsales)
{
clsSales temp = new clsSales();
foreach (DataRow i in mySet.Tables["Sales"].Rows)
{
if (i["RefSales"].ToString() == refsales.ToString())
{
temp.RefSales = (int)i["RefSales"];
temp.RefHouse = (int)i["RefHouse"];
temp.RefClient = (int)i["RefClient"];
temp.RefAgent = (int)i["RefAgent"];
temp.Description = i["Description"].ToString();
temp.SalesDate = DateTime.Parse(i["SalesDate"].ToString());
break;
}
}
return(temp);
}
private void lvSalesControl_KeyDown(object sender, KeyEventArgs e)
{
if (lvSalesControl.SelectedItems.Count != 1)
{
return;
}
clsSales oSales = new clsSales();
if (e.KeyCode == Keys.Delete)
{
if (General.askQuestion("Delete Record", "Are you sure do you want to delete this record?", "Permanent Deletion") == DialogResult.Yes)
{
if (oSales.delete((clsSales)lvSalesControl.SelectedItems[0].Tag))
{
General.showMessageBox("Success", "Succesfully deleted the record", MsgTypes.success);
lvSalesControl.SelectedItems[0].Remove();
}
}
}
}
static public bool Edit_Sales(clsSales sales)
{
bool job_done = false;
foreach (DataRow myRow in mySet.Tables["Sales"].Rows)
{
if ((int)myRow["RefSales"] == sales.RefSales)
{
myRow["RefHouse"] = sales.RefHouse;
myRow["RefClient"] = sales.RefClient;
myRow["RefAgent"] = sales.RefAgent;
myRow["Description"] = sales.Description;
myRow["SalesDate"] = sales.SalesDate;
OleDbCommandBuilder myBuild = new OleDbCommandBuilder(adpSales);
adpSales.Update(mySet.Tables["Sales"]);
job_done = true;
break;
}
}
return(job_done);
}
static public List <clsSales> Search_Sales_Belong_To_RefAgent(int refagent)
{
List <clsSales> temp_list = new List <clsSales>();
clsSales temp;
foreach (DataRow i in mySet.Tables["Sales"].Rows)
{
if (i["RefAgent"].ToString() == refagent.ToString())
{
temp = new clsSales();
temp.RefSales = (int)i["RefSales"];
temp.RefAgent = (int)i["RefAgent"];
temp.RefClient = (int)i["RefClient"];
temp.RefHouse = (int)i["RefHouse"];
temp.SalesDate = DateTime.Parse(i["SalesDate"].ToString());
temp.Description = i["Description"].ToString();
temp_list.Add(temp);
}
}
return(temp_list);
}
private void tsmiCreateSalesData_Click(object sender, System.EventArgs e)
{
if (lvSalesControl.SelectedItems.Count != 1)
{
General.showMessageBox("Warning", "Please select first a Receipt", MsgTypes.warning); return;
}
// @03271901 : root of the problem can't pass the sales data
clsSales currentSalesControl = (clsSales)this.lvSalesControl.SelectedItems[0].Tag;
frmSalesData frm = new frmSalesData();
frm.idCurrentSales = currentSalesControl.ID;
frm.SalesControlsoldDate = currentSalesControl.DateOfPurchase;
DialogResult res = frm.ShowDialog();
if (res == DialogResult.OK)
{
lvSalesData.Items.Clear(); General.showMessageBox("Succes", "Sucesfully added new record", MsgTypes.success);
}
}
private void gridAll_CellClick(object sender, DataGridViewCellEventArgs e)
{
if (!txtDescription.Enabled)
{
try
{
ButtonControl(true, true, false, false, true, false);
string salesid = gridAll.Rows[e.RowIndex].Cells[0].Value.ToString();
clsAdmin admin = new clsAdmin();
clsSales sales = new clsSales();
sales = admin.Search_Sales_by_RefSales(Convert.ToInt32(salesid));
cboAgent.SelectedValue = sales.RefAgent;
cboClient.SelectedValue = sales.RefClient;
cboHouse.SelectedValue = sales.RefHouse;
txtDescription.Text = sales.Description.ToString();
DateSales.Text = sales.SalesDate.ToString();
}
catch
{
// not in the grid content
}
}
}
static public bool Add_Sales(clsSales sales)
{
bool job_done = false;
try
{
DataRow myRow = mySet.Tables["Sales"].NewRow();
myRow["RefSales"] = sales.RefSales;
myRow["RefHouse"] = sales.RefHouse;
myRow["RefClient"] = sales.RefClient;
myRow["RefAgent"] = sales.RefAgent;
myRow["Description"] = sales.Description;
myRow["SalesDate"] = sales.SalesDate;
mySet.Tables["Sales"].Rows.Add(myRow);
OleDbCommandBuilder myBuild = new OleDbCommandBuilder(adpSales);
adpSales.Update(mySet.Tables["Sales"]);
job_done = true;
}
catch
{
job_done = false;
}
return(job_done);
}
public static void addSale(clsSales newSalesData)
{
salesData.Add(newSalesData.SalesId, newSalesData);
}
