コード例 #1
0
        public static System.Collections.Generic.List <FirstAidBag_Service> GetBatteryListExpiredEmail(int CompanyID)
        {
            System.Collections.Generic.List <FirstAidBag_Service> result = new System.Collections.Generic.List <FirstAidBag_Service>();
            int      ID = -1;
            DBAccess db = new DBAccess();

            db.AddInt("CompanyID", CompanyID);

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

            SqlDataReader dr = default(SqlDataReader);

            try
            {
                dr = (System.Data.SqlClient.SqlDataReader)(db.ExecuteReader(_SQLSelectAllExpiredEmail));
                if (dr.HasRows)
                {
                    while (dr.Read())
                    {
                        ID = System.Convert.ToInt32(dr.DBtoInt("ID"));
                        result.Add(FirstAidBag_Service.GetService(ID));
                    }
                }
                dr.Close();
            }
            catch (Exception ex)
            {
                throw (ex);
            }

            return(result);
        }
コード例 #2
0
        public static string Tags(string tekst, RescueTekniq.BOL.FirstAidBag_Service item)
        {
            string        res = "";
            StringBuilder sb  = new StringBuilder();

            sb.Append(tekst);
            sb.Replace("[VARE.TYPE]", "Service");
            sb.Replace("[SERVICE.TYPE]", "[VARE.NAVN]");

            sb.Replace("[DUEDATE]", item.ServiceDueDate.ToString("MMMM yyyy"));
            sb.Replace("[SERVICE.DUEDATE]", item.ServiceDueDate.ToString("MMMM yyyy"));
            sb.Replace("[SERVICE.BESØGSDATO]", item.ServiceDueDate.ToString("MMMM yyyy"));

            sb.Replace("[SERVICE.VISITEDDATE]", item.ServiceVisitedDate.ToString("dd MMMM yyyy"));
            sb.Replace("[SERVICE.BESØGTDATO]", item.ServiceVisitedDate.ToString("dd MMMM yyyy"));

            //.Replace("[SERVICE.EMAILSENDT]", item.ServiceEmailSendt.ToString())
            sb.Replace("[SERVICE.GUID]", item.Guid.ToString());

            sb.Replace("[SERVICE.VARENR]", "[VARE.VARENR]");
            sb.Replace("[SERVICE.SALGSPRIS]", "[VARE.SALGSPRIS]");
            sb.Replace("[SERVICE.RABAT]", "[VARE.RABAT]");
            sb.Replace("[SERVICE.PRIS]", "[VARE.PRIS]");
            sb.Replace("[SERVICE.KUNDEPRIS]", "[VARE.KUNDEPRIS]");
            sb.Replace("[SERVICE.FRAGTGEBYR]", "[VARE.FRAGTGEBYR]");
            sb.Replace("[SERVICE.FRAGTPRIS]", "[VARE.FRAGTPRIS]");
            sb.Replace("[SERVICE.MOMS]", "[VARE.MOMS]");
            sb.Replace("[SERVICE.TOTAL]", "[VARE.TOTAL]");

            res = sb.ToString();
            res = item.KundeGrpPris.Tags(res);
            res = item.FirstAidBag.Tags(res);

            return(res);
        }
コード例 #3
0
        public static int Insert(FirstAidBag_Service 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 = int.Parse(objParam.Value.ToString());
                AddLog(Status: "FirstAidBag_Service", Logtext: string.Format("Create FirstAidBag_Service: ID:{0}", rec.ID), Metode: "Insert");
                return(rec.ID);
            }
            else
            {
                AddLog(Status: "FirstAidBag_Service", Logtext: string.Format("Failure to Create FirstAidBag_Service:"), logtype: LogTypeEnum.Error, Metode: "Insert");
                return(-1);
            }
        }
コード例 #4
0
        public static List <FirstAidBag_Service> GetServicesByFAB(int FAB_FK)
        {
            List <FirstAidBag_Service> result = new List <FirstAidBag_Service>();
            int      ID = -1;
            DBAccess db = new DBAccess();

            db.AddInt("FAB_FK", FAB_FK);

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

            SqlDataReader dr = default(SqlDataReader);

            try
            {
                dr = (System.Data.SqlClient.SqlDataReader)(db.ExecuteReader(_SQLSelectByAED));
                if (dr.HasRows)
                {
                    while (dr.Read())
                    {
                        ID = System.Convert.ToInt32(dr.DBtoInt("ID"));
                        result.Add(FirstAidBag_Service.GetService(ID));
                    }
                }
                dr.Close();
            }
            catch (Exception ex)
            {
                throw (ex);
            }

            return(result);
        }
コード例 #5
0
        public static int Delete(int ID)
        {
            FirstAidBag_Service S = new FirstAidBag_Service();

            S.ID = ID;
            return(Delete(S));
        }
コード例 #6
0
        public static int Delete(FirstAidBag_Service rec)
        {
            DBAccess db = new DBAccess();

            db.AddInt("ID", rec.ID);
            int retval = db.ExecuteNonQuery(_SQLDelete);

            AddLog(Status: "FirstAidBag_Service", Logtext: string.Format("Delete FirstAidBag_Service: ID:{0}", rec.ID), Metode: "Delete");
            return(retval);
        }
コード例 #7
0
        public static int Save(FirstAidBag_Service rec)
        {
            int retval = 0;

            if (rec.ID > 0)
            {
                retval = rec.Update();
            }
            else
            {
                retval = rec.Insert();
            }
            return(retval);
        }
コード例 #8
0
        protected static void Populate(SqlDataReader dr, FirstAidBag_Service c)
        {
            PopulateStandard(dr, c);
            var with_1 = c;

            with_1.Status              = (RescueTekniq.BOL.FAB_ServiceStatusType)(dr.DBtoInt("Status"));
            with_1.FAB_FK              = System.Convert.ToInt32(dr.DBtoInt("FAB_FK"));
            with_1.ServiceType         = System.Convert.ToInt32(dr.DBtoInt("ServiceType"));
            with_1.ServiceActive       = System.Convert.ToBoolean(dr.DBtoBoolean("ServiceActive"));
            with_1.ServiceDueDate      = System.Convert.ToDateTime(dr.DBtoDate("ServiceDueDate"));
            with_1.ServiceVisitedDate  = System.Convert.ToDateTime(dr.DBtoDate("ServiceVisitedDate"));
            with_1.ServiceConsultantID = System.Convert.ToInt32(dr.DBtoInt("ServiceConsultantID"));
            with_1.ServiceConsultant   = dr.DBtoString("ServiceConsultant");
            with_1.ServicePrice        = System.Convert.ToDouble(dr.DBtoDouble("ServicePrice"));
        }
コード例 #9
0
        private static void AddParms(ref DBAccess db, FirstAidBag_Service c)
        {
            var with_1 = c;

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

            db.AddInt("ServiceType", with_1.ServiceType);
            db.AddBoolean("ServiceActive", with_1.ServiceActive);
            db.AddDateTime("ServiceDueDate", with_1.ServiceDueDate);
            db.AddDateTime("ServiceVisitedDate", with_1.ServiceVisitedDate);
            db.AddInt("ServiceConsultantID", with_1.ServiceConsultantID);
            db.AddNVarChar("ServiceConsultant", with_1.ServiceConsultant, 50);
            db.AddMoney("ServicePrice", with_1.ServicePrice);
            //
            AddParmsStandard(db, c);
        }
コード例 #10
0
        public static List <FirstAidBag_Service> GetServicesByCriteria(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_Service ";
            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 <FirstAidBag_Service> list = new List <FirstAidBag_Service>();

            while (dr.Read())
            {
                FirstAidBag_Service service = new FirstAidBag_Service();
                FirstAidBag_Service.Populate(dr, service);
                list.Add(service);
            }

            db.Dispose();

            return(list);
        }
コード例 #11
0
        public static FirstAidBag_Service GetService(System.Guid Guid)
        {
            FirstAidBag_Service c  = new FirstAidBag_Service();
            DBAccess            db = new DBAccess();

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