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 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 PopulateConsignmentData(object sender, EventArgs e)
{
try
{
string Result = "";
ItemDataSet = DatabaseCalls.GetItems();
ItemCode_txt.Items.Clear();
foreach (DataRow asdf in ItemDataSet.Tables[0].Rows)
{
ItemCode_txt.Items.Add(asdf["CODE"]);
}
string ItemCode = " ";
for (int loop = ExcelReader.Variables.RangeCurrentIndex; loop < ExcelReader.Variables.Range.Length && ItemCode != "" && ItemCode != "-----"; loop++)
{
try
{
ItemCode = ExcelReader.Variables.Range[loop][0];
if (ItemCode != "-----")
{
try
{
ItemCode_txt.Text = ExcelReader.Variables.Range[loop][0];
Description_txt.Text = ExcelReader.Variables.Range[loop][1];
Ctn_txt.Text = ExcelReader.Variables.Range[loop][2];
QtyPerBox_txt.Text = ExcelReader.Variables.Range[loop][3];
TQuantity_txt.Text = ExcelReader.Variables.Range[loop][4];
Price_txt.Text = ExcelReader.Variables.Range[loop][5];
if (ItemCode_txt.Items.Equals(ItemCode_txt.Text) == false && ItemCode_txt.Text != "" && Description_txt.Text != "" && Convert.ToInt32(QtyPerBox_txt.Text) > 0 && Convert.ToDecimal(Price_txt.Text) > 0)
{
try
{
Result = DatabaseCalls.AddItem(ItemCode_txt.Text, Description_txt.Text, Convert.ToInt32(QtyPerBox_txt.Text), Convert.ToDecimal(Price_txt.Text), ItemPictureBox.ImageLocation, "Toys");
Variables.NotificationStatus = true;
Variables.NotificationMessageTitle = this.Name;
Variables.NotificationMessageText = Result;
if (Result.StartsWith("Item Added with") != true)
{
Variables.NotificationMessageTitle = this.Name;
Variables.NotificationMessageText = Result;
Variables.NotificationStatus = true;
}
}
catch (Exception ex)
{
Variables.NotificationMessageTitle = this.Name;
Variables.NotificationMessageText = ex.Message;
Variables.NotificationStatus = true;
}
}
}
catch (Exception ex)
{
Variables.NotificationMessageTitle = this.Name;
Variables.NotificationMessageText = ex.Message;
Variables.NotificationStatus = true;
}
}
// if (ItemCode_txt.Items.Contains(ItemCode) == true)
{
AddDataToGrid();
}
}
catch (Exception ex)
{ }
//= ExcelReader.Variables.Range[loop][6];
}
}
catch (Exception ex)
{
Variables.NotificationMessageTitle = this.Name;
Variables.NotificationMessageText = ex.Message;
Variables.NotificationStatus = true;
}
}
private void toolStripButton1_Click(object sender, EventArgs e)
{
try
{
if (ConsignmentNumber_txt.Text == "")
{
Variables.NotificationMessageTitle = this.Name;
Variables.NotificationMessageText = "Please Enter The consignment Name..";
Variables.NotificationStatus = true;
return;
}
string Result = "";
try
{
//Add Consignment
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;
}
//Add Consignment Details
foreach (DataGridViewRow GridViewRow in ConsignmentDataGridView.Rows)
{
try
{
if (GridViewRow.Cells[2].Value != null && GridViewRow.Cells[2].Value.ToString() != "None" && GridViewRow.Cells[2].Value != "")
{
//if qty_box != same ... add item
string ItemCode = GridViewRow.Cells["ItemCode"].Value.ToString();
foreach (DataRow DR in ItemDataSet.Tables[0].Rows)
{
if (GridViewRow.Cells["ItemCode"].Value.ToString() == DR["Code"].ToString())
{
if (GridViewRow.Cells["ItemCode"].Value.ToString() == "302")
{
}
if (GridViewRow.Cells["QtyPerBox"].Value.ToString() != DR["QTY_BOX"].ToString())
{
string result = "";
try
{
ItemCode = ItemCode + "(" + GridViewRow.Cells["QtyPerBox"].Value.ToString() + "P)";
GridViewRow.Cells[1].Value = ItemCode;
result = DatabaseCalls.AddItem(ItemCode, GridViewRow.Cells["Description"].Value.ToString(), Convert.ToInt32(GridViewRow.Cells["QtyPerBox"].Value), Convert.ToDecimal(GridViewRow.Cells["Price"].Value), "", "Toys");
}
catch (Exception ex)
{
ItemCode = ItemCode + "(" + GridViewRow.Cells["QtyPerBox"].Value.ToString() + "P)";
GridViewRow.Cells[1].Value = ItemCode;
}
}
break;
}
}
String Result2 = DatabaseCalls.AddConsignmentDetail(ItemCode, ConsignmentNumber_txt.Text, Convert.ToInt32(GridViewRow.Cells["TQuantity"].Value), Convert.ToInt32(GridViewRow.Cells["QtyPerBox"].Value), GridViewRow.Cells["Description"].Value.ToString(), Convert.ToInt32(GridViewRow.Cells["Ctn"].Value), Convert.ToDecimal(GridViewRow.Cells["Price"].Value), Convert.ToDecimal(GridViewRow.Cells["SUBTOTAL"].Value));
if (Result2.StartsWith("Consignment added with id") != true)
{
Variables.NotificationStatus = true;
Variables.NotificationMessageTitle = this.Name;
Variables.NotificationMessageText = Result2;
return;
}
ItemDetails = DatabaseCalls.GetItemDetails("code", GridViewRow.Cells[1].Value.ToString());
int UpdatedItem_Quantity = (Convert.ToInt32(ItemDetails.Tables[0].Rows[0]["T_QUANTITY"]) + Convert.ToInt32(GridViewRow.Cells[5].Value));
String UpdateItemResult = DatabaseCalls.AddItemQutantity(GridViewRow.Cells[1].Value.ToString(), UpdatedItem_Quantity);
if (UpdateItemResult.StartsWith("Item Quantity Modified") != true)
{
Variables.NotificationStatus = true;
Variables.NotificationMessageTitle = this.Name;
Variables.NotificationMessageText = UpdateItemResult;
return;
}
String AddSaleResult = DatabaseCalls.AddSale(0, 0, -1, 0, GridViewRow.Cells[1].Value.ToString(), "Name", 0, 0, -1);
if (UpdateItemResult.StartsWith("Item Quantity Modified") != true)
{
Variables.NotificationStatus = true;
Variables.NotificationMessageTitle = this.Name;
Variables.NotificationMessageText = UpdateItemResult;
return;
}
//UPDATE PRICE IF MODIFIED
foreach (DataRow asdf in ItemDataSet.Tables[0].Rows)
{
if (asdf["CODE"].ToString() == GridViewRow.Cells["ItemCode"].Value.ToString())
{
if (Price_txt.Text != GridViewRow.Cells["Price"].Value.ToString())
{
string ModifyCustomerResult = DatabaseCalls.ModifyItemPrice(GridViewRow.Cells["ItemCode"].Value.ToString(), Convert.ToDecimal(GridViewRow.Cells["Price"].Value));
if (ModifyCustomerResult.StartsWith("Item Price Modified") != true)
{
Variables.NotificationStatus = true;
Variables.NotificationMessageTitle = this.Name;
Variables.NotificationMessageText = ModifyCustomerResult;
return;
}
//Item Price Modified
}
}
}
}
}
catch (Exception ex)
{
Variables.NotificationStatus = true;
Variables.NotificationMessageTitle = this.Name;
Variables.NotificationMessageText = ex.Message;
}
}
//ClearAllData();
Variables.NotificationStatus = true;
Variables.NotificationMessageTitle = this.Name;
Variables.NotificationMessageText = "Consignment Added Successfully... :)";
this.Close();
//ClearAllData();
}
catch (Exception ex)
{
Variables.NotificationStatus = true;
Variables.NotificationMessageTitle = this.Name;
Variables.NotificationMessageText = ex.Message;
}
RandomAlgos.DeleteConsignmentFile();
}
catch (Exception ex)
{
Variables.NotificationStatus = true;
Variables.NotificationMessageTitle = this.Name;
Variables.NotificationMessageText = ex.Message;
}
}