//updatebom
public bool UpdateBOM(eSunSpeedDomain.BillofMaterialModel objBOM)
{
string Query = string.Empty;
bool isUpdated = true;
try
{
DBParameterCollection paramCollection = new DBParameterCollection();
paramCollection.Add(new DBParameter("@BOMName", objBOM.BOMName));
paramCollection.Add(new DBParameter("@ItemProduct", objBOM.ItemProduct));
paramCollection.Add(new DBParameter("@Quantity", objBOM.Quantity, System.Data.DbType.Decimal));
paramCollection.Add(new DBParameter("@ItemUnit", objBOM.ItemUnit));
paramCollection.Add(new DBParameter("@Expenses", objBOM.Expenses, System.Data.DbType.Decimal));
paramCollection.Add(new DBParameter("@SpecifyMCGenerated", objBOM.SpecifyMCGenerated, System.Data.DbType.Boolean));
paramCollection.Add(new DBParameter("@SpecifyDefaultMCforItemConsumed", objBOM.SpecifyDefaultMCforItemConsumed, System.Data.DbType.Boolean));
paramCollection.Add(new DBParameter("@AppMc", objBOM.AppMc));
paramCollection.Add(new DBParameter("@SNo", objBOM.SNo));
paramCollection.Add(new DBParameter("@ItemName", objBOM.ItemName));
paramCollection.Add(new DBParameter("@Qty", objBOM.Qty, System.Data.DbType.Decimal));
paramCollection.Add(new DBParameter("@Unit", objBOM.Unit, System.Data.DbType.Decimal));
paramCollection.Add(new DBParameter("@TotalofConsumedqtyUnit", objBOM.TotalofConsumedqtyUnit, System.Data.DbType.Decimal));
paramCollection.Add(new DBParameter("@ModifiedBy", "Admin"));
paramCollection.Add(new DBParameter("@Bom_Id", objBOM.Bom_Id));
Query = "UPDATE BillsofMaterial SET [BOMName]=@BOMName,[ItemProduct]=@ItemProduct,[Quantity]=@Quantity,[ItemUnit]=@ItemUnit,[Expenses]=@Expenses,[SpecifyMCGenerated]=@SpecifyMCGenerated, " +
"[SpecifyDefaultMCforItemConsumed]=@SpecifyDefaultMCforItemConsumed,[AppMc]=@AppMc,[SNo]=@SNo,[ItemName]=@ItemName, " +
"[Qty]=@Qty,[Unit]=@Unit,[TotalofConsumedqtyUnit]=@TotalofConsumedqtyUnit,[ModifiedBy]=@ModifiedBy " +
"WHERE BOM_Id=@BOM_Id";
if (_dbHelper.ExecuteNonQuery(Query, paramCollection) > 0)
{
isUpdated = true;
}
}
catch (Exception ex)
{
isUpdated = false;
throw ex;
}
return(isUpdated);
}
//Save
public bool SaveBOM(eSunSpeedDomain.BillofMaterialModel objBOM)
{
string Query = string.Empty;
bool isSaved = true;
try
{
DBParameterCollection paramCollection = new DBParameterCollection();
paramCollection.Add(new DBParameter("@BOMName", objBOM.BOMName));
paramCollection.Add(new DBParameter("@Itemtoproduce", objBOM.Itemtoproduce));
paramCollection.Add(new DBParameter("@Quantity", objBOM.Quantity, System.Data.DbType.Decimal));
paramCollection.Add(new DBParameter("@ItemUnit", objBOM.ItemUnit));
paramCollection.Add(new DBParameter("@Expenses", objBOM.Expenses, System.Data.DbType.Decimal));
paramCollection.Add(new DBParameter("@SpecifyMCGenerated", objBOM.SpecifyMCGenerated, System.Data.DbType.Boolean));
paramCollection.Add(new DBParameter("@SpecifyDefaultMCforItemConsumed", objBOM.SpecifyDefaultMCforItemConsumed, System.Data.DbType.Boolean));
paramCollection.Add(new DBParameter("@AppMc", objBOM.AppMc));
paramCollection.Add(new DBParameter("@IGTotalQty", objBOM.IGTotalQty, System.Data.DbType.Decimal));
paramCollection.Add(new DBParameter("@ICTotalQty", objBOM.ICTotalQty, System.Data.DbType.Decimal));
paramCollection.Add(new DBParameter("@CreatedBy", "Admin"));
paramCollection.Add(new DBParameter("@CreatedDate", DateTime.Now, DbType.DateTime));
paramCollection.Add(new DBParameter("@ModifiedBy", ""));
paramCollection.Add(new DBParameter("@ModifiedDate", DateTime.Now, DbType.DateTime));
Query = "INSERT INTO billsofmaterial(`BomName`,`Itemtoproduce`,`Quantity`,`ItemUnit`,`Expenses`,`SpecifyMCGenerated`,`SpecifyDefaultMCforItemConsumed`,`AppMc`,`IGTotalQty`,`ICTotalQty`,`CreatedBy`,`CreatedDate`,`ModifiedBy`,`ModifiedDate`) " +
"VALUES(@BOMName,@Itemtoproduce,@Quantity,@ItemUnit,@Expenses,@SpecifyMCGenerated,@SpecifyDefaultMCforItemConsumed,@AppMc,@IGTotalQty,@ICTotalQty,@CreatedBy,@CreatedDate,@ModifiedBy,@ModifiedDate)";
if (_dbHelper.ExecuteNonQuery(Query, paramCollection) > 0)
{
SaveRawMaterialConsumed(objBOM.MaterialConsumed);
SaveMaterialGenerated(objBOM.MaterialGenerated);
isSaved = true;
}
}
catch (Exception ex)
{
isSaved = false;
throw ex;
}
return(isSaved);
}
//Save
public bool SaveBOM(eSunSpeedDomain.BillofMaterialModel objBOM)
{
string Query = string.Empty;
bool isSaved = true;
try
{
DBParameterCollection paramCollection = new DBParameterCollection();
paramCollection.Add(new DBParameter("@BOMName", objBOM.BOMName));
paramCollection.Add(new DBParameter("@ItemProduct", objBOM.ItemProduct));
paramCollection.Add(new DBParameter("@Quantity", objBOM.Quantity));
paramCollection.Add(new DBParameter("@ItemUnit", objBOM.ItemUnit));
paramCollection.Add(new DBParameter("@Expenses", objBOM.Expenses));
paramCollection.Add(new DBParameter("@SpecifyMCGenerated", objBOM.SpecifyMCGenerated));
paramCollection.Add(new DBParameter("@SpecifyDefaultMCforItemConsumed", objBOM.SpecifyDefaultMCforItemConsumed));
//paramCollection.Add(new DBParameter("@AppMc", objBOM.AppMc));
//paramCollection.Add(new DBParameter("@SNo", objBOM.SNo));
//paramCollection.Add(new DBParameter("@ItemName", objBOM.ItemName));
//paramCollection.Add(new DBParameter("@Qty", objBOM.Qty, System.Data.DbType.Decimal));
//paramCollection.Add(new DBParameter("@Unit", objBOM.Unit, System.Data.DbType.Decimal));
//paramCollection.Add(new DBParameter("@TotalofConsumedqtyUnit", objBOM.TotalofConsumedqtyUnit, System.Data.DbType.Decimal));
paramCollection.Add(new DBParameter("@CreatedBy", "Admin"));
Query = "INSERT INTO BillsofMaterial(`BomName`,`ItemProduct`,`Quantity`,`ItemUnit`,`Expenses`,`SpecifyMCGenerated`,`SpecifyDefaultMCforItemConsumed`,`CreatedBy`) " +
"VALUES(@BOMName,@ItemProduct,@Quantity,@ItemUnit,@Expenses,@SpecifyMCGenerated,@SpecifyDefaultMCforItemConsumed,@CreatedBy)";
if (_dbHelper.ExecuteNonQuery(Query, paramCollection) > 0)
{
isSaved = true;
}
}
catch (Exception ex)
{
isSaved = false;
throw ex;
}
return(isSaved);
}
//update bom
public bool UpdateBOM(eSunSpeedDomain.BillofMaterialModel objBOM)
{
string Query = string.Empty;
bool isUpdated = true;
try
{
DBParameterCollection paramCollection = new DBParameterCollection();
paramCollection.Add(new DBParameter("@BOMName", objBOM.BOMName));
paramCollection.Add(new DBParameter("@Itemtoproduce", objBOM.Itemtoproduce));
paramCollection.Add(new DBParameter("@Quantity", objBOM.Quantity, System.Data.DbType.Decimal));
paramCollection.Add(new DBParameter("@ItemUnit", objBOM.ItemUnit));
paramCollection.Add(new DBParameter("@Expenses", objBOM.Expenses, System.Data.DbType.Decimal));
paramCollection.Add(new DBParameter("@SpecifyMCGenerated", objBOM.SpecifyMCGenerated, System.Data.DbType.Boolean));
paramCollection.Add(new DBParameter("@SpecifyDefaultMCforItemConsumed", objBOM.SpecifyDefaultMCforItemConsumed, System.Data.DbType.Boolean));
paramCollection.Add(new DBParameter("@AppMc", objBOM.AppMc));
paramCollection.Add(new DBParameter("@IGTotalQty", objBOM.IGTotalQty, System.Data.DbType.Decimal));
paramCollection.Add(new DBParameter("@ICTotalQty", objBOM.ICTotalQty, System.Data.DbType.Decimal));
paramCollection.Add(new DBParameter("@CreatedBy", ""));
paramCollection.Add(new DBParameter("@CreatedDate", DateTime.Now, DbType.DateTime));
paramCollection.Add(new DBParameter("@ModifiedBy", "Admin"));
paramCollection.Add(new DBParameter("@ModifiedDate", DateTime.Now, DbType.DateTime));
paramCollection.Add(new DBParameter("@BillsId", objBOM.id));
System.Data.IDataReader dr =
_dbHelper.ExecuteDataReader("spUpdateBillsOfMaterial", _dbHelper.GetConnObject(), paramCollection, System.Data.CommandType.StoredProcedure);
UpdateBillsofMaterialConsumed(objBOM.MaterialConsumed, objBOM.id);
UpdateBillsofMaterialGenerate(objBOM.MaterialGenerated, objBOM.id);
}
catch (Exception ex)
{
isUpdated = false;
throw ex;
}
return(isUpdated);
}