public Boolean ApproveProductModel(productmodels pmodel, string modelNo)
{
Boolean status = true;
string utString = "";
try
{
string updateSQL = "update ProductModel set DocumentStatus=99" +
", Status=1" +
", ModelNo='" + modelNo + "'" +
", ApproveUser='******'" +
" where StockItemID='" + pmodel.StockItemID + "'" +
" and RowID = " + pmodel.rowID;
utString = utString + updateSQL + Main.QueryDelimiter;
utString = utString +
ActivityLogDB.PrepareActivityLogQquerString("approve", "ProductModel", "", updateSQL) +
Main.QueryDelimiter;
if (!UpdateTable.UT(utString))
{
status = false;
}
}
catch (Exception)
{
status = false;
}
return(status);
}
public Boolean reverseProductModel(productmodels prevpmodel)
{
Boolean status = true;
string utString = "";
try
{
string updateSQL = "update ProductModel set DocumentStatus=" + prevpmodel.DocumentStatus +
", forwardUser='******'" +
", ForwarderList='" + prevpmodel.ForwarderList + "'" +
" where StockItemID='" + prevpmodel.StockItemID + "'" +
" and RowID = " + prevpmodel.rowID;
utString = utString + updateSQL + Main.QueryDelimiter;
utString = utString +
ActivityLogDB.PrepareActivityLogQquerString("update", "ProductModel", "", updateSQL) +
Main.QueryDelimiter;
if (!UpdateTable.UT(utString))
{
status = false;
}
}
catch (Exception)
{
status = false;
}
return(status);
}
public Boolean validateProductModel(productmodels pmodel)
{
Boolean status = true;
try
{
if (pmodel.StockItemID.Trim().Length == 0 || pmodel.StockItemID == null)
{
return(false);
}
if (pmodel.Remarks.Trim().Length == 0 || pmodel.Remarks == null)
{
return(false);
}
if (pmodel.ModelName.Trim().Length == 0 || pmodel.ModelName == null)
{
return(false);
}
}
catch (Exception)
{
MessageBox.Show("Failed to insert product model.");
}
return(status);
}
public Boolean updateProductModels(productmodels pmodel, productmodels prevpmodel)
{
Boolean status = true;
string utString = "";
try
{
string updateSQL = "update ProductModel set ModelDetails='" + pmodel.ModelName + "'" +
", StockItemID='" + pmodel.StockItemID +
"', Remarks ='" + pmodel.Remarks +
"', ForwarderList='" + pmodel.ForwarderList +
"' where RowID=" + prevpmodel.rowID;
utString = utString + updateSQL + Main.QueryDelimiter;
utString = utString +
ActivityLogDB.PrepareActivityLogQquerString("update", "ProductModel", "", updateSQL) +
Main.QueryDelimiter;
if (!UpdateTable.UT(utString))
{
status = false;
}
}
catch (Exception)
{
status = false;
}
return(status);
}
public Boolean insertProductModel(productmodels pmodel)
{
Boolean status = true;
string utString = "";
try
{
string updateSQL = "insert into ProductModel " +
" (ModelNo,ModelName,StockItemID,Remarks," +
"DocumentStatus,Status,CreateUser,CreateTime,ForwarderList)" +
"values (" +
"'0'," +
"'" + pmodel.ModelName + "'," +
"'" + pmodel.StockItemID + "'," +
"'" + pmodel.Remarks + "'," +
pmodel.DocumentStatus + "," +
pmodel.Status + "," +
"'" + Login.userLoggedIn + "'," +
"GETDATE()" +
",'" + pmodel.ForwarderList + "')";
//"'" + pheader.ForwardUser + "'," +
//"'" + pheader.ApproveUser + "'," +
utString = utString + updateSQL + Main.QueryDelimiter;
utString = utString +
ActivityLogDB.PrepareActivityLogQquerString("insert", "ProductModel", "", updateSQL) +
Main.QueryDelimiter;
if (!UpdateTable.UT(utString))
{
status = false;
}
}
catch (Exception)
{
status = false;
}
return(status);
}
public List <productmodels> getFilteredModelName(string userList, int opt, string stockid)
{
productmodels pmodel;
List <productmodels> pmodelList = new List <productmodels>();
try
{
string query1 = "select RowID,ModelNo,ModelName," +
" StockItemID,StockItemName,Remarks," +
" Status,DocumentStatus,CreateTime, " +
"CreateUser,ForwardUser,ApproveUser,CreatorName,ForwarderName,ApproverName , ForwarderList" +
" from ViewProductModel" +
" where ((ForwardUser='******' and DocumentStatus between 2 and 98 and StockItemID = '" + stockid + "') " +
" or (CreateUser='******' and DocumentStatus=1 and StockItemID = '" + stockid + "'))";
string query2 = "select RowID,ModelNo,ModelName," +
" StockItemID,StockItemName,Remarks," +
" Status,DocumentStatus,CreateTime, " +
"CreateUser,ForwardUser,ApproveUser,CreatorName,ForwarderName,ApproverName , ForwarderList" +
" from ViewProductModel" +
" where ((createuser='******' and DocumentStatus between 2 and 98 and StockItemID = '" + stockid + "') " +
" or (ForwarderList like '%" + userList + "%' and DocumentStatus between 2 and 98 and ForwardUser <> '" + Login.userLoggedIn + "' and StockItemID = '" + stockid + "'))";
string query3 = "select RowID,ModelNo,ModelName," +
" StockItemID,StockItemName,Remarks," +
" Status,DocumentStatus,CreateTime, " +
"CreateUser,ForwardUser,ApproveUser,CreatorName,ForwarderName,ApproverName , ForwarderList" +
" from ViewProductModel" +
" where ((createuser='******'" +
" or ForwarderList like '%" + userList + "%'" +
" or approveUser='******')" +
" and DocumentStatus = 99 and StockItemID = '" + stockid + "')";
string query6 = "select RowID,ModelNo,ModelName," +
" StockItemID,StockItemName,Remarks," +
" Status,DocumentStatus,CreateTime, " +
"CreateUser,ForwardUser,ApproveUser,CreatorName,ForwarderName,ApproverName , ForwarderList" +
" from ViewProductModel" +
" where DocumentStatus = 99 and Status = 1 and StockItemID = '" + stockid + "'";
SqlConnection conn = new SqlConnection(Login.connString);
string query = "";
switch (opt)
{
case 1:
query = query1;
break;
case 2:
query = query2;
break;
case 3:
query = query3;
break;
case 6:
query = query6;
break;
default:
query = "";
break;
}
SqlCommand cmd = new SqlCommand(query, conn);
conn.Open();
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
pmodel = new productmodels();
pmodel.rowID = reader.GetInt32(0);
pmodel.ModelNo = reader.GetString(1);
pmodel.ModelName = reader.GetString(2);
pmodel.StockItemID = reader.GetString(3);
pmodel.StockItemName = reader.GetString(4);
pmodel.Remarks = reader.GetString(5);
pmodel.Status = reader.GetInt32(6);
pmodel.DocumentStatus = reader.GetInt32(7);
pmodel.CreateTime = reader.GetDateTime(8);
pmodel.CreateUser = reader.GetString(9);
pmodel.ForwardUser = reader.GetString(10);
pmodel.ApproveUser = reader.GetString(11);
pmodel.CreatorName = reader.GetString(12);
pmodel.ForwarderName = reader.GetString(13);
pmodel.ApproverName = reader.GetString(14);
if (!reader.IsDBNull(15))
{
pmodel.ForwarderList = reader.GetString(15);
}
else
{
pmodel.ForwarderList = "";
}
pmodelList.Add(pmodel);
}
conn.Close();
}
catch (Exception)
{
MessageBox.Show("Error querying Product Model Data");
}
return(pmodelList);
}
