Ejemplo n.º 1
0
        public override bool AfterSave()
        {
            if (IsDoctorRelated == null || !Convert.ToBoolean(IsDoctorRelated))
            {
                return(true);
            }

            if (DoctorID == null)
            {
                MessageToView = "You should choose the Doctor";
                return(false);
            }

            Doctor_Diagnosis_cu bridge = DBCommon.CreateNewDBEntity <Doctor_Diagnosis_cu>();

            bridge.Diagnosis_CU_ID = ((Diagnosis_cu)ActiveCollector.ActiveDBItem).ID;
            bridge.Doctor_CU_ID    = Convert.ToInt32(DoctorID);
            if (UserID != null)
            {
                bridge.InsertedBy = Convert.ToInt32(UserID);
            }

            bridge.IsOnDuty = true;
            switch (((IDiagnosis_Viewer)ActiveCollector.ActiveViewer).CommonTransactionType)
            {
            case DB_CommonTransactionType.DeleteExisting:
                bridge.IsOnDuty = false;
                break;
            }

            bridge.IsMerkInsertion = false;
            return(bridge.SaveChanges());
        }
Ejemplo n.º 2
0
        public Drawing CreateDefaultDrawingWithFileName()
        {
            try
            {
                Drawing d = DBCommon.CreateDefaultDrawing();
                d.FileName = _db.Filename;
                try
                {
                    d.Number = Path.GetFileNameWithoutExtension(d.FileName);
                    while (DBCommon.DrawingComboExists(d.Number, d.Sheet))
                    {
                        PromptStringOptions pso = new PromptStringOptions(string.Format("Drawing {0} sheet {1} already exists. Please enter a new sheet number:", d.Number, d.Sheet));
                        string str = _ed.DoPrompt(pso).StringResult;
                        _ed.WriteMessage(str + Environment.NewLine);
                        if (str == "")
                        {
                            return(null);
                        }
                        d.Sheet = str;
                    }
                }
                catch (Exception ex) { _ed.WriteMessage(ex.ToString()); }


                return(d);
            }
            catch { return(null); }
        }
Ejemplo n.º 3
0
        public static int UserLoginByExternalGate(int ObjectTypeId, int ObjectId, string GUID, string Email)
        {
            int    UserId = DBUser.GetUserByEmail(Email, true);
            string DBGUID = DBCommon.GetGateGuid(ObjectTypeId, ObjectId, UserId);

            if (0 != string.Compare(DBGUID, GUID, true))
            {
                // Audit
                if (PortalConfig.AuditWebLogin)
                {
                    HttpRequest request  = HttpContext.Current.Request;
                    string      referrer = "";
                    if (request.UrlReferrer != null)
                    {
                        referrer = String.Concat(request.UrlReferrer.Host, request.UrlReferrer.PathAndQuery);
                    }
                    string message = String.Format(CultureInfo.InvariantCulture,
                                                   "Failed IBN portal external login.\r\n\r\nEmail: {0}\r\nGate:{1}\r\nIP: {2}\r\nReferrer: {3}",
                                                   Email,
                                                   GUID,
                                                   request.UserHostAddress,
                                                   referrer);
                    Log.WriteEntry(message, System.Diagnostics.EventLogEntryType.FailureAudit);
                }
                //

                throw new AccessDeniedException();
            }

            return(UserId);
        }
        /// <summary>
        /// Load the list of recently used templates, and add the default template
        /// </summary>
        public AddTemplateDrawingViewModel()
        {
            //load the default template
            Drawing d = DBCommon.CreateDefaultDrawing();

            _recentTemplates = new ObservableCollection <TemplateDrawingModel>();
            _recentTemplates.Add(new TemplateDrawingModel("(default)", d));

            //read the recent templates, and attempt to load them
            string[] templates = Properties.Settings.Default.RecentTemplates.Split(new char[] { ';' });
            foreach (string file in templates)
            {
                try
                {
                    if (!File.Exists(file))
                    {
                        continue;
                    }
                    _recentTemplates.Add(new TemplateDrawingModel(file));
                }
                //if we have a problem then just ignore it and continue
                //TODO: perhaps log these errors somewhere
                catch { }
            }
        }
        public static AccountingJournalEntryTransaction CreateAccountingJournalEntryTransaction(
            object accountingJournalTransaction_ID, object amount, object serial, object chartOfAccount_CU_ID, object isDebit,
            object description)
        {
            if (amount == null || serial == null || accountingJournalTransaction_ID == null ||
                chartOfAccount_CU_ID == null || isDebit == null)
            {
                return(null);
            }

            AccountingJournalEntryTransaction accountingJournalEntryTransaction =
                DBCommon.CreateNewDBEntity <AccountingJournalEntryTransaction>();

            accountingJournalEntryTransaction.Amount = Convert.ToDouble(amount);
            accountingJournalEntryTransaction.Serial = serial.ToString();
            accountingJournalEntryTransaction.AccountingJournalTransaction_ID = Convert.ToInt32(accountingJournalTransaction_ID);
            accountingJournalEntryTransaction.ChartOfAccount_CU_ID            = Convert.ToInt32(chartOfAccount_CU_ID);
            accountingJournalEntryTransaction.IsDebit = Convert.ToBoolean(isDebit);
            if (description != null)
            {
                accountingJournalEntryTransaction.Description = description.ToString();
            }

            return(accountingJournalEntryTransaction);
        }
        private void AddTemplateExecute()
        {
            Drawing d = DBCommon.CreateDefaultDrawing();

            d.Number = "";
            _recentTemplates.Add(new TemplateDrawingModel("[new template]", d));
        }
Ejemplo n.º 7
0
        public ActionResult UserActivity(string userID)
        {
            DBCommon commObj = new DBCommon();
            var      result  = commObj.UserActivity(userID, "Vmrx");

            return(Json(result, JsonRequestBehavior.AllowGet));
        }
        public static CashBoxInOutTransaction CreateCashBoxInOutTransaction(object transactionDate,
                                                                            object cashBoxTransactionType_P_ID, object chartOfAccount_CU_ID, object generalChartOfAccountType_CU_ID,
                                                                            object transactionAmount, object paymentType_P_ID, object cashBox_CU_ID, object bank_CU_ID, object bankAccount_CU_ID,
                                                                            object currency_CU_ID, object currencyExchangeRate, object transcationSerial, object description)
        {
            if (transactionDate == null || cashBoxTransactionType_P_ID == null || chartOfAccount_CU_ID == null ||
                generalChartOfAccountType_CU_ID == null || transactionAmount == null || paymentType_P_ID == null ||
                currency_CU_ID == null)
            {
                return(null);
            }

            CashBoxInOutTransaction cashBoxInOutTransaction = DBCommon.CreateNewDBEntity <CashBoxInOutTransaction>();

            cashBoxInOutTransaction.TranscationDate                 = Convert.ToDateTime(transactionDate);
            cashBoxInOutTransaction.CashBoxTransactionType_P_ID     = Convert.ToInt32(cashBoxTransactionType_P_ID);
            cashBoxInOutTransaction.ChartOfAccount_CU_ID            = Convert.ToInt32(chartOfAccount_CU_ID);
            cashBoxInOutTransaction.GeneralChartOfAccountType_CU_ID = Convert.ToInt32(generalChartOfAccountType_CU_ID);
            cashBoxInOutTransaction.TransactionAmount               = Convert.ToDouble(transactionAmount);
            cashBoxInOutTransaction.PaymentType_P_ID                = Convert.ToInt32(paymentType_P_ID);
            cashBoxInOutTransaction.Currency_CU_ID = Convert.ToInt32(currency_CU_ID);
            if (currencyExchangeRate != null)
            {
                cashBoxInOutTransaction.CurrencyExchangeRate = Convert.ToDouble(currencyExchangeRate);
            }
            if (transcationSerial != null)
            {
                cashBoxInOutTransaction.TranscationSerial = transcationSerial.ToString();
            }
            cashBoxInOutTransaction.IsCancelled = false;

            return(cashBoxInOutTransaction);
        }
        public override IEnumerable <TEntity> GetItemsList()
        {
            List <InsuranceCarrier_InsuranceLevel_cu> list =
                DBCommon.GetItemsList <InsuranceCarrier_InsuranceLevel_cu>().ToList().ToList();

            return((IEnumerable <TEntity>)list);
        }
Ejemplo n.º 10
0
        private static void ValidateSqlServerVesion()
        {
            // SQL Server 2005: 9.00.1399.06
            // SQL Server 2000 SP4: 8.00.2039
            // SQL Server 2000 SP3: 8.00.760

            bool   success       = false;
            string productVesion = DBCommon.GetSqlServerVersion();

            try
            {
                int firstDotPos  = productVesion.IndexOf(".");
                int lastDotPos   = productVesion.LastIndexOf(".");
                int majorVersion = int.Parse(productVesion.Substring(0, firstDotPos));
                int build        = int.Parse(productVesion.Substring(lastDotPos + 1));
                if (majorVersion > 8 || (majorVersion == 8 && build >= 760))
                {
                    success = true;
                }
            }
            catch
            {
            }

            if (!success)
            {
                throw new UnsupportedSqlServerVersionException();
            }
        }
Ejemplo n.º 11
0
 private void Button_Click(object sender, RoutedEventArgs e)
 {
     btnSave.Focus();//prop grid wont save unless it loses focus (which it wont if we press enter instead of click the button)
     if (propGrid.IsReadOnly)
     {
         propGrid.IsReadOnly       = false;
         btnSave.Content           = "Save and Close";
         lblEditMessage.Visibility = System.Windows.Visibility.Visible;
     }
     else
     {
         if (DBCommon.DrawingComboExists(_d.Number, _d.Sheet, _d.Id))
         {
             MessageBox.Show("A drawing with the specified number and sheet number already exists.");
         }
         else
         {
             try
             {
                 _dc.SubmitChanges();
             }
             catch (Exception ex)
             {
                 MessageBox.Show("An error has occured while trying to commit changes to the database.  A data concurrency exception may have occured, please refresh the data by re-searching." + Environment.NewLine + Environment.NewLine + ex.Message);
             }
             this.Close();
         }
     }
 }
Ejemplo n.º 12
0
        /// <summary>
        /// Fills a title blocks drawing number with the next available number, then saves it to the database
        /// (so a subsequent call to this function will give the next number, not the same one)
        /// </summary>
        public void AutoNumberBlockThenSave()
        {
            Transaction tr = _db.TransactionManager.StartTransaction();

            try
            {
                IEnumerable <BlockReference> blocks = PromptForBlock(tr);

                foreach (BlockReference blkRef in blocks)
                {
                    Dictionary <string, AttributeReference> attribs = GetBlockAttributes(blkRef, tr);

                    attribs["DRAWING-NUMBER"].TextString = DBCommon.GetNextDrawingNumber();
                    if (!BlockToDatabase(blkRef, tr))
                    {
                        _ed.WriteMessage("Could not save drawing to database, returning drawing number to the pool \n");
                        attribs["DRAWING-NUMBER"].TextString = "";
                    }
                }

                tr.Commit();
            }
            catch (Exception ex)
            {
                _ed.WriteMessage(ex.Message + "\n");
            }
            finally
            {
                tr.Dispose();
            }
        }
Ejemplo n.º 13
0
        public static void UpdateTimeline(int taskId, DateTime startDate, DateTime finishDate)
        {
            string title;
            string description;
            int    priorityId;
            bool   isMilestone;
            int    activationType;
            int    completionType;
            bool   mustBeConfirmed;
            int    phaseId;
            int    taskTime;

            using (IDataReader TaskReader = Task.GetTask(taskId))
            {
                if (TaskReader.Read())
                {
                    title           = (string)TaskReader["Title"];
                    description     = TaskReader["Description"].GetType() == typeof(DBNull) ? null: (string)TaskReader["Description"];
                    isMilestone     = (bool)TaskReader["IsMilestone"];
                    priorityId      = (int)TaskReader["PriorityId"];
                    completionType  = (int)TaskReader["CompletionTypeId"];
                    activationType  = (int)TaskReader["ActivationTypeId"];
                    mustBeConfirmed = (bool)TaskReader["MustBeConfirmed"];
                    phaseId         = DBCommon.NullToInt32(TaskReader["PhaseId"]);
                    taskTime        = (int)TaskReader["TaskTime"];
                }
                else
                {
                    throw new Exception("Task not found");
                }
            }

            ArrayList categories = new ArrayList();

            using (IDataReader reader = DBCommon.GetListCategoriesByObject((int)OBJECT_TYPE, taskId))
            {
                while (reader.Read())
                {
                    int categoryId = (int)reader["CategoryId"];
                    categories.Add(categoryId);
                }
            }

            Task.Update(
                taskId
                , title
                , description
                , startDate
                , finishDate
                , priorityId
                , isMilestone
                , activationType
                , completionType
                , mustBeConfirmed
                , categories
                , phaseId
                , taskTime
                );
        }
Ejemplo n.º 14
0
        public List <TicketExceptions> GetTicket_VoidnExpired(Tickets oTickets, List <string> lstPositions)
        {
            string strTicketInException        = string.Empty;
            List <TicketExceptions> lstTickets = null;
            TicketExceptions        excep      = null;


            try
            {
                DataTable dtTickets = cashdeskmanagerDataAccess.GetTickets(oTickets);
                if (dtTickets == null && dtTickets.Rows.Count < 0)
                {
                }
                else
                {
                    lstTickets = new List <TicketExceptions>();

                    foreach (DataRow row in dtTickets.Rows)
                    {
                        excep           = new TicketExceptions();
                        excep.SEGM      = row["PrintDevice"].ToString();
                        excep.Machine   = cashdeskmanagerDataAccess.GetBarPositionFromAsset(row["PrintDevice"].ToString());
                        excep.currValue = (float)Convert.ToDouble(row["iAmount"]) / 100;
                        if (DBCommon.CheckPositionToDisplay(excep.Machine, lstPositions))
                        {
                            excep.Position        = cashdeskmanagerDataAccess.GetBarPositionFromAsset(row["PrintDevice"].ToString());
                            excep.TransactionType = "Voucher";
                            excep.Zone            = "n/a";

                            System.Threading.Thread.CurrentThread.CurrentCulture = new System.Globalization.CultureInfo("en-GB");
                            DateTime dt = DateTime.Parse(row["dtPrinted"].ToString(),
                                                         System.Threading.Thread.CurrentThread.CurrentCulture.DateTimeFormat);
                            excep.Asset = row["Asset"].ToString();

                            //  excep.PrintDate = row["dtPrinted"].ToString().ReadDateTimeWithSeconds().ToString();
                            excep.PrintDate = Convert.ToDateTime(row["dtPrinted"]).ToString("dd MMM yyyy HH:mm:ss").ReadDateTimeWithSeconds().ToString();

                            excep.PayDate = Convert.ToDateTime(row["dtExpire"]).ToString("dd MMM yyyy HH:mm:ss").ReadDateTimeWithSeconds().ToString();
                            excep.Value   = Convert.ToDouble(row["iAmount"]) / 100;
                            //excep.Amount = (Convert.ToDouble().ToString("###0.#0") +")";
                            excep.Amount = CurrencySymbol + " " + (Convert.ToDecimal(row["iAmount"]) / 100).GetUniversalCurrencyFormat();

                            excep.Status = (row["StrVoucherStatus"].ToString().Trim().ToUpper() == "NA" ? "Auto Cancelled" :
                                            row["StrVoucherStatus"].ToString().Trim().ToUpper() == "VD" ? "Void" : row["StrVoucherStatus"].ToString().Trim().ToUpper() == "EXP" ? "Expired" : "Expired");
                            excep.cExceptionsTotal += excep.currValue;
                        }

                        lstTickets.Add(excep);
                    }
                }
            }

            catch (Exception ex)
            {
                LogManager.WriteLog(ex.Message, LogManager.enumLogLevel.Info);
                ExceptionManager.Publish(ex);
            }
            return(lstTickets);
        }
Ejemplo n.º 15
0
        public ActionResult UpdatePendingInvoiceNotifications()
        {
            DBCommon commObj    = new DBCommon();
            var      result     = commObj.GetNumwithQuery("SendInvoiceNotif", "", getUserId());
            string   displayMsg = result > 0 ? DBQueries.msgUpPendingNotifSuccess : DBQueries.msgUpPendingNotifFailed;

            return(Json(displayMsg, JsonRequestBehavior.AllowGet));
        }
Ejemplo n.º 16
0
        public static DataTable GetSystemEventsDT(DateTime StartDate, DateTime EndDate)
        {
            int TimeZoneId = Security.CurrentUser.TimeZoneId;

            StartDate = DBCommon.GetUTCDate(TimeZoneId, StartDate);
            EndDate   = DBCommon.GetUTCDate(TimeZoneId, EndDate);
            return(DBSystemEvents.GetSystemEventsDT(Security.CurrentUser.UserID, StartDate, EndDate, TimeZoneId));
        }
Ejemplo n.º 17
0
        public ActionResult UpdateResendInvNotif(InvNotifications ResendNotifications)
        {
            DBCommon  commObj   = new DBCommon();
            DBQueries dbQueries = new DBQueries();
            string    query     = string.Format(dbQueries.sqlUpdateResendInvoiceNotif, ResendNotifications.PharmacyCode, ResendNotifications.FacilityCode, ResendNotifications.Email, getUserId());
            int       result    = commObj.GetNumwithQuery("UpdateResend", query, getUserId());

            return(Json(result, JsonRequestBehavior.AllowGet));
        }
Ejemplo n.º 18
0
        /// <summary>
        /// Reader returns fields:
        ///		GroupId, GroupName, HasChildren
        /// </summary>
        public static IDataReader GetListGroupsBySubstring(string SubString)
        {
            // O.R. [2008-08-21]: Wildcard chars replacing
            SubString = DBCommon.ReplaceSqlWildcard(SubString);
            //

            return(DbHelper2.RunSpDataReader("GroupsSearch",
                                             DbHelper2.mp("@SubString", SqlDbType.NVarChar, 50, @SubString)));
        }
Ejemplo n.º 19
0
        string getManager(string id)
        {
            CoreClass.DBCommon db   = new DBCommon();
            string             sql  = "select chuliren from Bank_tixian where id =" + id;
            DataTable          dt   = db.GetDataTableBySql(sql);
            string             temp = dt.Rows[0][0].ToString();

            return(temp);
        }
        private void btnAddToList_Click(object sender, EventArgs e)
        {
            if (spnAmount.EditValue == null || Math.Abs(Convert.ToDouble(spnAmount.EditValue)) < 0.0001)
            {
                return;
            }

            if (CashBoxInOutTransactionsList == null)
            {
                CashBoxInOutTransactionsList = new List <CashBoxInOutTransaction>();
            }

            CashBoxInOutTransaction cashBoxInOutTransaction = DBCommon.CreateNewDBEntity <CashBoxInOutTransaction>();

            if (CashBoxTransactionType_P_ID != null)
            {
                cashBoxInOutTransaction.CashBoxTransactionType_P_ID = Convert.ToInt32(CashBoxTransactionType_P_ID);
            }
            if (TransactionAmount != null)
            {
                cashBoxInOutTransaction.TransactionAmount = chkExpenses.Checked || chkReverseRevenue.Checked
                                        ? Convert.ToDouble(TransactionAmount) * -1
                                        : Convert.ToDouble(TransactionAmount);
            }
            if (TranscationSerial != null)
            {
                cashBoxInOutTransaction.TranscationSerial = TranscationSerial.ToString();
            }
            if (Description != null)
            {
                cashBoxInOutTransaction.Description = Description.ToString();
            }
            if (TranscationDate != null)
            {
                cashBoxInOutTransaction.TranscationDate = Convert.ToDateTime(TranscationDate);
            }
            if (ApplicationStaticConfiguration.ActiveCashBox != null)
            {
                cashBoxInOutTransaction.CashBox_CU_ID = ApplicationStaticConfiguration.ActiveCashBox.ID;
            }

            cashBoxInOutTransaction.AddedType = AddedType.NewelyAdded;

            CashBoxInOutTransactionsList.Add(cashBoxInOutTransaction);
            listToBeViewedOnly.Clear();

            listToBeViewedOnly.AddRange(CashBoxInOutTransaction.ItemsList.FindAll(item =>
                                                                                  !Convert.ToInt32(item.AddedType).Equals(Convert.ToInt32(AddedType.Removed))));
            listToBeViewedOnly.AddRange(CashBoxInOutTransactionsList.FindAll(item =>
                                                                             !Convert.ToInt32(item.AddedType).Equals(Convert.ToInt32(AddedType.Removed))));

            grdCashBoxInOutTransactions.DataSource = listToBeViewedOnly.OrderByDescending(item => item.TranscationDate);
            grdCashBoxInOutTransactions.RefreshDataSource();
            gridView7.SelectRow(-1);
            ClearControls();
        }
Ejemplo n.º 21
0
 public override bool CreateNew()
 {
     if (ActiveDBItem == null)
     {
         ActiveDBItem = DBCommon.CreateNewDBEntity <InventoryItem_UnitMeasurment_cu>();
         ((IInventoryItem_UnitMeasurment_Viewer)ActiveCollector.ActiveViewer).CommonTransactionType = DB_CommonTransactionType.SaveNew;
         return(true);
     }
     return(false);
 }
Ejemplo n.º 22
0
 public override bool CreateNew()
 {
     if (ActiveDBItem == null)
     {
         ActiveDBItem = DBCommon.CreateNewDBEntity <InPatientRoomBed_cu>();
         ((IInPatientRoomBedViewer)ActiveCollector.ActiveViewer).CommonTransactionType = DB_CommonTransactionType.SaveNew;
         return(true);
     }
     return(false);
 }
 public override bool CreateNew()
 {
     if (ActiveDBItem == null)
     {
         ActiveDBItem = DBCommon.CreateNewDBEntity <InsuranceCarrier_InsuranceLevel_cu>();
         ((IInsurancePolicyViewer)ActiveCollector.ActiveViewer).CommonTransactionType = DB_CommonTransactionType.SaveNew;
         return(true);
     }
     return(false);
 }
Ejemplo n.º 24
0
 // Internal
 #region Load(IDataReader reader)
 internal void Load(IDataReader reader)
 {
     FieldId   = (int)reader["FieldId"];
     BitField  = (bool)reader["BitField"];
     IbnName   = reader["IbnName"].ToString();
     LdapName  = reader["LdapName"].ToString();
     BitMask   = DBCommon.NullToInt32(reader["BitMask"]);
     Equal     = (bool)DBCommon.NullToObject(reader["Equal"], true);
     CompareTo = DBCommon.NullToInt32(reader["CompareTo"]);
 }
Ejemplo n.º 25
0
        string getCpUser()
        {
            string uid = Request.Cookies["userid"].Value;
            string sql = "select * from z8 where id = " + uid;

            CoreClass.DBCommon db = new DBCommon();
            DataTable          dt = db.GetDataTableBySql(sql);

            return(dt.Rows[0]["name"].ToString());
        }
 public override bool CreateNew()
 {
     if (ActiveDBItem == null)
     {
         ActiveDBItem = DBCommon.CreateNewDBEntity <User_UserGroup_cu>();
         ((IUser_UserGroup_Viewer)ActiveCollector.ActiveViewer).CommonTransactionType = DB_CommonTransactionType.SaveNew;
         return(true);
     }
     return(false);
 }
Ejemplo n.º 27
0
        /// <summary>
        /// Reader returns fields:
        ///		GroupId, GroupName, HasChildren
        /// </summary>
        public static IDataReader GetListGroupsBySubstringForPartner(string SubString, int UserId)
        {
            // O.R. [2008-08-21]: Wildcard chars replacing
            SubString = DBCommon.ReplaceSqlWildcard(SubString);
            //

            return(DbHelper2.RunSpDataReader("GroupsSearchForPartner",
                                             DbHelper2.mp("@SubString", SqlDbType.NVarChar, 50, @SubString),
                                             DbHelper2.mp("@PrincipalId", SqlDbType.Int, UserId)));
        }
 public override bool CreateNew()
 {
     if (ActiveDBItem == null)
     {
         ActiveDBItem = DBCommon.CreateNewDBEntity <FinanceInvoice>();
         ((IFinanceInvoiceCreation)ActiveCollector.ActiveViewer).CommonTransactionType = DB_CommonTransactionType.SaveNew;
         return(true);
     }
     return(false);
 }
Ejemplo n.º 29
0
        protected override int CreateSystemRow(FillDataMode mode, params object[] item)
        {
            if (mode == FillDataMode.Update)
            {
                throw new NotSupportedException("Update is not supported for Incident import");
            }
            string   Description  = "";
            string   Resolution   = "";
            string   Workaround   = "";
            string   Title        = "Imported incident " + DateTime.Now.ToString("d");
            DateTime CreationDate = DateTime.UtcNow;
            int      PriorityId   = int.Parse(PortalConfig.IncidentDefaultValuePriorityField);
            int      TypeId       = int.Parse(PortalConfig.IncidentDefaultValueTypeField);
            int      SeverityId   = int.Parse(PortalConfig.IncidentDefaultValueSeverityField);;

            if (item[0] != null)
            {
                Title = (string)item[0];
            }

            if (item[2] != null)
            {
                CreationDate = DBCommon.GetUTCDate(Security.CurrentUser.TimeZoneId, (DateTime)item[2]);
            }
            if (item[1] != null)
            {
                Description = (string)item[1];
            }
            if (item[6] != null)
            {
                Resolution = (string)item[6];
            }
            if (item[7] != null)
            {
                Workaround = item[7].ToString();
            }
            if (item[3] != null)
            {
                PriorityId = GetPriorityId((string)item[3]);
            }
            if (item[4] != null)
            {
                TypeId = GetTypeId((string)item[4]);
            }
            if (item[5] != null)
            {
                SeverityId = GetSeverityId((string)item[5]);
            }

            int IncidentId = Incident.Create(Title, Description, TypeId, PriorityId, SeverityId, Security.CurrentUser.UserID, CreationDate);

            //Issue2.UpdateResolutionInfo(IncidentId, Resolution, Workaround);

            return(IncidentId);
        }
 private void mnuRemovePlugin2015_Click(object sender, RoutedEventArgs e)
 {
     try
     {
         DBCommon.RemovePlugin(AcadVersion.ACAD2015);
     }
     catch (Exception ex)
     {
         MessageBox.Show(ex.Message);
     }
 }
Ejemplo n.º 31
0
        /// <summary>
        /// 进行 Token 请求,将值存储在静态类中
        /// </summary>
        public static void RequestServiceToken()
        {
            //表示 请求 成功与否
            bool flag = false;

            //1.请求 Token
            string url = "https://api.weixin.qq.com/cgi-bin/token";

            //2.带参数

            var dnmXML = XMLHelper.LoadConfigXML("SystemConfigXML");

            var par = new
            {
                grant_type = "client_credential",
                appid = dnmXML.SystemConfig.AppID,
                secret = dnmXML.SystemConfig.AppSecret
            };

            RequestHelper _requestHelper = new RequestHelper();

            string strPar = _requestHelper.JoinArguments(par);

            //接收准备
            string s_access_token = string.Empty;
            string s_expires_in = string.Empty;

            //3.请求
            using (HttpClient htpClt = new HttpClient())
            {
                string rqtResult = htpClt.GetStringAsync(new Uri(url + strPar)).Result;

                dynamic dnm = JsonConvert.DeserializeObject(rqtResult);

                if (dnm.errorcode != null)
                {
                    flag = false; //失败
                }
                else
                {
                    flag = true; //成功
                    s_access_token = dnm.access_token;
                    s_expires_in = dnm.expires_in;
                }
            }

            if (flag)
            {
                //4.给静态对象赋值
                TokenEntity.Token = s_access_token;
                TokenEntity.DateLength = int.Parse(s_expires_in);
                TokenEntity.ExpiresDate = DateTime.Now.AddSeconds(TokenEntity.DateLength);
            }
        }
Ejemplo n.º 32
0
        /// <summary>
        /// 注册按钮 - 需要将按钮配置信息存入XML中
        /// </summary>
        /// <returns></returns>
        public ActionResult RegisterMenu()
        {
            //将菜单信息配置到XML中
            List<object> buttonList = new List<object>();

            //第一顺序菜单
            buttonList.Add(
                new
                {
                    type = "click",
                    name = "精彩推荐",
                    key = "zzsc_BestArticle"
                }
            );
            //第二顺序菜单
            buttonList.Add(
                new
                {
                    type = "view",
                    name = "智种商城",
                    url = "http://inovoseed.com/WeShop/Main"
                }
            );
            //第三顺序菜单

            buttonList.Add(
                new
                {
                    name = "了解我们",
                    sub_button = new List<object>()
                    {
                        new { type = "view",name = "公司简介",url = "http://123.56.205.75:8123/zzwIntro.html"},
                        new { type = "click",name = "联系我们",key = "zzsc_Contect"}
                    }
                }
            );

            var objMenu = new { button = buttonList };

            return Content(RequestRegisterMenu(objMenu));
        }
Ejemplo n.º 33
0
        /// <summary>
        /// 获取所有素材?
        /// </summary>
        /// <param name="par1">从全部素材的该偏移位置开始返回,0表示从第一个素材返回</param>
        /// <param name="par2">返回素材的数量,取值在1到20之间</param>
        /// <returns></returns>
        public ActionResult RequestMaterialList(string par1, string par2)
        {
            string strResult = "请求失败!";

            if (string.IsNullOrEmpty(par1) || string.IsNullOrEmpty(par2))
            { //都为空
                return Content(strResult);
            }

            //参数准备
            string offset = par1;
            string count = par2;
            string token = tokenOpe.GetToken();
            string url = "https://api.weixin.qq.com/cgi-bin/material/batchget_material?access_token=";
            object param = new { type = "news", offset = offset, count = count };
            //请求
            using (WebClient wc = new WebClient())
            {
                Encoding enc = Encoding.UTF8;
                strResult = enc.GetString(wc.UploadData(new Uri(url + token), enc.GetBytes(JsonConvert.SerializeObject(param))));
            }

            return Content(strResult);
        }
Ejemplo n.º 34
0
        /// <summary>
        /// 自定义菜单创建接口
        /// </summary>
        /// <returns></returns>
        public ActionResult RequestCreateMenu()
        {
            string strResult = string.Empty;

            //1.获取 Token
            string token = tokenOpe.GetToken();

            //2.api地址
            string url = "https://api.weixin.qq.com/cgi-bin/menu/create?access_token=";

            //3.准备发送信息
            List<object> buttonList = new List<object>();

            #region 按照顺序添加菜单
            //第一顺序菜单
            buttonList.Add(
                new
                {
                    name = "公司概况",
                    sub_button = new List<object>()
                    {
                        new { type = "view",name = "公司简介",url = "http://101.200.140.102:8123/"},
                        new { type = "click",name = "经典回顾",key = "xrhf_BestArticle"}
                    }
                }
            );
            //第二顺序菜单
            buttonList.Add(
                new
                {
                    type = "view",
                    name = "智种商城",
                    url = "http://101.200.140.102:8123/zzwIntro.html"
                }
            );
            //第三顺序菜单
            buttonList.Add(
                new
                {
                    type = "click",
                    name = "联系我们",
                    key = "xrhf_Contect"
                }
            );

            var postParam = new { button = buttonList };
            #endregion

            string strJson = JsonConvert.SerializeObject(postParam);

            //4.发送请求
            using (WebClient wc = new WebClient())
            {
                Encoding enc = Encoding.UTF8;
                strResult = enc.GetString(wc.UploadData(new Uri(url + token), enc.GetBytes(strJson)));
            }

            return Content(strResult);
        }
Ejemplo n.º 35
0
        /// <summary>
        /// 获取openid
        /// Remark:校验code
        /// </summary>
        public Tuple<bool, string> GetOpenidAndAccessToken(HttpContextBase _base)
        {
            if (!string.IsNullOrEmpty(_base.Request["code"]))
            {
                //获取code码,以获取openid和access_token
                string code = _base.Request["code"];
                GetOpenidAndAccessTokenFromCode(_base, code);

                return new Tuple<bool, string>(true, string.Empty);
            }
            else
            {
                //构造网页授权获取code的URL
                string url = "https://open.weixin.qq.com/connect/oauth2/authorize";
                string host = _base.Request.Url.Host;
                string path = _base.Request.Path;
                string redirect_uri = HttpUtility.UrlEncode("http://" + host + path);

                var par = new
                {
                    appid = ZZSCResource.DnmSystemConfig.SystemConfig.AppID,
                    redirect_uri = redirect_uri,
                    response_type = "code",
                    scope = ZZSCResource.DnmSystemConfig.SystemConfig.scope,
                    state = "STATE" + "#wechat_redirect"
                };

                //Log
                string strPar = new RequestHelper().JoinArguments(par);

                //跳转
                return new Tuple<bool, string>(false, url + strPar);
            }
        }
Ejemplo n.º 36
0
        /// <summary>
        /// 注册 自定义菜单事件
        /// </summary>
        /// <param name="id">token</param>
        /// <returns></returns>
        public ActionResult RegisterSelfMenu()
        {
            string strResult = "注册失败";

            string token = tokenOpe.GetToken();

            //请求的路径
            string url = "https://api.weixin.qq.com/cgi-bin/menu/create?access_token=";

            //提交的内容
            List<object> buttonList = new List<object>();

            #region 按照顺序添加菜单
            //第一顺序菜单
            buttonList.Add(
                new
                {
                    name = "了解我们",
                    sub_button = new List<object>()
                    {
                        new { type = "view",name = "公司简介",url = "http://101.200.140.102:8123/"},
                        new { type = "click",name = "经典回顾",key = "xrhf_BestArticle"}
                    }
                }
            );
            //第二顺序菜单
            buttonList.Add(
                new
                {
                    type = "view",
                    name = "智种商城",
                    url = "http://101.200.140.102:8123/zzwIntro.html"
                }
            );
            //第三顺序菜单
            buttonList.Add(
                new
                {
                    type = "click",
                    name = "联系我们",
                    key = "xrhf_Contect"
                }
            );

            var registerValue = new { button = buttonList };
            #endregion

            //请求
            using (WebClient wc = new WebClient())
            {
                Encoding enc = Encoding.UTF8;
                strResult = enc.GetString(wc.UploadData(new Uri(url + token), enc.GetBytes(JsonConvert.SerializeObject(registerValue))));

                dynamic dnm = JsonConvert.DeserializeObject(strResult);

                if (dnm.errmsg == "ok" && dnm.errcode == "0")
                {
                    strResult = "注册成功!";
                }
                else
                {
                    strResult = dnm.ToString();
                }
            }

            return Content(strResult);
        }
Ejemplo n.º 37
0
        /// <summary>
        /// 根据Code取出 access_token、openid 值
        /// Remark:存储到Session中
        /// </summary>
        /// <param name="code"></param>
        public void GetOpenidAndAccessTokenFromCode(HttpContextBase _base, string code)
        {
            //Result Data
            string access_token = string.Empty;
            string openid = string.Empty;

            //Init Data
            bool flag = false;
            string url = "https://api.weixin.qq.com/sns/oauth2/access_token";

            var par = new
            {
                appid = ZZSCResource.DnmSystemConfig.SystemConfig.AppID,
                secret = ZZSCResource.DnmSystemConfig.SystemConfig.AppSecret,
                code = code,
                grant_type = "authorization_code"
            };

            string strPar = new RequestHelper().JoinArguments(par);

            //Request
            using (HttpClient htpClt = new HttpClient())
            {
                string rqtResult = htpClt.GetStringAsync(new Uri(url + strPar)).Result;

                dynamic dnm = JsonConvert.DeserializeObject(rqtResult);

                if (dnm.errorcode != null)
                {
                    flag = false; //失败
                }
                else
                {
                    flag = true; //成功
                    access_token = dnm.access_token;
                    openid = dnm.openid;

                    _base.Session["access_token"] = access_token;
                    _base.Session["openid"] = openid;
                }
            }
        }
Ejemplo n.º 38
0
        /// <summary>
        /// 根据 MediaID 请求素材
        /// </summary>
        /// <param name="mediaID"></param>
        /// <returns></returns>
        public static string RequestArticleItemByID(string mediaID)
        {
            //Result Data
            string strResult = string.Empty;

            //Init Data
            string token = new TokenOpe().GetToken();
            string url = "https://api.weixin.qq.com/cgi-bin/material/get_material?access_token=";

            //Post Data
            object param = new { media_id = mediaID };

            //请求
            using (WebClient wc = new WebClient())
            {
                Encoding enc = Encoding.UTF8;
                strResult = enc.GetString(wc.UploadData(new Uri(url + token), enc.GetBytes(JsonConvert.SerializeObject(param))));
            }

            return strResult;
        }
Ejemplo n.º 39
0
        /// <summary>
        /// 根据 起始时间 + 结束时间 查询图文总分析结果
        /// </summary>
        /// <param name="par1">起始时间</param>
        /// <param name="par2">截止时间</param>
        /// <param name="par3">查询接口类型 推荐:1</param>
        /// <returns></returns>
        public ActionResult RequestArticleUserRead(string par1, string par2, string par3)
        {
            DateTime startDate;
            DateTime endDate;

            DateTime.TryParse(par1, out startDate);
            DateTime.TryParse(par2, out endDate);
            string token = tokenOpe.GetToken();
            string strResult = string.Empty;

            //测试 - 接口类别
            string type = par3;

            //请求的路径
            string url = "";

            switch (type)
            {
                case "":
                    url = "https://api.weixin.qq.com/datacube/getarticlesummary?access_token=";
                    break;
                case "1":
                    url = "https://api.weixin.qq.com/datacube/getarticlesummary?access_token=";
                    break;
                case "2":
                    url = "https://api.weixin.qq.com/datacube/getarticletotal?access_token=";
                    break;
                case "3":
                    url = "https://api.weixin.qq.com/datacube/getuserread?access_token=";
                    break;
                case "4":
                    url = "https://api.weixin.qq.com/datacube/getuserreadhour?access_token=";
                    break;
                case "5":
                    url = "https://api.weixin.qq.com/datacube/getusershare?access_token=";
                    break;
                case "6":
                    url = "https://api.weixin.qq.com/datacube/getusersharehour?access_token=";
                    break;
                default:
                    break;
            }

            //提交的内容
            var postParam = new
            {
                begin_date = startDate,
                end_date = endDate
            };

            //请求
            using (WebClient wc = new WebClient())
            {
                Encoding enc = Encoding.UTF8;
                strResult = enc.GetString(wc.UploadData(new Uri(url + token), enc.GetBytes(JsonConvert.SerializeObject(postParam))));
            }

            return Content(strResult);
        }
Ejemplo n.º 40
0
        /// <summary>
        /// 用地址信息
        /// </summary>
        /// <returns></returns>
        public string GetEditAddressParameters(HttpContextBase _base)
        {
            string parameter = "";
            try
            {
                string host = _base.Request.Url.Host;
                string path = _base.Request.Path;
                string queryString = _base.Request.Url.Query;
                //这个地方要注意,参与签名的是网页授权获取用户信息时微信后台回传的完整url
                string url = "http://" + host + path + queryString;

                //构造需要用SHA1算法加密的数据
                var par = new
                {
                    accesstoken = _base.Session["access_token"],
                    appid = ZZSCResource.DnmSystemConfig.SystemConfig.AppID,
                    noncestr = TokenHelper.GenerateNonceStr(),
                    timestamp = TokenHelper.GenerateTimeStamp(),
                    url = url
                };

                string param = new RequestHelper().JoinArguments(par);

                //Log.Debug(this.GetType().ToString(), "SHA1 encrypt param : " + param);
                //SHA1加密
                string addrSign = FormsAuthentication.HashPasswordForStoringInConfigFile(param.TrimStart('?'), "SHA1");
                //Log.Debug(this.GetType().ToString(), "SHA1 encrypt result : " + addrSign);

                //获取收货地址js函数入口参数
                var parNa = new
                {
                    addrSign = addrSign,
                    appId = ZZSCResource.DnmSystemConfig.SystemConfig.AppID,
                    noncestr = TokenHelper.GenerateNonceStr(),
                    timestamp = TokenHelper.GenerateTimeStamp(),
                    scope = "jsapi_address",
                    signType = "sha1"
                };

                SortedDictionary<string, object> dicPar = new SortedDictionary<string, object>();
                dicPar.Add("addrSign", addrSign);
                dicPar.Add("appId", ZZSCResource.DnmSystemConfig.SystemConfig.AppID);
                dicPar.Add("noncestr", TokenHelper.GenerateNonceStr());
                dicPar.Add("timestamp", TokenHelper.GenerateTimeStamp());
                dicPar.Add("scope", "jsapi_address");
                dicPar.Add("signType", "sha1");

                //转为json格式
                parameter = JsonConvert.SerializeObject(parNa);
                //parameter = JsonMapper.ToJson(dicPar);
                //Log.Debug(this.GetType().ToString(), "Get EditAddressParam : " + parameter);
            }
            catch (Exception ex)
            {
                //Log.Error(this.GetType().ToString(), ex.ToString());
                DBCommon.LogFileHelper.WriteLogByTxt(string.Format("GetEditAddressParameters方法异常:{0}", ex.ToString()));
                throw new Exception(ex.ToString());
            }

            return parameter;
        }