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); }