public static bool Update(ContentAudioDto content) { string sql = " UPDATE tblContentAudio SET ChapterID=@ChapterID,Content=@Content,Remarks=@Remarks,CreatedDate=@CreatedDate,CreatedBy=@CreatedBy,ModifyDate=@ModifyDate,ModifyedBy=@ModifyedBy,BookID=@BookID WHERE ContentID=@ContentID"; SqlConnection con = new SqlConnection(Properties.Settings.Default.BlindEyeDBConStr); SqlCommand cmd = new SqlCommand(sql, con); cmd.Parameters.AddWithValue("@ChapterID", content.ChapterID); cmd.Parameters.AddWithValue("@Remarks", content.Remarks); cmd.Parameters.AddWithValue("@BookId", content.BookID); cmd.Parameters.AddWithValue("@CreatedDate", content.CreatedDate); cmd.Parameters.AddWithValue("@CreatedBy", content.CreatedBy); cmd.Parameters.AddWithValue("@ModifyDate", content.ModifyDate); cmd.Parameters.AddWithValue("@ModifyedBy", content.ModifyedBy); cmd.Parameters.AddWithValue("@Content", content.Content); try { con.Open(); cmd.ExecuteNonQuery(); return(true); } catch (Exception ex) { Constant.DBErrorMsg = ex.Message; return(false); } finally { con.Close(); } }
private void btnSave_Click(object sender, EventArgs e) { ContentTextDto ctext = new ContentTextDto(); ctext.BookID = Convert.ToInt64(cmbBook.SelectedValue.ToString()); ctext.ChapterID = Convert.ToInt64(cmbChapter.SelectedValue.ToString()); ctext.Content = rtxtContent.Text; ctext.CreatedBy = MDIParent._UserMasterID; ctext.CreatedDate = DateTime.Now; ctext.ModifyedBy = MDIParent._UserMasterID; ctext.ModifyDate = DateTime.Now; ctext.Remarks = rtxtRemarksForText.Text; if (ContentTextDao.Insert(ctext)) { MessageBox.Show(Constant.NOTIFICATION_SUCCESS_DATA_SAVING, Constant.NOTIFICATION_CAPTION_SAVE, MessageBoxButtons.OK, MessageBoxIcon.Asterisk); // ini(); } else { MessageBox.Show(Constant.DBErrorMsg, Constant.NOTIFICATION_ERROR_DATA_SAVING, MessageBoxButtons.OK, MessageBoxIcon.Error); } //under cn if (txtBrowesAudio.Text.Trim() != string.Empty) { ContentAudioDto caudio = new ContentAudioDto(); caudio.BookID = Convert.ToInt64(cmbBook.SelectedValue.ToString()); caudio.ChapterID = Convert.ToInt64(cmbChapter.SelectedValue.ToString()); caudio.Content = buffAudioData; caudio.CreatedBy = MDIParent._UserMasterID; caudio.CreatedDate = DateTime.Now; caudio.ModifyedBy = MDIParent._UserMasterID; caudio.ModifyDate = DateTime.Now; ctext.Remarks = rtxtRemarksForAudio.Text; if (ContentAudioDao.Insert(caudio)) { MessageBox.Show(Constant.NOTIFICATION_SUCCESS_DATA_SAVING, Constant.NOTIFICATION_CAPTION_SAVE, MessageBoxButtons.OK, MessageBoxIcon.Asterisk); ini(); } else { MessageBox.Show(Constant.DBErrorMsg, Constant.NOTIFICATION_ERROR_DATA_SAVING, MessageBoxButtons.OK, MessageBoxIcon.Error); } } rtxtContent.Text = string.Empty; cmbBook.SelectedIndex = 0; cmbChapter.SelectedIndex = 0; tbcUpload.SelectedIndex = 0; }