//internal static int GetCount() //{ // Model.Common.ArchiveCommonDataClassesDataContext db = new Model.Common.ArchiveCommonDataClassesDataContext(Setting.Sql.ThisProgram.DatabaseConnection.ConnectionString); // return db.Messages.Count(); //} #region ذخیره پیام internal static bool Insert(Model.Common.Message model) { try { Model.Common.ArchiveCommonDataClassesDataContext db = new Model.Common.ArchiveCommonDataClassesDataContext(Setting.Sql.ThisProgram.DatabaseConnection.ConnectionString); db.Messages.InsertOnSubmit(model); db.SubmitChanges(); return(true); } catch { return(false); } }
private void btn_Save_Click(object sender, EventArgs e) { if (txtB_Title.Text.Count() > 0 && cblTitle.CheckedItems.Count > 0) { Model.Common.Message NewMessage = new Model.Common.Message() { SendDate = DateTime.Now, Text = editorMessage.BodyText, Title = txtB_Title.Text, Type = 1, UserCode = id_User, }; bool Result = MessageController.Insert(NewMessage); if (Result) { int id = 0; foreach (DataRowView checkedItem in cblTitle.CheckedItems) { id = Convert.ToInt32(checkedItem[cblTitle.ValueMember].ToString()); MessageUserController.Insert(new Model.Common.MessageUser() { UserCode = id, MessageID = NewMessage.ID, State = (int)Enums.StateTypeMessage.خوانده_نشده, DateShow = DateTime.Now }); } PersianMessageBox.Show("پیام ارسال شد", "پیام"); this.Close(); } } else { PersianMessageBox.Show("لطفا عنوان و گیرنندگان را مشخص نید", "پیام"); } }