private void btnEncrypt_Click(object sender, EventArgs e) { status.Text = ""; try { byte[] buffer = File.ReadAllBytes(txtFilePath.Text); using (DB db = new DB()) { SqlParameter[] par = new SqlParameter[1]; par[0] = new SqlParameter("@image", DalRules.EncryptSignature(buffer)); int cnt = db.ExecNonQuerySP("UpdateSignature", par); } status.Text = "Saved to DB!"; } catch (Exception ex) { status.Text = ex.Message; } }
private void doInsertToDB() { using (DB db = new DB()) { try { db.BeginTransaction(); //TRUNCATE table Raw_Transaction SqlParameter[] par = new SqlParameter[1]; par[0] = new SqlParameter("@batchNo", _batchNo); db.ExecNonQuerySP("DeleteRawDataByFileName", par); //Insert transaction records foreach (string txVals in _alTX) { db.ExecNonQuery(string.Format("INSERT Raw_Transaction VALUES ({0})", txVals)); } //Insert detail records foreach (var detail in _dicDetail) { db.ExecNonQuery(string.Format("INSERT Raw_Detail VALUES ('{0}',N'{1}')", detail.Key, detail.Value.Replace("'", "''"))); } //Insert BatchInfo SqlParameter[] par1 = new SqlParameter[3]; par1[0] = new SqlParameter("batchNo", _batchNo); par1[1] = new SqlParameter("fileName", _fileName); par1[2] = new SqlParameter("inputBy", GlobalParam.Inst.gsUserID); db.ExecNonQuerySP("InsertBatchInfo", par1); db.CommitTransaction(); status.Text = "Inserted to DB."; } catch (Exception ex) { db.AbortTransaction(); status.Text = ex.Message; Log.LogErr(ex); } } }