private void button2_Click(object sender, EventArgs e)
{
decimal CalculatedAmount = Convert.ToDecimal(CustomerOpeningBalance_txt.Text) - PreviousBalance + CurrentAmount;
string CustomerModifyResult = DatabaseCalls.ModifyCustomer(CustomersDataGridView.CurrentRow.Cells["ID"].Value.ToString(), CustomerName_txt.Text, CustomerAddress_txt.Text, CustomerPhone_txt.Text, CustomerEmail_txt.Text, Convert.ToInt32(CustomerOpeningBalance_txt.Text), CalculatedAmount);
DataSet CusomerBillDataSet = DatabaseCalls.GetBillsbyCustomer(CustomersDataGridView.CurrentRow.Cells["ID"].Value.ToString());
foreach (DataRow Remarks in CusomerBillDataSet.Tables[0].Rows)
{
if (Remarks.ItemArray[4].ToString().Contains("Opening Balance") == true)
{
DatabaseCalls.ModifyBillAmmount(Convert.ToInt32(Remarks.ItemArray[0].ToString()), Convert.ToDecimal(CustomerOpeningBalance_txt.Text));
break;
}
}
if (CustomerModifyResult.StartsWith("Customer modified = ") != true)
{
Variables.NotificationStatus = true;
}
Variables.NotificationMessageTitle = this.Name;
Variables.NotificationMessageText = CustomerModifyResult;
DataSet Result1 = new DataSet();
Result1 = DatabaseCalls.GetCustomers();
CustomersDataGridView.DataSource = Result1.Tables[0];
CustomersDataGridView.Columns[0].Visible = false;
}
private void AddConsignmentAdvanced_Shown(object sender, EventArgs e)
{
//TO GET ITEM LIST
try
{
ItemDataSet = DatabaseCalls.GetItems();
ItemCode_txt.Items.Clear();
foreach (DataRow asdf in ItemDataSet.Tables[0].Rows)
{
ItemCode_txt.Items.Add(asdf["CODE"]);
}
}
catch (Exception ex)
{
Variables.NotificationStatus = true;
Variables.NotificationMessageTitle = this.Name;
Variables.NotificationMessageText = ex.Message;
}
try
{
RandomAlgos.RestoreOldConsignmentDataInGrid(ConsignmentDataGridView, ConsignmentNumber_txt, textBox9, textBox8, textBox7);
}
catch (Exception ex)
{
Variables.NotificationStatus = true;
Variables.NotificationMessageTitle = this.Name;
Variables.NotificationMessageText = ex.Message;
}
}
public void RefreshCustomerData()
{
//get customers
try
{
CustomerDataSet = DatabaseCalls.GetCustomers();
CustomerNameDataGridView.DataSource = CustomerDataSet.Tables[0];
CustomerNameDataGridView.Columns["ID"].Visible = false;
CustomerNameDataGridView.Columns["OPENING_BALANCE"].Visible = false;
CustomerNameDataGridView.Columns["ADDRESS"].Visible = false;
CustomerNameDataGridView.Columns["EMAIL"].Visible = false;
CustomerNameDataGridView.Columns["PHONE"].Visible = false;
CustomerNameDataGridView.Columns["BALANCE_LIMIT"].Visible = false;
//foreach (DataRow GridViewColumn in CustomerDataSet.Tables[0].Rows)
//{
// CustomerName_txt.Items.Add(GridViewColumn.ItemArray[1]);
//}
}
catch (Exception ex)
{
Variables.NotificationStatus = true;
Variables.NotificationMessageTitle = this.Name;
Variables.NotificationMessageText = ex.Message;
}
}
private void AddCustomer_Shown(object sender, EventArgs e)
{
try
{
CustomerDataSet = DatabaseCalls.GetCustomers();
CustomersDataGridView.DataSource = CustomerDataSet.Tables[0];
CustomersDataGridView.Columns["ID"].Visible = false;
foreach (DataRow GridViewColumn in CustomerDataSet.Tables[0].Rows)
{
CustomerNameSearch_txt.Items.Add(GridViewColumn.ItemArray[1]);
}
CustomersDataGridView.Columns["NAME"].DisplayIndex = 0;
CustomersDataGridView.Columns["ADDRESS"].DisplayIndex = 1;
CustomersDataGridView.Columns["PHONE"].DisplayIndex = 2;
CustomersDataGridView.Columns["EMAIL"].DisplayIndex = 3;
CustomersDataGridView.Columns["OPENING_BALANCE"].DisplayIndex = 4;
CustomersDataGridView.Columns["AMOUNT"].Visible = false;
CustomersDataGridView.Columns["BALANCE_LIMIT"].Visible = false;
}
catch (Exception ex)
{
Variables.NotificationStatus = true;
Variables.NotificationMessageTitle = this.Name;
Variables.NotificationMessageText = ex.Message;
}
FormLoading = false;
CustomerName_txt.Focus();
}
private void button1_Click(object sender, EventArgs e)
{
string Result = "";
try
{
Result = DatabaseCalls.AddConsignment(ConsignmentNumber_txt.Text, Convert.ToDateTime(ConsignmentDate_txt.Text));
if (Result.StartsWith("Consignment Added with ID") != true)
{
Variables.NotificationStatus = true;
Variables.NotificationMessageTitle = this.Name;
Variables.NotificationMessageText = Result;
return;
}
DataSet Result1 = new DataSet();
Result1 = DatabaseCalls.GetConsignments();
ItemsDataGridView.DataSource = Result1.Tables[0];
ItemsDataGridView.Columns[0].Visible = false;
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
Variables.NotificationStatus = true;
Variables.NotificationMessageTitle = this.Name;
Variables.NotificationMessageText = Result;
}
private void button3_Click(object sender, EventArgs e)
{
if (BillNumberSearch_txt.Text != "")
{
DataSet BillDataSet = new DataSet();
BillDataSet = DatabaseCalls.GetBill(BillNumberSearch_txt.Text);
if (BillDataSet.Tables[0].Rows.Count == 0)
{
Variables.NotificationStatus = true;
Variables.NotificationMessageTitle = this.Name;
Variables.NotificationMessageText = "No Bill Found";
return;
}
DataSet CustomerDataSet = new DataSet();
CustomerDataSet = DatabaseCalls.GetCustomer(Convert.ToInt32(BillDataSet.Tables[0].Rows[0]["CUSTOMER_ID"].ToString()));
if (CustomerDataSet.Tables[0].Rows.Count == 0)
{
Variables.NotificationStatus = true;
Variables.NotificationMessageTitle = this.Name;
Variables.NotificationMessageText = "No Customer Found";
return;
}
decimal CustomerNewBalance = Convert.ToDecimal(CustomerDataSet.Tables[0].Rows[0]["AMOUNT"]);
CustomerNewBalance -= Convert.ToDecimal(BillDataSet.Tables[0].Rows[0]["AMOUNT"]);
DatabaseCalls.ModifyCustomer(Convert.ToInt32(BillDataSet.Tables[0].Rows[0]["Customer_ID"]), CustomerNewBalance);
DatabaseCalls.DeleteBillDetails(BillNumberSearch_txt.Text);
DatabaseCalls.DeleteBill(BillNumberSearch_txt.Text);
BillNumberSearch_txt.Text = "";
DeleteBill_Load(sender, e);
}
BillNumberSearch_txt.Text = "";
}
private void button1_Click(object sender, EventArgs e)
{
string Result = "";
try
{
Result = DatabaseCalls.AddItem(ItemNewName_txt.Text, ItemModel_txt.Text, Convert.ToInt32(ItemQuantity_txt.Text), Convert.ToDecimal(ItemPrice_txt.Text), ItemPictureBox.ImageLocation, ItemCategory_txt.Text);
if (Result.StartsWith("Item Added with") != true)
{
Variables.NotificationStatus = true;
Variables.NotificationMessageTitle = this.Name;
Variables.NotificationMessageText = Result;
return;
}
ItemDataSet = DatabaseCalls.GetItems();
ItemCode_txt.Items.Clear();
foreach (DataRow asdf in ItemDataSet.Tables[0].Rows)
{
ItemCode_txt.Items.Add(asdf["CODE"]);
}
ItemCode_txt.Focus();
Variables.NotificationStatus = true;
Variables.NotificationMessageTitle = this.Name;
Variables.NotificationMessageText = Result;
}
catch (Exception ex)
{
Variables.NotificationStatus = true;
Variables.NotificationMessageTitle = this.Name;
Variables.NotificationMessageText = ex.Message;
}
}
private void button2_Click(object sender, EventArgs e)
{
if (ItemPictureBox.ImageLocation == null || ItemPictureBox.ImageLocation == "")
{
if (File.Exists("ItemImages\\" + ItemNewName_txt.Text + ".JPG") == true)
{
ItemPictureBox.ImageLocation = Directory.GetCurrentDirectory() + "\\ItemImages\\" + ItemNewName_txt.Text + ".JPG";
}
else if (File.Exists("ItemImages\\" + ItemNewName_txt.Text + ".JPEG") == true)
{
ItemPictureBox.ImageLocation = Directory.GetCurrentDirectory() + "\\ItemImages\\" + ItemNewName_txt.Text + ".JPEG";
}
}
string Result = DatabaseCalls.ModifyItems(ItemsDataGridView.Rows[currentRow].Cells["ID"].Value.ToString(), ItemNewName_txt.Text, ItemModel_txt.Text, ItemQuantity_txt.Text, ItemPrice_txt.Text, ItemPictureBox, ItemCategory_txt.Text, Convert.ToInt32(TQUANTITY_txt.Text));
if (Result.StartsWith("Item modified") != true)
{
Variables.NotificationStatus = true;
Variables.NotificationMessageTitle = this.Name;
Variables.NotificationMessageText = Result;
return;
}
DataSet Result1 = new DataSet();
Result1 = DatabaseCalls.GetItems();
ItemsDataGridView.DataSource = Result1.Tables[0];
ItemsDataGridView.Columns[0].Visible = false;
}
private void ItemHistory_Load(object sender, EventArgs e)
{
DataSet ItemHistory = new DataSet();
ItemHistory = DatabaseCalls.GetItemHistory(ItemCode1);
dataGridView1.DataSource = ItemHistory.Tables[0];
//dataGridView1.DataSource = ItemHistory;
}
private void button2_Click(object sender, EventArgs e)
{
String Result = DatabaseCalls.AddCustomer(textBox1.Text, "None", "None", "None", 0, 0);
CustomerName_txt.Items.Add(textBox1.Text);
CustomerName_txt.Text = textBox1.Text;
button1_Click(sender, e);
}
private void AddConsignmentDetail_Load(object sender, EventArgs e)
{
//TO GET ITEM LIST
try
{
DataSet Result1 = new DataSet();
Result1 = DatabaseCalls.GetItems();
ItemSearchName_txt.Items.Clear();
ItemName_txt.Items.Clear();
foreach (DataRow asdf in Result1.Tables[0].Rows)
{
ItemSearchName_txt.Items.Add(asdf.ItemArray[1]);
ItemName_txt.Items.Add(asdf["CODE"]);
}
}
catch (Exception ex)
{
Variables.NotificationStatus = true;
Variables.NotificationMessageTitle = this.Name;
Variables.NotificationMessageText = ex.Message;
}
//TO GET Consingment ID LIST
try
{
DataSet Result1 = new DataSet();
Result1 = DatabaseCalls.GetConsignments();
foreach (DataRow asdf in Result1.Tables[0].Rows)
{
ShipID_txt.Items.Add(asdf.ItemArray[0]);
}
}
catch (Exception ex)
{
Variables.NotificationStatus = true;
Variables.NotificationMessageTitle = this.Name;
Variables.NotificationMessageText = ex.Message;
}
//TO GET Consingment Detail LIST
try
{
DataSet Result1 = new DataSet();
Result1 = DatabaseCalls.GetConsignmentDetails();
ItemsDataGridView.DataSource = Result1.Tables[0];
ItemsDataGridView.Columns[0].Visible = false;
}
catch (Exception ex)
{
Variables.NotificationStatus = true;
Variables.NotificationMessageTitle = this.Name;
Variables.NotificationMessageText = ex.Message;
}
}
private void button6_Click(object sender, EventArgs e)
{
ItemDataSet = DatabaseCalls.GetItems();
ItemCode_txt.Items.Clear();
foreach (DataRow asdf in ItemDataSet.Tables[0].Rows)
{
ItemCode_txt.Items.Add(asdf["CODE"]);
}
}
public JsonResult ReadIntraData(string tickers)
{
var databaseCalls = new DatabaseCalls();
var iDay_Root = ExternalApiCalls.CallIntradayData(tickers);
var iDay_Id = databaseCalls.PostIntraDayPagination(iDay_Root.pagination);
databaseCalls.PostIntraDayData(iDay_Root.data, iDay_Id);
return(Json(new { success = true }, JsonRequestBehavior.AllowGet));
}
public JsonResult ReadHistoricData(string tickers, DateTime fromDate, DateTime toDate)
{
var databaseCalls = new DatabaseCalls();
var hd_Root = ExternalApiCalls.CallExternalAPIForHistoricData(tickers, fromDate, toDate);
var hd_Id = databaseCalls.PostHistoricPagination(hd_Root.pagination);
databaseCalls.PostHistoricData(hd_Root.data, hd_Id);
return(Json(new { success = true }, JsonRequestBehavior.AllowGet));
}
private void EditItem_Load(object sender, EventArgs e)
{
DataSet Result1 = new DataSet();
Result1 = DatabaseCalls.GetItems("Name");
foreach (DataRow asdf in Result1.Tables[0].Rows)
{
ItemName_ComboBox.Items.Add(asdf.ItemArray[0]);
}
}
//string MakeImageSrcData(byte[] filebytes)
//{
// return "data:image/png;base64," + Convert.ToBase64String(filebytes, Base64FormattingOptions.None);
//}
private void button1_Click(object sender, EventArgs e)
{
try
{
this.SALETableAdapter.Fill(this.DataSet1.SALE);
DataSet BillDataSet = new DataSet();
BillDataSet = DatabaseCalls.GetBill(BillNumberSearch_txt.Text);
ReportParameter[] _ReportParameter = new ReportParameter[8];
String CustomerID = BillDataGridView.CurrentRow.Cells["CUSTOMER_ID"].Value.ToString();
decimal CalculatedBalance = DatabaseCalls.GetCurrentRowBalance(CustomerID, BillNumberSearch_txt.Text);
foreach (DataRow GridViewColumn in BillDataSet.Tables[0].Rows)
{
_ReportParameter[0] = new ReportParameter("BillNumber", BillNumberSearch_txt.Text);
_ReportParameter[1] = new ReportParameter("InvoiceDate", Convert.ToDateTime(GridViewColumn.ItemArray[2]).ToShortDateString());
_ReportParameter[2] = new ReportParameter("BillBalance", GridViewColumn.ItemArray[5].ToString());
_ReportParameter[6] = new ReportParameter("Total", BillDataGridView.Rows[BillDataGridView.CurrentCell.RowIndex].Cells["CUSTOMER_BALANCE"].Value.ToString());
CustomerID = GridViewColumn.ItemArray[1].ToString();
}
DataSet CustomerDataSet = new DataSet();
CustomerDataSet = DatabaseCalls.GetCustomer(Convert.ToInt32(CustomerID));
foreach (DataRow GridViewColumn in CustomerDataSet.Tables[0].Rows)
{
_ReportParameter[3] = new ReportParameter("CustomerName", GridViewColumn.ItemArray[1].ToString());
_ReportParameter[4] = new ReportParameter("CustomerShipAddress", GridViewColumn.ItemArray[4].ToString());
decimal CustomerBalanceCalculated = Convert.ToDecimal(BillDataGridView.Rows[BillDataGridView.CurrentCell.RowIndex].Cells["CUSTOMER_BALANCE"].Value.ToString()) - Convert.ToDecimal(BillDataGridView.Rows[BillDataGridView.CurrentCell.RowIndex].Cells["AMOUNT"].Value.ToString());
_ReportParameter[5] = new ReportParameter("CustomerBalance", CustomerBalanceCalculated.ToString());
}
DataSet BillDetailDataSet = new DataSet();
BillDetailDataSet = DatabaseCalls.GetSale(BillNumberSearch_txt.Text);
int TotalCTNs = 0;
foreach (DataRow BillDetail in BillDetailDataSet.Tables[0].Rows)
{
TotalCTNs += Convert.ToInt32(BillDetail["QTY"].ToString());
}
_ReportParameter[7] = new ReportParameter("TotalCTN", TotalCTNs.ToString());
reportViewer1.LocalReport.SetParameters(_ReportParameter);
reportViewer1.RefreshReport();
}
catch (Exception ex)
{
if (ex.Message.ToString().Contains("One or more rows contain values violating non-null, ") == true)
{
button1_Click(sender, e);
}
else
{
Variables.NotificationMessageTitle = this.Name;
Variables.NotificationMessageText = ex.Message;
Variables.NotificationStatus = true;
}
}
}
private void button2_Click(object sender, EventArgs e)
{
try
{
VoucherAmount_txt_TextChanged(sender, e);
if (VoucherAmount_txt.Text == "0" || VoucherAmount_txt.Text == "")
{
Variables.NotificationMessageTitle = this.Name;
Variables.NotificationMessageText = "add amount.";
Variables.NotificationStatus = true;
return;
}
int CustomerID = Convert.ToInt32(CustomerID_txt.Text);
//foreach (DataRow GridViewColumn in CustomerDataSet.Tables[0].Rows)
//{
// if (GridViewColumn.ItemArray[1].ToString() == CustomerName_txt.Text)
// {
// CustomerID = Convert.ToInt32(GridViewColumn.ItemArray[0]);
// break;
// }
//}
decimal VoucherAmount = Convert.ToDecimal(VoucherAmount_txt.Text) * (-1);
//Add Bill Number
String Result1 = DatabaseCalls.AddVoucherPayment(CustomerID, Voucher_DTPicker.Value, VoucherAmount, VoucherRemarks_txt.Text, Convert.ToDecimal(RemainingBalance_txt.Text));
if (Result1.StartsWith("Voucher Added with") != true)
{
Variables.NotificationStatus = true;
Variables.NotificationMessageTitle = this.Name;
Variables.NotificationMessageText = Result1;
return;
}
//LedgerStatement_Load(sender, e);
//Variables.FormRefresh = "AddBill/Leadger";
RemainingBalance_txt.Text = "0";
CustomerBalance_txt.Text = "0";
VoucherAmount_txt.Text = "0";
VoucherRemarks_txt.Text = "0";
// CustomerName_txt.Text = "";
// CustomerName_txt_Enter(sender, e);
// CustomerID_txt.Text = "";
//get customers
RefreshCustomerData();
CustomerName_txt.Focus();
}
catch (Exception ex)
{
Variables.NotificationMessageTitle = this.Name;
Variables.NotificationMessageText = ex.Message;
Variables.NotificationStatus = true;
}
}
public JsonResult ReadEndOfTheDayData(string tickers)
{
var databaseCalls = new DatabaseCalls();
var eod_Root = ExternalApiCalls.CallExternalAPIForEndOfDayData(tickers);
var eod_Id = databaseCalls.PostEODPagination(eod_Root.pagination);
databaseCalls.PostEODData(eod_Root.data, eod_Id);
return(Json(new { success = true }, JsonRequestBehavior.AllowGet));
}
public ItemHistoryReport()
{
InitializeComponent();
DataSet Result1 = new DataSet();
Result1 = DatabaseCalls.GetItems();
//Result1.Tables[0].Columns["Item_Code"].ColumnName = "Item Code";
for (int loop = 0; loop < Result1.Tables[0].Rows.Count; loop++)//each (DataRow asdf in Result1.Tables[0].Rows[]["CODE"])
{
ItemName_txt.Items.Add(Result1.Tables[0].Rows[loop]["CODE"]);
}
}
private void DeleteBill_Load(object sender, EventArgs e)
{
try
{
System.Drawing.Icon ico = new System.Drawing.Icon("favicon.ico");
this.Icon = ico;
}
catch (Exception ex)
{ }
//Bills
try
{
BillDataSet = DatabaseCalls.GetBills();
CustomerDataSet = DatabaseCalls.GetCustomers();
BillDataSet.Tables[0].Columns.Add("Customer");
for (int loop = 0; loop < BillDataSet.Tables[0].Rows.Count; loop++)
{
for (int loop1 = 0; loop1 < CustomerDataSet.Tables[0].Rows.Count; loop1++)
{
if (CustomerDataSet.Tables[0].Rows[loop1]["ID"].ToString().Equals(BillDataSet.Tables[0].Rows[loop]["Customer_ID"].ToString()) == true)
{
BillDataSet.Tables[0].Rows[loop]["Customer"] = CustomerDataSet.Tables[0].Rows[loop1]["Name"].ToString();
}
}
if (Convert.ToInt32(BillDataSet.Tables[0].Rows[loop]["ID"]) < 0)
{
BillDataSet.Tables[0].Rows[loop].Delete();
}
}
BillDataGridView.DataSource = BillDataSet.Tables[0];
BillDataGridView.CurrentCell = null;
BillDataGridView.Columns[0].HeaderText = "Bill Number";
BillDataGridView.Columns["Customer_ID"].Visible = false;
BillDataGridView.Columns["Customer"].DisplayIndex = 1;
BillDataGridView.Update();
for (int loop = 0; loop < BillDataGridView.Rows.Count; loop++)
{
BillNumberSearch_txt.Items.Add(BillDataGridView.Rows[loop].Cells["ID"].Value);
}
// BillDataGridView.Columns["Customer_ID"].HeaderText = "Customer";
}
catch (Exception ex)
{
Variables.NotificationStatus = true;
Variables.NotificationMessageTitle = this.Name;
Variables.NotificationMessageText = ex.Message;
}
}
private void Recieve(string message, string from)
{
if (from == "Process 2" && message == "order")
{
var databaseCall = new DatabaseCalls();
//calculates how much its's going to cost
var cost = databaseCall.CalculateCost(itemOrder);
MessageBox.Show("This will cost £ " + cost);
/*Send a message to the mediator to indicate success. Mediator will then send a message via the event channel
* so the next process knows when to start*/
Send("order");
}
}
private void button1_Click(object sender, EventArgs e)
{
string Result = "";
try
{
if (ItemNewName_txt.Text == "")
{
return;
}
if (ItemPictureBox.ImageLocation == null || ItemPictureBox.ImageLocation == "")
{
if (File.Exists("ItemImages\\" + ItemNewName_txt.Text + ".JPG") == true)
{
ItemPictureBox.ImageLocation = Directory.GetCurrentDirectory() + "\\ItemImages\\" + ItemNewName_txt.Text + ".JPG";
}
else if (File.Exists("ItemImages\\" + ItemNewName_txt.Text + ".JPEG") == true)
{
ItemPictureBox.ImageLocation = Directory.GetCurrentDirectory() + "\\ItemImages\\" + ItemNewName_txt.Text + ".JPEG";
}
}
Result = DatabaseCalls.AddItem(ItemNewName_txt.Text, ItemModel_txt.Text, Convert.ToInt32(ItemQuantity_txt.Text), Convert.ToDecimal(ItemPrice_txt.Text), ItemPictureBox.ImageLocation, ItemCategory_txt.Text);
Variables.NotificationStatus = true;
Variables.NotificationMessageTitle = this.Name;
Variables.NotificationMessageText = Result;
if (Result.StartsWith("Item Added with") != true)
{
return;
}
DataSet Result1 = new DataSet();
Result1 = DatabaseCalls.GetItems();
ItemsDataGridView.DataSource = Result1.Tables[0];
ItemsDataGridView.Columns[0].Visible = false;
}
catch (Exception ex)
{
Variables.NotificationMessageText = ex.Message;
Variables.NotificationMessageTitle = this.Name;
Variables.NotificationStatus = true;
Console.WriteLine(ex.Message);
}
button6_Click(sender, e);
}
private void SelectItemCode_Load(object sender, EventArgs e)
{
//TO GET ITEM LIST
try
{
ItemDetailsDataSet = DatabaseCalls.GetItems();
foreach (DataRow asdf in ItemDetailsDataSet.Tables[0].Rows)
{
SelectedItemCode_txt.Items.Add(asdf.ItemArray[6]);
}
}
catch (Exception ex)
{
Variables.NotificationStatus = true;
Variables.NotificationMessageTitle = this.Name;
Variables.NotificationMessageText = ex.Message;
}
}
private void SelectCustomerName_Load(object sender, EventArgs e)
{
//Customer Detail
try
{
CustomerDataSet = DatabaseCalls.GetCustomers();
foreach (DataRow GridViewColumn in CustomerDataSet.Tables[0].Rows)
{
CustomerName_txt.Items.Add(GridViewColumn.ItemArray[1]);
}
}
catch (Exception ex)
{
Variables.NotificationStatus = true;
Variables.NotificationMessageTitle = this.Name;
Variables.NotificationMessageText = ex.Message;
}
}
//DB calls
private double returnRefundSubtotalAmount(string invoice, object[] objPageDetails)
{
string strQueryName = "returnRefundSubtotalAmount";
string sqlCmd = "SELECT (CASE WHEN SUM(itemRefund * quantity) IS NULL OR "
+ "SUM(itemRefund * quantity) = '' THEN 0 ELSE SUM(itemRefund * quantity) END) "
+ "AS totalRefund FROM tbl_currentSalesItems WHERE invoiceNum = @invoiceNum "
+ "AND invoiceSubNum = @invoiceSubNum";
object[][] parms =
{
new object[] { "@invoiceNum", Convert.ToInt32(invoice.Split('-')[1]) },
new object[] { "@invoiceSubNum", Convert.ToInt32(invoice.Split('-')[2]) }
};
//Returns the total refund subtotal of the cart
DatabaseCalls dbc = new DatabaseCalls();
return(dbc.MakeDataBaseCallToReturnDouble(sqlCmd, parms, objPageDetails, strQueryName));
//return dbc.MakeDataBaseCallToReturnDouble(sqlCmd, parms, objPageDetails, strQueryName);
}
private void ListConsignmentDetails_Load(object sender, EventArgs e)
{
try
{
System.Drawing.Icon ico = new System.Drawing.Icon("favicon.ico");
this.Icon = ico;
}
catch (Exception ex)
{ }
//TO GET Consingment Detail LIST
try
{
DataSet Result1 = new DataSet();
Result1 = DatabaseCalls.GetConsignmentDetails();
ItemsDataGridView.DataSource = Result1.Tables[0];
ItemsDataGridView.Columns[0].Visible = false;
ItemsDataGridView.Columns["SHIP_ID"].DisplayIndex = 0;
ItemsDataGridView.Columns["ITEM_CODE"].DisplayIndex = 1;
ItemsDataGridView.Columns["MODEL"].DisplayIndex = 2;
ItemsDataGridView.Columns["MODEL"].HeaderText = "Discription";
ItemsDataGridView.Columns["CTN"].DisplayIndex = 3;
ItemsDataGridView.Columns["QTY_PER_BOX"].DisplayIndex = 4;
ItemsDataGridView.Columns["T_QUANTITY"].DisplayIndex = 5;
for (int loop = 0; loop < ItemsDataGridView.Rows.Count; loop++)
{
if (ItemSearchName_txt.Items.Contains(ItemsDataGridView.Rows[loop].Cells["SHIP_ID"].Value) == false)
{
ItemSearchName_txt.Items.Add(ItemsDataGridView.Rows[loop].Cells["SHIP_ID"].Value);
}
}
ItemSearchName_txt.Text = " ";
//ItemSearchName_txt_TextChanged(sender, e);
}
catch (Exception ex)
{
Variables.NotificationStatus = true;
Variables.NotificationMessageTitle = this.Name;
Variables.NotificationMessageText = ex.Message;
}
}
private void button5_Click(object sender, EventArgs e)
{
string Result = DatabaseCalls.AddCategory(ItemCategory_txt);
if (Result.StartsWith("Category added") != true)
{
Variables.NotificationStatus = true;
Variables.NotificationMessageTitle = this.Name;
Variables.NotificationMessageText = Result;
return;
}
DataSet Result1 = new DataSet();
Result1 = DatabaseCalls.GetCategory();
ItemCategory_txt.Items.Clear();
foreach (DataRow asdf in Result1.Tables[0].Rows)
{
ItemCategory_txt.Items.Add(asdf.ItemArray[0]);
}
}
private void ListCustomers_Load(object sender, EventArgs e)
{
try
{
DataSet Result1 = new DataSet();
Result1 = DatabaseCalls.GetCustomers();
CustomersDataGridView.DataSource = Result1.Tables[0];
CustomersDataGridView.Columns["ID"].Visible = false;
CustomersDataGridView.Columns["IMAGE"].Visible = false;
foreach (DataRow GridViewColumn in Result1.Tables[0].Rows)
{
CustomerNameSearch_txt.Items.Add(GridViewColumn.ItemArray[1]);
}
}
catch (Exception ex)
{
Variables.NotificationStatus = true;
Variables.NotificationMessageTitle = this.Name;
Variables.NotificationMessageText = ex.Message;
}
}
private void AddConsignment_Load(object sender, EventArgs e)
{
try
{
DataSet Result1 = new DataSet();
Result1 = DatabaseCalls.GetConsignments();
ItemsDataGridView.DataSource = Result1.Tables[0];
ItemsDataGridView.Columns[0].Visible = false;
foreach (DataRow GridViewColumn in Result1.Tables[0].Rows)
{
ConsignmentNumberSearch_txt.Items.Add(GridViewColumn.ItemArray[0]);
}
}
catch (Exception ex)
{
Variables.NotificationStatus = true;
Variables.NotificationMessageTitle = this.Name;
Variables.NotificationMessageText = ex.Message;
}
}
public List <object> fillTemperatureChart(string date, string devicename, string timzoneoffset)
{
int offset = 0;
try
{
offset = int.Parse(timzoneoffset);
}
catch
{
}
//fill Chart (ref:http://www.c-sharpcorner.com/UploadFile/0c1bb2/spline-and-line-chart-in-Asp-Net/)
DataSet ds = DatabaseCalls.GetTemperatureDataForChart(devicename, User.Identity.Name, date);
DataTable chartData = ds.Tables[0];
List <string> labels = new List <string>();
List <int> temperature = new List <int>();
for (int count = 0; count < chartData.Rows.Count; count++)
{
//storing Values for X axis
DateTime time = (DateTime)chartData.Rows[count]["EntryTime"];
if (time.AddMinutes(-offset).Date == DateTime.Parse(date).Date) //ensure its todays date
{
//X axis
labels.Add(time.AddMinutes(-offset).ToString("yyyy-MM-dd HH:mm:ss"));
//storing values for Y Axis
temperature.Add(Convert.ToInt32(chartData.Rows[count]["Temperature"]));
}
}
List <object> iData = new List <object>();
iData.Add(labels);
iData.Add(temperature);
return(iData);
}