예제 #1
0
        public LanguageDir GetSingle(Int32 Id)
        {
            LanguageDir obj = new LanguageDir();

            try
            {
                string     query = "select * from language_dirs where ID = " + Id + "";
                SqlCommand cmd   = new SqlCommand(query, mySQLDBConnect.connection);
                mySQLDBConnect.OpenConnection();
                DataTable      dt = new DataTable();
                SqlDataAdapter dA = new SqlDataAdapter(cmd);
                dA.Fill(dt);
                obj = (from x in dt.AsEnumerable()
                       select new LanguageDir
                {
                    Id = x.Field <Int32>("id"),
                    Module = x.Field <Int32>("module"),
                    Remarks = x.Field <String>("remarks"),
                    Status = x.Field <Int32>("status"),
                    TextEn = x.Field <String>("text_en"),
                    TextId = x.Field <String>("text_id"),
                    TextTh = x.Field <String>("text_th"),
                    TextMs = x.Field <String>("text_ms"),
                    TextPage = x.Field <String>("text_page"),
                    TextZh = x.Field <String>("text_zh"),
                }).ToList().FirstOrDefault();
                mySQLDBConnect.CloseConnection();
            }
            catch (Exception ex)
            {
                Console.Write(ex.ToString());
            }
            return(obj);
        }
예제 #2
0
        public static object Add(LanguageDir obj)
        {
            Int32 LoginUserId = 0;

            if (HttpContext.Current.Session["UserId"] != null)
            {
                LoginUserId = Convert.ToInt32(HttpContext.Current.Session["UserId"].ToString());
            }
            try
            {
                if (obj.Id == 0)
                {
                    ILanguageDirService.PostData(obj);
                }
                else
                {
                    ILanguageDirService.UpdateData(obj);
                }
                return(true);
            }
            catch (Exception ex)
            {
                Console.WriteLine("Add language dir action: " + ex.Message);
                return(false);
            }
        }
예제 #3
0
 public LanguageDir UpdateData(LanguageDir obj)
 {
     try
     {
         obj = ILanguageDirRepo.UpdateData(obj);
     }
     catch (Exception ex)
     {
         Console.Write(ex.ToString());
     }
     return(obj);
 }
예제 #4
0
        public LanguageDir DeleteData(Int32 Id)
        {
            LanguageDir obj = new LanguageDir();

            try
            {
                obj = ILanguageDirRepo.DeleteData(Id);
            }
            catch (Exception ex)
            {
                Console.Write(ex.ToString());
            }
            return(obj);
        }
예제 #5
0
 public LanguageDir UpdateData(LanguageDir obj)
 {
     try
     {
         //string query = obj.ObjectToQuery<LanguageDir>("update");
         string     query = "UPDATE language_dirs SET text_id = '" + obj.TextId + "', status = '" + obj.Status + "', remarks = '" + obj.Remarks + "', module = '" + obj.Module + "', text_page = '" + obj.TextPage + "', text_en = '" + obj.TextEn + "', text_th = N'" + obj.TextTh + "', text_ms = N'" + obj.TextMs + "', text_zh = N'" + obj.TextZh + "' where ID = " + obj.Id + ";";
         SqlCommand cmd   = new SqlCommand(query, mySQLDBConnect.connection);
         mySQLDBConnect.OpenConnection();
         cmd.ExecuteNonQuery();
         mySQLDBConnect.CloseConnection();
     }
     catch (Exception ex)
     {
         Console.Write(ex.ToString());
     }
     return(obj);
 }
예제 #6
0
        public LanguageDir DeleteData(Int32 Id)
        {
            LanguageDir obj = GetSingle(Id);

            try
            {
                string     query = obj.ObjectToQuery <LanguageDir>("update");
                SqlCommand cmd   = new SqlCommand(query, mySQLDBConnect.connection);
                mySQLDBConnect.OpenConnection();
                cmd.ExecuteNonQuery();
                mySQLDBConnect.CloseConnection();
            }
            catch (Exception ex)
            {
                Console.Write(ex.ToString());
            }
            return(obj);
        }
예제 #7
0
 public LanguageDir PostData(LanguageDir obj)
 {
     try
     {
         //string query = obj.ObjectToQuery<LanguageDir>("insert") + "SELECT SCOPE_IDENTITY()";
         string     query = @"INSERT INTO language_dirs(module, remarks, status, text_en, text_id, text_th, text_ms, text_page, text_zh) 
                         VALUES ('" + obj.Module + "','" + obj.Remarks + "','" + obj.Status + "','" + obj.TextEn + "','" + obj.TextId + "',N'" + obj.TextTh + "',N'" + obj.TextMs + "','" + obj.TextPage + "',N'" + obj.TextZh + "'); SELECT SCOPE_IDENTITY()";
         SqlCommand cmd   = new SqlCommand(query, mySQLDBConnect.connection);
         mySQLDBConnect.OpenConnection();
         // cmd.ExecuteNonQuery();
         obj.Id = Convert.ToInt32(cmd.ExecuteScalar());
         mySQLDBConnect.CloseConnection();
     }
     catch (Exception ex)
     {
         Console.Write(ex.ToString());
     }
     return(obj);
 }
예제 #8
0
        protected void Page_Load(object sender, EventArgs e)
        {
            Int32 LoginUserId = 0;

            if (HttpContext.Current.Session["UserId"] != null)
            {
                LoginUserId = Convert.ToInt32(HttpContext.Current.Session["UserId"].ToString());
            }

            string        path       = AppDomain.CurrentDomain.BaseDirectory;
            DirectoryInfo currentDir = new DirectoryInfo(path);
            DirectoryInfo parentDir  = new DirectoryInfo(currentDir.Parent.FullName + "\\Silverlake.Web\\");

            FileInfo[] Files = parentDir.GetFiles("*.aspx");
            TextPage.DataSource     = Files;
            TextPage.DataTextField  = "Name";
            TextPage.DataValueField = "Name";
            TextPage.DataBind();

            //TextPage.Items.Insert(0, new ListItem()
            //{
            //    Text = "Select",
            //    Value = ""
            //});

            string idString = Request.QueryString["id"];

            if (idString != null && idString != "")
            {
                int         id          = Convert.ToInt32(idString);
                LanguageDir languageDir = ILanguageDirService.GetSingle(id);
                ID.Value       = languageDir.Id.ToString();
                Module.Value   = languageDir.Module.ToString();
                TextId.Value   = languageDir.TextId;
                TextPage.Value = languageDir.TextPage.ToString();
                TextEn.Value   = languageDir.TextEn.ToString();
                TextMs.Value   = languageDir.TextMs.ToString();
                TextZh.Value   = languageDir.TextZh.ToString();
                TextTh.Value   = languageDir.TextTh.ToString();
                Status.Value   = languageDir.Status.ToString();
                Remarks.Value  = languageDir.Remarks;
            }
        }
예제 #9
0
        public Int32 DeleteBulkData(List <Int32> Ids)
        {
            Int32 result = 0;

            try
            {
                string query = "";
                Ids.ForEach(Id =>
                {
                    LanguageDir obj = GetSingle(Id);
                    query          += obj.ObjectToQuery <LanguageDir>("update");
                });
                SqlCommand cmd = new SqlCommand(query, mySQLDBConnect.connection);
                mySQLDBConnect.OpenConnection();
                result = cmd.ExecuteNonQuery();
                mySQLDBConnect.CloseConnection();
            }
            catch (Exception ex)
            {
                Console.Write(ex.ToString());
            }
            return(result);
        }