public bool ExecuteDownLoadTask(DownloadTask dtask, DownloadLogVo downloadLogVo)
{
try
{
WebClient webclient = new WebClient();
webclient.Credentials = WerpCredentials.GetDefaultCredentials();
NAVFile = GetLocalStoragePath() + "NAV-" + DateTime.Now.ToString("yyyy-MM-dd") + "---" + DateTime.Now.Ticks + ".txt";
logger.Info("Download file name : " + NAVFile);
webclient.DownloadFile(dtask.DownLoadURL, NAVFile);
downloadLogVo.Is_Downloaded = true;
DownloadLog.Update(downloadLogVo);
//NAVFile = "C:\\PCGNAVData\\NAV-2010-04-23---634076155947031250.txt";
}
catch (Exception ex)
{
logger.Fatal("Error occurred while downloading NAV. ExecuteDownLoadTask()" + ex.ToString());
return(false);
}
List <WerpMutualFund> listMF = new NavFormatter().LoadMutualData(new NavFormatter().FormatDownloadedFile(NAVFile));
DBUpdate dbupdate = new DBUpdate();
int totalUpdateSchemes = dbupdate.DBupload(listMF, downloadLogVo);
if (totalUpdateSchemes > 0)
{
downloadLogVo.Is_AF_Updated = true;
DownloadLog.Update(downloadLogVo);
return(true);
}
else
{
return(false);
}
}
public static bool Update(DownloadLogVo downloadLogVo)
{
SqlConnection con = DBAccess.GetWERPOpenConnection();
SqlCommand cmd = null;
string logFile = "NAV_LOG--" + DateTime.Now.ToString("") + ".txt";
try
{
cmd = new SqlCommand("usp_NAV_DOWNLOAD_LOGUpdate", con);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
//cmd.Parameters.Add("@Start_Time", SqlDbType.DateTime).Value = DateTime.Now;
cmd.Parameters.Add(new SqlParameter("@ID", downloadLogVo.ID));
cmd.Parameters.Add(new SqlParameter("@End_Time", DateTime.Now));
if (downloadLogVo.Is_Downloaded == true)
{
cmd.Parameters.Add(new SqlParameter("@Is_Downloaded", downloadLogVo.Is_Downloaded));
}
if (downloadLogVo.Is_AF_Updated == true)
{
cmd.Parameters.Add(new SqlParameter("@Is_AF_Updated", downloadLogVo.Is_AF_Updated));
}
if (downloadLogVo.Is_AF_Updated == true)
{
cmd.Parameters.Add(new SqlParameter("Is_WERP_Snapshot_Updated", downloadLogVo.Is_WERP_Snapshot_Updated));
}
//if (downloadLogVo.Downloaded_Schemes != null)
// cmd.Parameters.Add(new SqlParameter("@Downloaded_Schemes", downloadLogVo.Downloaded_Schemes));
if (downloadLogVo.Description != null)
{
cmd.Parameters.Add(new SqlParameter("@Description", downloadLogVo.Description));
}
// cmd.Parameters.Add(new SqlParameter("@Rejected_Schemes", downloadLogVo.RejectedSchemes));
cmd.Parameters.Add(new SqlParameter("@Updated_Schemes_Count", downloadLogVo.UpdatedSchemesCount));
cmd.Parameters.Add(new SqlParameter("@Rejected_Schemes_Count", downloadLogVo.RejectedSchemesCount));
int retValue = cmd.ExecuteNonQuery();
if (retValue == 1)
{
return(true);
}
else
{
return(false);
}
}
catch (Exception ex)
{
logger.Error("An error occurred while updating download log." + ex.ToString());
}
return(false);
}
public int DBupload(List <WerpMutualFund> mflist, DownloadLogVo downloadLogVo)
{
SqlCommand cmd = null;
SqlConnection con = DBAccess.GetAFOpenConnection();
string updatedSchemes = string.Empty;
logger.Debug("Updating/Inserting data to DB");
int totalUpdatedSchemes = 0;
foreach (WerpMutualFund m in mflist)
{
try
{
cmd = new SqlCommand("usp_DAILY_NAV_Upload", con);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.Add("@SCHEMECODE", SqlDbType.Float).Value = m.SCHEMECODE;
if (!String.IsNullOrEmpty(m.NAV_DATE))
{
cmd.Parameters.Add("@NAV_DATE", SqlDbType.DateTime).Value = DateTime.Parse(m.NAV_DATE);
}
if (!String.IsNullOrEmpty(m.NAVRS))
{
cmd.Parameters.Add("@NAVRS", SqlDbType.Float).Value = m.NAVRS;
}
;
if (!String.IsNullOrEmpty(m.REPURPRICE))
{
cmd.Parameters.Add("@REPURPRICE", SqlDbType.Float).Value = m.REPURPRICE;
}
;
if (!String.IsNullOrEmpty(m.SALEPRICE))
{
cmd.Parameters.Add("@SALEPRICE", SqlDbType.Float).Value = m.SALEPRICE;
}
;
if (m.CLDATE != string.Empty)
{
cmd.Parameters.Add("@CLDATE", SqlDbType.DateTime).Value = DateTime.Parse(m.CLDATE);//, "MM/dd/yyyy hh:mm:ss", culture, DateTimeStyles.NoCurrentDateDefault);// DateTime.Parse(m.CLDATE);
}
if (!String.IsNullOrEmpty(m.CHANGE))
{
cmd.Parameters.Add("@CHANGE", SqlDbType.Float).Value = m.CHANGE;
}
if (!String.IsNullOrEmpty(m.NETCHANGE))
{
cmd.Parameters.Add("@NETCHANGE", SqlDbType.Float).Value = m.NETCHANGE;
}
if (!String.IsNullOrEmpty(m.PREVNAV))
{
cmd.Parameters.Add("@PREVNAV", SqlDbType.Float).Value = m.PREVNAV;
}
if (m.PRENAVDATE != string.Empty)
{
cmd.Parameters.Add("@PRENAVDATE", SqlDbType.DateTime).Value = DateTime.Parse(m.PRENAVDATE);//, "MM/dd/yyyy hh:mm:ss", culture, DateTimeStyles.NoCurrentDateDefault);// DateTime.Parse(m.PRENAVDATE);
}
cmd.Parameters.Add("@UPD_FLAG", SqlDbType.VarChar).Value = m.UPD_FLAG;;
cmd.ExecuteNonQuery();
updatedSchemes += m.SCHEMECODE + ",";
totalUpdatedSchemes++;
}
catch (Exception ex)
{
// downloadLogVo.Downloaded_Schemes += m.SCHEMECODE;
logger.Error("An error occurred while updating the scheme details for scheme : " + m.SCHEMECODE + ": " + ex.ToString());
}
}
// logger.Debug("Updated Schemes :" + updatedSchemes);
if (!String.IsNullOrEmpty(downloadLogVo.RejectedSchemes))
{
logger.Debug("Rejected Schemes : " + downloadLogVo.RejectedSchemes);
}
downloadLogVo.Is_AF_Updated = true;
logger.Debug("The following schemes Inserted/Updated in AF table: " + updatedSchemes.ToString());
// downloadLogVo.Downloaded_Schemes = updatedSchemes;
DownloadLog.Update(downloadLogVo);
if (con != null && con.State == ConnectionState.Open)
{
try
{
// logger.Debug("Closing DB connection");
con.Close();
}
catch (Exception ex)
{
logger.Fatal("Error occurred while closing connection");
}
}
return(totalUpdatedSchemes);
}
