public static void UpdateQuantityOfProduct()
{
ProductRawMaterial productRawMaterial = new ProductRawMaterial();
ProductRawMaterialBusinessLogicLayer prbl = new ProductRawMaterialBusinessLogicLayer();//creating object of businessLogicLayer class
System.Console.WriteLine("enter ProductID (ProductID must Starts With *PID*)");
productRawMaterial.ProductID = System.Console.ReadLine();
System.Console.WriteLine("enter RawMaterialID (RawMaterialID must Starts With *RMID* and length should be *6*)");
productRawMaterial.RawMaterialID = System.Console.ReadLine();
ProductRawMaterial a = prbl.GetProductRawMaterialByID(productRawMaterial.ProductID, productRawMaterial.RawMaterialID);
if (a != null)
{
productRawMaterial.RawMaterialName = a.RawMaterialName;
System.Console.WriteLine(productRawMaterial.RawMaterialName);
System.Console.WriteLine("Enter the Quantity");
productRawMaterial.Quantity = System.Convert.ToDouble(System.Console.ReadLine());
prbl.UpdateQuantityOfProduct(productRawMaterial);
System.Console.WriteLine("******************* Successfully added RawMaterial Details to ProductID " + productRawMaterial.ProductID + " ************** ");
}
else
{
System.Console.WriteLine("**************entered ProductID " + productRawMaterial.ProductID + " and RawMaterialID " + productRawMaterial.RawMaterialID + " doesn't exists. Pls Try again*************");
}
}
/// <summary>
/// UpdateQuantityOfProduct is a instane method used to Update the Quantity Based on ProductID and RawMaterialID
/// </summary>
/// <param name="productRawMaterial">Contain the all the Details of the feild present in ProductRawMaterial Class</param>
public void UpdateQuantityOfProduct(ProductRawMaterial productRawMaterial)
{
ProductRawMaterial abc = _productRawMaterials.Find(temp => temp.ProductID == productRawMaterial.ProductID && temp.RawMaterialID == productRawMaterial.RawMaterialID);
abc.Quantity = productRawMaterial.Quantity;
ListOfRawMaterials();
}
public void AddModifyRawMaterialForFinishedProductsItems(ProductRawMaterial itm)
{
using (SqlConnection conn = connect.getConnection())
{
using (SqlCommand cmd = new SqlCommand("AddFinishedProductRawMaterials", conn))//call Stored Procedure
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@businessid", itm.businessId);
cmd.Parameters.AddWithValue("@productID", itm.productId);
cmd.Parameters.AddWithValue("@rawMaterialID", itm.rawMaterialID);
cmd.Parameters.AddWithValue("@rawMaterialQty", itm.rawMaterialQty);
cmd.Parameters.Add("@returnvalue", SqlDbType.Int);
cmd.Parameters["@returnvalue"].Direction = ParameterDirection.Output;
cmd.Parameters.Add("@returnvalueString", System.Data.SqlDbType.VarChar, 200);
cmd.Parameters["@returnvalueString"].Direction = ParameterDirection.Output;
try
{
cmd.ExecuteNonQuery();
/* rv.StatusCode = Convert.ToInt32(cmd.Parameters["@returnvalue"].Value);
* rv.StatusMessage = Convert.ToString(cmd.Parameters["@returnvalueString"].Value); */
}
catch (Exception ex)
{
CommonUtilityClass.ExceptionLog(ex);
/* rv.StatusCode = 2000;
* rv.StatusMessage = "An Error Occured"; */
}
}
}
}
public void AddProductRawMaterial(AddEditProductRawMaterialModel model)
{
using (var uow = new UnitOfWork(new DataContext()))
{
var obj = new ProductRawMaterial();
obj.ProductID = model.ProductID;
obj.SupplyTypeID = model.SupplyTypeID;
obj.Quantity = model.Quantity;
uow.ProductRawMaterials.Add(obj);
uow.Complete();
model.ID = obj.ProductRawMaterialID;
}
}
/// <summary>
/// GetProductRawMaterialByID is a instance method used to check weather the below condition satisfies or not
/// </summary>
/// <param name="ProductID">represents ID of the product</param>
/// <param name="RawMaterialID">represents ID of the RawMaterial</param>
/// <returns>Returns the details</returns>
public ProductRawMaterial GetProductRawMaterialByID(string ProductID, string RawMaterialID)
{
ProductRawMaterial abc = _productRawMaterials.Find(temp => temp.ProductID == ProductID && temp.RawMaterialID == RawMaterialID);
if (abc != null)
{
return(abc);
}
else
{
return(null);
}
}
public static void GetDetailsUsingOrderBy()
{
ProductRawMaterial productRawMaterial = new ProductRawMaterial();
ProductRawMaterialBusinessLogicLayer prbl = new ProductRawMaterialBusinessLogicLayer(); //creating object of businessLogicLayer class
List <ProductRawMaterial> rms = prbl.GetDetailsUsingOrderBy(); // call the GetRawMaterial method with no arguments in the BusinessLogicLayer by using Refernce Variable
System.Console.WriteLine("**********************************************************************************");
foreach (ProductRawMaterial rm in rms)//to print the list
{
System.Console.WriteLine("ProductID:-" + rm.ProductID + " RawMaterialID:-" + rm.RawMaterialID + " RawMaterialName:-" + rm.RawMaterialName + " Quantity:-" + rm.Quantity + "" + rm.Units);
}
System.Console.WriteLine("**********************************************************************************");
}
/// <summary>
/// checks weather entered details contains or not in the List
/// </summary>
/// <param name="productRawMaterial">Contain the all the Details of the feild present in ProductRawMaterial Class</param>
/// <returns>Returns the details based on ProductID and RwMaterialID</returns>
public ProductRawMaterial GetDetailsByProductIDAndRawMaterialID(ProductRawMaterial productRawMaterial)
{
ProductRawMaterial ab = _productRawMaterials.Find(temp => temp.ProductID == productRawMaterial.ProductID && temp.RawMaterialID == productRawMaterial.RawMaterialID);
if (ab != null)
{
return(ab);
}
else
{
return(null);
}
}
public static void GetDetailsByProductID()
{
ProductRawMaterial productRawMaterial = new ProductRawMaterial();
System.Console.WriteLine("enter ProductID (ProductID must Starts With *PID*)");
productRawMaterial.ProductID = System.Console.ReadLine();
System.Console.WriteLine("ProductID:-" + productRawMaterial.ProductID);
ProductRawMaterialBusinessLogicLayer prbl = new ProductRawMaterialBusinessLogicLayer();//creating object of businessLogicLayer class
List <ProductRawMaterial> prm = prbl.GetDetailsByProductID(productRawMaterial);
foreach (ProductRawMaterial rm in prm)//to print the list
{
System.Console.WriteLine("RawMaterialID:-" + rm.RawMaterialID + " RawMaterialName:-" + rm.RawMaterialName + " Quantity:-" + rm.Quantity + "" + rm.Units);
}
System.Console.WriteLine("**********************************************************************************");
}
/// <summary>
/// deletes RawMaterial of Product
/// </summary>
/// <param name="productRawMaterial">contains all the details of feilds</param>
public void DeleteRawMaterialOfProduct(ProductRawMaterial productRawMaterial)
{
try
{
if ((productRawMaterial.ProductID != null) && (productRawMaterial.RawMaterialID != null))// && (productRawMaterial.Quantity != 0D) && (productRawMaterial.Units != null))
{
prda.DeleteRawMaterialOfProduct(productRawMaterial);
}
else
{
throw new ProductRawMaterialException("Entered Values contains null values");
}
}
catch
{
}
}
public static void AddRawMaterialToProduct()
{
ProductRawMaterial productRawMaterial = new ProductRawMaterial();
ProductRawMaterialBusinessLogicLayer prbl = new ProductRawMaterialBusinessLogicLayer(); //creating object of businessLogicLayer class
System.Console.WriteLine("enter ProductID (ProductID must Starts With *PID*)");
productRawMaterial.ProductID = System.Console.ReadLine();
Product a = prbl.GetProductByProductID(productRawMaterial.ProductID);
if (a != null)
{
productRawMaterial.ProductID = a.ProductID;
System.Console.WriteLine("enter RawMaterialID (RawMaterialID must Starts With *RMID* and length should be *6*)");
productRawMaterial.RawMaterialID = System.Console.ReadLine();
RawMaterial prm = prbl.GetRawMaterialByRawMaterialID(productRawMaterial.RawMaterialID);
if (prm != null)
{
productRawMaterial.RawMaterialID = prm.RawMaterialID;
productRawMaterial.RawMaterialName = prm.RawMaterialName;
System.Console.WriteLine(productRawMaterial.RawMaterialName);
if (prbl.GetDetailsByProductIDAndRawMaterialID(productRawMaterial) == null)
{
System.Console.WriteLine("Enter the Quantity");
productRawMaterial.Quantity = System.Convert.ToDouble(System.Console.ReadLine());
System.Console.WriteLine("Enter the Units");
productRawMaterial.Units = System.Console.ReadLine();
prbl.AddRawMaterialToProduct(productRawMaterial);
System.Console.WriteLine("******************* Successfully added RawMaterial Details to ProductID " + productRawMaterial.ProductID + " ************** ");
}
else
{
System.Console.WriteLine("*************** Entered details all ready exits ********************");
}
}
else
{
System.Console.WriteLine("**************entered RawMaterialID " + productRawMaterial.RawMaterialID + " does not exists. Pls Try again*************");
}
}
else
{
throw new ProductRawMaterialException("**************entered ProductID " + productRawMaterial.ProductID + " doesn't exists. Pls Try again*************");
}
}
/// <summary>
/// To add the RawMaterials to Product
/// </summary>
/// <param name="productRawMaterial">contains all the details of feilds</param>
public void AddRawMaterialToProduct(ProductRawMaterial productRawMaterial)
{
try
{
if ((productRawMaterial.ProductID != null) && (productRawMaterial.RawMaterialID != null) && (productRawMaterial.RawMaterialName != null) && (productRawMaterial.Quantity != 0D) && (productRawMaterial.Units != null))
{
prda.AddRawMaterialToProduct(productRawMaterial);
}
else
{
throw new ProductRawMaterialException("Entered Values contains null values");
}
}
catch
{
throw;
}
}
/// <summary>
/// To update Quantity of RawMaterial
/// </summary>
/// <param name="productRawMaterial">Represents ProductID</param>
public void UpdateQuantityOfProduct(ProductRawMaterial productRawMaterial)
{
try
{
if ((productRawMaterial.ProductID != null) && (productRawMaterial.RawMaterialID != null) && (productRawMaterial.Quantity != 0D))
{
prda.UpdateQuantityOfProduct(productRawMaterial);
}
else
{
throw new ProductRawMaterialException("Entered Values contains null values");
}
}
catch
{
throw;
}
}
public static void DeleteRawMaterialOfProduct()
{
ProductRawMaterial productRawMaterial = new ProductRawMaterial();
ProductRawMaterialBusinessLogicLayer prbl = new ProductRawMaterialBusinessLogicLayer();//creating object of businessLogicLayer class
System.Console.WriteLine("enter ProductID (ProductID must Starts With *PID*)");
productRawMaterial.ProductID = System.Console.ReadLine();
System.Console.WriteLine("enter RawMaterialID (RawMaterialID must Starts With *RMID* and length should be *6*)");
productRawMaterial.RawMaterialID = System.Console.ReadLine();
if (prbl.GetProductRawMaterialByID(productRawMaterial.ProductID, productRawMaterial.RawMaterialID) != null)
{
prbl.DeleteRawMaterialOfProduct(productRawMaterial);
System.Console.WriteLine("******************* Successfully deleted RawMaterial Details from ProductID " + productRawMaterial.ProductID + " ************** ");
}
else
{
System.Console.WriteLine("**************entered ProductID " + productRawMaterial.ProductID + " and RawMaterialID " + productRawMaterial.RawMaterialID + " doesn't exists. Pls Try again*************");
}
}
public List <ProductRawMaterial> GetProductsRawMaterial(int proid, int busId)
{
List <ProductRawMaterial> prl = new List <ProductRawMaterial>();
using (SqlConnection conn = connect.getConnection())
{
using (SqlCommand cmd = new SqlCommand("getRawMaterialByProductId", conn))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@productId", proid);
try
{
ProductRawMaterial _prl = new ProductRawMaterial();
SqlDataReader reader = cmd.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
_prl = new ProductRawMaterial
{
productId = proid,
businessId = busId,
rawMaterialID = Convert.ToInt32(reader["rawMaterialID"]),
rawMaterialName = reader["MaterialName"] is DBNull ? null : (String)reader["MaterialName"],
rawMaterialQty = Convert.ToDecimal(reader["rawMaterialQty"]),
};
prl.Add(_prl);
}
}
else
{
prl = null;
}
}
catch (Exception ex)
{
CommonUtilityClass.ExceptionLog(ex);
}
}
}
return(prl);
}
/// <summary>
/// checks weather entered productID and RawMaterialID exists or not
/// </summary>
/// <param name="productRawMaterial"></param>
/// <returns>Returns the details</returns>
public ProductRawMaterial GetDetailsByProductIDAndRawMaterialID(ProductRawMaterial productRawMaterial)
{
return(prda.GetDetailsByProductIDAndRawMaterialID(productRawMaterial));
}
/// <summary>
/// checks entered productID exists or not. if yes Returns the Details
/// </summary>
/// <param name="productRawMaterial"></param>
/// <returns></returns>
public List <ProductRawMaterial> GetDetailsByProductID(ProductRawMaterial productRawMaterial)
{
return(prda.GetDetailsByProductID(productRawMaterial));
}
/// <summary>
/// DeleteRawMaterialProduct is a instance Method used to Delete RawMaterial of the Product from the List
/// </summary>
/// <param name="productRawMaterial">Contain the all the Details of the feild present in ProductRawMaterial Class</param>
public void DeleteRawMaterialOfProduct(ProductRawMaterial productRawMaterial)
{
_productRawMaterials.RemoveAll(temp => temp.ProductID == productRawMaterial.ProductID && temp.RawMaterialID == productRawMaterial.RawMaterialID);
ListOfRawMaterials();
}
/// <summary>
/// GetDetailsByProductID is a instance method used to Return the List if ProductID matches
/// </summary>
/// <param name="productRawMaterial">Contain the all the Details of the feild present in ProductRawMaterial Class</param>
/// <returns>Return the list</returns>
public List <ProductRawMaterial> GetDetailsByProductID(ProductRawMaterial productRawMaterial)
{
List <ProductRawMaterial> ab = _productRawMaterials.Where(temp => temp.ProductID == productRawMaterial.ProductID).ToList();
return(ab);
}
/// <summary>
/// AddRawMaterialToProduct is a instance Method used to Add RawMaterial of product to the List
/// </summary>
/// <param name="ProductRawMaterial">Contain the all the Details of the feild present in ProductRawMaterial Class</param>
public void AddRawMaterialToProduct(ProductRawMaterial productRawMaterial)
{
_productRawMaterials.Add(productRawMaterial);//Addess ProductRawMaterial details to List
ListOfRawMaterials();
}
