public void GetDailyXmlFile(int xslIId)
{
WebClient webCli = new WebClient();
string xmlData = "";
if (!Directory.Exists(Server.MapPath("~/Services/PrayerTimes/" + DateTime.Now.Day + DateTime.Now.Month + ".xml")))
{
xmlData = webCli.DownloadString("http://www.islamicfinder.org/prayer_service.php?country=jordan&city=amman&state=11&zipcode=&latitude=31.9500&longitude=35.9333&timezone=2&HanfiShafi=1&pmethod=4&fajrTwilight1=10&fajrTwilight2=10&ishaTwilight=10&ishaInterval=30&dhuhrInterval=1&maghribInterval=1&dayLight=1&simpleFormat=xml");
xmlData = xmlData.Substring(3, xmlData.Length - 3);
XmlDocument xDoc = new XmlDocument();
xDoc.LoadXml(xmlData);
xDoc.Save(Server.MapPath("~/Services/PrayerTimes/" + DateTime.Now.Day + DateTime.Now.Month + ".xml"));
}
else
{
StreamReader reader = new StreamReader(Server.MapPath("~/Services/PrayerTimes/" + DateTime.Now.Day + DateTime.Now.Month + ".xml"));
xmlData = reader.ReadToEnd();
}
XslTemplate _xslTemplate = new XslTemplate();
_xslTemplate = XslTemplateManager.GetByID(xslIId);
if (null == _xslTemplate)
return;
string html = TransformXMLWithXSLText(xmlData, _xslTemplate.Details);
dvdate.InnerHtml = html;
}
public int Add(XslTemplate obj)
{
_connection.ConnectionString = _ConnectionString;
_command.Connection = _connection;
_command.CommandType = CommandType.StoredProcedure;
_command.CommandText = INSERTXslTemplate;
#region [Parameters]
SqlParameter parameterID = new SqlParameter(PN_ID, SqlDbType.Int);
parameterID.Value = obj.ID;
parameterID.Direction = ParameterDirection.Output;
_command.Parameters.Add(parameterID);
SqlParameter parameterName = new SqlParameter(PN_NAME, SqlDbType.NVarChar);
parameterName.Value = obj.Name;
parameterName.Direction = ParameterDirection.Input;
_command.Parameters.Add(parameterName);
SqlParameter parameterDetails = new SqlParameter(PN_DETAILS, SqlDbType.NVarChar);
parameterDetails.Value = obj.Details;
parameterDetails.Direction = ParameterDirection.Input;
_command.Parameters.Add(parameterDetails);
SqlParameter parameterIsDeleted = new SqlParameter(PN_ISDELETED, SqlDbType.Int);
parameterIsDeleted.Value = obj.IsDeleted;
parameterIsDeleted.Direction = ParameterDirection.Input;
_command.Parameters.Add(parameterIsDeleted);
SqlParameter parameterHash = new SqlParameter(PN_HASH, SqlDbType.NVarChar);
parameterHash.Value = obj.Hash;
parameterHash.Direction = ParameterDirection.Input;
_command.Parameters.Add(parameterHash);
SqlParameter parameterCategoryID = new SqlParameter(PN_CATEGORYID, SqlDbType.Int);
parameterCategoryID.Value = obj.CategoryID;
parameterCategoryID.Direction = ParameterDirection.Input;
_command.Parameters.Add(parameterCategoryID);
#endregion;
_connection.Open();
_command.ExecuteNonQuery();
_connection.Close();
obj.ID = Convert.ToInt32(parameterID.Value);
return obj.ID;
}
public void PopulateXslTemplate(SqlDataReader _dtr, XslTemplate obj)
{
int columnIndex = 0;
columnIndex = _dtr.GetOrdinal(XslTemplateDataMapper.CN_ID);
if (!_dtr.IsDBNull(columnIndex))
{
obj.ID = _dtr.GetInt32((columnIndex));
}
columnIndex = _dtr.GetOrdinal(XslTemplateDataMapper.CN_NAME);
if (!_dtr.IsDBNull(columnIndex))
{
obj.Name = _dtr.GetString((columnIndex));
}
columnIndex = _dtr.GetOrdinal(XslTemplateDataMapper.CN_DETAILS);
if (!_dtr.IsDBNull(columnIndex))
{
obj.Details = _dtr.GetString((columnIndex));
}
columnIndex = _dtr.GetOrdinal(XslTemplateDataMapper.CN_ISDELETED);
if (!_dtr.IsDBNull(columnIndex))
{
obj.IsDeleted = _dtr.GetBoolean((columnIndex));
}
columnIndex = _dtr.GetOrdinal(XslTemplateDataMapper.CN_HASH);
if (!_dtr.IsDBNull(columnIndex))
{
obj.Hash = _dtr.GetString((columnIndex));
}
columnIndex = _dtr.GetOrdinal(XslTemplateDataMapper.CN_CATEGORYID);
if (!_dtr.IsDBNull(columnIndex))
{
obj.CategoryID = _dtr.GetInt32((columnIndex));
}
}
public XslTemplate GetXslTemplate(SqlDataReader _dtr, IList<XslTemplate> colobj)
{
XslTemplate obj = colobj.Where(t => t.ID == Convert.ToInt32(_dtr[CN_ID].ToString())).SingleOrDefault();
if (null == obj)
{
obj = new XslTemplate();
colobj.Add(obj);
}
return obj;
}
public IList<XslTemplate> GetByCategoryID(int CatID)
{
XslTemplate obj = null;
IList<XslTemplate> colobj = null;
_connection.ConnectionString = _ConnectionString;
_command.Connection = _connection;
_command.CommandType = CommandType.StoredProcedure;
_command.CommandText = SELECTALLXslTemplateByCatID;
#region [Parameters]
SqlParameter parameterID = new SqlParameter(PN_CATEGORYID, SqlDbType.Int);
parameterID.Value = CatID;
parameterID.Direction = ParameterDirection.Input;
_command.Parameters.Add(parameterID);
#endregion;
_connection.Open();
try
{
using (_dtreader = _command.ExecuteReader())
{
if (_dtreader != null && _dtreader.HasRows)
{
obj = new XslTemplate();
colobj = new List<XslTemplate>();
while (_dtreader.Read())
{
obj = GetXslTemplate(_dtreader, colobj);
GetEntityFromReader(_dtreader, obj);
}
}
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
_dtreader.Close();
_connection.Close();
}
return colobj;
}
public IList<XslTemplate> GetAll()
{
XslTemplate obj = null;
IList<XslTemplate> colobj = new List<XslTemplate>();
_connection.ConnectionString = _ConnectionString;
_command.Connection = _connection;
_command.CommandType = CommandType.StoredProcedure;
_command.CommandText = SELECTALLXslTemplate;
_connection.Open();
try
{
using (_dtreader = _command.ExecuteReader())
{
if (_dtreader != null && _dtreader.HasRows)
{
obj = new XslTemplate();
colobj = new List<XslTemplate>();
while (_dtreader.Read())
{
obj = GetXslTemplate(_dtreader, colobj);
GetEntityFromReader(_dtreader, obj);
}
}
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
_dtreader.Close();
_connection.Close();
}
return colobj;
}
private void GetEntityFromReader(SqlDataReader _dtr, XslTemplate obj)
{
PopulateXslTemplate(_dtr, obj);
}
public XslTemplate GetByID(int ID)
{
XslTemplate obj = null;
_connection.ConnectionString = _ConnectionString;
_command.Connection = _connection;
_command.CommandType = CommandType.StoredProcedure;
_command.CommandText = SELECTXslTemplate;
#region [Parameters]
SqlParameter parameterID = new SqlParameter(PN_ID, SqlDbType.Int);
parameterID.Value = ID;
parameterID.Direction = ParameterDirection.Input;
_command.Parameters.Add(parameterID);
#endregion;
_connection.Open();
try
{
using (_dtreader = _command.ExecuteReader())
{
if (_dtreader != null && _dtreader.HasRows)
{
obj = new XslTemplate();
if (_dtreader.Read())
GetEntityFromReader(_dtreader, obj);
}
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
_dtreader.Close();
_connection.Close();
}
return obj;
}
public static void Update(XslTemplate obj)
{
XslTemplateDataMapper objCaller = new XslTemplateDataMapper();
objCaller.Update(obj);
}
public static int Add(XslTemplate obj)
{
XslTemplateDataMapper objCaller = new XslTemplateDataMapper();
return objCaller.Add(obj);
}
private void EditMode()
{
if (ObjectID > 0)
{
XslTemplate cat = new XslTemplate();
cat = XslTemplateManager.GetByID(ObjectID);
if (null == cat)
return;
txtName.Text = cat.Name;
txtHash.Text = cat.Hash;
txtDetails.Content = cat.Details;
plcControls.Visible = true;
}
}
void btnSaveUpdate_Click(object sender, EventArgs e)
{
XslTemplate Xsl = new XslTemplate();
if (ObjectID <= 0)
{
try
{
Xsl.IsDeleted = false;
Xsl.Name = txtName.Text;
using (StringReader xslStringReader = new StringReader(txtDetails.Content))
{
//pass xsl text into xmltextreader
using (XmlReader styleSheet = new XmlTextReader(xslStringReader))
{
//create the transformation class
XslCompiledTransform xslTrans = new XslCompiledTransform();
//load the xsl into the transformer
xslTrans.Load(styleSheet);
//create a stringwriter for outputting html to
}
}
Xsl.Details = (txtDetails.Content);
Xsl.Hash = txtHash.Text;
Xsl.CategoryID = -1;
XslTemplateManager.Add(Xsl);
AddMode();
}
catch (Exception ex)
{
dvProblems.Style.Clear();
dvProblems.InnerText = ex.ToString();
}
}
else
{
try
{
Xsl = XslTemplateManager.GetByID(ObjectID);
if (null == Xsl)
{
dvProblems.InnerText = Resources.ExpressCMS.ResourceManager.GetString(ConstantsManager.UnknowErronOccures);
return;
}
Xsl.IsDeleted = false;
Xsl.Name = txtName.Text;
using (StringReader xslStringReader = new StringReader(txtDetails.Content))
{
//pass xsl text into xmltextreader
using (XmlReader styleSheet = new XmlTextReader(xslStringReader))
{
//create the transformation class
XslCompiledTransform xslTrans = new XslCompiledTransform();
//load the xsl into the transformer
xslTrans.Load(styleSheet);
}
}
Xsl.Details = (txtDetails.Content);
Xsl.Hash = txtHash.Text;
Xsl.CategoryID = -1;
XslTemplateManager.Update(Xsl);
EditMode();
}
catch (Exception ex)
{
dvProblems.Style.Clear();
dvProblems.InnerText = ex.ToString();
}
}
BindGrid();
}