public bool addDocument(string sFileName, string sContentType, byte[] readByteFile, int docSendID, int iParentDocID, string userForwardIDs = "", string docChkLst = "")
{
SqlDataAccess objConnection = new SqlDataAccess(clsConstant.DBCONSTRING);
try
{
if (objConnection.Connection.State == ConnectionState.Closed)
{
objConnection.Connection.Open();
}
objConnection.BeginTransaction();
if (docSendID != 0 && iParentDocID != 0)
{
if (sFileName != string.Empty && sContentType != string.Empty && readByteFile != null)
{
//Insert New File
SqlParameter[] param = new SqlParameter[] { new SqlParameter("@filename", sFileName),
new SqlParameter("@contenttype", sContentType),
new SqlParameter("@attachFile", readByteFile),
new SqlParameter("@iDocSendID", docSendID),
new SqlParameter("@iPDocID", iParentDocID),
new SqlParameter("@iForwardUsers", userForwardIDs), // Use file name as variable for storing Forward ID's
new SqlParameter("@iDocSendFid", docChkLst) };
objConnection.ExecuteNonQuery(clsConstant.SP_INSERT_DOC_SEND_FILE, CommandType.StoredProcedure, param);
}
else if ((sFileName == string.Empty && sContentType == string.Empty && readByteFile == null))
{
//Update "Forward" Details with null values
//Insert New File
SqlParameter[] param = new SqlParameter[] { new SqlParameter("@iDocSendID", docSendID),
new SqlParameter("@iPDocID", iParentDocID),
new SqlParameter("@iForwardUsers", userForwardIDs), // Use file name as variable for storing Forward ID's
new SqlParameter("@iDocSendFid", docChkLst) };
objConnection.ExecuteNonQuery(clsConstant.SP_INSERT_DOC_SEND_FILE, CommandType.StoredProcedure, param);
}
}
else // GO FOR REPLYALL
{
if (sFileName != string.Empty && sContentType != string.Empty && readByteFile != null)
{
//Insert New File
SqlParameter[] param = new SqlParameter[] { new SqlParameter("@filename", sFileName),
new SqlParameter("@contenttype", sContentType),
new SqlParameter("@attachFile", readByteFile),
new SqlParameter("@iDocSendID", docSendID),
new SqlParameter("@iPDocID", iParentDocID),
new SqlParameter("@iForwardUsers", userForwardIDs), // Use file name as variable for storing Forward ID's
new SqlParameter("@iDocSendFid", docChkLst) };
// STORE THE DOCUMENT ID
objConnection.ExecuteNonQuery(clsConstant.SP_INSERT_DOC_SEND_FILE, CommandType.StoredProcedure, param);
}
else if ((sFileName == string.Empty && sContentType == string.Empty && readByteFile == null)) // Forward Document Mapping
/*
* Insert document in database against a empty message forwarded, with previous document send
*/
{
SqlParameter[] param = new SqlParameter[] { new SqlParameter("@iDocSendID", docSendID),
new SqlParameter("@iPDocID", iParentDocID),
new SqlParameter("@iForwardUsers", userForwardIDs), // Use file name as variable for storing Forward ID's
new SqlParameter("@iDocSendFid", docChkLst) };
objConnection.ExecuteNonQuery(clsConstant.SP_INSERT_DOC_SEND_FILE, CommandType.StoredProcedure, param);
}
//// UPLOAD OLD Way THE ATTACHEMENT
//if (sFileName != string.Empty && sContentType != string.Empty && readByteFile != null)
//{
// //Insert New File
// SqlParameter[] param = new SqlParameter[] { new SqlParameter("@filename", sFileName),
// new SqlParameter("@contenttype", sContentType),
// new SqlParameter("@attachFile", readByteFile),
// new SqlParameter("@iDocSendID", docSendID)
// };
// objConnection.ExecuteNonQuery(clsConstant.SP_INSERT_DOC_SEND_FILE, CommandType.StoredProcedure, param);
//}
//else if ((sFileName == string.Empty && sContentType == string.Empty && readByteFile == null))
//{
// //Update "Forward" Details with null values
// //Insert New File
// SqlParameter[] param = new SqlParameter[] { new SqlParameter("@iDocSendID", docSendID),
// };
// objConnection.ExecuteNonQuery(clsConstant.SP_INSERT_DOC_SEND_FILE, CommandType.StoredProcedure, param);
//}
}
objConnection.CommitTransaction();
return(true);
}
catch (Exception ex)
{
throw ex;
}
}
public int saveALLCommentMDB(string MCID, string iDocDettailID, string cType, string sComment, string docNm, DateTime dueDt, int uID = -1, string ToUsers = "", string TaorLoan = "", string CCUsers = "") // mcid added on 27 dec
{
try
{
if (objConnection.Connection.State == ConnectionState.Closed)
{
objConnection.Connection.Open();
}
ToUsers = ToUsers.Replace("," + uID, "");
objConnection.BeginTransaction();
#region SAVE THE NEW DOCUMENT
SqlParameter[] newParam = new SqlParameter[] {
new SqlParameter("@userId", uID),
new SqlParameter("@messageDetails", sComment),
new SqlParameter("@action", "A"), // reply All
new SqlParameter("@docSendID", iDocDettailID), // SEND THE DOCUMENT DETAILS ID AND FIND THE PARENT FOR THE SAME
new SqlParameter("@docName ", docNm), new SqlParameter("@dueDate", dueDt), new SqlParameter("@mcid", MCID)
};
int getId = int.Parse(objConnection.ExecuteScalarQuery("sp_insertSendNewDocumentmdb", CommandType.StoredProcedure, newParam).ToString());
#endregion
#region SAVE ALL Users
if (getId != -1)
{
int defaultval = 0; // CC
int defaultval1 = 1; // TO
// CHECK FOR THE TO USERS
if (ToUsers != "")
{
SqlParameter[] pAllUsers = new SqlParameter[] {
new SqlParameter("@iDocID", getId),
new SqlParameter("@bToOrCC", defaultval1),
new SqlParameter("@vsUsrString", ToUsers),
new SqlParameter("@cTAStatus", TaorLoan),
new SqlParameter("@action", "A") // REPLY ALL
}; //, new SqlParameter("@bIsReply", defaultval) };// For To 1
objConnection.ExecuteNonQuery("sp_insertDocSendDetailsMDB", CommandType.StoredProcedure, pAllUsers);
}
//CHECK FOR CC USERS
if (CCUsers != "")
{
SqlParameter[] pCcUsers = new SqlParameter[] {
new SqlParameter("@iDocID", getId),
new SqlParameter("@bToOrCC", defaultval),
new SqlParameter("@vsUsrString", CCUsers),
new SqlParameter("@cTAStatus", TaorLoan),
new SqlParameter("@action", "A") // REPLY ALL
}; //, new SqlParameter("@bIsReply", defaultval) };// For To 1
objConnection.ExecuteNonQuery("sp_insertDocSendDetailsmdb", CommandType.StoredProcedure, pCcUsers);
}
}
else
{
objConnection.RollbackTransaction();
return(-1);
}
#endregion
objConnection.CommitTransaction();
return(getId);
}
catch (Exception ex)
{
return(-1);
}
}