public void CreateApplication(ApplicationEmpModel am)
{
if (am != null)
{
try
{
SQLServerDBHelper db = new SQLServerDBHelper("ESignDB");
string InsertSQL = @"INSERT INTO Application(ApplicationNo, Username, Email, Timecreate, status,FileName,FileContent) VALUES(@APPID,@USERNAME,@USERMAIL,@TIMECREATE,@APPSTATUS,@FileName,@FileContent)";
SqlParameter[] parameters = new SqlParameter[7];
parameters.SetValue(new SqlParameter("APPID", am.APPID), 0);
parameters.SetValue(new SqlParameter("USERNAME", am.USERNAME), 1);
parameters.SetValue(new SqlParameter("USERMAIL", am.USERMAIL), 2);
parameters.SetValue(new SqlParameter("TIMECREATE", am.TIMECREATE), 3);
parameters.SetValue(new SqlParameter("APPSTATUS", am.APPSTATUS), 4);
parameters.SetValue(new SqlParameter("FileName", am.FileName), 5);
parameters.SetValue(new SqlParameter("FileContent", am.FileContent), 6);
db.ExcuteNonQuery(InsertSQL, parameters);
}
catch (Exception ex)
{
throw ex;
}
//if (db.ExcuteNonQuery(InsertSQL))
// Ultils.WriteCookie("Success", LanguageHelper.GetResource("AddSuccess"));
//else
// Ultils.WriteCookie("Error", LanguageHelper.GetResource("AddFail"));
}
else
{
Ultils.WriteCookie("Error", LanguageHelper.GetResource("ApproverUpdateEmpty"));
}
}
public ActionResult Create(ApplicationEmpModel appEmp, HttpPostedFileBase files)
{
if (files != null)
{
String FileExt = Path.GetExtension(files.FileName).ToUpper();
if (FileExt == ".PDF" || FileExt == ".XLSX")
{
Stream str = files.InputStream;
BinaryReader Br = new BinaryReader(str);
Byte[] FileDet = Br.ReadBytes((Int32)str.Length);
appEmp.FileName = files.FileName;
appEmp.FileContent = FileDet;
appEmp.TIMECREATE = DateTime.Now;
CreateApplication(appEmp);
return(View());
}
else
{
ViewBag.FileStatus = "Invalid file format.";
return(View());
}
}
else
{
return(View("Index"));
}
}
