Пример #1
0
        protected void btnok_Click(object sender, EventArgs e)
        {

            if (checkNull())
            {
                if (FUCPic.FileBytes.Length > 0)
                {
                    uploadPic();
                }
                Entity.AssuranceInfo assuran = new Entity.AssuranceInfo();
                assuran.Assurance_Name = txttitle.Text.ToString();
                assuran.Date_End = txtdate.Text.ToString();
                assuran.Assurance_Detail = editor.Content.ToString();
                assuran.Assurance_Path = picturPath;
                assuran.Create_user = Session["userid"].ToString();
                assuran.Update_user = Session["userid"].ToString();


                bool insert = BLL.Assurance.insertAssurance(assuran);
                if (insert)
                {
                    ShowMessageWeb("บันทึกข้อมูลเรียบร้อย!  ");
                    clearValue();
                }
                else
                {
                    ShowMessageWeb("บันทึกข้อมูลล้มเหลว! ");
                    if (FUCPic.FileBytes.Length > 0)
                    {
                        System.IO.File.Delete(Server.MapPath(picturPath));
                    }
                }

            }

        }
Пример #2
0
        protected void gvAssurance_RowCommand(object sender, GridViewCommandEventArgs e)
        {

            if (e.CommandName == "Select")
            {
                Assurance_ID = gvAssurance.DataKeys[Convert.ToInt32(e.CommandArgument)].Value.ToString();


                Entity.AssuranceInfo assurance = new Entity.AssuranceInfo();
                assurance = BLL.Assurance.selectShowPopup(Assurance_ID.ToString());


                txtPoPtitle.Text = assurance.Assurance_Name;
                editorPopup.Content = assurance.Assurance_Detail;



                pathImage = assurance.Assurance_Path.ToString();
                imgID = pathImage;
                if (pathImage.Length > 0)
                {
                    imgPopPic.ImageUrl = pathImage;
                    imgPopPic.Visible = true;
                }
                else imgPopPic.Visible = false;

                string status = assurance.Assurance_status;
                if (status == "A") { ddlStatus.SelectedIndex = 0; }
                else { ddlStatus.SelectedIndex = 1; }
                txtPopdate.Text = assurance.Date_End;

                mdlpopup.Show();

            }

        }
Пример #3
0
        protected void btnsave_Click(object sender, EventArgs e)
        {
            Entity.AssuranceInfo update = new Entity.AssuranceInfo();
            update.Assurance_ID = Assurance_ID.ToString();
            update.Assurance_Name = txtPoPtitle.Text.ToString();
            update.Assurance_Detail = editorPopup.Content.ToString();
            update.Date_End = txtPopdate.Text.ToString();

            if (FUCPic.FileBytes.Length > 0)
            {
                uploadPic();
                update.Assurance_Path = picturPath;

            }
            else update.Assurance_Path = imgID.ToString();


            if (ddlStatus.SelectedIndex == 0) { update.Assurance_status = "A"; }
            else { update.Assurance_status = "U"; }

            bool checkStatusUpdate = BLL.Assurance.UpdateAssurance(update);
            if (checkStatusUpdate)
            {
                if (FUCPic.FileBytes.Length > 0 && imgID.ToString().Length > 0)
                {
                    System.IO.File.Delete(Server.MapPath(imgID.ToString()));
                }
                ShowMessageWeb("Update TrainningNews Success ! ");
            }
            else
            {
                ShowMessageWeb("Update TrainningNews Fail ! ");
                System.IO.File.Delete(Server.MapPath(picturPath));
            }
            this.butImgSearch_Click(null, null);

        }
Пример #4
0
        public static Entity.AssuranceInfo selectShowPopup(string id)
        {
            try
            {
                SqlDataReader dtReader;
                Entity.AssuranceInfo stdNews = new Entity.AssuranceInfo();
                string sqlString = "SELECT Assurance_Name, Assurance_Detail, Assurance_Path, Assurance_Status, convert(datetime, Date_End, 103) as date FROM Assurance where Assurance_ID=@id";
                ConnectDB connpath = new ConnectDB();
                objConn = new SqlConnection();
                objConn.ConnectionString = connpath.connectPath();
                objConn.Open();
                objCmd = new SqlCommand(sqlString, objConn);
                objCmd.Parameters.Add("@id", SqlDbType.Int).Value = Convert.ToInt32(id);
                dtReader = objCmd.ExecuteReader();
                if (dtReader.Read())
                {
                    stdNews.Assurance_Name = dtReader["Assurance_Name"].ToString();
                    stdNews.Assurance_Detail = dtReader["Assurance_Detail"].ToString();
                    stdNews.Assurance_Path = dtReader["Assurance_Path"].ToString();
                    stdNews.Assurance_status = dtReader["Assurance_Status"].ToString();
                    stdNews.Date_End = dtReader["date"].ToString();

                }
                dtReader.Close();
                objConn.Close();
                return stdNews;
            }
            catch (Exception)
            {
                return null;
            }
        }