public distroTrend.Model.Points Select(string connString, distroTrend.Model.Points points)
{
DBConn conn = new DBConn();
String query = "SELECT * FROM [dbo].[tbl_Points] WHERE distroId = @distroId and Date = @Date";
distroTrend.Model.Points objPoints = new distroTrend.Model.Points();
List <SqlParameter> sp = new List <SqlParameter>()
{
new SqlParameter()
{
ParameterName = "@distroId", SqlDbType = SqlDbType.Int, Value = points.distroId
},
new SqlParameter()
{
ParameterName = "@Date", SqlDbType = SqlDbType.DateTime, Value = points.Date.Date
}
};
DataSet ds = conn.GetData(connString, query, sp);
objPoints = ds.Tables[0].AsEnumerable()
.Select(dataRow => new distroTrend.Model.Points
{
distroId = dataRow.Field <int>("distroId"),
Date = dataRow.Field <DateTime>("Date"),
TotalPoints = dataRow["TotalPoints"] == DBNull.Value ? 0 : dataRow.Field <decimal>("TotalPoints")
}).FirstOrDefault();
return(objPoints);
}
public int Update(string connString, distroTrend.Model.Points points)
{
DBConn conn = new DBConn();
String query = "UPDATE [dbo].[tbl_Points] SET [DistroWatchPoints] = @DistroWatchPoints WHERE distroId = @distroId";
List <SqlParameter> sp = new List <SqlParameter>()
{
new SqlParameter()
{
ParameterName = "@distroId", SqlDbType = SqlDbType.Int, Value = points.distroId
},
new SqlParameter()
{
ParameterName = "@DistroWatchPoints", SqlDbType = SqlDbType.Decimal, Value = points.DistroWatchPoints
}
};
return(conn.UpdateData(connString, query, sp));
}
public int Insert(string connString, distroTrend.Model.Points points)
{
DBConn conn = new DBConn();
String query = "INSERT INTO [dbo].[tbl_Points] ([distroId],[DistroWatchPoints]) VALUES (@distroId,@DistroWatchPoints)";
List <SqlParameter> sp = new List <SqlParameter>()
{
new SqlParameter()
{
ParameterName = "@distroId", SqlDbType = SqlDbType.Int, Value = points.distroId
},
new SqlParameter()
{
ParameterName = "@DistroWatchPoints", SqlDbType = SqlDbType.Decimal, Value = points.DistroWatchPoints
}
};
return(conn.InsertData(connString, query, sp));
}
public bool IsExists(string connString, int distroId, DateTime date)
{
DAL.Points objPoints = new DAL.Points();
bool isExists = false;
distroTrend.Model.Points points = new distroTrend.Model.Points()
{
distroId = distroId,
Date = date
};
distroTrend.Model.Points pointsDb = objPoints.Select(connString, points);
if (pointsDb != null)
{
isExists = true;
}
return(isExists);
}
static List <distroTrend.Model.Points> ParseDataDWPoints(string data, string connString)
{
BLL.Distro distroBL = new BLL.Distro();
List <distroTrend.Model.Distro> listDistro = distroBL.GetDistro(connString);
List <distroTrend.Model.Points> listDistroPoints = new List <distroTrend.Model.Points>();
var doc = new HtmlAgilityPack.HtmlDocument();
doc.LoadHtml(data);
var nodes = doc.DocumentNode.SelectNodes(@"//td[@class='phr2']/a");
int counter = 0;
foreach (HtmlNode node in nodes)
{
counter++;
string title = node.InnerText;
string[] token = node.OuterHtml.Split(new char[] { '\"' }, StringSplitOptions.RemoveEmptyEntries);
string dwCode = string.Empty;
if (token.Length > 1)
{
dwCode = token[1];
}
string code = GetCode(title);
Decimal points = 0;
string pointsString = string.Empty;
HtmlNode nodeTr = node.ParentNode.ParentNode;
if (nodeTr != null && nodeTr.ChildNodes.Count > 4)
{
pointsString = nodeTr.ChildNodes[5].InnerText;
}
//HtmlNodeCollection nodePoints = nodeTr.SelectNodes(@"//td[@class='phr3']");
//foreach (HtmlNode nodeTd in nodePoints)
//{
// pointsString = nodeTd.InnerText;
//}
Decimal.TryParse(pointsString, out points);
logger.Debug("Points in string=" + pointsString + ", and after convertion points=" + points);
distroTrend.Model.Distro distro = listDistro.Where(x => x.Code.Trim() == code).FirstOrDefault();
//distro.Id;
if (distro != null)
{
distroTrend.Model.Points objPoints = new distroTrend.Model.Points();
objPoints.distroId = distro.Id;
objPoints.DistroWatchPoints = points;
objPoints.Date = DateTime.Now;
distroTrend.Model.Points pointE = listDistroPoints.FirstOrDefault(p => p.distroId == objPoints.distroId);
if (pointE != null)
{
pointE.DistroWatchPoints = points;
logger.Debug("Updated in list, Id=" + objPoints.distroId + ", Points=" + objPoints.DistroWatchPoints);
}
else
{
listDistroPoints.Add(objPoints);
logger.Debug("Added to list, Id=" + objPoints.distroId + ", Points=" + objPoints.DistroWatchPoints);
}
}
//if (listDistroPoints.Count > 30)
// break;
}
return(listDistroPoints);
}
public int Update(string connString, distroTrend.Model.Points points)
{
DAL.Points objVersion = new DAL.Points();
return(objVersion.Update(connString, points));
}
public int Insert(string connString, distroTrend.Model.Points points)
{
DAL.Points objVersion = new DAL.Points();
return(objVersion.Insert(connString, points));
}
