private void ItemCode_txt_KeyUp(object sender, KeyEventArgs e)
{
try
{
if (e.KeyCode != Keys.Up && e.KeyCode != Keys.Down && e.KeyCode != Keys.Enter && e.KeyValue != 27)
{
try
{
if (ItemCode_txt.Text != null)
{
RandomAlgos.comboKeyPressed(ItemCode_txt);
}
}
catch (Exception ex)
{
Variables.NotificationMessageTitle = this.Name;
Variables.NotificationMessageText = ex.Message;
Variables.NotificationStatus = true;
}
}
}
catch (Exception ex)
{
Variables.NotificationStatus = true;
Variables.NotificationMessageTitle = this.Name;
Variables.NotificationMessageText = ex.Message;
}
}
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;
}
}
private void AddDataToGrid()
{
try
{
decimal PriceMultiplied_TQuantity = (Convert.ToDecimal(Price_txt.Text) * Convert.ToDecimal(TQuantity_txt.Text));
string[] row = { (ConsignmentDataGridView.NewRowIndex + 1).ToString(), ItemCode_txt.Text, Description_txt.Text, Ctn_txt.Text, QtyPerBox_txt.Text, TQuantity_txt.Text, Price_txt.Text, PriceMultiplied_TQuantity.ToString() };
textBox7.Text = (ConsignmentDataGridView.NewRowIndex + 1).ToString();
textBox8.Text = (Convert.ToDecimal(textBox8.Text) + Convert.ToDecimal(Ctn_txt.Text)).ToString();
textBox1.Text = (Convert.ToDecimal(textBox1.Text) + Convert.ToDecimal(TQuantity_txt.Text)).ToString();
textBox9.Text = (Convert.ToDecimal(textBox9.Text) + PriceMultiplied_TQuantity).ToString();
RandomAlgos.AddDataInConsignmentFile((ConsignmentDataGridView.NewRowIndex).ToString(), ItemCode_txt.Text, Description_txt.Text, QtyPerBox_txt.Text, Ctn_txt.Text, TQuantity_txt.Text, Price_txt.Text, (Convert.ToDecimal(TQuantity_txt.Text) * Convert.ToDecimal(Price_txt.Text)).ToString(), ConsignmentNumber_txt.Text, textBox8.Text, textBox7.Text, textBox9.Text);
ConsignmentDataGridView.Rows.Add(row);
ConsignmentDataGridView.Update();
ItemCode_txt.Text = "";
QtyPerBox_txt.Text = "0";
Description_txt.Text = "None";
Ctn_txt.Text = "0";
TQuantity_txt.Text = "0";
Price_txt.Text = "0";
ItemCode_txt.Focus();
}
catch (Exception ex)
{
Variables.NotificationStatus = true;
Variables.NotificationMessageTitle = this.Name;
Variables.NotificationMessageText = ex.Message;
}
}
public void TestFindDuplicateElementInLimitedRangeArray()
{
int[] array = { 1, 2, 3, 4, 5, 3 };
int result = RandomAlgos.FindDuplicateElementInimitedRangeArray(array);
Assert.IsTrue(result == 3);
}
public void TestSortBinaryArrayInLinearTime()
{
int[] array = { 1, 0, 1, 0, 1, 0, 0, 1 };
int[] output = { 0, 0, 0, 0, 1, 1, 1, 1 };
var result = RandomAlgos.SortBinaryArrayInLinearTime(array);
Assert.IsTrue(result.SequenceEqual(output));
}
public void TestFindSubArrayWithGivenSum()
{
int[] arr = { 15, 2, 4, 8, 9, 5, 10, 23 };
int sum = 23;
var result = RandomAlgos.FindSubArrayWithGivenSum(arr, sum);
Assert.IsTrue(result.Count == 2);
}
private void ConsignmentNumberSearch_txt_KeyDown(object sender, KeyEventArgs e)
{
try
{
if (e.KeyCode != Keys.Up && e.KeyCode != Keys.Down && e.KeyCode != Keys.Right && e.KeyCode != Keys.Left && e.KeyCode != Keys.Enter)
{
if (ConsignmentNumberSearch_txt.Text != null)
{
RandomAlgos.comboKeyPressed(ConsignmentNumberSearch_txt);
}
}
}
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;
}
}
