public void runStoreProcedure(String downloadSessionId, int syncDetailId)
{
CRUD sql = new CRUD();
SqlConnection con = ckon.sqlConMsg();
try
{
con.Open();
String cmd_sp = "DatadownloadtoApplied";
SqlCommand cmd = new SqlCommand(cmd_sp, con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandTimeout = 120;
cmd.Parameters.Add("@Downloadsessionid", DbType.Guid).Value = downloadSessionId;
cmd.ExecuteNonQuery();
}
catch (Exception e)
{
String delete = "DELETE FROM JobSynchDetailDownloadStatus WHERE SynchDetail = '" + syncDetailId + "'";
sql.ExecuteNonQueryMsg(delete);
MessageBox.Show(e.ToString(), "No Connection", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
finally
{
if (con.State == ConnectionState.Open)
{
con.Close();
}
}
}
//==========================================================================================================
public void clearUploadSyncHist()
{
CRUD sql = new CRUD();
try
{
string cmd_uploadStatus = "delete from JobSynchDetailUploadStatus where SynchDetail not in (select top 2 SynchDetail from JobTabletoSynchDetailUpload order by SynchDetail desc)";
sql.ExecuteNonQueryMsg(cmd_uploadStatus);
string cmd_uploadDetail = "delete from JobTabletoSynchDetailUpload where SynchDetail not in (select top 2 SynchDetail from JobTabletoSynchDetailUpload order by SynchDetail desc)";
sql.ExecuteNonQueryMsg(cmd_uploadDetail);
}
catch (Exception e)
{
MessageBox.Show(e.ToString(), "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public void uploadToFTP(String fileName, String storeId, String syncDetail, String rowFatch)
{
CRUD sql = new CRUD();
String ftpWebReq = "";
String uploadFilePath = "";
String fileToExtract = "";
API_UploadSync uploadSyncDetail = new API_UploadSync();
ftpWebReq = ftpServer + "Uploadfile" + "/" + storeId + "/" + fileName + ".bcp";
uploadFilePath = getFilePath(storeId);
try
{
FtpWebRequest request = (FtpWebRequest)FtpWebRequest.Create(ftpWebReq);
request.Method = WebRequestMethods.Ftp.UploadFile;
request.Credentials = new NetworkCredential(ftpUsername, ftpPassword);
request.UsePassive = true;
request.UseBinary = true;
request.KeepAlive = false;
FileStream stream = File.OpenRead(uploadFilePath + @"\" + fileName + ".bcp");
byte[] buffer = new byte[stream.Length];
stream.Read(buffer, 0, buffer.Length);
stream.Close();
Stream reqStream = request.GetRequestStream();
reqStream.Write(buffer, 0, buffer.Length);
reqStream.Close();
uploadSyncDetail.uploadSync(syncDetail);
string cmd_insert = "IF NOT EXISTS (SELECT * FROM JobSynchDetailUploadStatus WHERE SynchDetail = '" + syncDetail + "') " +
"BEGIN " +
"INSERT INTO JobSynchDetailUploadStatus(SynchDetail, RowFatch, RowApplied, Status) " +
"VALUES('" + syncDetail + "', '" + rowFatch + "', 0, 1) " +
"END";
sql.ExecuteNonQueryMsg(cmd_insert);
}
catch (Exception e)
{
using (EventLog eventLog = new EventLog("Application"))
{
eventLog.Source = "Application";
eventLog.WriteEntry("Upload background " + e.Message.ToString(), EventLogEntryType.Information, 101, 1);
}
MessageBox.Show(e.ToString());
}
}
public void downloadFromFTP(String downloadPath, String fileName, String id, String jobId, String storeId, String rowFatch, Guid downloadSessionId, int syncType)
{
CRUD sql = new CRUD();
String ftpWebReq = "";
String downloadFilePath = "";
String fileToExtract = "";
String extractFilePath = "";
downloadFilePath = getDownloadFilePath(downloadPath, syncType);
ftpWebReq = ftpServer + downloadFilePath;
createFilePath(downloadPath);
try
{
FtpWebRequest request = (FtpWebRequest)WebRequest.Create(ftpWebReq);
request.Method = WebRequestMethods.Ftp.DownloadFile;
request.Credentials = new NetworkCredential(ftpUsername, ftpPassword);
if (!File.Exists(downloadPath))
{
FtpWebResponse response = (FtpWebResponse)request.GetResponse();
Stream responseStream = response.GetResponseStream();
FileStream file = File.Create(downloadPath);
byte[] buffer = new byte[32 * 1024];
int read;
while ((read = responseStream.Read(buffer, 0, buffer.Length)) > 0)
{
file.Write(buffer, 0, read);
}
file.Close();
responseStream.Close();
response.Close();
}
extractFilePath = getExtactFilePath(downloadPath);
if (!File.Exists(extractFilePath + @"\" + fileName + ".bcp") && syncType == 0)
{
fileToExtract = extractFilePath + @"\" + fileName + ".zip";
ExtractFile(fileToExtract, extractFilePath + @"\");
}
String cmd_insert = "IF NOT EXISTS (SELECT * FROM JobSynchDetailDownloadStatus WHERE SynchDetail = '" + id + "') " +
"BEGIN " +
"INSERT INTO JobSynchDetailDownloadStatus(SynchDetail, RowFatch, RowApplied, Status, Downloadsessionid) " +
"VALUES('" + id + "', '" + rowFatch + "', 0, 1, '" + downloadSessionId + "') " +
"END";
sql.ExecuteNonQueryMsg(cmd_insert);
}
catch (Exception e)
{
if (e.Message.IndexOf("550") != -1)
{
MessageBox.Show("File " + fileName + " not found", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
MessageBox.Show(e.ToString(), "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
