Esempio n. 1
0
        //DeleteProduct

        public ZA3720ILD DeleteProduct(ZA3620SD FilterData)
        {
            ZA3720ILD UsageD = new ZA3720ILD();

            try
            {
                XDocument doc = new XDocument(new XElement("Root",
                                                           new XElement("ai_clasifdad_mast_id", FilterData.ClasifdADMastID)
                                                           ));

                String     XString = doc.ToString();
                PLABSM.DAL dbObj   = new PLABSM.DAL();
                dbObj.ConnectionMode = PLABSM.ConnectionModes.WebDB;
                DataSet ds = dbObj.SelectSP("ZA3620AD_Del", XString, PLABSM.DbProvider.MSSql);
            }
            catch (Exception e)
            {
                UsageD.UserData.ZaBase.ErrorMsg = PLWM.Utils.CnvToSentenceCase(e.Message.ToLower().Replace("plerror", "").Replace("plerror", "").Trim());
            }
            return(UsageD);
        }
Esempio n. 2
0
        public ZA3720ILD DoInit(ZA3000D FilterData, String Mode)
        {
            ZA3720ILD UsageD = new ZA3720ILD();

            try
            {
                XDocument doc = new XDocument(new XElement("Root",
                                                           new XElement("as_mode", Mode),
                                                           new XElement("ai_pageno", ""),
                                                           new XElement("as_sessionid", FilterData.ZaBase.SessionId),
                                                           new XElement("as_Option", ""),
                                                           new XElement("as_location", ""),
                                                           new XElement("as_sortby", "")
                                                           ));

                String     XString = doc.ToString();
                PLABSM.DAL dbObj   = new PLABSM.DAL();
                dbObj.ConnectionMode = PLABSM.ConnectionModes.WebDB;
                DataSet ds = dbObj.SelectSP("ZA3720_sel", XString, PLABSM.DbProvider.MSSql);


                System.Data.DataTable ClasifiedDt = PLWM.Utils.GetDataTable(ds, 0);
                System.Data.DataTable PageNoDt    = PLWM.Utils.GetDataTable(ds, 1);

                System.Data.DataTable UserDataDt = PLWM.Utils.GetDataTable(ds, 2);

                System.Data.DataTable CatagoryDt = PLWM.Utils.GetDataTable(ds, 3);
                System.Data.DataTable LocationDt = PLWM.Utils.GetDataTable(ds, 4);
                System.Data.DataTable SortByDt   = PLWM.Utils.GetDataTable(ds, 5);

                if (UserDataDt.Rows.Count > 0)
                {
                    UsageD.UserData = new ZA3000D()
                    {
                        FistNam = PLWM.Utils.CnvToStr(UserDataDt.Rows[0]["FirstName"]),
                        ZaBase  = new BaseD()
                        {
                            ZaKey     = Utils.GetKey(),
                            SessionId = PLWM.Utils.CnvToStr(UserDataDt.Rows[0]["SESSIONID"]),
                            ErrorMsg  = "",
                        }
                    };
                }
                else
                {
                    UsageD.UserData = new ZA3000D()
                    {
                        FistNam = "",
                        ZaBase  = new BaseD()
                        {
                            ZaKey     = Utils.GetKey(),
                            SessionId = "",
                            ErrorMsg  = "",
                        }
                    };
                }

                UsageD.ClasifiedsDataCol = new ZA3720BDCol();
                foreach (DataRow Dr in ClasifiedDt.Rows)
                {
                    UsageD.ClasifiedsDataCol.Add(new ZA3720BD
                    {
                        Title           = PLWM.Utils.CnvToStr(Dr["clasifd_title"]),
                        Age             = PLWM.Utils.CnvToStr(Dr["Age"]),
                        Condition       = PLWM.Utils.CnvToStr(Dr["Condition"]),
                        Email           = PLWM.Utils.CnvToStr(Dr["usr_email"]),
                        Location        = PLWM.Utils.CnvToStr(Dr["Location"]),
                        PhNo            = PLWM.Utils.CnvToStr(Dr["usr_phno"]),
                        PostDate        = PLWM.Utils.CnvToStr(Dr["crtd_dt"]),
                        ProductImage    = PLWM.Utils.CnvToStr(Dr["full_path"]),
                        Rate            = PLWM.Utils.CnvToStr(Dr["Price"]),
                        Usage           = PLWM.Utils.CnvToStr(Dr["Usage"]),
                        Warranty        = PLWM.Utils.CnvToStr(Dr["warrenty"]),
                        ClasifdAdMastId = PLWM.Utils.CnvToStr(Dr["clasifd_ad_mast_id"]),
                    });
                }

                UsageD.AgeCol = new ComDisValDCol();
                UsageD.AgeCol.Add(new ComDisValD()
                {
                    DisPlyMembr = "Age", ValMembr = -1
                });
                foreach (DataRow Dr in LocationDt.Rows)
                {
                    UsageD.AgeCol.Add(new ComDisValD()
                    {
                        DisPlyMembr = PLWM.Utils.CnvToStr(Dr["clasifd_value"]),
                        ValMembr    = PLWM.Utils.CnvToInt(Dr["clasifd_dtl_id"]),
                    });
                }


                UsageD.SortByCol = new ComDisValDCol();
                UsageD.SortByCol.Add(new ComDisValD()
                {
                    DisPlyMembr = "Sorted By", ValMembr = -1
                });
                foreach (DataRow Dr in SortByDt.Rows)
                {
                    UsageD.SortByCol.Add(new ComDisValD()
                    {
                        DisPlyMembr = PLWM.Utils.CnvToStr(Dr["SortMode"]),
                        ValMembr    = PLWM.Utils.CnvToInt(Dr["SortValue"]),
                    });
                }

                UsageD.CatagoryCol = new ZA3220DCol();
                foreach (DataRow Dr in CatagoryDt.Rows)
                {
                    UsageD.CatagoryCol.Add(new ZA3220D()
                    {
                        ClasifdSpecDtlId = PLWM.Utils.CnvToInt(Dr["clasifd_dtl_id"]),
                        ClasifdSpecValue = PLWM.Utils.CnvToStr(Dr["clasifd_value"]),
                    });
                }

                UsageD.PageNoCol = new ComDisValDCol();
                foreach (DataRow Dr in PageNoDt.Rows)
                {
                    UsageD.PageNoCol.Add(new ComDisValD()
                    {
                        ValMembr    = PLWM.Utils.CnvToInt(Dr["TotalPages"]),
                        DisPlyMembr = PLWM.Utils.CnvToStr(Dr["Page_No"]),
                    });
                }
            }
            catch (Exception e)
            {
                UsageD.UserData.ZaBase.ErrorMsg = PLWM.Utils.CnvToSentenceCase(e.Message.ToLower().Replace("plerror", "").Replace("plerror", "").Trim());
            }
            return(UsageD);
        }
Esempio n. 3
0
        public ZA3720ILD DoLoad(ZA3720LFD FilterData, String Mode)
        {
            ZA3720ILD UsageD = new ZA3720ILD();

            try
            {
                XDocument doc = new XDocument(new XElement("Root",
                                                           new XElement("as_mode", "LD"),
                                                           new XElement("ai_pageno", FilterData.PageNo),
                                                           new XElement("as_sessionid", ""),
                                                           new XElement("as_Option", FilterData.Category.ClasifdSpecDtlId),
                                                           new XElement("as_age", FilterData.Age.ValMembr),
                                                           new XElement("as_sortby", FilterData.SortBy.ValMembr)
                                                           ));

                String     XString = doc.ToString();
                PLABSM.DAL dbObj   = new PLABSM.DAL();
                dbObj.ConnectionMode = PLABSM.ConnectionModes.WebDB;
                DataSet ds = dbObj.SelectSP("ZA3720_sel", XString, PLABSM.DbProvider.MSSql);

                System.Data.DataTable ClasifiedDt = PLWM.Utils.GetDataTable(ds, 0);
                System.Data.DataTable PageNoDt    = PLWM.Utils.GetDataTable(ds, 1);

                UsageD.UserData = new ZA3000D()
                {
                    ZaBase = new BaseD()
                    {
                        ZaKey    = Utils.GetKey(),
                        ErrorMsg = ""
                    }
                };


                UsageD.ClasifiedsDataCol = new ZA3720BDCol();
                foreach (DataRow Dr in ClasifiedDt.Rows)
                {
                    UsageD.ClasifiedsDataCol.Add(new ZA3720BD
                    {
                        Title           = PLWM.Utils.CnvToStr(Dr["clasifd_title"]),
                        Age             = PLWM.Utils.CnvToStr(Dr["Age"]),
                        Condition       = PLWM.Utils.CnvToStr(Dr["Condition"]),
                        Email           = PLWM.Utils.CnvToStr(Dr["usr_email"]),
                        Location        = PLWM.Utils.CnvToStr(Dr["Location"]),
                        PhNo            = PLWM.Utils.CnvToStr(Dr["usr_phno"]),
                        PostDate        = PLWM.Utils.CnvToStr(Dr["crtd_dt"]),
                        ProductImage    = PLWM.Utils.CnvToStr(Dr["full_path"]),
                        Rate            = PLWM.Utils.CnvToStr(Dr["Price"]),
                        Usage           = PLWM.Utils.CnvToStr(Dr["Usage"]),
                        Warranty        = PLWM.Utils.CnvToStr(Dr["warrenty"]),
                        ClasifdAdMastId = PLWM.Utils.CnvToStr(Dr["clasifd_ad_mast_id"]),
                    });
                }


                UsageD.PageNoCol = new ComDisValDCol();
                foreach (DataRow Dr in PageNoDt.Rows)
                {
                    UsageD.PageNoCol.Add(new ComDisValD()
                    {
                        ValMembr    = PLWM.Utils.CnvToInt(Dr["TotalPages"]),
                        DisPlyMembr = PLWM.Utils.CnvToStr(Dr["Page_No"]),
                    });
                }
            }
            catch (Exception e)
            {
                UsageD.UserData.ZaBase.ErrorMsg = PLWM.Utils.CnvToSentenceCase(e.Message.ToLower().Replace("plerror", "").Replace("plerror", "").Trim());
            }
            return(UsageD);
        }
Esempio n. 4
0
        public ZA3720ILD DoInit(ZA3000D FilterData, String Mode)
        {
            ZA3720ILD UsageD = new ZA3720ILD();

            try
            {
                XDocument doc = new XDocument(new XElement("Root",
                                                           new XElement("as_mode", Mode),
                                                           new XElement("as_sessionid", FilterData.ZaBase.SessionId)
                                                           ));

                String     XString = doc.ToString();
                PLABSM.DAL dbObj   = new PLABSM.DAL();
                dbObj.ConnectionMode = PLABSM.ConnectionModes.WebDB;
                DataSet ds = dbObj.SelectSP("ZA3620AD_Sel", XString, PLABSM.DbProvider.MSSql);


                System.Data.DataTable ClasifiedDt = PLWM.Utils.GetDataTable(ds, 0);
                System.Data.DataTable UserDataDt  = PLWM.Utils.GetDataTable(ds, 2);

                if (UserDataDt.Rows.Count > 0)
                {
                    UsageD.UserData = new ZA3000D()
                    {
                        FistNam = PLWM.Utils.CnvToStr(UserDataDt.Rows[0]["FirstName"]),
                        ZaBase  = new BaseD()
                        {
                            ZaKey     = Utils.GetKey(),
                            SessionId = PLWM.Utils.CnvToStr(UserDataDt.Rows[0]["SESSIONID"]),
                            ErrorMsg  = "",
                        }
                    };
                }
                else
                {
                    UsageD.UserData = new ZA3000D()
                    {
                        FistNam = "",
                        ZaBase  = new BaseD()
                        {
                            ZaKey     = Utils.GetKey(),
                            SessionId = "",
                            ErrorMsg  = "",
                        }
                    };
                }

                UsageD.ClasifiedsDataCol = new ZA3720BDCol();
                foreach (DataRow Dr in ClasifiedDt.Rows)
                {
                    UsageD.ClasifiedsDataCol.Add(new ZA3720BD
                    {
                        Title           = PLWM.Utils.CnvToStr(Dr["clasifd_title"]),
                        Age             = PLWM.Utils.CnvToStr(Dr["Age"]),
                        Condition       = PLWM.Utils.CnvToStr(Dr["Condition"]),
                        Email           = PLWM.Utils.CnvToStr(Dr["usr_email"]),
                        Location        = PLWM.Utils.CnvToStr(Dr["Location"]),
                        PhNo            = PLWM.Utils.CnvToStr(Dr["usr_phno"]),
                        PostDate        = PLWM.Utils.CnvToStr(Dr["crtd_dt"]),
                        ProductImage    = PLWM.Utils.CnvToStr(Dr["full_path"]),
                        Rate            = PLWM.Utils.CnvToStr(Dr["Price"]),
                        Usage           = PLWM.Utils.CnvToStr(Dr["Usage"]),
                        Warranty        = PLWM.Utils.CnvToStr(Dr["warrenty"]),
                        ClasifdAdMastId = PLWM.Utils.CnvToStr(Dr["clasifd_ad_mast_id"]),
                    });
                }
            }
            catch (Exception e)
            {
                UsageD.UserData.ZaBase.ErrorMsg = PLWM.Utils.CnvToSentenceCase(e.Message.ToLower().Replace("plerror", "").Replace("plerror", "").Trim());
            }
            return(UsageD);
        }