コード例 #1
0
        private int UpdatePhoto()
        {
            objSQLDB  = new SQLDB();
            objHrInfo = new HRInfo();
            DataTable dt     = new DataTable();
            int       iEcode = 0;

            try
            {
                dt = objSQLDB.ExecuteDataSet("SELECT top 1 HAMH_APPL_NUMBER,HAMH_EORA_CODE FROM temp_hr_photo_upload21112013 " +
                                             "INNER JOIN HR_APPL_MASTER_HEAD ON HAMH_EORA_CODE = ecode " +
                                             "where HAMH_MY_PHOTO is null").Tables[0];
                int iApplNo = Convert.ToInt32(dt.Rows[0]["HAMH_APPL_NUMBER"].ToString());
                iEcode = Convert.ToInt32(dt.Rows[0]["HAMH_EORA_CODE"].ToString());
                Image  loadedImage = Image.FromFile("D:\\Scan Photos\\" + iEcode + ".jpg");
                byte[] imageData   = { 0 };
                imageData = ReadFile("D:\\Scan Photos\\" + iEcode + ".jpg");
                objHrInfo.UpdatePhoto(iApplNo, imageData);
            }
            catch (Exception ex)
            {
                objSQLDB.ExecuteSaveData("DELETE FROM temp_hr_photo_upload21112013 WHERE ecode = " + iEcode);
            }
            objHrInfo = null;
            dt        = null;
            return(iEcode);
        }
コード例 #2
0
        private void btnUpdate_Click(object sender, EventArgs e)
        {
            objSQLDB = new SQLDB();
            int iRetVal = 0;

            byte[] imageData = { 0 };
            int    iPin      = 0;

            if (addressPresent.Pin.Length > 0)
            {
                iPin = Convert.ToInt32(addressPresent.Pin);
            }
            else
            {
                iPin = 0;
            }
            if (lblPath.Text != "")
            {
                imageData = ReadFile(lblPath.Text);
            }
            //else
            //    imageData = (byte)pictureBox1.BackgroundImage;
            //string sConnVal = ConfigurationSettings.AppSettings["DBCon"].ToString();
            //objSecurity = new Security();
            //SqlConnection CN = new SqlConnection(objSecurity.GetDecodeString(sConnVal));
            try
            {
                string sqlStr = "UPDATE HR_APPL_MASTER_HEAD SET HAMH_PD_BLOOD_GROUP_CODE='" + cmbBloodGrp_optional.Text + "',HAMH_ADD_PRES_ADDR_HNO='" + addressPresent.HouseNo + "'," +
                                "HAMH_ADD_PRES_ADDR_LANDMARK='" + addressPresent.LandMark + "',HAMH_ADD_PRES_ADDR_VILL_OR_TOWN='" + addressPresent.Village + "',HAMH_ADD_PRES_ADDR_MANDAL='" + addressPresent.Mondal + "'," +
                                "HAMH_ADD_PRES_ADDR_DISTRICT='" + addressPresent.District + "',HAMH_ADD_PRES_ADDR_STATE='" + addressPresent.State + "',HAMH_ADD_PRES_ADDR_PIN=" + iPin + ",HAMH_ADD_PRES_ADDR_PHONE='" + txtMobileNo.Text + "'";
                //if (lblPath.Text != "")
                //    sqlStr += ", HAMH_MY_PHOTO='" + (object)imageData + "'";
                sqlStr += " WHERE HAMH_EORA_CODE=" + txtEcodeSearch.Text;
                //SqlCommand SqlCom = new SqlCommand(sqlStr, CN);
                //if (lblPath.Text.Length > 1)
                //    SqlCom.Parameters.Add(new SqlParameter("@Photo", (object)imageData));
                //CN.Open();
                iRetVal = objSQLDB.ExecuteSaveData(sqlStr);
                if (lblPath.Text != "")
                {
                    objHrInfo = new HRInfo();
                    objHrInfo.UpdatePhoto(Convert.ToInt32(lblApplNo.Text), imageData);
                }
                //CN.Close();
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.ToString());
            }
            finally
            {
                objSQLDB = null;
            }
            if (iRetVal > 0)
            {
                btnClear_Click(null, null);
                MessageBox.Show("Selected information Has Been Updated", "SSCRM Application", MessageBoxButtons.OK, MessageBoxIcon.Information);
            }
            else
            {
                MessageBox.Show("Selected information not Updated", "SSCRM Application", MessageBoxButtons.OK, MessageBoxIcon.Error);
            }
            objSecurity = null;
        }