Example #1
0
 partial void DeletetblContact(tblContact instance);
Example #2
0
 partial void InserttblContact(tblContact instance);
Example #3
0
 partial void UpdatetblContact(tblContact instance);
Example #4
0
        /// <summary>
        /// Thêm một email
        /// </summary>
        /// <param name="_from"></param>
        /// <param name="_to"></param>
        /// <param name="_subject"></param>
        /// <param name="_content"></param>
        /// <param name="_posted"></param>
        /// <returns></returns>
        public Boolean insertEmail(string _username, string _from, string _to,
            string _subject, string _content, DateTime _posted)
        {
            int id = 0;
            try
            {
                using (TransactionScope ts = new TransactionScope())
                {
                    tblContact contact = new tblContact();
                    contact.EmailFrom = _from;
                    contact.EmailTo = _to;
                    contact.Subject = _subject;
                    contact.Contents = _content;
                    contact.Posted = _posted;
                    contact.isRead = false;

                    DB.tblContacts.InsertOnSubmit(contact);
                    DB.SubmitChanges();
                    ts.Complete();

                    id = contact.ID;

                    log.writeLog(DBHelper.strPathLogFile,
                                  _username,
                                  BaseServices.createMsgByTemplate(CommonConstants.SQL_INSERT_SUCCESSFUL_TEMPLATE,
                                                                   Convert.ToString(id),
                                                                   CommonConstants.SQL_TABLE_CONTACT));

                }
            }
            catch (Exception e)
            {

                log.writeLog(DBHelper.strPathLogFile,
                                  _username,
                                  BaseServices.createMsgByTemplate(CommonConstants.SQL_INSERT_SUCCESSFUL_TEMPLATE,
                                                                   Convert.ToString(id),
                                                                   CommonConstants.SQL_TABLE_CONTACT));
                log.writeLog(DBHelper.strPathLogFile, _username, e.Message);

                return false;
            }

            return true;
        }