Exemple #1
0
        public static string Tags(string tekst, RescueTekniq.BOL.FAB item)
        {
            string        res = "";
            StringBuilder sb  = new StringBuilder();

            sb.Append(tekst);
            sb.Replace("[VARE.TYPE]", "FAB/FirstAidBag");

            sb.Replace("[FAB.ANSVARLIG]", item.ResponsibleName);
            sb.Replace("[FAB.ANSVARLIG.NAVN]", item.ResponsibleName);
            sb.Replace("[FAB.ANSVARLIG.EMAIL]", item.ResponsibleEmail);
            sb.Replace("[FAB.ANSVARLIG.TELEFON]", item.ResponsiblePhone);
            sb.Replace("[FAB.NOTE]", item.Note);

            sb.Replace("[FAB.PDF.LINK]", "<a href='[FAB.PDF]' target='_Blank'>LINK</a>");
            sb.Replace("[FAB.PDF]", item.PDF);

            sb.Replace("[FAB.SERVICEDATE]", Combobox.GetTitleByValue("Combobox.Måneder", System.Convert.ToString(item.ServiceDate)));

            sb.Replace("[FAB.TYPE]", "[VARE.NAVN]");
            sb.Replace("[FAB.SERIALNO]", item.SerialNo);
            sb.Replace("[FAB.LOCATION]", item.Location);
            sb.Replace("[FAB.LOCATIONFULDADR]", item.LocationFuldAdresse);
            sb.Replace("[FAB.VARENR]", "[VARE.VARENR]");
            sb.Replace("[FAB.NAVN]", "[VARE.NAVN]");
            sb.Replace("[FAB.MODEL]", "[VARE.NAVN]");
            sb.Replace("[FAB.EXPIREDATE]", item.WarencyExpireDate.ToString("dd MMMM yyyy"));
            res = sb.ToString();
            res = item.KundeGrpPris.Tags(res);
            res = item.Virksomhed.Tags(res);

            return(res);
        }
Exemple #2
0
        public static System.Collections.Generic.List <FAB> GetListSoonExpired(int CompanyID)
        {
            System.Collections.Generic.List <FAB> result = new System.Collections.Generic.List <FAB>();
            int      ID = -1;
            DBAccess db = new DBAccess();

            db.AddInt("CompanyID", CompanyID);

            db.AddBoolean("IsAgent", AdgangsKontrol.IsAgent());
            db.AddGuid("AgentID", CurrentUserID);

            System.Data.SqlClient.SqlDataReader dr = default(System.Data.SqlClient.SqlDataReader);
            //Try
            dr = (System.Data.SqlClient.SqlDataReader)(db.ExecuteReader(_SQLSelectAllSoonExpired));
            if (dr.HasRows)
            {
                while (dr.Read())
                {
                    ID = System.Convert.ToInt32(dr.DBtoInt("ID"));
                    result.Add(FAB.GetFAB(ID));
                }
            }
            dr.Close();
            //Catch ex As Exception
            //    Throw ex
            //End Try

            return(result);
        }
Exemple #3
0
            /// <summary>
            /// Creates the PDF document.
            /// </summary>
            public Document CreateDocument()
            {
                if (!_FAB.loaded)
                {
                    if (_fabID > 0)
                    {
                        _FAB = new RescueTekniq.BOL.FAB(_fabID);
                    }
                }

                if (!_FAB.loaded)
                {
                    throw (new Exception("Førstehjælpstaske findes ikke, ID ukendt :" + fabID.ToString()));
                }

                // Create a new MigraDoc document
                this.document = new Document();
                var with_1 = this.document.Info;

                with_1.Title    = "Førstehjælpstaske regstering nr. " + System.Convert.ToString(_fabID);
                with_1.Subject  = "Førstehjælpstaske registering";
                with_1.Author   = Company.name;
                with_1.Comment  = "";
                with_1.Keywords = "";

                DefineStyles();

                CreatePage();

                FillContent();

                return(this.document);
            }
Exemple #4
0
        public static int MoveToNewOwner(int ID, int NewOwner)
        {
            FAB rec = new FAB(ID);

            rec.CompanyID = NewOwner;
            AddLog(Status: "FAB", Logtext: string.Format("Update FAB: ID:{0} SNo:{1} New owner: {2}-{3}", rec.ID, rec.SerialNo, rec.CompanyID, rec.Firmanavn), Metode: "MoveToNewOwner");
            return(rec.Save());
        }
Exemple #5
0
        public static int Update(FAB c)
        {
            DBAccess db = new DBAccess();

            db.AddInt("ID", c.ID);
            AddParms(ref db, c);

            int retval = db.ExecuteNonQuery(_SQLUpdate);

            AddLog(Status: "FAB", Logtext: string.Format("Update FAB: ID:{0} SNo:{1} ", c.ID, c.SerialNo), Metode: "Update");
            return(retval);
        }
Exemple #6
0
        public static int Save(FAB rec)
        {
            int retval = 0; //db.ExecuteNonQuery(_SQLUpdate)

            if (rec.ID > 0)
            {
                retval = rec.Update();
            }
            else
            {
                retval = rec.Insert();
            }
            return(retval);
        }
Exemple #7
0
        public static List <FAB> GetFABsByCriteria(string OrderBY, string criteria, params SqlParameter[] @params)
        {
            DBAccess db = new DBAccess();
            //Dim conn As SqlConnection = DataFunctions.GetConnection()
            string query = "";

            query += "SELECT ";
            if (OrderBY != "")
            {
                query += " TOP (100) PERCENT ";
            }
            query += " * FROM vw_Co2Db_FirstAidBag ";
            query += " WHERE ( @IsAgent = 0 OR ( @IsAgent = 1 AND [AgentID] = @AgentID ) )";
            if (criteria != "")
            {
                query += " AND (" + criteria + ")";
            }
            if (OrderBY != "")
            {
                query += " ORDER BY " + OrderBY;
            }

            //Dim cmd As New SqlCommand(query, conn)
            db.CommandType = CommandType.Text;
            db.CommandText = query;
            db.AddRange(@params);
            db.AddBoolean("IsAgent", AdgangsKontrol.IsAgent());
            db.AddGuid("AgentID", CurrentUserID);

            db.Open();
            SqlDataReader dr = (SqlDataReader)(db.ExecuteReader());  //cmd.ExecuteReader()

            List <FAB> list = new List <FAB>();

            while (dr.Read())
            {
                FAB _fab = new FAB();
                FAB.Populate(dr, _fab);
                list.Add(_fab);
            }

            db.Dispose();

            return(list);
        }
Exemple #8
0
        public static int Delete(FAB rec)
        {
            int retval = -1;

            if (rec.ID > 0)
            {
                foreach (FirstAidBag_Service S in rec.ServiceList)
                {
                    S.Delete();
                }

                DBAccess db = new DBAccess();
                db.AddInt("ID", rec.ID);

                retval = db.ExecuteNonQuery(_SQLDelete);
                AddLog(Status: "FAB", Logtext: string.Format("Delete FAB: ID:{0} SNo:{1} ", rec.ID, rec.SerialNo), Metode: "Delete");
            }

            return(retval);
        }
Exemple #9
0
        private static void AddParms(ref DBAccess db, FAB c)
        {
            var with_1 = c;

            db.AddInt("Status", (System.Int32)with_1.Status);
            db.AddInt("CompanyID", with_1.CompanyID);

            db.AddInt("ModelID", with_1.ModelID);
            db.AddNVarChar("SerialNo", with_1.SerialNo, 50);

            db.AddDateTime("DeleveryDate", with_1.DeleveryDate);
            db.AddDateTime("WarencyExpireDate", with_1.WarencyExpireDate);
            db.AddDateTime("DecommissionDate", with_1.DecommissionDate);
            db.AddDateTime("EmailSendt", with_1.EmailSendt);

            db.AddInt("BilagStatus", (System.Int32)with_1.BilagStatus);
            db.AddDateTime("BilagSendtDato", with_1.BilagSendtDato);
            db.AddDateTime("BilagModtagetDato", with_1.BilagModtagetDato);

            db.AddNVarChar("ResponsibleName", with_1.ResponsibleName, 50);
            db.AddNVarChar("ResponsiblePhone", with_1.ResponsiblePhone, 16);
            db.AddNVarChar("ResponsibleEmail", with_1.ResponsibleEmail, 250);

            db.AddNVarChar("LocationAdresse", with_1.LocationAdresse, 50);
            db.AddNVarChar("LocationPostnr", with_1.LocationPostnr, 16);
            db.AddNVarChar("LocationBy", with_1.LocationBy, 50);
            db.AddNVarChar("LocationState", with_1.LocationState, 50);
            db.AddInt("LocationLandID", with_1.LocationLandID);
            db.AddNVarChar("Location", with_1.Location, -1);
            db.AddNVarChar("LocationBuildingNo", with_1.LocationBuildingNo, 10);

            db.AddInt("ServiceDate", with_1.ServiceDate);
            db.AddDateTime("ServiceDateEmail", with_1.ServiceDateEmail);
            db.AddBoolean("VisibleRescueinfo", with_1.VisibleRescueinfo);
            //
            db.AddNVarChar("RegisterretAF", with_1.RegisterretAF, 50);

            db.AddNVarChar("Note", with_1.Note, -1);

            AddParmsStandard(db, c);
        }
Exemple #10
0
        private static void Populate(System.Data.SqlClient.SqlDataReader dr, FAB c)
        {
            var with_1 = c;

            with_1.Status    = (RescueTekniq.BOL.FAB_StatusEnum)(dr.DBtoInt("Status"));
            with_1.CompanyID = System.Convert.ToInt32(dr.DBtoInt("CompanyID"));

            with_1.ModelID  = System.Convert.ToInt32(dr.DBtoInt("ModelID"));
            with_1.SerialNo = dr.DBtoString("SerialNo");

            with_1.DeleveryDate      = System.Convert.ToDateTime(dr.DBtoDate("DeleveryDate"));
            with_1.WarencyExpireDate = System.Convert.ToDateTime(dr.DBtoDate("WarencyExpireDate"));
            with_1.DecommissionDate  = System.Convert.ToDateTime(dr.DBtoDate("DecommissionDate"));
            with_1.EmailSendt        = System.Convert.ToDateTime(dr.DBtoDate("EmailSendt"));

            with_1.BilagStatus       = (RescueTekniq.BOL.FAB_BilagStatus)(dr.DBtoInt("BilagStatus"));
            with_1.BilagSendtDato    = System.Convert.ToDateTime(dr.DBtoDate("BilagSendtDato"));
            with_1.BilagModtagetDato = System.Convert.ToDateTime(dr.DBtoDate("BilagModtagetDato"));

            with_1.ResponsibleName  = dr.DBtoString("ResponsibleName");
            with_1.ResponsiblePhone = dr.DBtoString("ResponsiblePhone");
            with_1.ResponsibleEmail = dr.DBtoString("ResponsibleEmail");

            with_1.LocationAdresse    = dr.DBtoString("LocationAdresse");
            with_1.LocationPostnr     = dr.DBtoString("LocationPostnr");
            with_1.LocationBy         = dr.DBtoString("LocationBy");
            with_1.LocationState      = dr.DBtoString("LocationState");
            with_1.LocationLandID     = System.Convert.ToInt32(dr.DBtoInt("LocationLandID"));
            with_1.Location           = dr.DBtoString("Location");
            with_1.LocationBuildingNo = dr.DBtoString("LocationBuildingNo");

            with_1.ServiceDate       = System.Convert.ToInt32(dr.DBtoInt("ServiceDate"));
            with_1.ServiceDateEmail  = System.Convert.ToDateTime(dr.DBtoDate("ServiceDateEmail"));
            with_1.VisibleRescueinfo = System.Convert.ToBoolean(dr.DBtoBoolean("VisibleRescueinfo"));
            with_1.RegisterretAF     = dr.DBtoString("RegisterretAF");

            with_1.Note = dr.DBtoString("Note");

            PopulateStandard(dr, c);
        }
Exemple #11
0
        public static FAB GetFABBySerialNo(string SerialNo)
        {
            DBAccess db = new DBAccess();
            FAB      c  = new FAB();

            db.AddNVarChar("SerialNo", SerialNo, 50);

            db.AddBoolean("IsAgent", AdgangsKontrol.IsAgent());
            db.AddGuid("AgentID", CurrentUserID);

            SqlDataReader dr = (SqlDataReader)(db.ExecuteReader(_SQLSelectBySerialNo));

            if (dr.HasRows)
            {
                while (dr.Read())
                {
                    Populate(dr, c);
                }
            }
            dr.Close();
            return(c);
        }
Exemple #12
0
        public static FAB GetFABbyGuid(Guid GuID)
        {
            DBAccess db = new DBAccess();
            FAB      c  = new FAB();

            db.AddGuid("Guid", GuID);

            db.AddBoolean("IsAgent", AdgangsKontrol.IsAgent());
            db.AddGuid("AgentID", CurrentUserID);

            SqlDataReader dr = (SqlDataReader)(db.ExecuteReader(_SQLSelectByGuid));

            if (dr.HasRows)
            {
                while (dr.Read())
                {
                    Populate(dr, c);
                }
            }
            dr.Close();
            return(c);
        }
Exemple #13
0
        public static int Insert(FAB rec)
        {
            DBAccess db = new DBAccess();

            AddParms(ref db, rec);

            SqlParameter objParam = new SqlParameter("@ID", 0);

            objParam.Direction = ParameterDirection.Output;
            db.Parameters.Add(objParam);
            int retval = db.ExecuteNonQuery(_SQLInsert);

            if (retval == 1)
            {
                rec.ID = Funktioner.ToInt(objParam.Value, -1); //Integer.Parse(objParam.Value.ToString)
                AddLog(Status: "FAB", Logtext: string.Format("Create FAB: ID:{0} SNo:{1} ", rec.ID, rec.SerialNo), Metode: "Insert");
                return(rec.ID);
            }
            else
            {
                AddLog(Status: "FAB", Logtext: string.Format("Failure to Create FAB: SNo:{0}", rec.SerialNo), logtype: LogTypeEnum.Error, Metode: "Insert");
                return(-1);
            }
        }
Exemple #14
0
        public static int Delete(int ID)
        {
            FAB item = new FAB(ID);

            return(Delete(item));
        }