public FileLocationFetchModel GetfileInformation()
{
FileLocationFetchModel fdModel = new FileLocationFetchModel();
try
{
using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["fileDbConnection"].ConnectionString))
{
SqlDataAdapter daFetch = new SqlDataAdapter("Get_FileInformation", conn);
daFetch.SelectCommand.CommandType = CommandType.StoredProcedure;
DataTable dt = new DataTable();
daFetch.Fill(dt);
if (dt.Rows.Count > 0)
{
fdModel.File_id = Convert.ToInt32(dt.Rows[0]["file_id"]);
fdModel.FileName = dt.Rows[0]["filename"].ToString();
fdModel.FileLocation = dt.Rows[0]["filelocation"].ToString();
fdModel.FileExtension = dt.Rows[0]["fileextension"].ToString();
fdModel.FirstDelieryMethod = dt.Rows[0]["firstdeliveryMethod"].ToString();
fdModel.SeconddeliveryMethod = dt.Rows[0]["seconddeliveryMethod"].ToString();
fdModel.Status = dt.Rows[0]["Status"].ToString();
}
}
return(fdModel);
}
catch (Exception ex)
{
string Path = "File Service";
string Method = MethodBase.GetCurrentMethod().Name;
string Exmsg = ex.Message;
InsertException(Path, Method, DateTime.Now, Exmsg);
return(fdModel);
}
}
public void OnTimer(object sender, ElapsedEventArgs args)
{
eventLog1.WriteEntry("Entered Event");
DataLayer data = new DataLayer();
FileLocationFetchModel fetchModel = data.GetfileInformation();
if (fetchModel != null)
{
FileOperations file = new FileOperations(fetchModel);
DeliveryMethods deliveryMethod;
if (fetchModel.Status == "")
{
Enum.TryParse(fetchModel.FirstDelieryMethod, out deliveryMethod);
}
else
{
Enum.TryParse(fetchModel.SeconddeliveryMethod, out deliveryMethod);
}
switch (deliveryMethod)
{
case DeliveryMethods.SendMail:
int ret = file.SendMail();
if (ret == 1)
{
eventLog1.WriteEntry("Mail Event Successfull");
data.UpdateFileOperationStatus(fetchModel.File_id, fetchModel.Status);
}
else
{
eventLog1.WriteEntry("Mail Event Unsuccessfull");
data.InsertException("File Service", MethodBase.GetCurrentMethod().Name, DateTime.Now, "Mail Sending Failed");
}
break;
case DeliveryMethods.NewFolder:
int successs = file.SaveToAnotherFolder();
if (successs == 1)
{
eventLog1.WriteEntry("Folder Event Successfull");
data.UpdateFileOperationStatus(fetchModel.File_id, fetchModel.Status);
}
else
{
eventLog1.WriteEntry("Folder Event UnSuccessfull");
data.InsertException("File Service", MethodBase.GetCurrentMethod().Name, DateTime.Now, "File Transfer Failed");
}
break;
}
}
}
public FileOperations(FileLocationFetchModel md)
{
this.fetchModl = md;
}
