public int delete(int id) { AbstractCommonData entity = new AttachmentChequeEntity(); string delQuery = "DELETE FROM " + entity.TableName + " WHERE " + AttachmentChequeEntity.indexField + "=" + provider.getSQLString(id); return(provider.delete(delQuery)); }
private void fillGrid() { AttachmentChequeEntity entity = null; entity = _attachmentChequeBl.get(_chequeId); System.Collections.Hashtable hash = new Hashtable(); _gridTools.bindDataToGrid(dataGridView1, entity, null, hash); }
public AttachmentChequeEntity getById(int id) { AttachmentChequeEntity entity = new AttachmentChequeEntity(); String cond = AttachmentChequeEntity.FIELD_ID + "=" + provider.getSQLString(id); provider.loadToDataSet(entity, cond); return(entity); }
public int getCount(int letterid) { //ToDo reprogram this lines AttachmentChequeEntity entity = new AttachmentChequeEntity(); String sql = "SELECT COUNT(1) FROM " + entity.TableName + " WHERE " + AttachmentChequeEntity.FIELD_CHEQUE_ID + "=" + provider.getSQLString(letterid); String cond = AttachmentChequeEntity.FIELD_CHEQUE_ID + "=" + provider.getSQLString(letterid); provider.loadToDataSet(entity, cond); return(entity.Tables[entity.FilledTableName].Rows.Count); }
private void btnSave_Click(object sender, EventArgs e) { try { string s = openFileDialog1.FileName; if (s != null && s.Length > 0 && txtFullFileName.Text.Trim().Length > 0) { AttachmentChequeEntity entity = new AttachmentChequeEntity(); DataRow dr = entity.Tables[entity.TableName].NewRow(); dr[AttachmentChequeEntity.FIELD_CHEQUE_ID] = _chequeId; dr[AttachmentChequeEntity.FIELD_FILE_NAME] = txtFileName.Text; dr[AttachmentChequeEntity.FIELD_ID] = _id; dr[AttachmentChequeEntity.FIELD_CONTENT] = ReadFile(txtFullFileName.Text); entity.Tables[entity.TableName].Rows.Add(dr); if (_id > 0) { _attachmentChequeBL.update(entity); //lblMsg.Text = "به روز رسانی گردید"; } else { _id = _attachmentChequeBL.add(entity); //lblMsg.Text = "ذخیره شد "; } this.Close(); } } catch (Exception ex) { if (ex.Message != null && (ex.Message.IndexOf("cannot access the file ") >= 0 || ex.Message.IndexOf("") >= 0)) { MessageBox.Show("فایل مورد نظر توسط برنامه ای دیگر در حال استفاده است!" + "\n" + ex.Message); return; } } }
private void loadForm() { if (_id > 0) { try { AttachmentChequeEntity entity = _attachmentChequeBL.getById(_id); txtFileName.Text = entity.get(AttachmentChequeEntity.FIELD_FILE_NAME).ToString(); _fileName = txtFileName.Text; _imageData = (byte[])entity.Tables[entity.FilledTableName].Rows[0][AttachmentChequeEntity.FIELD_CONTENT]; if (isImage(txtFullFileName.Text)) { Image newImage; //Read image data into a memory stream using (MemoryStream ms = new MemoryStream(_imageData, 0, _imageData.Length)) { ms.Write(_imageData, 0, _imageData.Length); //Set image variable value using memory stream. newImage = Image.FromStream(ms, true); } pictureBox1.Height = newImage.Height; pictureBox1.Width = newImage.Width; pictureBox1.Image = newImage; pictureBox1.SizeMode = PictureBoxSizeMode.StretchImage; } else { displayNonImageFile(); } } catch (Exception ex) { MessageBox.Show(ex.ToString()); } } }
public int update(AttachmentChequeEntity entity) { return(provider.update(entity)); }
public int add(AttachmentChequeEntity entity) { return(provider.add(entity)); }
public int update(AttachmentChequeEntity entity) { return(((AttachmentChequeDA)_abstractDA).update(entity)); }
public int add(AttachmentChequeEntity entity) { return(((AttachmentChequeDA)_abstractDA).add(entity)); }