public string ShowProductDocumation(string pName, string pType, string pDocumation)
{
if (pNameList.Contains(pName) && pTypeList.Contains(pType) && pDocumationList.Contains(pDocumation))
{
if (pDocumation == "Produkt infomation")
{
ProductInfo pi = new ProductInfo(pName, pType);
return pi.ToString();
}
else if (pDocumation == "Opskirft")
{
Recipe r = new Recipe(pName, pType);
return r.ToString();
}
else if (pDocumation == "Correspondance")
{
}
else if (pDocumation == "QualityAssurance")
{
}
//database metode til at give data tilbage i en string
}
return null;
}
public int InsertProduct(ProductInfo product)
{
SqlConnection conn;
int count = 0;
using (conn = SqlHelper.CreateConntion())
{
conn.Open();
SqlTransaction trans = conn.BeginTransaction();
try
{
count = DAL.InsertProduct(product, trans);
trans.Commit();
}
catch (Exception)
{
trans.Rollback();
}
conn.Close();
}
return count;
}
public int UpdateProduct(ProductInfo product, SqlTransaction trans)
{
string sql = @"UPDATE [Product]
SET [ProductNO] = @ProductNO
,[ProductName] = @ProductName
,[CategoryID] = @CategoryID
,[ProductSKU] = @ProductSKU
,[ProductDetail] = @ProductDetail
,[Price] = @Price
,[SailPrice] = @SailPrice
,[Place] = @Place
,[SaveTime] = @SaveTime
,[Define1] = @Define1
,[Define2] = @Define2
,[Define3] = @Define3
,[UpdateDateTime] = @UpdateDateTime
,[UpdateUser] = @UpdateUser
WHERE id=@id";
SqlParameter[] spvalues = DBTool.GetSqlPm(product);
return SqlHelper.ExecuteNonQuery(trans, System.Data.CommandType.Text, sql, spvalues);
}
public int InsertProduct(ProductInfo product, SqlTransaction trans)
{
string sql = @"INSERT INTO [Product]
([ProductNO]
,[ProductName]
,[CategoryID]
,[ProductSKU]
,[ProductDetail]
,[Price]
,[SailPrice]
,[Place]
,[SaveTime]
,[Define1]
,[Define2]
,[Define3]
,[InsertDateTime]
,[InsertUser])
VALUES
(@ProductNO
,@ProductName
,@CategoryID
,@ProductSKU
,@ProductDetail
,@Price
,@SailPrice
,@Place
,@SaveTime
,@Define1
,@Define2
,@Define3
,@InsertDateTime
,@InsertUser)";
SqlParameter[] spvalues = DBTool.GetSqlPm(product);
return SqlHelper.ExecuteNonQuery(trans, System.Data.CommandType.Text, sql, spvalues);
}
