/// <summary>
///
/// </summary>
/// <param name="param"></param>
private void ParameterHandler(HttpMultipartParser.ParameterPart param)
{
if (param.Name == "mediaoptions")
{
string chFilesJson = param.Data;
choosenFiles = JsonConvert.DeserializeObject <ChoosenFilesList>(chFilesJson);
//xcc_dt = Common.GetTable("select appname, call_date from xcc_report_new where id=" + choosenFiles.xcc_id);
using (CC_ProdEntities dataContext = new CC_ProdEntities())
{
int xcc_Id = 0;
if (choosenFiles.xcc_id != "")
{
xcc_Id = Convert.ToInt32(choosenFiles.xcc_id);
var xcc_dt = dataContext.XCC_REPORT_NEW.Where(x => x.ID == xcc_Id).Select(x => new { x.appname, x.call_date }).ToList();
}
}
}
}
/// <summary>
/// GetAudioFileName
/// </summary>
/// <param name="drv"></param>
/// <returns></returns>
public static string GetAudioFileName(getScorecardData_Result drv)
{
// If this scorecard is for website, just return the website
int Id;
try
{
Id = drv.X_ID;
}
catch (Exception ex)
{
Id = drv.F_ID;
}
//DataTable sc_id = GetTable("select *, (select bypass from userextrainfo where username = '******') as bypass from xcc_report_new join scorecards on xcc_report_new.scorecard = scorecards.id join app_settings on app_settings.appname = xcc_report_new.appname where xcc_report_new.id = " + Id);
using (CC_ProdEntities dataContext = new CC_ProdEntities())
{
var sc_id = dataContext.GetAudioFileName(HttpContext.Current.User.Identity.Name, Id).FirstOrDefault();
if (sc_id != null)
{
if (sc_id.bypass.ToString() == "True" & sc_id.onAWS.ToString() == "True")
{
return("http://files.callcriteria.com" + sc_id.audio_link);
}
if (sc_id.onAWS.ToString() == "True")
{
string audio_link = sc_id.audio_link;
IAmazonS3 s3Client;
s3Client = new AmazonS3Client(System.Configuration.ConfigurationManager.AppSettings["CCAWSAccessKey"], System.Configuration.ConfigurationManager.AppSettings["CCCAWSSecretKey"], Amazon.RegionEndpoint.APSoutheast1);
GetPreSignedUrlRequest request1 = new GetPreSignedUrlRequest();
GetPreSignedUrlRequest URL_REQ = new GetPreSignedUrlRequest();
URL_REQ.BucketName = "callcriteriasingapore" + Strings.Left(audio_link, audio_link.LastIndexOf("/")).Replace("/audio2/", "/audio/");
URL_REQ.Key = audio_link.Substring(audio_link.LastIndexOf("/") + 1);
URL_REQ.Expires = DateTime.Now.AddHours(1);
return(s3Client.GetPreSignedURL(URL_REQ));
}
if (sc_id.review_type == "website")
{
return("/point1sec.mp3");
}
if (sc_id.stream_only.ToString() == "True")
{
return(sc_id.audio_link);
}
}
if (Strings.Left(drv.audio_link.ToString(), 6) == "/audio" & (Strings.Right(drv.audio_link.ToString(), 4) == ".mp3" | Strings.Right(drv.audio_link.ToString(), 4) == ".mp4" | Strings.Right(drv.audio_link.ToString(), 4) == ".gsm"))
{
//try
//{
// TimeSpan call_len = new TimeSpan(0, 0, Convert.ToInt32(GetMediaDuration("http://files.callcriteria.com" + drv.audio_link)) / 2); // tlf.Properties.Duration
// DateTime call_time = Convert.ToDateTime("12/30/1899") + call_len;
// UpdateTable("update XCC_REPORT_NEW set call_time = '" + call_time.ToString() + "' where ID = (select review_id from form_score3 where ID = " + Id + ")");
// UpdateTable("update form_score3 set call_length = '" + call_len.TotalSeconds + "' where ID = " + Id);
// return "http://files.callcriteria.com" + drv.audio_link.ToString(); // already converted, send it back
//}
//catch (Exception ex)
//{
// return "http://files.callcriteria.com" + drv.audio_link.ToString();
//}
}
// thinks it's downloaded, but file's not there, get the orignal file and download again
if (Strings.Left(drv.audio_link.ToString(), 6) == "/audio" & (Strings.Right(drv.audio_link.ToString(), 4) == ".mp3" | Strings.Right(drv.audio_link.ToString(), 4) == ".mp4" | Strings.Right(drv.audio_link.ToString(), 4) == ".gsm"))
{
// Email_Error("trying to reload " & drv.Item("audio_link").ToString)
// See if session ID has data
//wav_dt = GetTable("select * from wav_data where session_id = '" + drv.SESSION_ID + "'");
var wav_dt = dataContext.WAV_DATA.Where(x => x.session_id == drv.SESSION_ID).FirstOrDefault();
if (wav_dt == null)
{
//wav_dt = GetTable("select * from wav_data where filename like '%" + drv.SESSION_ID + "%'");
}
if (wav_dt != null)
{
drv.audio_link = wav_dt.filename;
}
}
string session_id;
if (drv.SESSION_ID.ToString().IndexOf(" ") > 0)
{
session_id = Strings.Left(drv.SESSION_ID.ToString(), drv.SESSION_ID.ToString().IndexOf(" "));
}
else
{
session_id = drv.SESSION_ID;
}
string phone = drv.phone.ToString();
string this_filename = drv.audio_link.ToString();
string call_date = drv.call_date.ToString().Substring(0, drv.call_date.ToString().IndexOf(" ")).Replace("/", "_");
if (!System.IO.Directory.Exists(HttpContext.Current.Server.MapPath("/audio/" + drv.appname.ToString() + "/" + call_date + "/")))
{
System.IO.Directory.CreateDirectory(HttpContext.Current.Server.MapPath("/audio/" + drv.appname.ToString() + "/" + call_date + "/"));
}
if (drv.audio_link.ToString() != "")
{
if (Strings.Left(drv.audio_link.ToString(), 4) == "http" | Strings.Left(drv.audio_link.ToString(), 6) == "/audio" | Strings.Left(drv.audio_link.ToString(), 3) == "ftp")
{
this_filename = drv.audio_link.ToString().Replace(" ", "%20");
}
else
{
this_filename = drv.url_prefix + (drv.audio_link.ToString().Replace(" ", "%20"));
}
string file_ending = Strings.Right(this_filename, 4).ToLower();
if ((this_filename.IndexOf("@") > -1 | this_filename.IndexOf("http") > -1) & Strings.Left(this_filename, 3) != "ftp" & Strings.Left(this_filename, 4) != "sftp" & Strings.Left(this_filename, 6) != "/audio")
{
// Email_Error(this_filename)
System.Net.WebClient WebClient_down = new System.Net.WebClient();
WebClient_down.Credentials = new System.Net.NetworkCredential(drv.recording_user.ToString(), drv.record_password.ToString(), "");
try
{
WebClient_down.DownloadFile(this_filename, HttpContext.Current.Server.MapPath("/audio/" + drv.appname.ToString() + "/" + call_date + "/" + session_id + file_ending));
}
catch (Exception ex)
{
HttpContext.Current.Response.Write("File not found, refresh page." + this_filename + " to " + HttpContext.Current.Server.MapPath("/audio/" + drv.appname.ToString() + "/" + call_date + "/" + session_id + file_ending) + ex.Message);
//Email_Error(HttpContext.Current.Server.MapPath("/audio/" + drv.appname.ToString() + "/" + call_date + "/" + session_id + file_ending) + ex.Message);
HttpContext.Current.Response.Redirect("listen.aspx");
}
while (!!WebClient_down.IsBusy)
{
System.Threading.Thread.Sleep(100);
}
}
if (Strings.Left(this_filename, 6) == "ftp://")
{
WebClient ftpc = new WebClient();
ftpc.Credentials = new System.Net.NetworkCredential(drv.audio_user.ToString(), drv.audio_password.ToString(), "");
try
{
System.IO.File.Delete(@"d:\wwwroot\audio\" + drv.appname.ToString() + @"\" + call_date + @"\" + session_id + file_ending);
}
catch (Exception ex)
{
}
try
{
ftpc.DownloadFile(this_filename, @"d:\wwwroot\audio\" + drv.appname.ToString() + @"\" + call_date + @"\" + session_id + file_ending);
System.Threading.Thread.Sleep(500);
}
catch (Exception ex)
{
HttpContext.Current.Response.Write(@"d:\wwwroot\audio\" + drv.appname.ToString() + @"\" + call_date + @"\" + session_id + file_ending + " " + ex.Message + "<br><br><br>");
HttpContext.Current.Response.End();
}
while (!!ftpc.IsBusy)
{
System.Threading.Thread.Sleep(100);
}
}
if (Strings.Left(this_filename, 7) == "sftp://")
{
try
{
Renci.SshNet.SftpClient sftp_new = new Renci.SshNet.SftpClient(drv.recording_user.ToString().Substring(7), Convert.ToInt32(drv.audio_link.ToString()), drv.audio_user.ToString(), drv.audio_password.ToString());
sftp_new.Connect();
System.IO.FileStream dest_file = new System.IO.FileStream(@"d:\wwwroot\audio\" + drv.appname.ToString() + @"\" + call_date + @"\" + session_id + file_ending, FileMode.OpenOrCreate);
sftp_new.DownloadFile(this_filename.Substring(Strings.Len(drv.recording_user)).Replace("%20", " "), dest_file);
sftp_new.Disconnect();
sftp_new.Dispose();
dest_file.Close();
dest_file.Dispose();
}
catch (Exception ex)
{
HttpContext.Current.Response.Write(ex.Message + "<br>");
HttpContext.Current.Response.Write(@"d:\wwwroot\audio\" + drv.appname.ToString() + @"\" + call_date + @"\" + session_id + file_ending + "<br>");
HttpContext.Current.Response.Write(this_filename.Substring(Strings.Len(drv.recording_user)).Replace("%20", " "));
HttpContext.Current.Response.End();
}
int max_wait = 0;
while (!System.IO.File.Exists(HttpContext.Current.Server.MapPath("/audio/" + drv.appname.ToString() + "/" + call_date + "/" + session_id + file_ending)) | max_wait == 100)
{
System.Threading.Thread.Sleep(100);
max_wait += 1;
}
}
if (file_ending == ".mp3" | file_ending == ".mp4")
{
this_filename = HttpContext.Current.Server.MapPath("/audio/" + drv.appname.ToString() + "/" + call_date + "/" + session_id + file_ending);
}
else
{
try
{
this_filename = HttpContext.Current.Server.MapPath("/audio/" + drv.appname.ToString() + "/" + call_date + "/" + session_id + file_ending);
}
catch (Exception ex)
{
return("");
}
string output = "";
string out_error = "";
string destination_file = HttpContext.Current.Server.MapPath("/audio/" + drv.appname.ToString() + "/" + call_date + "/" + session_id + ".mp3");
//RunFFMPEG("-i " + Strings.Chr(34) + this_filename + Strings.Chr(34) + " -b:a 16k -y " + destination_file, ref output, ref out_error);
try
{
System.IO.File.Delete(HttpContext.Current.Server.MapPath("/audio/" + drv.appname.ToString() + "/" + call_date + "/" + session_id + file_ending));
}
catch (Exception ex)
{
}
file_ending = ".mp3";
}
this_filename = "/audio/" + drv.appname.ToString() + "/" + call_date + "/" + session_id + file_ending;
if (System.IO.File.Exists(HttpContext.Current.Server.MapPath(this_filename)))
{
//UpdateTable("update XCC_REPORT_NEW set audio_link = '" + this_filename + "' where ID = " + Id);
var isExist = dataContext.XCC_REPORT_NEW.Where(x => x.ID == Id).FirstOrDefault();
XCC_REPORT_NEW tblXCC_REPORT_NEW = new XCC_REPORT_NEW();
if (isExist != null)
{
tblXCC_REPORT_NEW = dataContext.XCC_REPORT_NEW.Find(Id);
dataContext.Entry(tblXCC_REPORT_NEW).State = EntityState.Modified;
tblXCC_REPORT_NEW.bad_call_accepted = System.DateTime.Now;
tblXCC_REPORT_NEW.audio_link = this_filename;
int result = dataContext.SaveChanges();
}
return(this_filename);
}
else
{
return(drv.audio_link.ToString());// already an mp3, file exists though doesn't match session ID
}
}
return("");
}
}
/// <summary>
///
/// </summary>
/// <param name="db"></param>
/// <param name="storedProcedure"></param>
public MultipleResultSetWrapper(CC_ProdEntities db, SqlCommand storedProcedure)
{
_db = db;
_storedProcedure = storedProcedure;
_resultSets = new List <Func <IObjectContextAdapter, DbDataReader, IEnumerable> >();
}
/// <summary>
///
/// </summary>
/// <param name="db"></param>
/// <param name="storedProcedure"></param>
/// <returns></returns>
public static MultipleResultSetWrapper MultipleResults(this CC_ProdEntities db, SqlCommand storedProcedure)
{
return(new MultipleResultSetWrapper(db, storedProcedure));
}
/// <summary>
///
/// </summary>
/// <param name="context"></param>
public Utility(CC_ProdEntities context)
{
this.context = context;
}
/// <summary>
///
/// </summary>
public UnitOfWork()
{
context = new CC_ProdEntities();
}
/// <summary>
///
/// </summary>
/// <param name="context"></param>
public UnitOfWork(CC_ProdEntities context)
{
this.context = context;
}
