public UserNotification InsertUserNotification(UserNotification ins)
        {
            int ModifiedBy = (int)HttpContext.Current.Session["UserNo"];

            DataBaseConnection dbConn = new DataBaseConnection();
            SqlConnection con = dbConn.SqlConn();
            con.Open();

            SqlCommand cmdI = con.CreateCommand();
            SqlTransaction trx = con.BeginTransaction(CommonStrings.InsertTransaction);

            cmdI.Connection = con;
            cmdI.Transaction = trx;

            try
            {
                cmdI.Parameters.Clear();
                cmdI.CommandText = CommonStrings.InsertUserNotifications;
                cmdI.CommandType = System.Data.CommandType.StoredProcedure;
                cmdI.Parameters.AddWithValue("@UserId", ModifiedBy);
                cmdI.Parameters.AddWithValue("@NotificationType", ins.NotificationTypeId);
                cmdI.Parameters.AddWithValue("@API", ins.API);
                cmdI.Parameters.AddWithValue("@ModifiedDate", DateTime.Now);
                cmdI.Parameters.AddWithValue("@ModifiedBy", ModifiedBy);
                cmdI.Parameters.AddWithValue("@Removed", 0);
                cmdI.Parameters.AddWithValue("@CompanyId", ins.CompanyId);
                ins.UserNotificationId = (int)cmdI.ExecuteScalar();

                trx.Commit();
                cmdI.Connection.Close();
            }
            catch (SqlException ex)
            {
                if (trx != null) trx.Rollback();
            }
            finally
            {
                if (con.State != ConnectionState.Closed)
                {
                    con.Close();
                }

                con.Dispose();
                cmdI.Dispose();
                trx.Dispose();
            }

            return ins;
        }
        public UserNotification GetUserNotification(int UserNotificationId)
        {
            UserNotification ReturnObject = new UserNotification();

            DataBaseConnection dbConn = new DataBaseConnection();
            SqlConnection con = dbConn.SqlConn();
            SqlCommand cmdI = con.CreateCommand();
            cmdI.Connection = con;

            cmdI.Parameters.Clear();
            cmdI.CommandText = CommonStrings.GetUserNotification;
            cmdI.CommandType = System.Data.CommandType.StoredProcedure;
            cmdI.Parameters.AddWithValue("@UserNotificationId", UserNotificationId);
            cmdI.Connection.Open();

            SqlDataReader drI = cmdI.ExecuteReader();

            if (drI.HasRows)
            {
                while (drI.Read())
                {
                    ReturnObject.UserNotificationId = Convert.ToInt32(drI["UserNotificationId"]);
                    ReturnObject.API = drI["API"].ToString();
                    ReturnObject.ModifiedBy = Convert.ToInt32(drI["ModifiedBy"]);
                    ReturnObject.ModifiedDate = Convert.ToDateTime(drI["ModifiedDate"]);
                    ReturnObject.CompanyId = Convert.ToInt32(drI["CompanyId"]);
                    ReturnObject.NotificationTypeId = Convert.ToInt32(drI["NotificationType"]);
                    ReturnObject.UserId = Convert.ToInt32(drI["UserId"]);
                }
            }

            cmdI.Connection.Close();
            con.Dispose();

            return ReturnObject;
        }
Exemple #3
0
        public List<UserNotification> GetUserNotifications()
        {
            List<UserNotification> ReturnObject = new List<UserNotification>();
            UserNotification ins;

            DataBaseConnection dbConn = new DataBaseConnection();

            var table = GetCompaniesDBVariable();

            if (table != null)
            {
                using (var con = dbConn.SqlConn())
                {
                    con.Open();

                    using (SqlCommand cmd = new SqlCommand("exec " + CommonStrings.GetAllUserNotifications + " @Companies", con))
                    {
                        var pList = new SqlParameter("@Companies", SqlDbType.Structured);
                        pList.TypeName = "dbo.IntList";
                        pList.Value = table;

                        cmd.Parameters.Add(pList);

                        using (var drI = cmd.ExecuteReader())
                        {
                            while (drI.Read())
                            {
                                ins = new UserNotification();
                                ins.UserNotificationId = Convert.ToInt32(drI["UserNotificationId"]);
                                ins._Company = drI["Company"].ToString();
                                ins._ModifiedBy = drI["ModifiedUser"].ToString();
                                ins._NotificationType = drI["NotificationTypeDescription"].ToString();
                                ins._Username = drI["Username"].ToString();
                                ins.API = drI["API"].ToString();
                                ins.ModifiedBy = Convert.ToInt32(drI["ModifiedBy"]);
                                ins.ModifiedDate = Convert.ToDateTime(drI["ModifiedDate"]);
                                ins.CompanyId = Convert.ToInt32(drI["CompanyId"]);
                                ins.NotificationTypeId = Convert.ToInt32(drI["NotificationType"]);
                                ins.UserId = Convert.ToInt32(drI["UserId"]);
                                ReturnObject.Add(ins);
                            }
                        }
                    }
                }
            }

            return ReturnObject;
        }
        public UserNotification UpdateUserNotification(UserNotification ins)
        {
            int ModifiedBy = (int)HttpContext.Current.Session["UserNo"];
            DataBaseConnection dbConn = new DataBaseConnection();
            SqlConnection con = dbConn.SqlConn();
            con.Open();
            SqlCommand cmdI = con.CreateCommand();
            cmdI.Connection = con;

            cmdI.Parameters.Clear();
            cmdI.CommandText = CommonStrings.UpdateUserNotifications;
            cmdI.CommandType = System.Data.CommandType.StoredProcedure;
            cmdI.Parameters.AddWithValue("@UserNotificationId", ins.UserNotificationId);
            cmdI.Parameters.AddWithValue("@UserId", ModifiedBy);
            cmdI.Parameters.AddWithValue("@NotificationType", ins.NotificationTypeId);
            cmdI.Parameters.AddWithValue("@API", ins.API);
            cmdI.Parameters.AddWithValue("@ModifiedDate", DateTime.Now);
            cmdI.Parameters.AddWithValue("@ModifiedBy", ModifiedBy);
            cmdI.Parameters.AddWithValue("@Removed", 0);
            cmdI.Parameters.AddWithValue("@CompanyId", ins.CompanyId);

            cmdI.ExecuteNonQuery();
            cmdI.Connection.Close();
            con.Dispose();

            return ins;
        }
 public JsonResult _UpdateUserNotification(UserNotification ins)
 {
     ins = notifyRep.UpdateUserNotification(ins);
     return Json(new GridModel(commonRep.GetUserNotifications()));
 }