private void GetFromNotification() { if (Session["AlertID"] != null) { int alertid = int.TryParse(Session["AlertID"].ToString(), out alertid) ? alertid : 0; Session["AlertID"] = null; NotifiedData notifiedData = DCMemoBAL.GetNotifiedData(alertid); Response.Write(notifiedData.ToJSON()); } }
public static NotifiedData GetNotifiedData(int alertid, int userid) { var dbUtil = new DatabaseManager(); var notifiedData = new NotifiedData(); using (var conn = new SqlConnection(dbUtil.getSQLConnectionString("MainDB"))) { conn.Open(); using (SqlCommand cmd = conn.CreateCommand()) { cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "spGetNotifiedData"; cmd.CommandTimeout = 180; cmd.Parameters.Clear(); cmd.Parameters.AddWithValue("@intAlertID", alertid); cmd.Parameters.AddWithValue("@intUserID", userid); using (SqlDataReader reader = cmd.ExecuteReader()) { while (reader.Read()) { notifiedData = new NotifiedData { BranchID = ReferenceEquals(reader["intBranchID"], DBNull.Value) ? 0 : Convert.ToInt32(reader["intBranchID"]), OriginatingBranchID = ReferenceEquals(reader["intOriginatingBranchID"], DBNull.Value) ? 0 : Convert.ToInt32(reader["intOriginatingBranchID"]), SaleID = ReferenceEquals(reader["intSaleID"], DBNull.Value) ? 0 : Convert.ToInt32(reader["intSaleID"]), AccountCode = ReferenceEquals(reader["strAccountCode"], DBNull.Value) ? String.Empty : Convert.ToString(reader["strAccountCode"]), CustomerName = ReferenceEquals(reader["strCustomerName"], DBNull.Value) ? String.Empty : Convert.ToString(reader["strCustomerName"]), AlertID = ReferenceEquals(reader["intAlertID"], DBNull.Value) ? 0 : Convert.ToInt32(reader["intAlertID"]), AdjustmentTypeID = ReferenceEquals(reader["intAdjustmentTypeID"], DBNull.Value) ? 0 : Convert.ToInt32(reader["intAdjustmentTypeID"]), AdjustmentDate = ReferenceEquals(reader["datAdjustmentDate"], DBNull.Value) ? String.Empty : Convert.ToString(reader["datAdjustmentDate"]), Remarks = ReferenceEquals(reader["strRemarks"], DBNull.Value) ? String.Empty : Convert.ToString(reader["strRemarks"]), SIDate = ReferenceEquals(reader["datSIDate"], DBNull.Value) ? String.Empty : Convert.ToString(reader["datSIDate"]), AmountToAdjust = ReferenceEquals(reader["curAmountToAdjust"], DBNull.Value) ? 0 : Convert.ToDouble(reader["curAmountToAdjust"]), Rebate = ReferenceEquals(reader["curRebate"], DBNull.Value) ? 0 : Convert.ToDouble(reader["curRebate"]), Penalty = ReferenceEquals(reader["curPenalty"], DBNull.Value) ? 0 : Convert.ToDouble(reader["curPenalty"]), TotalAmountAdjust = ReferenceEquals(reader["curTotalAmountAdjust"], DBNull.Value) ? 0 : Convert.ToDouble(reader["curTotalAmountAdjust"]) }; } return(notifiedData); } } } }