//--------------------------To get the item details---------------------------------------------------------------------//
public void details(string itemid)
{
//--------------------------from InventoryCatalogue table(BIN,Description,UOM)------------------------------------------//
detFromInventory = InventoryLogic.GetInventoryDetails(itemid);
LblDesD.Text = detFromInventory.Description;
LblUomD.Text = detFromInventory.UOM;
LblBinD.Text = detFromInventory.BIN;
LblIdD.Text = detFromInventory.ItemID;
//---------------------------from SupplierCatalogue table(Supplier details)--------------------------------------------//
sCatList = InventoryLogic.GetCatalogueDetails(itemid);
LblS1D.Text = sCatList[0].SupplierID;
LblS2D.Text = sCatList[1].SupplierID;
LblS3D.Text = sCatList[2].SupplierID;
}
//-----------------------Find transaction details button click event----------------------------------------------------//
protected void BtnFind_Click(object sender, EventArgs e)
{
try {
DatgridViewRefresh();
ControlVisibleTrue();
//-----------------------------Getting the value from the date time picker----------------------------------------------//
try
{
date1 = DateTime.ParseExact(Request.Form["datepicker"], "MM/dd/yyyy", CultureInfo.InvariantCulture);
date2 = DateTime.ParseExact(Request.Form["datepicker2"], "MM/dd/yyyy", CultureInfo.InvariantCulture);
}
catch
{ }
//--------------convert date to string----------------------------------------------------------------------------------//
string d1 = Convert.ToString(date1);
string d2 = Convert.ToString(date2);
//---------If user wont select a date default value is "1/1/0001 12:00:00 AM".setting that to null here-----------------//
if (d1 == "1/1/0001 12:00:00 AM" || d2 == "1/1/0001 12:00:00 AM")
{
d1 = null;
d2 = null;
}
//----------------------------Search based on item code & transaction dates-------------------------------------------//
//-------------Datagrid view load with transaction records of selected item within the selected dates--------------//
//To get the item name corresponding to the item code selected
InventoryCatalogue i = InventoryLogic.GetInventoryDetails(TxtId.Text);
string d0 = date1.ToString("yyyy-MM-dd");
string d = date2.ToString("yyyy-MM-dd");
if (TxtId.Text != string.Empty && d1 != null && d2 != null)
{
tList = InventoryLogic.GetTransactionByDate(date1, date2, TxtId.Text);
details(TxtId.Text);
GridViewStockCard.DataSource = tList;
GridViewStockCard.DataBind();
LblMsg.Visible = true;
LblMsg.Text = "*Showing transaction records of " + i.Description + " within the date range " + d0 + " and " + d;
}
//-----------------------------Transaction records of selected item----here user not selected any dates-----------------//
else if (TxtId.Text != string.Empty && d1 == null && d2 == null)
{
string id = TxtId.Text;
tList = InventoryLogic.GetStockCardList(TxtId.Text);
details(TxtId.Text);
GridViewStockCard.DataSource = tList;
GridViewStockCard.DataBind();
LblMsg.Visible = true;
LblMsg.Text = "*Showing transaction records of " + i.Description;
}
//--------------------------------Transaction records within the selected date range------------------------------------//
else if (TxtId.Text == string.Empty && d1 != null && d2 != null)
{
tList = InventoryLogic.GetAllTransactionByDate(date1, date2);
GridViewStockCard.DataSource = tList;
GridViewStockCard.DataBind();
LblMsg.Visible = true;
LblMsg.Text = "*Showing transaction records " + "within the date range " + d0 + " and " + d;
ControlVisibleFalse();
}
//--------------------user don't give any input.just click search button.then this condition will fire------------------//
else if (TxtId.Text == string.Empty && d1 == null && d2 == null)
{
ControlVisibleFalse();
LblMsg.Visible = true;
LblMsg.Text = "*Please give valid data to search in the inventory";
}
}
//-----------------------catch the invalid item code-----------display status message-----------------------------------//
catch
{
ControlVisibleFalse();
}
}