/// <summary>
/// Method for adding email log.
/// </summary>
/// <param name="objEmailLog"></param>
/// <returns></returns>
public int AddEmailLog(EmailLog objEmailLog)
{
return objCommonDAL.AddEmailLog(objEmailLog);
}
/// <summary>
/// Method for adding email details in to email log
/// </summary>
/// <param name="objEmailLog"></param>
/// <returns></returns>
public int AddEmailLog(EmailLog objEmailLog)
{
int result = 0;
try
{
SqlCommand objSqlCommand = new SqlCommand();
SqlParameter[] objLstParams = new SqlParameter[6];
SqlParameter objSubject = new SqlParameter("@Subject", SqlDbType.VarChar);
objSubject.Value = objEmailLog.Subject;
objLstParams[0] = objSubject;
SqlParameter objBody = new SqlParameter("@Body", SqlDbType.VarChar);
objBody.Value = Convert.ToString(objEmailLog.Body);
objLstParams[1] = objBody;
SqlParameter objTo = new SqlParameter("@To", SqlDbType.VarChar);
objTo.Value = objEmailLog.To;
objLstParams[2] = objTo;
SqlParameter objFrom = new SqlParameter("@From", SqlDbType.VarChar);
objFrom.Value = objEmailLog.From;
objLstParams[3] = objFrom;
SqlParameter objCreatedBy = new SqlParameter("@CreatedBy", SqlDbType.Int);
objCreatedBy.Value = objEmailLog.CreatedBy;
objLstParams[4] = objCreatedBy;
SqlParameter objCreatedOn = new SqlParameter("@CreatedOn", SqlDbType.DateTime);
objCreatedOn.Value = objEmailLog.CreatedOn;
objLstParams[5] = objCreatedOn;
result = Convert.ToInt32(SqlHelper.ExecuteScalar(SqlHelper.ConnectionString, CommandType.StoredProcedure, SP_AddEmailLog, objLstParams));
objSqlCommand.Parameters.Clear();
}
catch (Exception ex)
{
log.Error("AddEmailLog \n Message: " + ex.Message + "\n Source: " + ex.Source + "\n StackTrace: " + ex.StackTrace);
ExceptionLog.WriteLog(COMMONDATA + " @ AddEmailLog ", ex.Message + " \n " + ex.StackTrace);
}
return result;
}