public int Upload(string folder, int module, int transaction)
{
try
{
int result = 0;
file_manager_in_lib obj = new file_manager_in_lib();
int company_id = Convert.ToInt32(Crypto.url_decrypt(Request.Cookies["CompanyId"]));
int created_by = Convert.ToInt32(Crypto.url_decrypt(Request.Cookies["UserId"]));
int warehouse_id = Convert.ToInt32(Crypto.url_decrypt(Request.Cookies["WarehouseId"]));
if (Request.Form.Files.Count > 0)
{
foreach (var file in Request.Form.Files)
{
var fileName = file.FileName;
var customDir = "Uploaded\\Images\\" + company_id.ToString() + "\\" + folder;
var directory = Path.Combine(_environment.WebRootPath, customDir);
if (!Directory.Exists(directory))
{
Directory.CreateDirectory(directory);
}
var fullPath = Path.Combine(_environment.WebRootPath, customDir) + $@"\{fileName}";
using (FileStream fs = System.IO.File.Create(fullPath))
{
file.CopyTo(fs);
fs.Flush();
}
obj.module_id = module;
obj.transaction_id = transaction;
obj.file_name = fileName;
obj.file_extension = Path.GetExtension(fileName);
obj.file_path = "\\" + customDir + "\\" + fileName;
obj.created_by = created_by;
obj.warehouse_id = warehouse_id;
obj.company_id = company_id;
result = _master.file_manager_inAsync(obj).Result;
}
}
return(result);
}
catch (Exception ex)
{
string cont = ex.Message;
return(0);
}
}
public int file_manager_in(file_manager_in_lib objHeader)
{
int ret = 1;
SqlConnection oConn = new SqlConnection(_master);
SqlTransaction oTrans;
oConn.Open();
oTrans = oConn.BeginTransaction();
SqlCommand oCmd = new SqlCommand();
oCmd.Connection = oConn;
oCmd.Transaction = oTrans;
try
{
oCmd.CommandText = "file_manager_in";
oCmd.CommandType = CommandType.StoredProcedure;
oCmd.Parameters.Clear();
oCmd.Parameters.AddWithValue("@module_id", objHeader.module_id);
oCmd.Parameters.AddWithValue("@transaction_id", objHeader.transaction_id);
oCmd.Parameters.AddWithValue("@file_name", objHeader.file_name);
oCmd.Parameters.AddWithValue("@file_extension", objHeader.file_extension);
oCmd.Parameters.AddWithValue("@file_path", objHeader.file_path);
oCmd.Parameters.AddWithValue("@created_by", objHeader.created_by);
oCmd.Parameters.AddWithValue("@warehouse_id", objHeader.warehouse_id);
oCmd.Parameters.AddWithValue("@company_id", objHeader.company_id);
oCmd.ExecuteNonQuery();
oTrans.Commit();
}
catch (Exception e)
{
oTrans.Rollback();
Console.WriteLine("Error: " + e.Message);
error_log_in("0", "SP = file_manager_in | " + e.Message, objHeader.company_id, objHeader.created_by);
ret = 0;
}
finally
{
oConn.Close();
}
return(ret);
}
