public int SaveDocumentDA(DocumentBE objDocumentBE, int userID, int webinarID)
{
int rtnDocID = 0;
try
{
using (MySqlConnection sqlCon = new MySqlConnection(Constant.EBirdConnectionString))
{
MySqlCommand sqlCmd = new MySqlCommand("spUpdateDocumentRef", sqlCon);
sqlCon.Open();
sqlCmd.CommandType = CommandType.StoredProcedure;
sqlCmd.Parameters.Add(new MySqlParameter("pClientID", objDocumentBE.ClientID));
sqlCmd.Parameters.Add(new MySqlParameter("pCategory", objDocumentBE.Category));
sqlCmd.Parameters.Add(new MySqlParameter("pOrgFileName", objDocumentBE.OrginalFileName));
sqlCmd.Parameters.Add(new MySqlParameter("pSavedFileName", objDocumentBE.SavedFileName));
sqlCmd.Parameters.Add(new MySqlParameter("pInsertedBy", objDocumentBE.InsertedBy));
sqlCmd.Parameters.Add(new MySqlParameter("pDocID", objDocumentBE.DocumentID));
sqlCmd.Parameters.Add(new MySqlParameter("pUserID", userID));
sqlCmd.Parameters.Add(new MySqlParameter("pWebinarID", webinarID));
MySqlDataReader reader = sqlCmd.ExecuteReader();
if (reader.HasRows)
{
reader.Read();
rtnDocID = Convert.ToInt32(reader[0]);
}
}
}
catch (Exception ex)
{
throw;
}
return rtnDocID;
}
public int saveFiles(UploadedFile fs, string folderType, int clientID, int actionBy, int userID, int webinarID)
{
int DocID = 0;
string fname = "";
try
{
DocumentBE objDcoumentBE = new DocumentBE();
DocumentDA objDocumentDA = new DocumentDA();
if (fs.FileName != "")
{
fname = System.IO.Path.GetFileName(fs.FileName);
switch (folderType.ToUpper())
{
case "PROFILE":
fs.SaveAs(Constant.DocRepoClient + clientID.ToString() + "\\Profile\\" + fname);
break;
case "LOGO":
fs.SaveAs(Constant.DocRepoClient + clientID.ToString() + "\\Logo\\" + fname);
break;
case "BANNER":
fs.SaveAs(Constant.DocRepoClient + clientID.ToString() + "\\Logo\\" + fname);
break;
case "PRESENTATION":
fs.SaveAs(Constant.DocRepoClient + clientID.ToString() + "\\WebinarDocs\\" + fname);
break;
case "SS":
fs.SaveAs(Constant.DocRepoClient + clientID.ToString() + "\\SS\\" + fname);
break;
case "TEMP":
fs.SaveAs(Constant.DocRepoClient + clientID.ToString() + "\\Temp\\" + fname);
break;
}
objDcoumentBE.DocumentID = 0;
objDcoumentBE.ClientID = clientID;
objDcoumentBE.Category = folderType;
objDcoumentBE.OrginalFileName = fname; //fs.GetName();
objDcoumentBE.SavedFileName = fname; //fs.GetName();
objDcoumentBE.InsertedBy = actionBy;
objDcoumentBE.PresenterID = userID;
objDcoumentBE.WebinarID = webinarID;
DocID = objDocumentDA.SaveDocumentDA(objDcoumentBE, userID, webinarID);
}
}
catch (Exception ex)
{
objUtil.RecordLogToFS("DocAccess-saveFiles:" + ex.Message);
}
return DocID;
}
public int SaveDocumentDA(DocumentBE objDocumentBE)
{
int docID = objDocumentBE.DocumentID;
string sql1 = "";
if (docID == 0)
sql1 = DBQuery.sqlDocumentInsert;
else
sql1 = DBQuery.sqlDocumentUpdate;
try
{
using (MySqlConnection sqlCon = new MySqlConnection(Constant.EBirdConnectionString))
{
MySqlCommand sqlCmd = new MySqlCommand("spUpdateDocumentRef", sqlCon);
sqlCon.Open();
sqlCmd.CommandType = CommandType.StoredProcedure;
sqlCmd.Parameters.Add(new MySqlParameter("pClientID", objDocumentBE.ClientID));
sqlCmd.Parameters.Add(new MySqlParameter("pCategory", objDocumentBE.Category));
sqlCmd.Parameters.Add(new MySqlParameter("pOrgFileName", objDocumentBE.OrginalFileName));
sqlCmd.Parameters.Add(new MySqlParameter("pSavedFileName", objDocumentBE.SavedFileName));
sqlCmd.Parameters.Add(new MySqlParameter("pInsertedBy", objDocumentBE.InsertedBy));
sqlCmd.Parameters.Add(new MySqlParameter("pDocID", objDocumentBE.DocumentID));
sqlCmd.Parameters.Add(new MySqlParameter("pUserID", objDocumentBE.PresenterID));
sqlCmd.Parameters.Add(new MySqlParameter("pWebinarID", objDocumentBE.WebinarID));
MySqlDataReader reader = sqlCmd.ExecuteReader();
if (reader.HasRows)
{
reader.Read();
docID = Convert.ToInt32(reader.GetValue(0));
}
reader.Close();
reader = null;
sqlCon.Close();
//}
return docID;
}
}
catch (Exception ex)
{
throw;
}
}
public int saveFiles(UploadedFile fs, string folderType, int clientID, int actionBy)
{
int DocID = 0;
string fname = "";
try
{
DocumentBE objDcoumentBE = new DocumentBE();
DocumentDA objDocumentDA = new DocumentDA();
if (fs.FileName != "")
{
fname = System.IO.Path.GetFileName(fs.FileName);
switch (folderType.ToUpper())
{
case "PROFILE":
fs.SaveAs(Constant.DocRepoClient + clientID.ToString() + "\\Profile\\" + fname);
break;
case "LOGO":
fs.SaveAs(Constant.DocRepoClient + clientID.ToString() + "\\Logo\\" + fname);
break;
case "BANNER":
fs.SaveAs(Constant.DocRepoClient + clientID.ToString() + "\\Logo\\" + fname);
break;
case "PRESENTATION":
fs.SaveAs(Constant.DocRepoClient + clientID.ToString() + "\\WebinarDocs\\" + fname);
break;
}
objDcoumentBE.DocumentID = 0;
objDcoumentBE.ClientID = clientID;
objDcoumentBE.Category = folderType;
objDcoumentBE.OrginalFileName = fname; //fs.GetName();
objDcoumentBE.SavedFileName = fname; //fs.GetName();
objDcoumentBE.InsertedBy = actionBy;
DocID = objDocumentDA.SaveDocumentDA(objDcoumentBE);
}
}
catch (Exception ex)
{
}
return DocID;
}