public List <clsFruitModel> RetrieveFruits()
{
List <clsFruitModel> result = new List <clsFruitModel>();
DataSet dataSet = new DataSet();
dataSet = masterData.RetrieveFruits();
if (dataSet?.Tables?.Count == 0 || dataSet?.Tables[0].Rows.Count == 0)
{
throw new Exception(Convert.ToString((int)ErrorStatus.LoadDiscountMasterDataFail));
}
if (dataSet?.Tables[0]?.Rows.Count > 0)
{
foreach (DataRow item in dataSet.Tables[0].Rows)
{
clsFruitModel discount = new clsFruitModel()
{
iFruitId = Convert.ToInt32(item[0]),
sFruitName = item[1].ToString(),
};
result.Add(discount);
}
}
return(result);
}
public clsFruitModel GetFruitByFruitId(int fruitId)
{
clsFruitModel result = new clsFruitModel();
DataSet data = new DataSet();
if (fruitId == 0)
{
throw new Exception();
}
data = dataLayer.GetFruitByFruitId(fruitId);
if (data?.Tables.Count == 0 || data?.Tables[0]?.Rows.Count == 0)
{
throw new Exception();
}
result = new clsFruitModel()
{
iFruitId = Convert.ToInt32(data.Tables[0].Rows[0][0]),
sFruitName = data.Tables[0].Rows[0][1].ToString(),
sDescription = data.Tables[0].Rows[0][2].ToString(),
deQuantity = Convert.ToDecimal(data.Tables[0].Rows[0][3].ToString()),
eMeasurement = GetMeasurementType(Convert.ToInt32(data.Tables[0].Rows[0][4].ToString())),
bStatus = Convert.ToBoolean(data.Tables[0].Rows[0][5].ToString()),
deUnitPrice = Convert.ToDecimal(data.Tables[0].Rows[0][6].ToString())
};
return(result);
}
private void LoadFruitByFruitId(int fruitId)
{
fruit = businessLayer.GetFruitByFruitId(fruitId);
txtname.Text = fruit.sFruitName;
txtQuatity.Text = fruit.deQuantity.ToString();
txtUnitPrice.Text = fruit.deUnitPrice.ToString();
txtDescription.Text = fruit.sDescription;
drpMeasureUnit.SelectedValue = Convert.ToString((int)fruit.eMeasurement);
}
private void LoadFruitByFruitId(int fruitId)
{
List <clsDiscountModel> discount = new List <clsDiscountModel>();
fruit = BusinessLayer.GetFruitByFruitId(fruitId);
discount = master.RetrieveDiscount();
txtAvailable.Text = string.Format("{0} {1}", fruit.deQuantity.ToString(), fruit.eMeasurement);
txtUnitPrice.Text = string.Format("Rs {0}/{1}", fruit.deUnitPrice.ToString(), fruit.eMeasurement);
hidAvailable.Value = fruit.deQuantity.ToString();
hidUnitPrice.Value = fruit.deUnitPrice.ToString();
hidMeasurement.Value = fruit.eMeasurement.ToString();
hidDiscount.Value = JsonConvert.SerializeObject(discount);
}
private DataSet UpsertFruit(clsFruitModel item)
{
DataSet result = new DataSet();
DataTable data = new DataTable();
if (string.IsNullOrWhiteSpace(connectionString))
{
throw new Exception();
}
connection = new SqlConnection(connectionString);
connection.Open();
if (connection == null)
{
throw new Exception();
}
SqlCommand command = new SqlCommand("tblFruitUpsert", connection)
{
CommandType = CommandType.StoredProcedure
};
command.Parameters.Add(new SqlParameter("@fruitId", item.iFruitId));
command.Parameters.Add(new SqlParameter("@name", item.sFruitName));
command.Parameters.Add(new SqlParameter("@des", item.sDescription));
command.Parameters.Add(new SqlParameter("@measurement", (int)item.eMeasurement));
command.Parameters.Add(new SqlParameter("@quantity", item.deQuantity));
command.Parameters.Add(new SqlParameter("@unitPrice", item.deUnitPrice));
command.Parameters.Add(new SqlParameter("@stat", item.bStatus));
data.Load(command.ExecuteReader());
if (data?.Rows.Count == 0)
{
throw new Exception();
}
result.Tables.Add(data);
return(result);
}
private void RetriveFruit()
{
List <clsFruitModel> fruitsId = new List <clsFruitModel>();
List <clsFruitModel> fruits = new List <clsFruitModel>();
DataTable dataTable = new DataTable();
fruitsId = master.RetrieveFruits();
if (fruitsId.Count > 0)
{
foreach (var item in fruitsId)
{
clsFruitModel fruit = new clsFruitModel();
fruit = businessLayer.GetFruitByFruitId(item.iFruitId);
fruits.Add(fruit);
}
}
dataTable = GenerateCustomColumn(fruits);
grdInventory.DataSource = dataTable;
grdInventory.DataBind();
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
try
{
clsFruitModel fruitResult = new clsFruitModel()
{
bStatus = true,
deQuantity = string.IsNullOrWhiteSpace(txtQuatity.Text.Trim()) ? 0 : Convert.ToDecimal(txtQuatity.Text.Trim()),
deUnitPrice = string.IsNullOrWhiteSpace(txtUnitPrice.Text.Trim()) ? 0 : Convert.ToDecimal(txtUnitPrice.Text.Trim()),
eMeasurement = clsCommon.GetMeasurementType(Convert.ToInt32(drpMeasureUnit.SelectedValue)),
iFruitId = Convert.ToInt32(drpFruit.SelectedValue),
sDescription = txtDescription.Text.Trim(),
sFruitName = txtname.Text.Trim()
};
StockSummaryModel result = new StockSummaryModel()
{
objFruit = fruitResult,
lstStock = new List <clsStockModel>()
};
businessLayer.UpsertInventory(result);
pnlError.Visible = false;
pnlSuccess.Visible = true;
drpFruit.Items.Clear();
List <clsFruitModel> fruits = new List <clsFruitModel>();
fruits = master.RetrieveFruits();
foreach (var item in fruits)
{
ListItem list = new ListItem(item.sFruitName, item.iFruitId.ToString(), true);
drpFruit.Items.Add(list);
}
drpFruit.SelectedIndex = 0;
LoadFruitByFruitId(Convert.ToInt32(drpFruit.SelectedValue));
}
catch (FormatException ex)
{
pnlError.Visible = true;
pnlSuccess.Visible = false;
switch (Convert.ToInt32(ex.Message))
{
case (int)ErrorStatus.InventoryInvalidModel:
pnlError.Visible = true;
lblErrorDetails.Text = "Invalid fruit details";
break;
case (int)ErrorStatus.InventoryInvalidFruitName:
pnlError.Visible = true;
lblErrorDetails.Text = "Invalid fruit name";
break;
case (int)ErrorStatus.InventoryInvalidQuantity:
pnlError.Visible = true;
lblErrorDetails.Text = "Invalid quantity";
break;
case (int)ErrorStatus.InventoryInvalidUnitPrice:
pnlError.Visible = true;
lblErrorDetails.Text = "Invalid unit price";
break;
case (int)ErrorStatus.InventorySupplierDetails:
pnlError.Visible = false;
lblErrorDetails.Text = "invalid supplier details";
break;
case (int)ErrorStatus.InventoryInvalidDeliveryDate:
pnlError.Visible = false;
lblErrorDetails.Text = "Invalid delivery date";
break;
default:
break;
}
}
catch (Exception ex)
{
Response.Redirect(string.Format("~/Error.aspx?stat={0}", (int)ErrorStatus.InventoryConfigurationFail));
}
}