public void DoAction() { return; if (WasChanged) { BI.SGP.BLL.WF.Action.SendMailAction sma = new WF.Action.SendMailAction(); sma.DoAction(_activity); } }
public void SpecialSendMail(int EntityID,string VendorRFQNumber,string VendorCode) { string vendormail = ""; try { WF.WFUser user = new WF.WFUser(VendorCode); if (user != null) { vendormail = user.Email; } else { vendormail = "*****@*****.**"; } } catch { vendormail = "*****@*****.**"; } BI.SGP.BLL.WF.WFTemplate wftemplate = new WF.WFTemplate("SUPPLIERWF", EntityID, VendorRFQNumber); BI.SGP.BLL.WF.WFActivity wfactivity = wftemplate.FirstActivity; BI.SGP.BLL.WF.Action.SendMailAction sendmail = new WF.Action.SendMailAction(); sendmail.DoActionForVVI(wfactivity, VendorCode, vendormail); }
public SystemMessages AssignVVIData(int ID, string suppliercode, SystemMessages sysmgs) { this.ID = ID; //SystemMessages sysmgs = new SystemMessages(); try { string strField = "", strValue = ""; FieldInfoCollecton supplierfields = FieldCategory.GetAllFields(FieldCategory.Category_TYPE_SGPFORSUPPLIER); string number = ""; foreach (FieldInfo fi in AllMasterFields) { number += fi.FieldName == "Number" ? fi.DataValue.ToString() + "-" + suppliercode : ""; foreach (FieldInfo supplierfi in supplierfields) { if (fi.DisplayName == supplierfi.DisplayName) { if (supplierfi.FieldName == "NVARCHAR1") { fi.DataValue = number; strField += supplierfi.FieldName + ","; strValue += "'" + number + "',"; } else { strField += supplierfi.FieldName + ","; strValue += "'" + fi.DataValue.ToString() + "',"; } } } } strField += "DATETIME2,"; strValue += "GetDate(),"; string vendorname = DbHelperSQL.GetSingle<string>("select SupplierName from SYS_Supplier where SupplyCode=@SupplyCode", new SqlParameter("@SupplyCode",suppliercode)); vendorname = suppliercode + "[" + vendorname + "]"; strField += "NVARCHAR7,"; strValue += "'" + vendorname + "',"; strField = strField.TrimEnd(','); strValue = strValue.TrimEnd(','); bool existsRFQNumber = DbHelperSQL.Exists("select count(*) from SGP_SubData where NVARCHAR1=@Number and EntityName='VVIDETAIL' ", new SqlParameter("@Number", number)); if (existsRFQNumber == false) { try { int maxdataindex = -1; maxdataindex = DbHelperSQL.GetSingle<int>("select Max(DataIndex) from SGP_SubData where EntityID=" + ID.ToString() + " and EntityName='VVIDETAIL'"); maxdataindex++; string strSql = "insert into SGP_SubData(DataIndex,EntityID,EntityName," + strField + ") values(" + maxdataindex.ToString() + "," + ID.ToString() + ",'VVIDETAIL'," + strValue + ")"; DbHelperSQL.ExecuteSql(strSql); string vendormail = ""; try { WF.WFUser user = new WF.WFUser(suppliercode); if (user != null) { vendormail = user.Email; } else { vendormail = "*****@*****.**"; } } catch { vendormail = "*****@*****.**"; } // wf.Run(); sysmgs.isPass = true; sysmgs.MessageType = "Success"; sysmgs.Messages.Add("OK", number); BI.SGP.BLL.WF.WFTemplate wftemplate = new WF.WFTemplate("SUPPLIERWF", ID, number); BI.SGP.BLL.WF.WFActivity wfactivity = wftemplate.FirstActivity; BI.SGP.BLL.WF.Action.SendMailAction sendmail = new WF.Action.SendMailAction(); sendmail.DoActionForVVI(wfactivity, vendorname, vendormail); string strsql1 = "update SGP_RFQForVVI set ActivityID=102 where (ActivityID in(101) or ActivityID is null) and RFQID=@RFQID"; string strsql2 = "insert into SYS_WFProcessLog select @RFQID,3,@FromActivityID,@ToActivityID,0,GetDate(),@UserID,@Comment"; SqlParameter[] sp1 = new SqlParameter[] { new SqlParameter("@RFQID", ID) }; SqlParameter[] sp2 = new SqlParameter[] { new SqlParameter("@RFQID",ID), new SqlParameter("@FromActivityID",101), new SqlParameter("@ToActivityID",102), new SqlParameter("@UserID", BI.SGP.BLL.Utils.AccessControl.CurrentLogonUser.Uid), new SqlParameter("@Comment", "Assign RFQ")}; DbHelperSQL.ExecuteSql(strsql1, sp1.ToArray()); DbHelperSQL.ExecuteSql(strsql2, sp2.ToArray()); AddHistory(); } catch (Exception ex) { sysmgs.isPass = false; sysmgs.MessageType = "Error"; sysmgs.Messages.Add("Error",ex.Message); } } else { sysmgs.isPass = false; sysmgs.MessageType = "already exists"; sysmgs.Messages.Add("already exists", number); } } catch (Exception ex) { sysmgs.isPass = false; sysmgs.MessageType = "Error"; sysmgs.Messages.Add("Error", ex.Message); } return sysmgs; }