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);
}
}
}
}
