public bool EFileNameAvailability(string eFileName)
{
ElectronicFile efile = db.ElectronicFiles.Where(x => x.FileName.Equals(eFileName)).SingleOrDefault();
if (efile == null)
{
return(true);
}
else
{
return(false);
}
}
public bool AddElectronicFile(ElectronicFile efile)
{
try
{
efile.FileType = db.ElectronicFileTypes.Where(x => x.ElectronicFileTypeId.Equals(efile.FileType.ElectronicFileTypeId)).SingleOrDefault();
db.ElectronicFiles.Add(efile);
db.SaveChanges();
}
catch (Exception ex)
{
return(false);
}
return(true);
}
private void button2_Click(object sender, EventArgs e)
{
if (ValidateChildren(ValidationConstraints.Enabled))
{
if (WebApiClient.EFileNameAvailability(txtFileName.Text))
{
bool isSuccess = false;
string EFileCopyDirectoryPath = ConfigurationSettings.AppSettings.Get("EFileCopyDirectoryPath").ToString() + "\\" + (cbCategory.SelectedItem as ComboBoxItem).Text;
string FileSQLPath = ConfigurationSettings.AppSettings.Get("EFileSQLPath").ToString() + "/" + (cbCategory.SelectedItem as ComboBoxItem).Text;
ElectronicFile eFile = new ElectronicFile()
{
FileName = txtFileName.Text,
Path = FileSQLPath + "/" + Path.GetFileName(txtPath.Text),
FileType = new ElectronicFileType()
{
ElectronicFileTypeId = int.Parse((cbCategory.SelectedItem as ComboBoxItem).Value.ToString())
}
};
isSuccess = WebApiClient.AddElectronicFile(eFile);
if (isSuccess)
{
MessageBox.Show((cbCategory.SelectedItem as ComboBoxItem).Text + " has been added");
File.Copy(txtPath.Text, Path.Combine(EFileCopyDirectoryPath, Path.GetFileName(txtPath.Text)), true);
}
}
else
{
MessageBox.Show((cbCategory.SelectedItem as ComboBoxItem).Text + " already exist by that name");
}
if (!this.DesignMode)
{
list = GetPagedListAsync();
btnPrevious.Enabled = list.HasPreviousPage;
btnNext.Enabled = list.HasNextPage;
dgElectronicFiles.DataSource = list.Select(o => new { Name = o.FileName, Type = o.FileType.Name, Format = o.Path.Substring(o.Path.LastIndexOf('.') + 1) }).ToList();
lblPageCount.Text = string.Format("Page {0}/{1}", pageNumber, list.PageCount);
}
}
}
public static bool AddElectronicFile(ElectronicFile efile)
{
string urlWebConfig = ConfigurationSettings.AppSettings.Get("ApiURL").ToString();
string controller = "values";
string action = "AddElectronicFile";
string html = string.Empty;
bool isSuccess = false;
string url = urlWebConfig + "/" + controller + "/" + action;
string response = string.Empty;
var httpWebRequest = (System.Net.HttpWebRequest)WebRequest.Create(url);
httpWebRequest.ContentType = "application/json";
httpWebRequest.Method = "POST";
ServicePointManager.SecurityProtocol = SecurityProtocolType.Tls12 | SecurityProtocolType.Tls11 | SecurityProtocolType.Tls;
using (var streamWriter = new StreamWriter(httpWebRequest.GetRequestStream()))
{
string json = JsonConvert.SerializeObject(efile);
streamWriter.Write(json);
streamWriter.Flush();
streamWriter.Close();
}
var httpResponse = (HttpWebResponse)httpWebRequest.GetResponse();
using (var streamReader = new StreamReader(httpResponse.GetResponseStream()))
{
var result = streamReader.ReadToEnd();
result = result.ToString();
response = result;
isSuccess = bool.Parse(response);
}
return(isSuccess);
}
