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